Technical Blog Post
Abstract
50 DB2 Nuggets #23 : Tech Tip - db2pd -ha command fails
Body
When running:
db2pd -ha
command fails with:
"Changing data structure forced command termination."
The db2diag.log shows the following:
2014-04-15-12.40.52.576033+000 E1831A690 LEVEL: Error
PID : 34275574 TID : 1 PROC : db2pd
INSTANCE: test006 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure,
sqlhaGetParentResourceGroup, probe:300
MESSAGE : ECF=0x90000557=-1879046825=ECF_SQLHA_CLUSTER_ERROR Error reported from Cluster
DATA #1 : String, 35 bytes
Error during vendor call invocation
DATA #2 : unsigned integer, 4 bytes
34
DATA #3 : String, 33 bytes
db2_test006_test006_TST00I-rs
DATA #4 : unsigned integer, 8 bytes
1
DATA #5 : signed integer, 4 bytes
0
DATA #6 : String, 48 bytes
Line # : 11171---2610-400 Resource not defined
Check the TSA lssam output for something like:
Unknown IBM.ResourceGroup:db2_test_tss2dba2232ibm_0-rg Nominal=Online
Unknown IBM.ResourceGroup:db2_test006_test006_TST00I-rg Nominal=Online
Run the following commands to fix this issues:
1.) export CT_MANAGEMENT_SCOPE=2
2.) rmrg db2_test_tss2dba2232ibm_0-rg
3.) rmrg db2_test006_test006_TST00I-rg
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
UID
ibm11141546