IC98940: SDS SERVER LOSES ARBITRATOR IF CM'S CLUSTER HAS MULTIPLE ALIASESUNDER INFORMIXSERVER PARAMETER

APAR status

• Closed as program error.

Error description

• You have an SDS cluster with a connection manager used as a
  failover arbitrator (DRAUTO set to 3).
  
  Each of the Informix instances has multiple aliases configured:
  
  DBSERVERNAME ids1170fc7
  DBSERVERALIASES
  ids1170fc7a,ids1170fc7b,ids1170fc7c,ids1170fc7d,ids1170fc7e,ids1
  170fc7f
  ...
  DBSERVERNAME ids1170fc7_sds
  DBSERVERALIASES
  ids1170fc7_sdsa,ids1170fc7_sdsb,ids1170fc7_sdsc,ids1170fc7_sdsd,
  ids1170fc7_sdse,ids1170fc7_sdsf
  
  In the $CMCONFIG file you have specified all of the aliases
  under INFORMIXDIR parameter (see example below).
  
  NAME            mycm
  LOGFILE         ${INFORMIXDIR}/tmp/mycm.log
  
  
  CLUSTER g_clust
  {
  INFORMIXSERVER
  ids1170fc7,ids1170fc7a,ids1170fc7b,ids1170fc7c,ids1170fc7d,ids11
  70fc7e,ids1170fc7f,ids1170fc7_sds,ids1170fc7_sdsa,ids1170fc7_sds
  b,ids1170fc7_sdsc,ids1170fc7_sdsd,ids1170fc7_sdse,ids1170fc7_sds
  f
  
    SLA ids_cm1 DBSERVERS=primary+SDS <MODE=PROXY>
  
    FOC ORDER=SDS TIMEOUT=5 RETRY=2 PRIORITY=1
    DEBUG 1
    CMALARMPROGRAM ${INFORMIXDIR}/etc/cmalarmprogram.sh
  
    SECONDARY_EVENT_TIMEOUT 30
    EVENT_TIMEOUT 30
  }
  
  Initially both instances show that the arbitrator is active:
  
   $ onstat -g cmsm
  
  IBM Informix Dynamic Server Version 11.70.FC8 -- Updatable (SDS)
  -- Up 00:03:59 -- 275152 Kbytes
  Unified Connection Manager: mycm                     Hostname:
  samson-ifx1
  
  CLUSTER         g_clust LOCAL
          SLA                    Connections   Service/Protocol
  Rule
          ids_cm1                          0     11726/onsoctcp
  DBSERVERS=primary+SDS <MODE=PROXY>
  
          Failover Arbitrator: Active Arbitrator, Primary is up
          ORDER=SDS TIMEOUT=5 RETRY=2 PRIORITY=1
  
   $ onstat -g cmsm
  
  IBM Informix Dynamic Server Version 11.70.FC8 -- On-Line -- Up
  00:03:58 -- 275152 Kbytes
  Unified Connection Manager: mycm                     Hostname:
  samson-ifx1
  
  CLUSTER         g_clust LOCAL
          SLA                    Connections   Service/Protocol
  Rule
          ids_cm1                          0     11726/onsoctcp
  DBSERVERS=primary+SDS <MODE=PROXY>
  
          Failover Arbitrator: Active Arbitrator, Primary is up
          ORDER=SDS TIMEOUT=5 RETRY=2 PRIORITY=1
  
  However when the primary goes down, no failover happens:
  
  $ onstat -m
  
  IBM Informix Dynamic Server Version 11.70.FC8 -- Updates Blocked
  (SDS) -- Up 00:07:25 -- 275152 Kbytes
  
  Message Log File: /sqldists/11.70.FC8/tmp/online.ids1170fc7.log
  06:44:32  Updates from secondary currently not allowed
  06:44:32  Attempting to reconnect
  06:44:33  CM:Session for Connection manager mycm terminated
  06:44:33  Attempting to reconnect
  06:44:33  CM:Connection manager mycm registered with the server
  06:44:35  Attempting to reconnect
  
  The output of 'onstat -g cmsm' shows that there is no active
  arbitrator:
  
  IBM Informix Dynamic Server Version 11.70.FC8 -- Updates Blocked
  (SDS) -- Up 00:08:15 -- 275152 Kbytes
  Unified Connection Manager: mycm                     Hostname:
  samson-ifx1
  
  CLUSTER         g_clust LOCAL
          SLA                    Connections   Service/Protocol
  Rule
          ids_cm1                          0     11726/onsoctcp
  DBSERVERS=primary+SDS <MODE=PROXY>
  
          Failover Arbitrator: Primary is down
          ORDER=SDS TIMEOUT=5 RETRY=2 PRIORITY=1
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users with Informix Connection Manager                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.70.xC9                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.70.xC9
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels