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