IBM Support

IT04066: RUNNING A STORED PROCEDURE CREATES AF FILE AND ERROR 9791

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

  • Running a stored procedure assert fails and generates error
    9791.  The stack looks like:
    
    oninit :: expr2expr
    oninit :: op_bind_rtn
    oninit :: buildexpr
    oninit :: expr2expr
    oninit :: cond2expr
    oninit :: sel2cb
    oninit :: subq2cb
    oninit :: sq2expr
    oninit :: union_exist_sq2expr
    oninit :: expr2expr
    oninit :: op_bind_rtn
    oninit :: buildexpr
    oninit :: expr2expr
    oninit :: cond2expr
    oninit :: sel2cb
    oninit :: subq2cb
    oninit :: sq2expr
    oninit :: subq2expr
    oninit :: collsubq2expr
    oninit :: expr2expr
    oninit :: determine_cdt_coll_type
    oninit :: tlgetcolltab
    oninit :: tlgetddtab
    oninit :: spgettab
    oninit :: tlp2tnode + 0x714 sp=0x10bdf3a40(0x101556,
    0x0, 0xffffffffffffffff, 0x10bbb88
    38, 0x0, 0x0)
    oninit :: tbl2tab
    oninit :: sel2cb
    oninit :: qblk2cb
    oninit :: ip_scurparse_internal
    oninit :: ip_scurstart
    oninit :: ip_evalcursor
    oninit :: runproc
    oninit :: udrlm_spl_execute
    oninit :: udrlm_exec_routine
    oninit :: udr_execute
    oninit :: exroutine
    oninit :: execproc
    oninit :: aud_execproc
    oninit :: excommand
    oninit :: sq_execute
    oninit :: sqmain
    oninit :: listen_verify
    oninit :: spawn_thread
    oninit :: th_init_initgls
    oninit :: startup
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users running INTERSECT or MINUS operators inside Stored     *
    * Procedure.                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to IDS-12.10.xC5                                      *
    ****************************************************************
    

Problem conclusion

  • Problem Fixed In IDS-12.10.xC5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT04066

  • Reported component name

    IBM IDS EXPRESS

  • Reported component ID

    5724L2305

  • Reported release

    B15

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-08-27

  • Closed date

    2015-10-16

  • Last modified date

    2015-10-16

  • 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 EXPRESS

  • Fixed component ID

    5724L2305

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:
16 October 2015