IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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 number

    IC98940

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    B70

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-01-23

  • Closed date

    2017-06-09

  • Last modified date

    2017-06-09

  • 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

  • RB70 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B70","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
09 June 2017