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 number
IC78237
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
2024-09-24
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B50","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
24 September 2024