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":null,"label":null},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            30 December 2020
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback