IBM Support

50 DB2 Nuggets #23 : Tech Tip - db2pd -ha command fails

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":"BU029","label":"Data and AI"}, "Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11141546