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

HADR STANDBY MIGHT HIT DISK FULL , AS ARCHIVED LOGFILES IN PRIMARY ARE NOT
REMOVED IMMEDIATELY FROM STANDBY LOG PATH

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
HADR Standby might fail with DISK FULL error as - 
2016-05-12-17.19.19.473722+330 I25102691E501         LEVEL: 
Error 
PID     : 10903                TID : 46912858220864  PROC : 
db2sysc 0 
INSTANCE: db2inst1             NODE : 000            DB   : 
IFMSMIGR 
HOSTNAME: HYDMGOMDBS004 
EDUID   : 8317                 EDUNAME: db2logalloc.0 (IFMSMIGR) 
0 
FUNCTION: DB2 UDB, oper system services, 
sqlo_file_ext_and_commit, probe:100 
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full." 
          DIA8312C Disk was full. 
DATA #1: Codepath, 8 bytes 
25:26 
 
Ideally, once the log files are archived on primary the 
corresponding log files on standby should be deleted 
immediately. 
Currently, the design is DB2 reads the head extent ID on disk to 
understand the Log file status.It is not updated while Standby 
is replaying. Since the head extent ID is not moving, DB2 
assumes the number of Log files is not increasing, therefore, 
DB2 assumes there is no need to delete extra files log files. 
Once the head extent ID is flushed to disk, DB2  notices the 
need to delete the log files and starts deleting them. But in 
some cases, the customer can hit disk full even before the head 
extent ID is flushed to disk.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 10.5 Fix Pack 9 or higher                     * 
****************************************************************
Local Fix:
Deactivate and reactivate standby database, all those old logs 
would be removed from active path and this hdrSNextExtToRename 
value should automatically move up.
Solution
First fixed in Db2 10.5 Fix Pack 9
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
16.06.2016
29.09.2017
29.09.2017
Problem solved at the following versions (IBM BugInfos)
9.0.
Problem solved according to the fixlist(s) of the following version(s)