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