Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC91366 Status: Geschlossen

DB2RELOCATEDB CAN FAIL WITH DBT1015N WHEN CHANGING STORAGE_PATH

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
When db2relocatedb is issued to change the DB_PATH without 
changing STORAGE_PATH, it succeeds with no error. However, 
subsequent db2relocatedb command to change STORAGE_PATH fails 
with DBT1015N. 
 
Here is the repro steps: 
$ db2 create db p36705 on $PWD/src 
$ db2 terminate ; db2stop 
$ cat rel.cfg 
INSTANCE=v95fp5 
DB_NAME=P36705 
DB_PATH=/dbpath/36705/src,/dbpath/36705/des 
$ cp -pr src des 
$ db2relocatedb -f rel.cfg 
Files and control structures were changed successfully. 
Database was catalogued successfully. 
DBT1000I  The tool completed successfully. 
 
$ db2 terminate ; db2start 
$ db2 connect to p36705 
$ db2 list tablespaces 
 ... 
 Tablespace ID                        = 1 
 Name                                 = TEMPSPACE1 
 Type                                 = System managed space 
 Contents                             = System Temporary data 
 State                                = 0x4000              <<< 
tablespace is offline 
   Detailed explanation: 
     Offline 
 ... 
$ db2 terminate ; db2stop 
$ cat rel2.cfg 
INSTANCE=v95fp5 
DB_NAME=P36705 
DB_PATH=/dbpath/36705/des 
STORAGE_PATH=/dbpath/36705/src,/dbpath/36705/des 
$ db2relocatedb -f rel2.cfg 
DBT1015N  Unable to allocate memory.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* See Error Description                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 for Linux, UNIX, and Windows Fix * 
* Pack 3                                                       * 
****************************************************************
Local-Fix:
Change DB_PATH and STORAGE_PATH at the same time.
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
Problem first fixed in DB2 Version 10.1 for Linux, UNIX, and 
Windows Fix Pack 3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
05.04.2013
03.10.2013
03.10.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.3 FixList
10.1.0.3 FixList