IC77891: A STORED PROCEDURE CREATED BEFORE AN UPGRADE RETURNS 26060 OR 26061 WHEN RUNNING IN MULTIPLE SESSIONS AT THE SAME TIME

APAR status

• Closed as program error.

Error description

• You just upgraded. A stored procedure that existed before the
  upgrade is running in multiple sessions. The stored procedure
  returns errors 26060 or 26061.
  
  Some sysadmin stored procedures can also generate these errors
  
  eg:
  
  20:00:00  SCHAPI: [Auto Update Statistics Evaluation 18-4] Error
  -26061 Procedure (sysadmin:aus_setup_table) was created with an
  older version of the server and must be dropped and recreated
  again in order to work properly
  

Local fix

• Drop and recreate the Stored Procedure.
  If the Stored Procedure exists in the sysadmin database,
  reset/rebuild the sysadmin database:
  http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.
  ibm.adref.doc/ids_sapi_070.htm
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * A stored procedure that existed before the upgrade is        *
  * running in multiple sessions and objects in the procedure    *
  * are changed from last time execution or update statistics.   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A stored procedure that existed before the upgrade is        *
  * running in multiple sessions. The stored procedure may       *
  * return error 26060 or 26061.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC10 when available.                        *
  ****************************************************************
  

Problem conclusion

• The problem is fixed in 11.50.xC10.
  

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

• RB50 PSY

     UP

• RB70 PSY

     UP