home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IC95218 Status: Geschlossen

DB2RELOCATEDB CAN FAIL WITH DBT1015N WHEN CHANGING STORAGE_PATH

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - 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:                                              * 
* Users using db2relocatedb                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 3.                      * 
****************************************************************
Local-Fix:
Change DB_PATH and STORAGE_PATH at the same time.
verfügbare FixPacks:
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 Version 10.5 Fix Pack 3.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.08.2013
10.03.2014
10.03.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.3 FixList
10.5.0.3 FixList