Home

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

Have problems? - contact us.
Register for free
Contact form

DB2 - Problem description

Problem IC76327	Status: Closed
IN DPF ENVIRONMENT, CREATE INDEX ON CGTT COLLECT ... STATISTICS LEADS TO DB MARKED BAD
product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
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. 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 Summary:
**************************************************************** * 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
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
Problem was first fixed in Version 9.7 Fix Pack 5
Workaround
not known / see Local fix
Timestamps
Date - problem reported : Date - problem closed : Date - last modified :	11.05.2011 19.01.2012 19.01.2012
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