|
Problem IC92691
|
Status: Closed |
TAKEOVER DOES NOT OCCUR AFTER CHANGING LOGPATH IN THE STANDBY |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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
----------------------------------------------------------------
--------------- |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 9. *
**************************************************************** |
| Local Fix: |
Before activating standby, copy the log files in the old
logpath to new logpath manually. |
| available fix packs: |
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
|
| Solution |
First fixed in Version 9.7 Fix Pack 9. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 30.05.2013
10.12.2013
10.12.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.9
|
 |
| 9.7.0.9
|
|
