IT07982: SQL COMMAND CAN TERMINATE WITH SQL ERROR -242 AND ISAM ERROR -104 WHEN VIOLATIONS AND DIAGNOSTICS TABLES ARE USED

APAR status

• Closed as program error.

Error description

• When using violations and diagnostics tables you might observe
  SQL commands within one session terminate with SQL error code
  -242 and ISAM error -104.
  
  The ISAM error code -104 means "too many files open". When you
  have a look at the output of onstat -g opn for the affected
  session you will see more than 32700 open table entries with the
  partition numbers of the violations and diagnostics table
  appearing repeatedly.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * 12.10.XCX                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.XC6                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.XC6
  

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

• RC10 PSY

     UP