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 | |
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 |