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 IC88319 Status: Geschlossen

DB2 may abend with a trap (prior to Version 9.7 Fix Pack 5) or OLAP query
may fail with SQL0901N (Version 9.7 Fix pack 5 or 6).

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
DB2 may abend due to a trap (prior to Version 9.7 Fix Pack 5) or 
query may fail with SQL0901N (Reason "Bad victimPageHeader ") 
(Version 9.7 Fix pack 5 or 6) if the following occurs: 
 
- DB2 is running with configuration where sort memory is 
constrained (and may also be throttled to minimum allowances) 
- we are running an OLAP query that processes large amounts of 
data, 
 
An example of stacks trace for an abend that can happen in V9.7 
FP4 and prior: 
 
sqlri_buffer_fix_page 
sqlriScalagRecreatePageHdr 
sqlriScalagSearchPageHdrCache 
sqlri_buffer_fix_page_N_ptrs 
sqlri_scalag_aggregator 
sqlri_scalag_aggNfind_bot 
sqlri_scalag 
sqlriset 
sqlriSectInvoke 
 
An example of SQL0901N that can happen in V9.7 FP5 and later: 
 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:300 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 20 
 sqlerrmc: Bad victimPageHeader 
 sqlerrp : SQLRI4B3 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFDBDD      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate:
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FP7  or newer fix pack                    * 
****************************************************************
Local-Fix:
In order to avoid constrained sort memory, ensure that the 
configuration (including applicable limits and memory resources) 
is sufficient and throttling is avoided.
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
Problem Fixed in DB2 Version 9.7 Fix Pack 7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
17.11.2012
17.01.2013
17.01.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP7
Problem behoben lt. FixList in der Version
10.1.0.2 FixList
10.5.0.2 FixList