DB2 FOR LUW / DB2FORLUW / A10 - 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 V10 Fixpak 2 and below                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10 Fixpack 3                                 * 
****************************************************************

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 10.1 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

First fixed in DB2 v10 Fixpak 3

not known / see Local fix

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

22.04.2013
07.10.2013
07.10.2013