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

DB2INSTANCE -LIST SHOWING MISLEADING STATUS FOR SECONDARY CF DURING MEMBER
FAIL OVER.

product:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problem description:
The db2instance -list command shows misleading status for 
secondary CF during member fail over. 
The state of secondary CF should stay at CATCHUP during member 
fail over when there is no database attachment, and should 
remain at PEER state when there is a db attachment. 
 
$ db2instance -list 
ID     TYPE    STATE HOME_HOST CURRENT_HOST 
--     ----    ----- --------- ------------ 
0    MEMBER  STARTED     host2        host2 
1    MEMBER  STARTED     host3        host3 
128  CF      PRIMARY     host1        host1 
129  CF      CATCHUP     host4        host4
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All who uses pureScale feature.                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The db2instance -list command shows misleading status for    * 
* secondary CF during member fail over.                        * 
* The state of secondary CF should stay at CATCHUP during      * 
* member fail over when there is no database attachment, and   * 
* should remain at PEER state when there is a db attachment.   * 
*                                                              * 
* $ db2instance -list                                          * 
* ID    TYPE    STATE HOME_HOST CURRENT_HOST                   * 
* --    ----    ----- --------- ------------                   * 
* 0    MEMBER  STARTED    host2        host2                   * 
* 1    MEMBER  STARTED    host3        host3                   * 
* 128  CF      PRIMARY    host1        host1                   * 
* 129  CF      CATCHUP    host4        host4                   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to V9.8 FixPack 4 or later.                   * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
DB2 Version 9.8 Fix Pack 4 for AIX and Linux

Solution
This problem is first fixed in V9.8 Fixpack 4.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
06.03.2011
09.05.2017
09.05.2017
Problem solved at the following versions (IBM BugInfos)
9.8.FP4
Problem solved according to the fixlist(s) of the following version(s)
9.8.0.4 FixList