|
Problem IC62384
|
Status: Closed |
IN DPF ENVIRONMENT, REORG WITHOUT INDEXSCAN OPTION ON THE TABLE WITH CLUSTERING INDEX TRAPS IN SQLDREORGTABLESCANSORT |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
In DPF Environment, reorg without indexscan option on the table
with large number of columns with clustering index traps in
sqldReorgTableScanSort
The stack in trap file would look like this:
<StackTrace>
-------Frame------ ------Function + Offset------
0x0900000013187A20
@101@sqldReorgTableScanSort__FP13SQLD_REORG_CB + 0xD48
0x0900000013186A4C @101@sqldReorgAllRecords__FP13SQLD_REORG_CB +
0x8C
0x0900000013185CFC
@101@sqldReorgDriver__FP8sqeAgentP8SQLD_TCBP9SQLD_IXCBP9SQLD_IDE
FPcUliUsT8P8SQLP_LSNT7P14SQLP_LOCK_INFO + 0x3C8
0x090000001318435C
@101@sqldTableReorgObject__FP8sqeAgentP8SQLD_TCBP14SQLP_LOCK_INF
OUsN24UcUliN34P9SQLD_IDEFPcT9T14_T9P8SQLP_LSNT9 + 0xDFC
0x0900000013181A7C
sqldTableReorg__FP8sqeAgentUsT2UcUliN32P9SQLD_IDEFT6PcT6T12_T6Pi
P8SQLP_LSNT6 + 0xF2C
0x0900000012A0D450
sqlrreorg_table__FP8sqlrr_cbUsT2P8sqlrg_idiT5UlN25sPUcT5T11_T5T1
0_UcT5 + 0x1414
0x0900000012A51DE4
sqlrreorg_getinfo__FP8sqlrr_cbP16sqlkdRqstRplyFmti + 0x56C
0x09000000129CB9A8 sqlrr_rpc_router__FP8sqlrr_cb + 0x584
0x09000000129BEA78
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xF8C
0x09000000129BACCC sqleSubRequestRouter__FP8sqeAgentPUiT2 +
0x7DC
0x09000000129B9EE8 sqleProcessSubRequest__FP8sqeAgent + 0x124
0x0900000010ED50BC RunEDU__8sqeAgentFv + 0x300
0x09000000110D7C08 EDUDriver__9sqzEDUObjFv + 0x94
0x09000000110D1BD0 sqloEDUEntry + 0x54C
</StackTrace> |
| Problem Summary: |
The problem occured due to uninitialized pointer in the sort
code. |
| Local Fix: |
Use reorg with indexscan option or remove clustering index on
table. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows
|
| Solution |
The problem has been corrected. The APAR fix is available in Fix
Pack 1. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.08.2009
07.01.2010
07.01.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
