IBM Support

IT32724: SPL USING EXECUTE IMMEDIATE AND SQLTRACE IS ON CAN CAUSE AF ON STMTMON_SAVE_ITERATOR

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When a stored procedure is using execute immediate expressions
    in order to drop/create tables and indexes on the tables and
    SQLTRACE is on, an assertion failed may be seen:
    
    
    0x00000000006d2db8 (oninit) stmtmon_save_iterator
    0x00000000006dd933 (oninit) stmtmon_insert
    0x00000000005fb56b (oninit) excommand
    0x00000000006b9aa2 (oninit) ip_evalsql
    0x00000000006ba35a (oninit) ip_execimmed
    0x00000000006c18a5 (oninit) runproc
    0x00000000006c2f01 (oninit) udrlm_spl_execute
    0x0000000000a86c1e (oninit) udrlm_exec_routine
    0x00000000006fe0f9 (oninit) udr_execute
    0x0000000000704855 (oninit) exroutine
    0x0000000000a4345d (oninit) sq_exproc
    0x0000000000b0b6c1 (oninit) sqmain
    0x000000000155d25b (oninit) spawn_thread
    0x00000000014201b0 (oninit) th_init_initgls
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5.  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Informix Server 12.10.xC15 (when available) or    *
    * 14.10.xC5.                                                   *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix Server 12.10.xC15 and 14.10.xC5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32724

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-05-01

  • Closed date

    2020-12-29

  • Last modified date

    2020-12-29

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]

Document Information

Modified date:
30 December 2020