db2haicu was run against an xml file and failed while creating
the 129th partition.
On closer inspection it looks like the partition resources were
not created for partition 152. (3 standby nodes with 8
partitions not configured HENCE 152 is 129th partition to be
created)
Successful Example: Partition resources were created for
Partiion 151.
$ lssam | grep 151
Online IBM.ResourceGroup:db2_bcuaix_151-rg Nominal=Online
|- Online IBM.Application:db2_bcuaix_151-rs
|- Online
IBM.Application:db2_bcuaix_151-rs:vldbdata901
'- Offline
IBM.Application:db2_bcuaix_151-rs:vldbdta1003
|- Online
IBM.Application:db2mnt-db2fs_bcuaix_NODE0151-rs
|- Online
IBM.Application:db2mnt-db2fs_bcuaix_NODE0151-rs:vldbdata901
'- Offline
IBM.Application:db2mnt-db2fs_bcuaix_NODE0151-rs:vldbdta1003
'- Online
IBM.Application:db2mnt-db2path_bcuaix_NODE0151-rs
|- Online
IBM.Application:db2mnt-db2path_bcuaix_NODE0151-rs:vldbdata901
'- Offline
IBM.Application:db2mnt-db2path_bcuaix_NODE0151-rs:vldbdta1003
Online IBM.Equivalency:db2_bcuaix_151-rg_group-equ
Failed Example: Partition resources were NOT created for
Partiion 152
$ lssam | grep 152
Online IBM.ResourceGroup:db2_bcuaix_152-rg Nominal=Online
'- Online IBM.Application:db2_bcuaix_152-rs
|- Online
IBM.Application:db2_bcuaix_152-rs:vldbdata901
'- Offline
IBM.Application:db2_bcuaix_152-rs:vldbdta1003
Online IBM.Equivalency:db2_bcuaix_152-rg_group-equ
****************************************************************
****************************************************************
Steps:
Run "db2haicu -f filecontaining471partitions.xml"
Expected Result:
db2haicu processes all the data in xml file and creates the HA
domain with those characteristics
Actual Result:
db2haicu fails after part creating the 129th partition (Note it
gives a successful message for 152 when it is not successful,
seperate defect to be logged)
Adding DB2 database partition 151 to the cluster was successful.
Adding DB2 database partition 152 to the cluster ...
Adding DB2 database partition 152 to the cluster was successful.
There was an error with one of the issued cluster manager
commands. Refer to db2diag.log and the DB2 Information Center
for details.
There was an internal db2haicu error. Refer to db2diag.log and
the DB2 Information Center for details.
The db2diag.log contains this error:
2011-06-29-13.11.31.510504-240 E299205635A390 LEVEL: Error
PID : 451138 TID : 1 PROC :
db2haicu
INSTANCE: bcuaix NODE : 000
EDUID : 1
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure,
sqlhaGetInfoForDB2Partition, probe:70
RETCODE :
ECF=0x90000552=-1879046830=ECF_SQLHA_OBJECT_DOES_NOT_EXIST
Cluster object does not exist
2011-06-29-13.11.31.532178-240 E299206026A390 LEVEL: Info
PID : 451138 TID : 1 PROC :
db2haicu
INSTANCE: bcuaix NODE : 000
EDUID : 1
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure,
sqlhaGetInfoForDB2Partition, probe:160
RETCODE :
ECF=0x90000552=-1879046830=ECF_SQLHA_OBJECT_DOES_NOT_EXIST
Cluster object does not exist
2011-06-29-13.11.31.532583-240 E299206417A475 LEVEL: Error
PID : 451138 TID : 1 PROC :
db2haicu
INSTANCE: bcuaix NODE : 000
EDUID : 1
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure,
sqlhaUIListAllPartitionsInClus, probe:300
RETCODE :
ECF=0x90000552=-1879046830=ECF_SQLHA_OBJECT_DOES_NOT_EXIST
Cluster object does not exist
MESSAGE : Could not retrieve info for Partition
DATA #1 : String, 6 bytes
bcuaix
2011-06-29-13.11.31.532714-240 E299206893A427 LEVEL: Error
PID : 451138 TID : 1 PROC :
db2haicu
INSTANCE: bcuaix NODE : 000
EDUID : 1
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure,
sqlhaUIListAllPartitionsInClus, probe:300
RETCODE :
ECF=0x90000552=-1879046830=ECF_SQLHA_OBJECT_DOES_NOT_EXIST
Cluster object does not exist
DATA #1 : String, 6 bytes
bcuaix
2011-06-29-13.11.31.532847-240 E299207321A393 LEVEL: Error
PID : 451138 TID : 1 PROC :
db2haicu
INSTANCE: bcuaix NODE : 000
EDUID : 1
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure,
sqlhaUICheckIfPartitionInClus, probe:200
RETCODE :
ECF=0x90000552=-1879046830=ECF_SQLHA_OBJECT_DOES_NOT_EXIST
Cluster object does not exist
2011-06-29-13.11.31.533620-240 E299207715A582 LEVEL: Severe
PID : 451138 TID : 1 PROC :
db2haicu
INSTANCE: bcuaix NODE : 000
EDUID : 1
FUNCTION: DB2 Common, SQLHA APIs for DB2 HA Infrastructure,
handleEndElement, probe:1470
MESSAGE :
ECF=0x90000552=-1879046830=ECF_SQLHA_OBJECT_DOES_NOT_EXIST
Cluster object does not exist
DATA #1 : String, 47 bytes
Error in sqlhaUICheckIfPartitionInClus () Call.
DATA #2 : String, 24 bytes
/db2path/bcuaix/NODE0152
DATA #3 : unsigned integer, 4 bytes
152
DATA #4 : String, 6 bytes
bcuaix |
