DB2 FOR LUW / DB2FORLUW / 970 - DB2

In a HADR/TSA environment, where the language is not set as 
English, automatic HADR pair reintegration fails in the case 
where the standby server is restarted. 
 
E.g. In a French environment, where LANG=fr_FR@euro 
The standby instance is successfully started after a reboot, 
but the start HADR is not done automatically by TSA. 
 
The db2V97_start.ksh script is being initiated correctly, but 
reintegration does not take place. This is due to the 
following line within the db2V97_start.ksh script: 
 
su - ${DB2INSTANCE?} -c "db2 list database directory" | grep 
"Database name" \ 
| tr "[a-z]" "[A-Z]" | awk '{print $4}' > ${dbFN?} 
 
The script expects the pattern "Database name", but in a French 
environment this would instead read as "Nom de la base de 
donnﾂes". As a result the database is not activated as expected.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 V9.7 Fix Pack 7 and below                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.7 Fix Pack 8                               * 
****************************************************************

In the case of a French environment, the following change will 
need to be done to the db2V97_start.ksh script: 
 
Change: 
su - ${DB2INSTANCE?} -c "db2 list database directory" | grep 
"Database name" \ 
| tr "[a-z]" "[A-Z]" | awk '{print $4}' > ${dbFN?} 
 
To: 
su - ${DB2INSTANCE?} -c "db2 list database directory" | grep 
"Nom de la base de donn" \ 
| tr "[a-z]" "[A-Z]" | awk '{print $8}' > ${dbFN?}

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
 

First fixed in DB2 v9.7 Fix Pack 8

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC91748 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

03.01.2013
02.04.2013
02.04.2013

9.7.FP8