|
Problem IC87585
|
Status: Closed |
HADR RESOURCE GROUP REMAINS LOCKED AFTER SUCCESSFUL HADR REINTEGRATION. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
After a successful HADR pair reintegration, the HADR resource
group(RG) will be locked. In addition to this, there is a stray
IBM.Test resource which does not get cleaned up:
$ lsrsrc -Ab IBM.Test
Resource Persistent and Dynamic Attributes for IBM.Test
resource 1:
Name =
"db2_HADRDB__Reintegrate_DB2INST1_db2inst1"
ResourceType = 0
AggregateResource = "0x3fff 0xffff 0x00000000 0x00000000
0x00000000 0x00000000"
ForceOpState = 0
TimeToStart = 0
TimeToStop = 0
WriteToSyslog = 0
MoveTime = 0
MoveFail = 0
ForceMoveState = 0
ActivePeerDomain = "db2HADRdomain"
NodeNameList = {"nodeA"}
OpState = 2
ConfigChanged = 0
ChangedAttributes = {}
MoveState = [0,{}]
OpQuorumState = 0
This occurs if the value of the database configuration
parameter HADR_REMOTE_INST is set in upper-case letters.
For example:
$ db2 get db cfg for HADRDB | grep HADR_REMOTE_INST
HADR instance name of remote server (HADR_REMOTE_INST) =
DB2INST1
This will not affect HADR as both HADR pair servers will be in
peer state. However, the RG will need to be unlocked by
issuing: "rgreq -o unlock <ResourceGroupName>"
The state of the HADR RG from lssam output will look like this:
Online IBM.ResourceGroup:db2_db2ins1_db2inst1_HADRDB-rg
Request=Lock Nominal=Online
|- Online
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs
Control=SuspendedPropagated
|- Online
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs:nodeA
'- Offline
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs:nodeB |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to DB2 Version V9.7 FP8 *
**************************************************************** |
| Local Fix: |
Change the value of the HADR_REMOTE_INST db cfg parameter from
upper-casing to lower-casing. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
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 |
Fixed in DB2 Version V9.7 FP8 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC89722
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.10.2012
15.02.2013
15.02.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
