APAR status
Closed as program error.
Error description
Opened to support SLA lookup by NSF instead of name. If two SLA's have the same host name and port number, we will treat them as the same. If you have an invalid entry in a Server SQLHOSTS file such as: x1 onsoctcp apollo11 19900 where x1 is not a valid SLA or DBSERVERNAME and there is nothing listening on port 19900. The following SQL will return a -908 / -27001 as it should: SELECT COUNT(*) FROM sysutils@x1:systables If you then change that entry to be a valid group for an SLA such as: x1 group - - i=1,e=lx1 lx1 onsoctcp *apollo11 19100 g=x1 The SQL (SELECT COUNT(*) FROM sysutils@x1:systables) will still return a -908 / -27001. The problem will continue to happen until the server is bounced.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * Opened to support SLA lookup by NSF instead of name. If two * * SLA's have the same host name and port number, * * we will treat them as the same. * * * * If you have an invalid entry in a Server SQLHOSTS file such * * as: * * x1 onsoctcp apollo11 19900 * * * * where x1 is not a valid SLA or DBSERVERNAME and there is * * nothing * * listening on port 19900. * * * * The following SQL will return a -908 / -27001 as it should: * * * * SELECT COUNT(*) FROM sysutils@x1:systables * * * * If you then change that entry to be a valid group for an SLA * * such as: * * * * x1 group - - i=1,e=lx1 * * lx1 onsoctcp *apollo11 19100 g=x1 * * * * The SQL (SELECT COUNT(*) FROM sysutils@x1:systables) will * * still * * return a -908 / -27001. * * The problem will continue to happen until the server is * * bounced. * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * ****************************************************************
Problem conclusion
Fixed in Informix Server 12.10.xC15 and 14.10.xC5.
Temporary fix
Comments
APAR Information
APAR number
IT34041
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-08-28
Closed date
2021-01-25
Last modified date
2021-01-25
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
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]
Document Information
Modified date:
26 January 2021