home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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

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 FixList