home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IC75645 Status: Closed

TRAP IN SQLDHASHZVALUE24 OR SQLDHASHZVALUE32 DURING STATISTICS COLLECTION.

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Trap in sqldHashZValue24 or sqldHashZValue32 during statistics 
collection. 
 
Under rare circumstances, DB2 might trap during statistics 
collection in function sqldHashZValue24 or function 
sqldHashZValue32. 
 
Sample stack: 
 sqldHashZValue24 
 sqldProcessOneColCard 
 sqldtcst 
 sqldEvalDataPred 
 sqldReadNorm 
 sqldFetchNext 
 sqldfrd 
 sqldRowFetch 
 sqldTableStats 
 sqlrLocalRunstats 
 sqlrrsta
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Trap in sqldHashZValue24 or sqldHashZValue32 during          * 
* statistics collection.                                       * 
*                                                              * 
* Under rare circumstances, DB2 might trap during statistics   * 
* collection in function sqldHashZValue24 or function          * 
* sqldHashZValue32.                                            * 
*                                                              * 
* Sample stack:                                                * 
* sqldHashZValue24                                             * 
* sqldProcessOneColCard                                        * 
* sqldtcst                                                     * 
* sqldEvalDataPred                                             * 
* sqldReadNorm                                                 * 
* sqldFetchNext                                                * 
* sqldfrd                                                      * 
* sqldRowFetch                                                 * 
* sqldTableStats                                               * 
* sqlrLocalRunstats                                            * 
* sqlrrsta                                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Ungrade to  DB2 Version 9.7 FixPack 5                        * 
****************************************************************
Local Fix:
available fix packs:
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
First fixed in DB2 Version 9.7 FixPack 5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
07.04.2011
30.01.2012
30.01.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.5 FixList