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 IC77421 Status: Closed

HISTORY FILE CORRUPTION MAY OCCUR WHEN THE FILESYSTEM THAT THE HISTORY FILE
RESIDES ON BECOMES 100% FULL

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
History file corruption may occur when filesystem where the 
history file resides becomes full. Similar error messages will 
be noticed: 
 
2011-06-09-02.50.16.456580-240 I7140950E671        LEVEL: Error 
PID     : 19688                     TID  : 199455926624 PROC 
:db2sysc 0 
INSTANCE: db2inst1            NODE : 000          DB   : SAMPLE 
APPHDL  : 0-14180              APPID:LOCAL.db2inst1.198AA9065013 
AUTHID  : DB2INST1 
EDUID   : 10724                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, database utilities, 
sqluhBeginBatch,probe:1981 
MESSAGE : SQL2161N A damaged recovery history file could not be 
fixed. 
The specified action failed. 
DATA #1 : String, 32 bytes 
Error while opening history file 
DATA #2 : String, 58 bytes 
/home/db2inst1/db2inst1/NODE0000/SQL00002
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* History file corruption may occur when filesystem where the  * 
* history file resides becomes full.                           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 Fixpack 9                         * 
****************************************************************
Local Fix:
Rename the file db2rhist.asc
available fix packs:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First Fixed in DB2 Version 9.5 Fixpack 9
Workaround
Rename the history file db2rhist.asc
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC80429 IC84199 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.07.2011
28.02.2012
28.02.2012
Problem solved at the following versions (IBM BugInfos)
9.5.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.9 FixList