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

IN ENVIRONMENT WHERE CF AND MEMBER IS IN ONE HOST, UPDATING CF OR MEMBER
CHANGES NETWORK INTERFACE INFORMATION ABNORMALLY.

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
If update CF, infiniband information of member  disappears in 
db2nodes.cfg. 
And If update member, infiniband infromation of CF disappears in 
db2nodes.cfg. 
 
For example, 
 
# Original db2nodes.cfg 
0 sscp1101 0 sscp1102-ib0 - MEMBER 
1 sscp1102 0 sscp1102-ib0 - MEMBER 
128 sscp1102 0 sscp1102-ib0 - CF 
129 sscp1101 0 sscp1101-ib0 - CF 
 
# Update CF 
$ db2iupdt -update -cf sscp1101 -cfnet sscp1101-ib1,sscp1101-ib3 
db2e9p 
db2nodes.cfg: 
0 sscp1101 0 - - MEMBER 
1 sscp1102 0 sscp1102-ib0 - MEMBER 
128 sscp1102 0 sscp1102-ib0 - CF 
129 sscp1101 0 sscp1101-ib1,sscp1101-ib3 - CF 
 
# Update CF 
$ db2iupdt -update -cf sscp1102 -cfnet sscp1102-ib1,sscp1102-ib3 
db2e9p 
db2nodes.cfg 
0 sscp1101 0 - - MEMBER 
1 sscp1102 0 - - MEMBER 
128 sscp1102 0 sscp1102-ib1,sscp1102-ib3 - CF 
129 sscp1101 0 sscp1101-ib1,sscp1101-ib3 - CF 
 
# Update MEMBER 
$ db2iupdt -update -m sscp1101 -mnet sscp1101-ib0,sscp1101-ib2 
db2e9p 
db2nodes.cfg 
0 sscp1101 0 sscp1101-ib0,sscp1101-ib2 - MEMBER 
1 sscp1102 0 - - MEMBER 
128 sscp1102 0 sscp1102-ib1,sscp1102-ib3 - CF 
129 sscp1101 0 - - CF 
 
# Update MEMBER 
$ db2iupdt -update -m sscp1102 -mnet sscp1102-ib0,sscp1102-ib2 
db2e9p 
db2nodes.cfg 
0 sscp1101 0 sscp1101-ib0,sscp1101-ib2 - MEMBER 
1 sscp1102 0 sscp1102-ib0,sscp1102-ib2 - MEMBER 
128 sscp1102 0 - - CF 
129 sscp1101 0 - - CF
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 Fixpack 3.                       * 
****************************************************************
Local Fix:
Instead of updating a member or CF , drop and add the member or 
CF. 
ex: 
db2iupdt -drop -m sscp1101 
db2iupdt -add -m sscp1101 -mnet sscp1101-ib0,sscp1101-ib2 db2e9p
available fix packs:
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
First fixed in DB2 Version 10.1 Fixpack 3.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
02.05.2013
20.11.2013
20.11.2013
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.3 FixList
10.1.0.3 FixList