home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC82515 Status: Closed

HOSTNAME CONTAINING THE UNDERSCORE CHARACTER CAUSES SQL1517N DURING
DB2START

product:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
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
Problem Summary:
**************************************************************** 
* 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.
Solution
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-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC87849 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
04.04.2012
11.07.2012
11.07.2012
Problem solved at the following versions (IBM BugInfos)
9.8.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.8.0.5 FixList