Home

Neueste Versionen	FixList
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren
Kontaktformular

DB2 - Problembeschreibung

Problem IC76327	Status: Geschlossen
IN DPF ENVIRONMENT, CREATE INDEX ON CGTT COLLECT ... STATISTICS LEADS TO DB MARKED BAD
Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
In DPF environment, when CREATE INDEX is executed for a Created Global Temporary Tables (CGTT) and the COLLECT ... STATISTICS clause is specified, the database may encounter SQL1034C and is marked bad. This problem does not occur in serial mode. In the db2diag.log, there will be messages about "invalid pool ID" e.g. 2011-05-05-12.43.29.962968-300 I1130222127E487 LEVEL: Error PID : 28517 TID : 47089295812928PROC : db2sysc 1 INSTANCE: db2inst1 NODE : 001 DB : SAMPLE APPHDL : 0-58125 APPID: 10.30.60.210.3518.110505171433 AUTHID : DB2USER EDUID : 154073 EDUNAME: db2agntp (SAMPLE) 1 FUNCTION: <0>, <0>, <0>, probe:10 DATA #1 : String, 39 bytes sqlbGetPoolDefFromPtbl: Invalid poolID: DATA #2 : signed integer, 4 bytes 65530 ... 2011-05-05-12.43.30.172512-300 I1130233877E4115 LEVEL: Severe PID : 28517 TID : 47089295812928PROC : db2sysc 1 INSTANCE: db2inst1 NODE : 001 DB : SAMPLE APPHDL : 0-58125 APPID: 10.30.60.210.3518.110505171433 AUTHID : DB2USER EDUID : 154073 EDUNAME: db2agntp (SAMPLE) 1 FUNCTION: DB2 UDB, data management, sqldGetTableData, probe:157 MESSAGE : ZRC=0x87020076=-2029911946=SQLB_INV_POOLID "Invalid pool ID" DATA #1 : Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes 65530 DATA #2 : objectID, PD_TYPE_SQLD_OBJECT_ID, 2 bytes 0x802F DATA #3 : objectClass, PD_TYPE_SQLD_OBJECT_CLASS, 1 bytes SQLB_PERMANENT DATA #4 : Hexdump, 528 bytes 0x00002AD3D4BFC350 : 0800 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC360 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC370 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC380 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC390 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC3A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC3B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC3C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC3D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC3E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC3F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC400 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC410 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC420 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC430 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC440 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC450 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC460 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC470 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC480 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC490 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC4A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC4B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC4C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC4D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC4E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC4F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC500 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC510 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC520 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC530 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC540 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AD3D4BFC550 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ CALLSTCK: [0] 0x00002AD231B03F98 pdLog + 0x398 [1] 0x00002AD231BC2A87 _Z16sqldGetTableDataP8sqeAgenttththjPciS1_iP15SQLD_TABLE_DATA + 0x67B [2] 0x00002AD233B37A08 _Z8sqlrkrtcP8sqlrr_cbP13SQLR_RPC_DRTDP17SQLR_RPCRPLY_DRTD + 0x106 [3] 0x00002AD233B4AEEB _Z20sqlrl_rpc_dms_routerP8sqlrr_cbP16sqlkdRqstRplyFmtiP15SQLR_RP CMESSAGE + 0x643 [4] 0x00002AD233687CC3 _Z16sqlrr_rpc_routerP8sqlrr_cb + 0x4FD [5] 0x00002AD2336892CF _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xD9B [6] 0x00002AD2328E2B98 _Z20sqleSubRequestRouterP8sqeAgentPjS1_ + 0x672 [7] 0x00002AD2328E3610 _Z21sqleProcessSubRequestP8sqeAgent + 0xA6 [8] 0x00002AD231C1DA84 _ZN8sqeAgent6RunEDUEv + 0x630 [9] 0x00002AD23228BFC8 _ZN9sqzEDUObj9EDUDriverEv + 0xA6 2011-05-05-12.43.30.194813-300 I1130237993E476 LEVEL: Severe PID : 28517 TID : 47089295812928PROC : db2sysc 1 INSTANCE: db2inst1 NODE : 001 DB : SAMPLE APPHDL : 0-58125 APPID: 10.30.60.210.3518.110505171433 AUTHID : DB2USER EDUID : 154073 EDUNAME: db2agntp (SAMPLE) 1 FUNCTION: DB2 UDB, global services, sqlzeMapZrc, probe:45 MESSAGE : ZRC=0x87020076=-2029911946=SQLB_INV_POOLID "Invalid pool ID"
Problem-Zusammenfassung:
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * In DPF environment, when CREATE INDEX is executed for a * * Created Global Temporary Tables (CGTT) and the COLLECT ... * * STATISTICS clause is specified, the database may encounter * * SQL1034C and is marked bad * **************************************************************** * RECOMMENDATION: * * Update to Version 9.7 Fix Pack 5 * ****************************************************************
Local-Fix:
Remove the "collect ... statistics" clause from the CREATE INDEX statement, as it is a no-op for CGTT
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
Problem was first fixed in Version 9.7 Fix Pack 5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung:	11.05.2011 19.01.2012 19.01.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5