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