IC61548: -9791 ROUTINE EXECUTION TRAP ERROR IN IP_EVALEXPR AND IP_EVALSQL

APAR status

• Closed as program error.

Error description

• A -9791 error is returned to the client during execution of a
  stored procedure.
  
  An Assert failure will be generated with a stack trace similar
  to:
  
  0x1001f52e8 oninit :: ip_evalexpr
  0x1001f3938 oninit :: runproc
  0x100203244 oninit :: udrlm_spl_execute
  0x1004df51c oninit :: udrlm_exec_routine
  0x100235630 oninit :: udr_execute
  0x10023c500 oninit :: exroutine
  0x1005b5c6c oninit :: execproc
  0x1002254b8 oninit :: aud_execproc
  0x1005b2fd4 oninit :: excommand
  0x1003839c4 oninit :: dotrstmts
  0x1003833e4 oninit :: dotrigs
  0x100382bf8 oninit :: ferafttrig
  0x100378fd0 oninit :: dodmlrow
  0x1003775dc oninit :: dodelupd
  0x1005b298c oninit :: excommand
  0x1001f884c oninit :: ip_evalsql
  0x1001f39bc oninit :: runproc
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Applications running same SPL concurrently in big stress     *
  * scenario.                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * -9791 ERROR: Routine execution trap error in ip_evalexpr and *
  * ip_evalsql. The same SPLs executed in parallel may get -9791 *
  * error in rare scenarios.                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xC6 or above.                           *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in IDS 11.50.xC5W2.
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP