|
Problem IC80459
|
Status: Closed |
DB2 can crash during automatic statistics processing under rare circumstances |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Under rare circumstances, with AUTO_RUNSTATS enabled, you might
experience a crash with a stack that includes sqlrr_atm and
sqlrlc_foreach, for example:
stack trace:
0 ossDumpStackTraceEx
1 OSSTrapFile::dumpEx
2 sqlo_trce
3 sqloEDUCodeTrapHandler
4 __pthread_mutex_cond_lock
5 entryCallback
6 sqlrlc_foreach
7 atmGetHardeningList
8 atmAPI
9 sqlrr_atm
10 atmAPIEntry
11 sqlerKnownProcedure
You can also observe the following entry in the db2diag.log:
2011-09-14-15.20.19.819600+540 I1244631E561 LEVEL: Severe
PID : 2646 TID : 47155783919936 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-3604 APPID: *LOCAL.db2inst1.110914062023
AUTHID : DB2INST1 EDUID : 93 EDUNAME:
db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, RAS/PD component,
pdResilienceIsSafeToSustain, probe:800
DATA #1 : String, 37 bytes
Trap Sustainability Criteria Checking
DATA #2 : Hex integer, 8 bytes
0x0000000400001040
DATA #3 : Boolean, 1 bytes
false
The purpose of this apar is to prevent this crash to happen.
Note: Since this APAR was created, root cause has been
determined as APAR IC81500. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to V9.7 FP6 *
**************************************************************** |
| Local Fix: |
Disable automatic statistics by setting AUTO_RUNSTATS to OFF. |
| available fix packs: |
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
|
| Solution |
First fixed in V9.7 FP6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.12.2011
19.06.2012
19.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
