home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC70404 Status: Geschlossen

DB2 MAY ABEND DUE TO MEMORY CORRUPTION WHILE ESTIMATING STATISTICS.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
DB2 may terminate abnormally upon detecting memory corruption. 
This can happen if the query is complex with numerous tables and 
local range predicates. The problem does not happen if there is 
no local range predicate in the query. 
The stack trace might look as follows: 
 
  [0] 0x00002AEB54D36B9B pdLog + 0xD7 
  [1] 0x00002AEB563C061D 
/opt/IBM/dwe/db2/V9.5/lib64/libdb2e.so.1 + 0x275661D 
  [2] 0x00002AEB56F63EB5 sqlofmblkEx + 0x8B9 
  [3] 0x00002AEB54D208AC _Z9sqlofmblkPv + 0x6 
  [4] 0x00002AEB562354D1 
_Z23sqlnr_estimate_sel_cardP9sqlnq_oprP17sqlnq_qtbElemListP17sql 
nq_prdElemListiiRfS5_RiP3loc 
+ 0x152B 
  [5] 0x00002AEB5623D3E3 
_Z23sqlnr_estimate_box_cardP9sqlnq_qtbP17sqlnq_qtbElemListP17sql 
nq_prdElemListiiRfS5_RiP3loc 
+ 0x2EB 
  [6] 0x00002AEB5623C80D 
_Z19sqlnr_estimate_cardP9sqlnq_qtbP17sqlnq_qtbElemListP17sqlnq_p 
rdElemListiiP18sqlnr_qtbStatsListRiP3loc 
+ 0x79D 
  [7] 0x00002AEB5618563F 
/opt/IBM/dwe/db2/V9.5/lib64/libdb2e.so.1 + 0x251B63F 
  [8] 0x00002AEB56188FCE 
_Z26sqlnr_joinppd_magic_detailP10sqlnr_qrwaPiP14sqlnr_progress + 
0x1038 
  [9] 0x00002AEB5618BFF7 
_Z20sqlnr_joinppd_actionP10sqlnr_qrwaPiP14sqlnr_progress + 0x49 
 
 
Workaround: None
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* db2_v95fp5                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2 may terminate abnormally upon detecting memory           * 
* corruption.                                                  * 
* This can happen if the query is complex with numerous tables * 
* and                                                          * 
* local range predicates. The problem does not happen if there * 
* is                                                           * 
* no local range predicate in the query.                       * 
*                                                              * 
* The stack trace might look as follows:                       * 
*                                                              * 
*                                                              * 
*                                                              * 
*   [0] 0x00002AEB54D36B9B pdLog + 0xD7                        * 
*                                                              * 
*   [1] 0x00002AEB563C061D                                     * 
*                                                              * 
* /opt/IBM/dwe/db2/V9.5/lib64/libdb2e.so.1 + 0x275661D         * 
*                                                              * 
*   [2] 0x00002AEB56F63EB5 sqlofmblkEx + 0x8B9                 * 
*                                                              * 
*   [3] 0x00002AEB54D208AC _Z9sqlofmblkPv + 0x6                * 
*                                                              * 
*   [4] 0x00002AEB562354D1                                     * 
*                                                              * 
* _Z23sqlnr_estimate_sel_cardP9sqlnq_oprP17sqlnq_qtbElemListP17s 
* nq_prdElemListiiRfS5_RiP3loc                                 * 
*                                                              * 
* + 0x152B                                                     * 
*                                                              * 
*   [5] 0x00002AEB5623D3E3                                     * 
*                                                              * 
* _Z23sqlnr_estimate_box_cardP9sqlnq_qtbP17sqlnq_qtbElemListP17s 
* nq_prdElemListiiRfS5_RiP3loc                                 * 
*                                                              * 
* + 0x2EB                                                      * 
*                                                              * 
*   [6] 0x00002AEB5623C80D                                     * 
*                                                              * 
* _Z19sqlnr_estimate_cardP9sqlnq_qtbP17sqlnq_qtbElemListP17sqlnq 
* rdElemListiiP18sqlnr_qtbStatsListRiP3loc                     * 
*                                                              * 
* + 0x79D                                                      * 
*                                                              * 
*   [7] 0x00002AEB5618563F                                     * 
*                                                              * 
* /opt/IBM/dwe/db2/V9.5/lib64/libdb2e.so.1 + 0x251B63F         * 
*                                                              * 
*   [8] 0x00002AEB56188FCE                                     * 
*                                                              * 
* _Z26sqlnr_joinppd_magic_detailP10sqlnr_qrwaPiP14sqlnr_progress 
* +                                                            * 
* 0x1038                                                       * 
*                                                              * 
*   [9] 0x00002AEB5618BFF7                                     * 
*                                                              * 
* _Z20sqlnr_joinppd_actionP10sqlnr_qrwaPiP14sqlnr_progress +   * 
* 0x49                                                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* db2_v95fp7                                                   * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC70474 IC70475 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.08.2010
30.12.2010
30.12.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.1.0.7 FixList
9.5.0.7 FixList