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 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
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList