Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC77128 Status: Closed

DB2 INSTANCE CRASHED WITH SIGSEGV

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
This problem occurs when a reorg recommended operation alter 
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
Problem Summary:
Users Effected: 
All users 
 
Problem Description: 
DB2 INSTANCE CRASHED WITH SIGSEGV 
 
Problem Summary: 
This problem occurs when a reorg recommended operation alter 
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
Local Fix:
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.
available fix packs:
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
defect  wsdbu00844839 
CSD     First fixed in DB2 UDB Version 9, FixPak 11 
module  engn_sqx
Workaround
Upgrade to DB2 Version 9, Fix Pack 11
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC78409 IC78410 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.06.2011
07.12.2011
07.12.2011
Problem solved at the following versions (IBM BugInfos)
9.0.
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.11 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.