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 IC68339 Status: Closed

INSTANCE CRASH WHEN DB2 STORAGE OPTIMIZATION FEATURE IS ENABLED AND A
TEMPORARY TABLE IS SPILLED TO DISK

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
When DB2 Storage Optimization feature is enabled, temporary 
tables are automatically compressed. In this environemnt, 
instance crash may occur when a temporary table is spilled 
to the disk with the following stack traceback: 
 
SPDictTree::SPFindLongestPrefixSymCnt + 0x160 
SPDictTree::SPAddRecordToTree + 0x88 
sqlsCompDictFromBuff + 0xCC8 
sqlswrit + 0x254 
@103@sqlsBuildRow + 0x40 
sqlsinsr + 0xFC 
sqlrsinsr + 0x70 
sqlrisrt + 0x170 
sqlriSectInvoke + 0x588 
sqlrr_process_fetch_request + 0x18C 
sqlrr_open + 0x110 
  :
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using DB2 Storage Optimization feature                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When DB2 Storage Optimization feature is enabled,            * 
* temporarytables are automatically compressed. In this        * 
* environemnt,instance crash may occur when a temporary table  * 
* is spilledto the disk with the following stack               * 
* traceback:SPDictTree::SPFindLongestPrefixSymCnt +            * 
* 0x160SPDictTree::SPAddRecordToTree +                         * 
* 0x88sqlsCompDictFromBuff + 0xCC8sqlswrit +                   * 
* 0x254@103@sqlsBuildRow + 0x40sqlsinsr + 0xFCsqlrsinsr +      * 
* 0x70sqlrisrt + 0x170sqlriSectInvoke +                        * 
* 0x588sqlrr_process_fetch_request + 0x18C                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.7 FixPack 3.                            * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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
Problem was first fixed in DB2 UDB Version 9.7 FixPack 3.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC85343 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
03.05.2010
21.10.2010
21.10.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP3
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.3 FixList
9.7.0.3 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.