DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9.                       * 
****************************************************************

Change DB_PATH and STORAGE_PATH at the same time.

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.7 Fix Pack 9.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

28.03.2013
28.01.2014
28.01.2014

9.7.FP9