DB2 FOR LUW / DB2FORLUW / 970 - DB2

db2relocatedb command may set incorrect path for LOGARCHMETH1 
and LOGARCHMETH2 when both are defined in the configuration 
file. 
 
$ pwd 
/db1/db2inst1/sample 
$ db2 create db sample on $PWD 
$ mkdir -p arc1/test1 arc1/test2 arc2/test1 arc2/test2 
$ db2 update db cfg for sample using logarchmeth1 
disk:$PWD/arc1/test1 logarchmeth2 disk:$PWD/arc2/test1 
$ db2 connect to sample ; db2 backup db sample to /dev/null 
$ db2 connect to sample ; db2 get db cfg | grep LOGARCHMETH 
 First log archive method                 (LOGARCHMETH1) = 
DISK:/db1/db2inst1/sample/arc1/test1/ 
 Second log archive method                (LOGARCHMETH2) = 
DISK:/db1/db2inst1/sample/arc2/test1/ 
 
$ cat rel.cfg 
DB_NAME=sample 
DB_PATH=/db1/db2inst1/sample 
INSTANCE=db2inst1 
LOGARCHMETH1=DISK:/db1/db2inst1/sample/arc1/test2/ 
LOGARCHMETH2=DISK:/db1/db2inst1/sample/arc2/test2/ 
 
$ db2 terminate 
$ db2relocatedb -f rel.cfg 
Files and control structures were changed successfully. 
DBT1000I  The tool completed successfully. 
 
$ db2 get db cfg | grep LOGARCHMETH 
 First log archive method                 (LOGARCHMETH1) = 
DISK:/db1/db2inst1/sample/arc2/test2/ 
 Second log archive method                (LOGARCHMETH2) = 
DISK:/db1/db2inst1/sample/arc2/test1/

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using db2relocatedb command                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 10 or higher.            * 
****************************************************************

First fixed in DB2 Version 9.7 Fix Pack 10.

keiner bekannt / siehe Local-Fix

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

07.05.2014
01.12.2014
01.12.2014

9.7.FP10