|
Problem IC95450
|
Status: Closed |
DB2GCF UTILITY UPDATES THE DB2NODES.CFG TO SHORT HOSTNAME INSTEAD OF FULLY QUALIFIED HOST NAME |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
During a TSA automated database partition failover, db2gcfg
updates the db2nodes.cfg file. In some cases this will be
updated
to the short name of the host instead of the fully qualified
hostname.
Example:
$ cat db2nodes.cfg
0 test04.torolab.ibm.com 0
1 test04.torolab.ibm.com 1
$ hostname (Run from test03)
test03.torolab.ibm.com
$ hostname (Run from test04)
test04.torolab.ibm.com
Online IBM.ResourceGroup:db2_db2inst1_0-rg Nominal=Online
'- Online IBM.Application:db2_db2inst1_0-rs
|- Offline
IBM.Application:db2_db2inst1_0-rs:test03
'- Online
IBM.Application:db2_db2inst1_0-rs:test04
Online IBM.ResourceGroup:db2_db2inst1_1-rg Nominal=Online
'- Online IBM.Application:db2_db2inst1_1-rs
|- Offline
IBM.Application:db2_db2inst1_1-rs:test03
'- Online
IBM.Application:db2_db2inst1_1-rs:test04
Online IBM.Equivalency:db2_db2inst1_0-rg_group-equ
|- Online IBM.PeerNode:test04:test04
'- Online IBM.PeerNode:test03:test03
Online IBM.Equivalency:db2_db2inst1_1-rg_group-equ
|- Online IBM.PeerNode:test04:test04
'- Online IBM.PeerNode:test03:test03
In the above setup, if I then run the "rgreq -o move
db2_db2inst1_1-rg" command as root, it will cause TSA to
failover database partition 1 from host test04 to ceha03. This
works, but the problem is that the db2nodes.cfg file is being
updated with the short hostname as seen below
:
$ cat db2nodes.cfg
0 test04.torolab.ibm.com 0
1 test03 0 ceha03
The correct behavior would be for the DBM to update the 2nd line
of the db2nodes.cfg as follows:
1 test03.torolab.ibm.com 0 ceha03.torolab.ibm.com
This is because the hosts OS hostname value is set to
'test03.torolab.ibm.com'. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 and Fix Pack 3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 Version 10.5 and Fix Pack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
27.02.2014
27.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
