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

LOG RENAME ARRAY GETS FULL IN HADR ENVIRONMENT

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
Under certain workload conditions the rename array will get full 
in a HADR environment. The db2diag log will be flooded with 
messages such as: 
 
2010-06-03-08.39.28.581384-240 I2407774E533        LEVEL: 
Warning 
PID     : 11100                TID  : 46979333744960PROC : 
db2sysc 0 
INSTANCE: xxxxx               NODE : 000          DB   : GPR 
APPHDL  : 0-22666              APPID: *LOCAL.db2gpr.100602004002 
AUTHID  : XXXXX 
EDUID   : 894                  EDUNAME: db2agent (GPR) 0 
FUNCTION: DB2 UDB, data protection services, sqlpRenameStartUse, 
probe:1230 
MESSAGE : Log file 1685 is not added by DB2 because renameArray 
is full.File 
          could be renamed while in use. 
 
This condition might lead to a excessive number of entries in 
the db2diag.log with this messages. 
 
And these messages also indicate that those log files are not 
protected from being renamed by other applications yet. If these 
log files are incorrectly renamed while in use, some operations 
such as online backup which still need these log files could 
fail.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* HADR Env                                                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Log rename array gets full                                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply FP10                                                   * 
****************************************************************
Local Fix:
Since the rename array is a memory structure the database will 
need to be re-activated.
available fix packs:
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
Problem first fixed in FP10
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
16.07.2010
16.06.2011
16.06.2011
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.10 FixList