DB2 - Problem description
Problem IC74660 | Status: Closed |
HADR MONITOR SCRIPT MAY TIMEOUT AND RETURN UNKNOWN DURING REINTEGRATION (UNDER HEAVY LOAD) | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - 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 V97 HA (HADR) users * **************************************************************** * PROBLEM DESCRIPTION: * * Reintegration under heavy load (many dbs) fails due to HADR * * monitor script timeouts (returns UNKNOWN) * **************************************************************** * RECOMMENDATION: * * Upgrade to V97 latest fixpack * **************************************************************** | |
Local Fix: | |
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 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.02.2011 28.04.2011 28.04.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.7. | |
Problem solved according to the fixlist(s) of the following version(s) |