IBM Support

Effectively working with Informix Servers on AIX

Preventive Service Planning


Abstract

This document tells you how to work effectively with Informix database servers and the AIX operating system by providing information like recommended install levels, APARs, and tuning tips.

Content


Known issues for Informix servers running on AIX

IssueComments
APAR IC95265:
UPGRADE TO 12.10 FAILS WITH SANE_CHOPEN:CHECSUM 0XD0C1 != CHECKSUM 0XD0E1
This will be fixed in 12.10.FC3. Contact technical support for a special build on 12.10.FC2 that fixes this APAR.
APAR IC80345:
11.50.xC9W1 ALLOWS USER WITH WRONG PASSWORD TO CONNECT
A replacement for each PID is available on Fix Central. 11.50.UC9W1X1 replaces 11.50.UC9W1 and 11.50.FC9W1X1 replaces 11.50.FC9W1. Click here for details.



This document lists recommended installation levels, APARs, and known issues regarding the interaction between Informix databases and the AIX operating system. There may be additional AIX APARs that are unrelated to Informix activity that impact Informix databases. It is recommended that you consult the AIX fix distribution site to search for other AIX APARs which could impact your system:


Recommended Minimum AIX Technology Levels

The recommended minimum technology levels are minimum levels. Unless otherwise indicated, higher Technology (TL) or Service Pack (SP) levels are recommended. The prerequisite levels in the standard Informix product documentation are the minimum levels required for support and do not change after the product becomes generally available; the recommended minimum levels presented in this document deal with issues discovered after the product became generally available. Following these recommendations can result in increased system stability and reliability.

Recommendations for running Informix 12.10 on AIX
AIX versionRecommended minimum AIX technology levels
7.1 7100-03-01
6.16100-09-01

Recommendations for running Informix 11.70 on AIX
AIX versionRecommended minimum AIX technology levels
7.1 7100-03-01
6.16100-09-01

Recommendations for running Informix 11.50 on AIX
AIX versionRecommended minimum AIX technology levels
7.1 7100-03-01
6.16100-09-01
5.35300-12-08

Recommendations for running Informix 11.10 on AIX
AIX versionRecommended minimum AIX technology levels
6.16100-09-01
5.35300-12-08


Recommended Minimum AIX Firmware Release

It is important to maintain the most current version of firmware release to avoid known and fixed issues. You can access the firmware download list by providing your machine type and model number here:


AIX APARs which Affect Informix Server

AIX 7.1 APARs for Informix servers
APAR#AIX APAR DescriptionTLComments
IZ94610IO ON J2 AIO FASTPATH MAY CAUSE A HANG FOR SPARSE FILES 7100-00-03I/O hang
IZ92383TCP_NODELAYACK CAUSES EAGAIN ERROR ON SORECEIVE7100-00-03Indicators are 25582 and 25580 errors. Click here for more details.


AIX 6.1 APARs for Informix servers
APAR#AIX APAR DescriptionTLComments
IZ91171FAIL TO SEND SIGIO WHEN AIO J2 FASTPATH IS TAKEN6100-06-04I/O hang
IZ94663IO ON J2 AIO FASTPATH MAY CAUSE A HANG FOR SPARSE FILES 6100-06-05I/O hang
IZ85844TCP_NODELAYACK CAUSES EAGAIN ERROR ON SORECEIVE6100-06-05Indicators are 25582 and 25580 errors. Click here for more details.


AIX 5.3 APARs for Informix servers
APAR#AIX APAR DescriptionTLComments
IY8358064-BIT RTL ENABLED APPLICATIONS FAIL WITH ERROR 0509-0365300-04-02exec(): 0509-036 Cannot load program
IY93737INFORMIX COMMAND DUMPING CORE5300-08oninit fails with IOT/Abort trap



[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU001","label":"Analytics Private Cloud"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"}],"Version":"11.1;11.5;11.7;11.70;12.1","Edition":""}]

Document Information

Modified date:
16 June 2018

UID

swg21579767