|
Problem IC95871
|
Status: Geschlossen |
TRAP(SIGSEGV) DURING A NONPARTITIONED BLOCK INDEX SCAN ON A MDC & RANGE PARTITIONED TABLE IN DPF & SMP ENVIRONMENT |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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. |
| verfügbare FixPacks: |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Lösung |
The problem is first fixed in DB2 version 10.5.0.3. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 10.09.2013
08.09.2014
08.09.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.4
|
 |
