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 | |
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 | |
10.1.0.3 |