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 IC77797 Status: Geschlossen

VLDB - TRAP DURING ONLINE ADDNODE WITH CORRUPTED NODE AND
SQKFCOMMSESSION::UPDATEPITNODEINFORMATIO, PROBE:666

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
This specific issue (trap) was hit during the online addnode on 
VLDB testing with the following symptom: 
 
 several occurrences of 
2010-11-23-08.31.13.614898-300 I777322341A537     LEVEL: Severe 
PID     : 222176               TID  : 19535       PROC : db2sysc 
0 
INSTANCE: bcuaix               NODE : 000         DB   : 
VLDBMAIN 
APPHDL  : 0-92                 APPID: *N0.DB2.101121005837 
AUTHID  : BCUAIX 
EDUID   : 19535                EDUNAME: db2wlmd (VLDBMAIN) 0 
FUNCTION: DB2 UDB, buffer dist serv, sqlkdDispatchRequest, 
probe:60 
DATA #1 : String, 56 bytes 
Sending to (61) more nodes than defined in db2nodes.cfg. 
DATA #2 : Codepath, 8 bytes 
1:3:4:6:7:9:11:14:15 
 
several occurrences of: 
 
2010-11-23-09.04.22.711651-300 I816560A417        LEVEL: Severe 
PID     : 1041308              TID  : 3396        PROC : db2sysc 
314 
INSTANCE: bcuaix               NODE : 314 
APPHDL  : 0-16403 
EDUID   : 3396                 EDUNAME: db2agntp 314 
FUNCTION: DB2 UDB, fast comm manager, 
sqkfCommSession::UpdatePITNodeInformatio, probe:666 
DATA #1 : <preformatted> 
Error in inheriting node bitmap  cPITMaxNodeNumber=2304 
 
Note: 
- we do assert before the probe 666 above to make sure that 
cPITMaxNodeNumber < SQLZ_PDB_MAX_NUM_NODE 
- SQLZ_PDB_MAX_NUM_NODE is 1000
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DPF                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* This specific issue (trap) was hit during the online addnode * 
* on                                                           * 
* VLDB testing with the following symptom:                     * 
*                                                              * 
*                                                              * 
*                                                              * 
* several occurrences of                                       * 
*                                                              * 
* 2010-11-23-08.31.13.614898-300 I777322341A537    LEVEL:      * 
* Severe                                                       * 
* PID    : 222176              TID  : 19535      PROC :        * 
* db2sysc                                                      * 
* 0                                                            * 
*                                                              * 
* INSTANCE: bcuaix              NODE : 000        DB  :        * 
* VLDBMAIN                                                     * 
*                                                              * 
* APPHDL  : 0-92                APPID: *N0.DB2.101121005837    * 
*                                                              * 
* AUTHID  : BCUAIX                                             * 
*                                                              * 
* EDUID  : 19535                EDUNAME: db2wlmd (VLDBMAIN) 0  * 
*                                                              * 
* FUNCTION: DB2 UDB, buffer dist serv, sqlkdDispatchRequest,   * 
*                                                              * 
* probe:60                                                     * 
*                                                              * 
* DATA #1 : String, 56 bytes                                   * 
*                                                              * 
* Sending to (61) more nodes than defined in db2nodes.cfg.     * 
*                                                              * 
* DATA #2 : Codepath, 8 bytes                                  * 
*                                                              * 
* 1:3:4:6:7:9:11:14:15                                         * 
*                                                              * 
*                                                              * 
*                                                              * 
* several occurrences of:                                      * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2010-11-23-09.04.22.711651-300 I816560A417        LEVEL:     * 
* Severe                                                       * 
* PID    : 1041308              TID  : 3396        PROC :      * 
* db2sysc                                                      * 
* 314                                                          * 
*                                                              * 
* INSTANCE: bcuaix              NODE : 314                     * 
*                                                              * 
* APPHDL  : 0-16403                                            * 
*                                                              * 
* EDUID  : 3396                EDUNAME: db2agntp 314           * 
*                                                              * 
* FUNCTION: DB2 UDB, fast comm manager,                        * 
*                                                              * 
* sqkfCommSession::UpdatePITNodeInformatio, probe:666          * 
*                                                              * 
* DATA #1 : <preformatted>                                     * 
*                                                              * 
* Error in inheriting node bitmap  cPITMaxNodeNumber=2304      * 
*                                                              * 
*                                                              * 
*                                                              * 
* Note:                                                        * 
*                                                              * 
* - we do assert before the probe 666 above to make sure that  * 
*                                                              * 
* cPITMaxNodeNumber < SQLZ_PDB_MAX_NUM_NODE                    * 
*                                                              * 
* - SQLZ_PDB_MAX_NUM_NODE is 1000                              * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
* Metin suggested that there has to be some boundary condition * 
* it                                                           * 
* is leading us to evaluate  bitmap based on unsent/corrupt    * 
* start                                                        * 
* using information. So he provided this fix and tested again  * 
* on                                                           * 
* VLDB and this specific issue did not occur anymore           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to db2 version 9.7 fp5                               * 
****************************************************************
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
fix in v97fp5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
28.07.2011
08.12.2011
08.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList