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

HADR MONITOR SCRIPT MAY TIMEOUT AND RETURN UNKNOWN DURING REINTEGRATION
(UNDER HEAVY LOAD)

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
HADR monitor script may timeout and return UNKNOWN during 
reintegration, when under heavy load. 
 
The timeouts happen because the instance is in the process of 
starting and the monitor script, which runs for each database 
every 21 seconds, is adding additional load by executing "db2gcf 
-s" and "db2 force application". Both of these 
commands are irrelevant if the instance is not started. 
 
This APAR fix will do two things to avoid HADR monitor script 
timeouts during reintegration, when under heavy load - 
 
1. HADR monitor script will return Offline if instance is not 
started 
2. Dynamically determine timeout for "db2gcf -s" based on HADR 
monitor script timeout
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 V95 HA (HADR) users                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Reintegration under heavy load (many dbs) fails due to HADR  * 
* monitor script timeouts (returns UNKNOWN)                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V95FP8                                            * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
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
Modify HADR monitor script to return Offline is instance has not 
started 
Determine timeout for "db2gcf -s" dynamically, based on HADR 
monitor script timeout
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC74660 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.02.2011
27.06.2011
27.06.2011
Problem solved at the following versions (IBM BugInfos)
9.5.FP8
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.8 FixList