DB2 FOR LUW / DB2FORLUW / 970 - DB2

This problem occurs when a reorg operation on altered 
column is performed on a partitioned table which has outstanding 
asynchronized Index Cleaning (AIC) jobs. DB2 instance crashed 
with the following in db2diag.log: 
 
2011-05-09-00.15.50.106430-300 E8796E1368         LEVEL: Severe 
PID     : 21982                TID  : 47712760678304PROC : 
db2taskp (TWHPR1) 0 
INSTANCE: twhpr00              NODE : 000         DB   : TWHPR1 
APPHDL  : 0-20                 APPID: *LOCAL.DB2.110509051557 
AUTHID  : TWHPR00 
FUNCTION: DB2 UDB, SQO Memory Management, 
sqloDiagnoseFreeBlockFailure, probe:999 
MESSAGE : Memory validation failure, diagnostic file dumped. 
DATA #1 : String, 28 bytes 
Corrupt pool free tree node. 
DATA #2 : File name, 24 bytes 
p21982t0_diagnostics.mem 
CALLSTCK: 
  [0] 0x00002B64F715C0DF 
_ZN8SMemPool32diagnoseMemoryCorruptionAndCrashEmPKc + 0x1EF 
  [1] 0x00002B64F8466AE3 
_ZN8SMemPool10MemTreeGetEmmPPvPP17SqloChunkSubgroupPP12SMemLostN 
ode 
+ 0x57B 
  [2] 0x00002B64F84672E6 
_ZN8SMemPool19allocateMemoryBlockEmmmjmPPvPP17SqloChunkSubgroupP 
P12SMemLostNodeP12SMemLogEvent 
+ 0xCE 
  [3] 0x00002B64F84653BE sqlogmblkEx + 0x3DE 
  [4] 0x00002B64F6B9B6DA 
_Z18sqliGetKeyWorkAreaP17SQLI_KEY_WORKAREAP10SQLI_IDXCBm + 0x10A 
  [5] 0x00002B64F7E2B7B3 _Z20sqliReorgCleanupKeysP7SQLI_CB + 
0x2C3 
  [6] 0x00002B64F7E833E7 
_Z21sqliAsyncIndexCleanupP20sqle_agent_privatecbP6AIC_CBm + 
0x1B7 
  [7] 0x00002B64F826E971 aicTaskProcessor + 0x1B9 
  [8] 0x00002B64F8262A6D 
_ZN8ABPAgent19taskProcessorDriverEP17ABPTaskProContext + 0x1ED 
  [9] 0x00002B64F8262EA9 _ZN8ABPAgent4mainEP17ABPTaskProContext 
+ 0xC9

Users Effected: 
This problem effects all users that issue reorg command on DPF 
system. 
 
Problem Description: 
This problem occurs when a reorg operation on a altered column 
is performed on a partitioned table which has outstanding 
asynchronized Index Cleaning (AIC) jobs. DB2 instance crashed. 
 
Problem Summary: 
DB2 INSTANCE CRASHED WITH SIGSEGV CALLING aicTaskProcessor.

When encountering the problem, after crash, use the following 
to by pass AIC in crash recovery: 
1) set DB2_DISABLE_ABP=yes 
2) drop index and recreate the index 
3) unset DB2_DISABLE_ABP 
 
Use the following to avoid the problem: 
Check if there are outstanding index cleanup jobs from SYSTASKS 
before ALTER a column.

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
 

Upgrade to DB2 Version Version 9.7, FixPak 6.

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

30.08.2011
17.01.2013
17.01.2013