IC78237: ON SLA REDIRECTION CM DOESN'T ATTEMPT TO CONNECT TO A GOOD ALIASIF FIRST ONE IS 'BROKEN'

APAR status

• Closed as program error.

Error description

• You have set up an instance of Connection Manager and its
  sqlhosts of CM has a group which consists of two aliases of the
  same instance.  One alias is 'broken' (for example a rule is
  enabled on firewall which restricts access to port 11234):
  
  # 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_1    onsoctcp        9.156.38.189    1150fc8_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
  
  And you have PRI SLA defined in Connection Manager configuration
  file:
  
  # Connection Manager name
  NAME    cm_1
  
  # re-route Informix clients to the primary for transaction
  processing
  SLA     prim=primary
  
  Apparently the Connection Manager does not try to use the second
  alias.  If you try to use PRI SLA, the connection attempt fails
  with error -908.  According to the log of Connection Manager, it
  happens because CM tries to connect to the "bad" alias on SLA
  redirection:
  
  Fri Aug 19 13:53:12 2011
  13:53:12 IBM Informix Connection Manager
  13:53:12 Connection Manager name is cm_1
  13:53:12 Starting Connection Manager...
  13:53:12 the current maximum number of file descriptors is 32767
  13:53:12 switch to daemon mode
  13:53:12 new daemon pid is 7274744
  13:53:12 fcntl(/opt/IBM/11.50.FC8/tmp/cmsm.pid.cm_1) success
  errno = 0
  13:53:12 dbservername = g_test
  13:53:12 nettype      =
  13:53:12 hostname     = -
  13:53:12 servicename  = -
  13:53:12 options      = i=10
  13:53:12 listener prim initializing
  13:53:12 create new thread 772 for ids1150fc8tcp_aix
  13:53:12 Listener prim=primary is active with 8 worker threads
  13:53:12 CONNECT to
  sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
  ids1150fc8tcp_aix0 USER informix SQLCODE =
  (-908,79,ids1150fc8tcp_aix)
  13:53:13 Connection Manager started successfully
  13:53:13 CONNECT to
  sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
  ids1150fc8tcp_aix0 USER informix SQLCODE =
  (-908,79,ids1150fc8tcp_aix)
  13:53:14 CONNECT to
  sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
  ids1150fc8tcp_aix0 USER informix SQLCODE =
  (-908,79,ids1150fc8tcp_aix)
  13:53:15 CONNECT to
  sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
  ids1150fc8tcp_aix0 USER informix SQLCODE =
  (-908,79,ids1150fc8tcp_aix)
  13:53:16 CONNECT to
  sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
  ids1150fc8tcp_aix0 USER informix SQLCODE =
  (-908,79,ids1150fc8tcp_aix)
  13:53:17 CONNECT to
  sysmaster@ids1150fc8tcp_aix|onsoctcp|9.156.38.189|11234 AS
  ids1150fc8tcp_aix0 USER informix SQLCODE =
  (-908,79,ids1150fc8tcp_aix)
  13:53:17 try connect to ids1150fc8_1
  13:53:17 CONNECT to
  sysmaster@ids1150fc8_1|onsoctcp|9.156.38.189|1150fc8_srv AS
  ids1150fc8_10   SQLCODE = (0,0,)
  13:53:17 ids1150fc8_1 protocols = 1
  13:53:17 adding ids1150fc8_1 alias ids1150fc8tcp_aix with
  protocol onsoctcp 1
  13:53:17 adding ids1150fc8_1 alias ids1150fc8 with protocol
  onipcshm 1
  13:53:17 SQL fetch sysconfig_cursor sqlcode = (100,0,)
  13:53:17 Connection Manager successfully connected to
  ids1150fc8_1
  13:53:17 Arbitrator FOC string = DISABLED
  13:53:17 Arbitrator setting primary name = ids1150fc8
  13:53:17 FOC: Failover Arbitrator disabled
  13:53:17 FOC timeout = 0
  13:53:17 create new thread 269 for ids1150fc8_rss_tcp_aix
  13:53:17 Arbitrator reinitialized CM names
  13:53:17 CONNECT to
  sysmaster@ids1150fc8_rss_tcp_aix|onsoctcp|9.156.38.189|1150fc8_r
  ss_srv
  AS ids1150fc8_rss_tcp_aix0   SQLCODE = (0,0,)
  13:53:17 ids1150fc8_rss_tcp_aix protocols = 1
  13:53:17 Arbitrator added CM name = cm_1
  13:53:17 Arbitrator is active on CM = cm_1
  13:53:17 adding ids1150fc8_rss_tcp_aix alias ids1150fc8_rss with
  protocol onipcshm 1
  13:53:17 adding ids1150fc8_rss_tcp_aix alias ids1150fc8_r1 with
  protocol onsoctcp 1
  13:53:17 SQL fetch sysconfig_cursor sqlcode = (100,0,)
  13:53:17 Connection Manager successfully connected to
  ids1150fc8_rss_tcp_aix
  13:53:17 Arbitrator FOC string = DISABLED
  13:53:17 Arbitrator setting primary name = ids1150fc8tcp_aix
  13:53:17 FOC: Failover Arbitrator disabled
  13:53:17 FOC timeout = 0
  13:58:35 SLA prim redirect SQLI client from 9.156.38.189 to
  ids1150fc8tcp_aix 9.156.38.189.11234
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of CM where an SLA includes a server that has one or   *
  * more DBSERVERALIASES and the CM cannot successfully connect  *
  * to all the aliases.                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 11.50                          *
  *                                                              *
  * Upgrade to 3.50.xC10 or later.                               *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 11.50
  
  As of 3.50.xC10 the CM will not redirect a client to an alias it
  can't connect to.
  

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