| 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 IC95871 | Status: Closed |
TRAP(SIGSEGV) DURING A NONPARTITIONED BLOCK INDEX SCAN ON A MDC & RANGE PARTITIONED TABLE IN DPF & SMP ENVIRONMENT | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
A trap may occur on the non-catalog node in DPF (Data
Partitioning Feature) when doing a SMP (INTRA_PARALLEL ON) BLOCK
index scan on an MDC (Multidimensional clustering) and Range
partitioned table which has nonpartitioned block indexes.
Partitioned block indexes are the default since DB2 v9.7, so to
have nonpartitioned block indexes the table must have been
created prior to DB2 v9.7.
The stack for the trap will look similar to the following:
0x00002AAAB1B9842F sqloEDUCodeTrapHandler + 0x025f
(/home/user/sqllib/lib64/libdb2e.so.1)
0x00002AAAAABD4D60 address: 0x00002AAAAABD4D60 ; dladdress:
0x00002AAAAABC7000 ; offset in lib: 0x000000000000DD60 ;
(/lib64/libpthread.so.0)
0x00002AAAABCAA0E2
_Z29sqlbGetAdjustedPrefetchAmountP12SQLB_GLOBALSt + 0x0062
(/home/user/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC010AED
_Z22sqldmGetPrefetchAmountP8sqeAgentP8SQLD_CCBtPj + 0x024d
(/home/user/sqllib/lib64/libdb2e.so.1)
0x00002AAAB07618EE
_Z17sqldSetupParIScanP8sqeAgentP9SQLD_IXCBP10SQLI_IXPCRP8SQLD_CC
BP8SQLD_TCBtmP9sqlri_DSO + 0x023e
(/home/user/sqllib/lib64/libdb2e.so.1)
0x00002AAAB07628B6
_Z26sqldSetupParallelIndexScanP8sqeAgentP8SQLD_CCBP9SQLD_IXCBP10
SQLI_IXPCRP8SQLD_TCBjti + 0x0786
(/home/user/sqllib/lib64/libdb2e.so.1)
0x00002AAAB0764163 address: 0x00002AAAB0764163 ; dladdress:
0x00002AAAAACE0000 ; offset in lib: 0x0000000005A84163 ;
(/home/user/sqllib/lib64/libdb2e.so.1)
0x00002AAAB0766437
_Z12sqldScanOpenP8sqeAgentP14SQLD_SCANINFO1P14SQLD_SCANINFO2PPv
+ 0x0c37
(/home/user/sqllib/lib64/libdb2e.so.1) | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users using both Database Partitioning feature (DPF) and SMP * * (i.e. INTRA_PARALLEL ON) * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.5.0.3. * **************************************************************** | |
| Local Fix: | |
To fix the issue you may either turn off SMP (set INTRA_PARALLEL OFF) or drop and recreate the table so that the block indexes are recreated as partitioned block indexes. | |
| available fix packs: | |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows | |
| Solution | |
The problem is first fixed in DB2 version 10.5.0.3. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.09.2013 08.09.2014 08.09.2014 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.4 |
|
