IT41337: SETTING SESSION_LIMIT_TEMPSPACE LIMIT KILLS INFORMIX/DBSA USER SESSION

APAR status

• Closed as program error.

Error description

• As per the below document, The SESSION_LIMIT_TEMPSPACE
  configuration parameter specifies the maximum amount of
  temporary table space that a session can allocate. This limit
  does not apply to a user who holds administrative privileges,
  such as user informix or a DBSA user.
  
  https://www.ibm.com/docs/en/informix-servers/14.10?topic=paramet
  ers-session-limit-tempspace-configuration-parameter
  
  But we can see that, the limit applies to informix or a DBSA
  user.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to and including 12.10.xC16W1 *
  * and prior to 14.10.xC11.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 14.10.xC11.                       *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 14.10.xC11.  This will also be fixed in
  a future release of Informix Server 12.10.
  

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