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 IC87471 Status: Closed

USING FQDN FOR NODE NAMES DURING DB2HAICU SETUP IS BROKEN

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
Using Fully Qualified Domain Names(FQDN) for node names during 
db2haicu setup is broken. 
 
Attempted to run both the db2haicu interactive interface and the 
db2haicu XML 
input file methods using FQDN and it fails. 
 
db2haicu -f db2ha_HADR.xml 
Welcome to the DB2 High Availability Instance Configuration 
Utility (db2haicu). 
 
You can find detailed diagnostic information in the DB2 server 
diagnostic log file called db2diag.log. Also, you can use the 
utility called db2pd to query the status of the cluster domains 
you create. 
 
For more information about configuring your clustered 
environment using db2haicu, see the topic called 'DB2 High 
Availability Instance Configuration Utility (db2haicu)' in the 
DB2 Information Center. 
 
db2haicu determined the current DB2 database manager instance is 
'db2inst1'. The cluster configuration that follows will apply to 
this instance. 
 
db2haicu is collecting information on your current setup. This 
step may take some time as db2haicu will need to activate all 
databases for the instance to discover all paths ... 
The local hostname 'hostA' is not part of the host list passed 
in. Re-run the command and provide the local hostname in 
the host list. 
There was an internal db2cluster error. Refer to the diagnostic 
logs (db2diag.log or /tmp/ibm.db2.cluster.*) and the DB2 
Information Center for details. 
 
[db2inst1@xxx]$ db2level 
DB21085I  Instance "db2inst1" uses "64" bits and DB2 code 
release "SQL10010" 
with level identifier "0201010E". 
Informational tokens are "DB2 v10.1.0.0", "s120403", 
"LINUXAMD64101", and Fix 
Pack "0". 
Product is installed at "/opt/ibm/db2/V10.1". 
 
db2diag.log snippet: 
2012-04-27-17.37.51.670826-240 E1018418E449          LEVEL: 
Error 
PID     : 6471                 TID : 139994365077280 PROC : 
db2haicu 
INSTANCE: db2inst1             NODE : 000 
HOSTNAME: hostA.torolab.ibm.com 
FUNCTION: DB2 UDB, high avail services, sqlhaUICreateDomain, 
probe:3329 
RETCODE : ECF=0x9000000C=-1879048180=ECF_INVALID_PARAMETER 
          Invalid parameter 
DATA #1 : String, 11 bytes 
db2HAdomain 
DATA #2 : signed integer, 4 bytes 
2 
 
2012-04-27-17.37.51.670940-240 E1018868E361          LEVEL: Info 
PID     : 6471                 TID : 139994365077280 PROC : 
db2haicu 
INSTANCE: db2inst1             NODE : 000 
HOSTNAME: hostA.torolab.ibm.com 
FUNCTION: DB2 UDB, high avail services, sqlhaUICreateDomain, 
probe:3329 
DATA #1 : String, 11 bytes 
db2HAdomain 
DATA #2 : signed integer, 4 bytes 
2 
 
2012-04-27-17.37.51.671024-240 E1019230E590          LEVEL: 
Severe 
PID     : 6471                 TID : 139994365077280 PROC : 
db2haicu 
INSTANCE: db2inst1             NODE : 000 
HOSTNAME: hostA.torolab.ibm.com 
FUNCTION: DB2 UDB, high avail services, handleEndElement, 
probe:1200 
MESSAGE : ECF=0x9000000C=-1879048180=ECF_INVALID_PARAMETER 
          Invalid parameter 
DATA #1 : String, 58 bytes 
Error during Domain creation from HA XML input processing. 
DATA #2 : String, 11 bytes 
db2HAdomain 
DATA #3 : unsigned integer, 4 bytes 
2 
DATA #4 : String, 27 bytes 
hostA.torolab.ibm.com
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to version 10.1 Fixpack 4                            * 
****************************************************************
Local Fix:
Use short hostname values.
available fix packs:
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
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

Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.10.2012
01.01.2013
01.01.2013
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.2 FixList
10.5.0.2 FixList