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

IF A LOG FULL IS HIT BY LOAD, BLANK PAGES COULD REMAIN IN BUFFER POOL
CAUSING DATABASE TO BE MARKED BAD IF REUSED BY LOAD RESTART

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
If LOAD operation hits log full situation, it can leave some 
blank data pages in bufferpool after it rollback transaction. 
When subsequent LOAD RESTART operation reuses them, bad data 
page is encountered and database is marked as bad. The 
db2diag.log can have the following message showing blank PAGE 
HEADER: 
 
20xx-xx-xx-xx.xx.xx.xxxxxx-xxx xxxxxxxxxxxxxxx     LEVEL: Severe 
PID     : 24000                TID  : 47390123878720PROC : 
db2sysc 2 
INSTANCE: xxxxxxxx             NODE : 002          DB   : xxxxxx 
APPHDL  : 1-10058              APPID: 
xx.xxx.xx.xxx.xxxx.xxxxxxxxxxxx 
AUTHID  : xxxxxxx 
EDUID   : 67082                EDUNAME: db2linit 2 
FUNCTION: DB2 UDB, data management, sqldReadTableInfo, 
probe:9416 
RETCODE : ZRC=0x87040001=-2029780991=SQLD_BADPAGE "Bad Data 
Page" 
          DIA8500C A data file error has occurred, record id is 
"". 
 
.................. 
 
20xx-xx-xx-xx.xx.xx.xxxxxx-xxx xxxxxxxxxxxxxxx     LEVEL: Severe 
PID     : 24000                TID  : 47390123878720PROC : 
db2sysc 2 
INSTANCE: xxxxxxxx             NODE : 002          DB   : xxxxxx 
APPHDL  : 1-10058              APPID: 
xx.xxx.xx.xxx.xxxx.xxxxxxxxxxxx 
AUTHID  : xxxxxxx 
EDUID   : 67082                EDUNAME: db2linit 2 
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary 
logging func, probe:0 
MESSAGE : SQD PAGE HEADER 
DATA #1 : Hexdump, 22 bytes 
0x00002B16758DC030 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x00002B16758DC040 : 0000 0000 0000 
...... 
 
.............
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW Version 9.7 Fix Pack 6                    * 
****************************************************************
Local-Fix:
The page is only corrupted in bufferpool and not on disk. 
Terminating all connections to the database, deactivating, and 
reactivating the database should make the problem go away.
verfügbare FixPacks:
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

Lösung
Problem was first fixed in Version 9.7 Fix Pack 6
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.11.2011
11.06.2012
11.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP6
Problem behoben lt. FixList in der Version
9.7.0.6 FixList