|
Problem IC77797
|
Status: Closed |
VLDB - TRAP DURING ONLINE ADDNODE WITH CORRUPTED NODE AND SQKFCOMMSESSION::UPDATEPITNODEINFORMATIO, PROBE:666 |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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 |
| Problem Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
fix in v97fp5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.07.2011
08.12.2011
08.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
