IBM Support

IC78238: CM REDIRECTS FROM PRI SLA TO RSS INSTANCE IF IT CAN'T CONNECT TOPRIMARY AT STARTUP

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 set up an instance of Connection Manager (CM). Sqlhosts
file of CM has a group which consists of two entries. One is for
primary, second one - for RSS instance. First entry is 'broken'
(for example a rule is enabled on firewal which restricts access
to a connection port):

# INFORMIXSERVER
#ids            onsoctcp        host_ids        serv_ids
g_test group - - i=10
ids1150fc8tcp_aix       onsoctcp        9.156.38.189    11234
g=g_test # Bad
ids1150fc8_r1 onsoctcp  9.156.38.189 1150fc8_rss_srv g=g_test #
Good


# for Connection Manager's SLA defines

g_test2 group - - i=20
prim onsoctcp 9.156.38.189 prim_cm g=g_test2

sec_rss_cm onsoctcp 9.156.38.189 sec_rss_cm

Two SLA are defined in the configuration file of Connection
Manager - PRI and RSS:

# Connection Manager name
NAME    cm_1

# re-route Informix clients to the primary for transaction
processing
SLA     prim=primary

# re-route Informix clients to any secondary node for reporting
SLA     sec_rss_cm=RSS

Due to a failure of connection to the primary instance on
startup forces CM to bind RSS instance to PRI SLA, while RSS SLA
does not work:

14:25:01 IBM Informix Connection Manager
14:25:01 Connection Manager name is cm_1
14:25:01 Starting Connection Manager...
14:25:01 the current maximum number of file descriptors is 32767
14:25:01 switch to daemon mode
14:25:01 new daemon pid is 6881716
14:25:01 fcntl(/opt/IBM/11.50.FC8/tmp/cmsm.pid.cm_1) success
errno = 0
14:25:01 dbservername = g_test
14:25:01 nettype      =
14:25:01 hostname     = -
14:25:01 servicename  = -
14:25:01 options      = i=10
14:25:01 listener prim initializing
14:25:01 listener sec_rss_cm initializing
14:25:01 create new thread 1029 for ids1150fc8tcp_aix
14:25:01 Listener prim=primary is active with 8 worker threads
14:25:01 Listener sec_rss_cm=RSS is active with 8 worker threads
14:25:01 CONNECT to
sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
ids1150fc8tcp_aix0 USER informix SQLCODE =
(-908,79,ids1150fc8tcp_aix)
14:25:02 Connection Manager started successfully
14:25:02 CONNECT to
sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
ids1150fc8tcp_aix0 USER informix SQLCODE =
(-908,79,ids1150fc8tcp_aix)
14:25:03 CONNECT to
sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
ids1150fc8tcp_aix0 USER informix SQLCODE =
(-908,79,ids1150fc8tcp_aix)
14:25:04 CONNECT to
sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
ids1150fc8tcp_aix0 USER informix SQLCODE =
(-908,79,ids1150fc8tcp_aix)
14:25:05 CONNECT to
sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
ids1150fc8tcp_aix0 USER informix SQLCODE =
(-908,79,ids1150fc8tcp_aix)
14:25:06 CONNECT to
sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
ids1150fc8tcp_aix0 USER informix SQLCODE =
(-908,79,ids1150fc8tcp_aix)
14:25:06 try connect to ids1150fc8_r1
14:25:06 CONNECT to
sysmaster@ids1150fc8_r1|onsoctcp|9.156.38.189|1150fc8_rss_srv AS
ids1150fc8_r10   SQLCODE = (0,0,)
14:25:06 ids1150fc8_r1 protocols = 1
14:25:06 adding ids1150fc8_r1 alias ids1150fc8_rss with protocol
onipcshm 1
14:25:06 adding ids1150fc8_r1 alias ids1150fc8_rss_tcp_aix with
protocol onsoctcp 1
14:25:06 SQL fetch sysconfig_cursor sqlcode = (100,0,)
14:25:06 Connection Manager successfully connected to
ids1150fc8_r1
14:25:06 create new thread 278 for ids1150fc8tcp_aix
14:25:06 Arbitrator FOC string = DISABLED
14:25:06 Arbitrator setting primary name = ids1150fc8tcp_aix
14:25:06 FOC: Failover Arbitrator disabled
14:25:06 FOC timeout = 0
14:25:06 CONNECT to
sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
ids1150fc8tcp_aix0 USER informix SQLCODE =
(-908,79,ids1150fc8tcp_aix)
14:25:06 Arbitrator reinitialized CM names
14:25:06 Arbitrator added CM name = cm_1
14:25:06 Arbitrator is active on CM = cm_1
14:25:07 CONNECT to
sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
ids1150fc8tcp_aix0 USER informix SQLCODE =
(-908,79,ids1150fc8tcp_aix)
14:25:08 CONNECT to
sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
ids1150fc8tcp_aix0 USER informix SQLCODE =
(-908,79,ids1150fc8tcp_aix)
14:25:09 CONNECT to
sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
ids1150fc8tcp_aix0 USER informix SQLCODE =
(-908,79,ids1150fc8tcp_aix)
14:25:10 CONNECT to
sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
ids1150fc8tcp_aix0 USER informix SQLCODE =
(-908,79,ids1150fc8tcp_aix)
14:25:11 CONNECT to
sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
ids1150fc8tcp_aix0 USER informix SQLCODE =
(-908,79,ids1150fc8tcp_aix)
14:25:11 Monitor ids1150fc8tcp_aix exit with error -908
14:25:18 Warning: no server returned for SLA sec_rss_cm
14:25:18 SLA sec_rss_cm cannot find database server for SQLI
client
14:25:24 SLA prim redirect SQLI client from 9.156.38.189 to
ids1150fc8_rss_tcp_aix 9.156.38.189.9111

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* Users of the Connection Manager when a secondary is          *
* reachable but the primary is not.                            *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 11.50                          *
*                                                              *
* Please use the CM in CSDK 3.50.xC10 or later.                *
****************************************************************

    



Problem conclusion


    

  • Problem Fixed In IBM Informix Server 11.50

Fixed in CSDK 3.50.xC10.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IC78238
    • 

  • Reported component name
    INFORMIX SERVER
    • 

  • Reported component ID
    5725A3900
    • 

  • Reported release
    B50
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2011-08-19
    • 

  • Closed date
    2017-06-15
    • 

  • Last modified date
    2017-06-15
    • 





    

  • 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


    

  • RB50  PSN
       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":"B50","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            15 June 2017
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback