DB2 FOR LUW / DB2FORLUW / 970 - DB2

Takeover does not occur after changing logpath and mirror 
logpath. 
 
In HADR environment, if we follow the steps below 
1. change the logpath in the primary and standby 
2. deactivate db and stop instance on standby 
3. start instance and activate db on standby 
4. issue takeover command on standby, but get error message on 
the standby 
 
$ db2 takeover hadr on db tst2 
SQL0902C  A system error (reason code = "") occurred. 
Subsequent SQL statements cannot be processed. 
 
- db2diag.log message 
---------------------------------------------------------------- 
--------------- 
2013-04-30-13.41.34.555907+540 I191574A545        LEVEL: Severe 
PID     : 26773                TID  : 2199371376976PROC : 
db2sysc 0 
INSTANCE: *********             NODE : 000         DB   : ***** 
EDUID   : 24                   EDUNAME: db2loggr (*******) 0 
FUNCTION: DB2 UDB, data protection services, sqlpgarl, 
probe:2780 
MESSAGE : BADLSN: RelativeByte 309998473472, ByteOffset 2514, 
PageNumber 3, 
          extNum 76, ReadCount 1, rc1 3 Loop(i) 0, BlkOffset 4 
lastDiskLso 
          1271722668 HighPso 000000004C2C3010 LowPso 
000000004C2C2010 
---------------------------------------------------------------- 
---------------

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

Before activating standby, copy the log files in the old 
logpath to new logpath manually.

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 Version 9.7 Fix Pack 9.

keiner bekannt / siehe Local-Fix

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

30.05.2013
10.12.2013
10.12.2013

9.7.FP9