IBM Support

IC74057: SELECT ROW VARIABLE WITH ASTERISK(*) NOTATION IN STORED PROCEDURE FAILS WITH ERROR -9791 AT REPEATED EXECUTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • You can use an asterisk (*) notation to select all fields of a
    ROW column declared as a variable in the stored procedure.
    The repeated execution of the procedure with the select of ROW
    variable using an asterisk (*) notation assert fails
    in dotted2expr() with error -9791.
    
    Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem
    IBM Informix Dynamic Server Version 11.50.FC8
    Who: Session(65, informix@gaugin, 13563, 41588120)
         Thread(116, sqlexec, 41549e00, 3)
         File: mtex.c Line: 417
    Action: Please notify IBM Informix Technical Support.
    stack trace for pid 7757 written to
    /server/1150fc8/tmp/af.45cb32c
    Exception Caught. Type: MT_EX_OS, Context: mem
    (-9791): ERROR: Routine execution trap -- procname=<p1>
    procid=387
    reason: mem
    
    
    dotted2expr()
    expr2expr()
    prjlst2expr()
    sel2cb()
    subq2cb()
    ins2cb()
    p_sp2cb()
    ip_sqlparse()
    ip_evalsql()
    runproc()
    udrlm_spl_execute()
    udrlm_exec_routine()
    udr_execute()
    exroutine()
    execproc()
    aud_execproc()
    excommand()
    sq_execute()
    sqmain()
    listen_verify()
    spawn_thread()
    startup()
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users on all platforms where IDS is supported                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Server abends when running procedure multiple times and      *
    * procedure has ROW expanded like m.*                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.50xC9                                          *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC74057

  • Reported component name

    IBM IDS ENTRP E

  • Reported component ID

    5724L2304

  • Reported release

    B15

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-01-24

  • Closed date

    2011-09-27

  • Last modified date

    2011-09-27

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • RB15 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
27 September 2011