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 IC74247 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 / 950 - 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: 
 
2010-12-01-23.02.24.150848-300 I1136373424E540     LEVEL: Severe 
PID     : 24000                TID  : 47390123878720PROC : 
db2sysc 2 
INSTANCE: panipuri             NODE : 002          DB   : SAMPLE 
APPHDL  : 1-10058              APPID: 
10.184.12.205.2202.101202040221 
AUTHID  : DB2INST 
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 
"". 
 
.................. 
 
2010-12-01-23.02.24.185266-300 I1136381157E631     LEVEL: Severe 
PID     : 24000                TID  : 47390123878720PROC : 
db2sysc 2 
INSTANCE: panipuri             NODE : 002          DB   : SAMPLE 
APPHDL  : 1-10058              APPID: 
10.184.12.205.2202.101202040221 
AUTHID  : DB2INST 
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 Version 9.5 Fix Pack 9                        * 
****************************************************************
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.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 Version 9.5 Fix Pack 9
Workaround
See LOCAL FIX
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC79713 IC84131 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.02.2011
09.04.2012
09.04.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP9
Problem behoben lt. FixList in der Version
9.5.0.9 FixList