DB2 - Problembeschreibung
Problem IC77438 | Status: Geschlossen |
DB2HAICU SeTUP FAILURE ON CREATION OF 129TH PARTITION | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * db2haicu users on large systems with over 128 total NICs in * * the system. * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 5 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 Version 9.7 Fix Pack 5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 11.07.2011 19.12.2011 19.12.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP5 | |
Problem behoben lt. FixList in der Version | |
9.7.0.5 |