DB2 - Problem description
Problem IC72271 | Status: Closed |
DB2 HA SCRIPT HADRV97_START.KSH CAN RETURN WITH RC 0 ON REDHAT LINUX AND AUTOMATIC FAILOVER WILL NOT BE PERFORMED | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
On Redhat Enterprise Linux 5.5 there is an issue with the "su" command that is used in the hadrV97_start.ksh scripts to determine the server status. If the command gets killed by db2V97_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 db2V97_start.ksh[2176]: *************** Attempted to start partition db2inst1,0 and failed Oct 15 16:14:08 lx252 db2V97_start.ksh[2177]: Killing db2 processes : db2inst1, 0 Oct 15 16:14:08 lx252 /usr/sbin/rsct/sapolicies/db2/hadrV97_start.ksh[2185]: ...returns 0 Oct 15 16:14:08 lx252 /usr/sbin/rsct/sapolicies/db2/hadrV97_start.ksh[2186]: Returning 0 : db2inst1 db21inst1 PDB2UID Note: This appears to be an issue on the Redhat Linux distribution but DB2 will implement a workaround in the HA scripts. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL USERS ON REDHAT LINUX * **************************************************************** * PROBLEM DESCRIPTION: * * See Problem Description above. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 4. * **************************************************************** | |
Local Fix: | |
You can download and compile a "su" binary from GNU from http://ftp.gnu.org/gnu/coreutils I.e. version 5.97 does have the expected and correct behavior. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 Version 9.7 Fix Pack 4. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC72480 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.10.2010 01.05.2011 01.05.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP4 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.4 |