|
Problem IC81993
|
Status: Closed |
WHEN STARTING DB2 USING THE DB2START COMMAND ON A BUSY SYSTEM, NOT ALL DB2 DATABASE PARTITION RESOURCE GROUPS ARE UNLOCKED. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
After issuing a db2start command as the instance owner, TSA MP
does not unlock some database partitions, and the DB2 partition
resource remains offline. Furthermore, the following db2diag.log
message is seen for the affected partition during db2start
processing:
2012-01-01-12.00.00.000000-xxx E39330513A727 LEVEL: Error
PID : 975766 TID : 1 PROC : db2stop2
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure,
sqlhaEnableResourceGroup, probe:500
MESSAGE :
ECF=0x90000550=-1879046832=ECF_SQLHA_ENABLE_GROUP_FAILED
Error unlocking resource group
DATA #1 : String, 43 bytes
Cluster Error during vendor call invocation
DATA #2 : unsigned integer, 4 bytes
18
DATA #3 : String, 17 bytes
db2_db2inst1_0-rg
DATA #4 : unsigned integer, 8 bytes
1
DATA #5 : signed integer, 4 bytes
0
DATA #6 : String, 84 bytes
Line # : 5896---db2haGetGroupLockState timeout, group could not
be verified enabled |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Large multi-partition clustered DB2 environments. *
****************************************************************
* PROBLEM DESCRIPTION: *
* In a large clustered DB2 HA environment (TSA), the db2start *
* command does not successfully unlock all DB2 database *
* partition resource groups. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V9.7.0.6 *
**************************************************************** |
| Local Fix: |
Re-issue the db2start command until all DB2 partition resource
groups are succesfully unlocked. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
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 |
Upgrade to V9.7.0.6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.03.2012
04.06.2012
04.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.0.6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
