DB2 - Problem description
Problem IC77264 | Status: Closed |
DB2 HA SCRIPT HADRV95_START.KSH CAN RETURN WITH RC 0 ON REDHAT LINUX AND AUTOMATIC FAILOVER WILL NOT BE PERFORMED | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
On Redhat Enterprise Linux 5.5 there is an issue with the "su" command that is used in the hadrV95_start.ksh scripts to determine the server status. If the command gets killed by db2V95_start.ksh script - that can execute in parallel - then the return code of the su command remains 0 (zero). For TSA this indicates a false "successfull" startup and a potential failover will not be performed. In Linux system log (/var/log/messages) you will see the following messages: Oct 15 16:14:08 lx252 db2V95_start.ksh[2176]: *************** Attempted to start partition db2inst1,0 and failed Oct 15 16:14:08 lx252 db2V95_start.ksh[2177]: Killing db2 processes : db2inst1, 0 Oct 15 16:14:08 lx252 /usr/sbin/rsct/sapolicies/db2/hadrV95_start.ksh[2185]: ...returns 0 Oct 15 16:14:08 lx252 /usr/sbin/rsct/sapolicies/db2/hadrV95_start.ksh[2186]: Returning 0 : db2inst1 db21inst1 PDB2UID Note: This has been addressed already partially in APAR IC72271, db2gcf does not get killed anymore by the db2V95_start.ksh script. Unfortunately, there are two places in the script, where kill -9 is called, but only one call was fixed. This APAR will address the second call as well. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users on Redhat platform. * **************************************************************** * PROBLEM DESCRIPTION: * * See Problem Description above. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fix Pack 9. * **************************************************************** | |
Local Fix: | |
Modify the db2V95_start.ksh script to exclude db2gcf in both "kill -9" calls. | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 Version 9.5 Fix Pack 9. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.06.2011 14.03.2012 14.03.2012 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP9 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.9 |