DB2 - Problembeschreibung
| Problem IC82515 | Status: Geschlossen |
HOSTNAME CONTAINING THE UNDERSCORE CHARACTER CAUSES SQL1517N DURING DB2START | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
| Problembeschreibung: | |
A hostname containing the underscore character '_' causes DB2 to
fail to start the instance with the following error code:
"SQL1517N db2start failed because the cluster manager resource
states are inconsistent." The following diag.log messages are
also seen:
2012-04-03-10.37.53.434010+480 I48263A457 LEVEL: Error
PID : 4718810 TID : 1 PROC :
db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: xxxxxxxx
EDUID : 1
FUNCTION: DB2 UDB, high avail services,
sqlhaVerifyClusterObject, probe:16055
MESSAGE : CF parent group nodes does not match CF Control
resource
DATA #1 : String, 0 bytes
Object not dumped: Address: 0x0000000110240810 Size: 0 Reason:
Zero-length data
2012-04-03-10.37.53.434379+480 E48721A287 LEVEL: Error
PID : 4718810 TID : 1 PROC :
db2start
INSTANCE: db2inst1 NODE : 000
HOSTNAME: xxxxxxxx
EDUID : 1
FUNCTION: DB2 UDB, high avail services,
sqlhaVerifyClusterResources, probe:15351
Issuing the "db2instance -list" command will also generate the
following error: "The member, CF, or host information could not
be obtained. Check the db2diag.log for more information." The
following messages will be seen in the diag.log in this case:
2012-04-03-10.10.42.784883+480 I8638A356 LEVEL: Error
PID : 5177514 TID : 1 PROC :
db2instance
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: <0>, <0>, <0>, probe:100
RETCODE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt
invalid size"
DIA8563C An invalid memory size was requested.
2012-04-03-10.10.42.785260+480 I8995A575 LEVEL: Error
PID : 5177514 TID : 1 PROC :
db2instance
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, high avail services, sqlhaDB2HostClustered,
probe:6138
RETCODE : ECF=0x9000052E=-1879046866=ECF_SQLHA_FAILED
SQLHA API call error
DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
0x820F0004
DATA #2 : String, 0 bytes
Object not dumped: Address: 0x0FFFFFFFFFFFE3E0 Size: 0 Reason:
Zero-length data
DATA #3 : String, 8 bytes
db2inst1
DATA #4 : unsigned integer, 8 bytes
0
2012-04-03-10.10.42.818217+480 I9571A538 LEVEL: Error
PID : 5177514 TID : 1 PROC :
db2instance
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, high avail services, sqlhaSysProcDB2Host,
probe:6819
RETCODE : ECF=0x9000052E=-1879046866=ECF_SQLHA_FAILED
SQLHA API call error
DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
0x00000000
DATA #2 : String, 0 bytes
Object not dumped: Address: 0x0FFFFFFFFFFFE3E0 Size: 0 Reason:
Zero-length data
DATA #3 : unsigned integer, 8 bytes
0 | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * A hostname containing the underscore character '_' causes * * DB2 to * * fail to start the instance with the following error code: * * "SQL1517N db2start failed because the cluster manager * * resource * * states are inconsistent." The following diag.log messages * * are * * also seen: * * * * 2012-04-03-10.37.53.434010+480 I48263A457 LEVEL: * * Error * * PID : 4718810 TID : 1 PROC : * * db2start * * INSTANCE: db2inst1 NODE : 000 * * HOSTNAME: xxxxxxxx * * EDUID : 1 * * FUNCTION: DB2 UDB, high avail services, * * sqlhaVerifyClusterObject, probe:16055 * * MESSAGE : CF parent group nodes does not match CF Control * * resource * * DATA #1 : String, 0 bytes * * Object not dumped: Address: 0x0000000110240810 Size: 0 * * Reason: * * Zero-length data * * * * 2012-04-03-10.37.53.434379+480 E48721A287 LEVEL: * * Error * * PID : 4718810 TID : 1 PROC : * * db2start * * INSTANCE: db2inst1 NODE : 000 * * HOSTNAME: xxxxxxxx * * EDUID : 1 * * FUNCTION: DB2 UDB, high avail services, * * sqlhaVerifyClusterResources, probe:15351 * * * * * * Issuing the "db2instance -list" command will also generate * * the * * following error: "The member, CF, or host information could * * not * * be obtained. Check the db2diag.log for more information." * * The * * following messages will be seen in the diag.log in this * * case: * * * * 2012-04-03-10.10.42.784883+480 I8638A356 LEVEL: * * Error * * PID : 5177514 TID : 1 PROC : * * db2instance * * INSTANCE: db2inst1 NODE : 000 * * EDUID : 1 * * FUNCTION: <0>, <0>, <0>, probe:100 * * RETCODE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt * * invalid size" * * DIA8563C An invalid memory size was requested. * * * * 2012-04-03-10.10.42.785260+480 I8995A575 LEVEL: * * Error * * PID : 5177514 TID : 1 PROC : * * db2instance * * INSTANCE: db2inst1 NODE : 000 * * EDUID : 1 * * FUNCTION: DB2 UDB, high avail services, * * sqlhaDB2HostClustered, * * probe:6138 * * RETCODE : ECF=0x9000052E=-1879046866=ECF_SQLHA_FAILED * * SQLHA API call error * * DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes * * 0x820F0004 * * DATA #2 : String, 0 bytes * * Object not dumped: Address: 0x0FFFFFFFFFFFE3E0 Size: 0 * * Reason: * * Zero-length data * * DATA #3 : String, 8 bytes * * db2inst1 * * DATA #4 : unsigned integer, 8 bytes * * 0 * * * * 2012-04-03-10.10.42.818217+480 I9571A538 LEVEL: * * Error * * PID : 5177514 TID : 1 PROC : * * db2instance * * INSTANCE: db2inst1 NODE : 000 * * EDUID : 1 * * FUNCTION: DB2 UDB, high avail services, sqlhaSysProcDB2Host, * * probe:6819 * * RETCODE : ECF=0x9000052E=-1879046866=ECF_SQLHA_FAILED * * SQLHA API call error * * DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes * * 0x00000000 * * DATA #2 : String, 0 bytes * * Object not dumped: Address: 0x0FFFFFFFFFFFE3E0 Size: 0 * * Reason: * * Zero-length data * * DATA #3 : unsigned integer, 8 bytes * * 0 * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V98FP5 or higher version. * **************************************************************** | |
| Local-Fix: | |
If possible, change the hostname so that it does not contain the underscore character. Otherwise, contact IBM support. | |
| Lösung | |
The problem was fixed on DB2 V98FP5 or higher version. | |
| Workaround | |
If possible, change the hostname so that it does not contain the underscore character. Otherwise, contact IBM support. | |
| Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC87849 Nachfolger : | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 04.04.2012 11.07.2012 11.07.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.8.FP5 | |
| Problem behoben lt. FixList in der Version | |
| 9.8.0.5 |
|