IBM Support

IC62043: EXECUTING GENXMLQUERYCLOB OR GENXMLQUERY FUNCTIONS MAY CAUSE THEENGINE TO CRASH OR CORRUPT MEMORY

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 you execute the genxmlqueryclob or genxmlquery functions,
    memory corruption may occur and cause the engine to crash or bad
    XML output to be generated.
    
    Example of bad XML generated:
    
    <row>
    <id>18</id>
    <some_code>TAG2</some_code>
    <layer_name>Example layer</layer_name>
    <mandatory>N</mandatory>
    <special_order>40</special_order>
    <special_func>SomeFunc</special_func>
    <code>FUNC</code>
    <feature_hideable>t</feature_hideab<row>  <--- here you see a
    bad closing tag
    <id>19</id>
    <some_code>TAG2</some_code>
    ...
    
    In the case of an engine crash you may see the following stack
    trace:
    
    oninit :: add_to_list
    oninit :: mt_shm_malloc_segid
    oninit :: mt_realloc
    oninit :: mi_realloc
    oninit :: genxmlautoelem
    oninit :: genxmlqueryclob
    oninit :: udrlm_clang_execute_internal
    oninit :: udrlm_clang_execute
    oninit :: udrlm_exec_routine
    oninit :: udr_execute
    oninit :: exroutine
    oninit :: geval
    oninit :: evalcols
    oninit :: runudr
    oninit :: ip_curnext
    oninit :: ip_fetch
    oninit :: getrow
    oninit :: fetchrow
    oninit :: exfetch
    oninit :: sql_nfetch
    oninit :: sq_nfetch
    oninit :: sqmain
    oninit :: listen_verify
    oninit :: spawn_thread
    oninit :: startup
    
    The query may also return a -9791 error
    
     9791: User Defined Routine (genxmlqueryclob) execution failed.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Applications using XML publishing functions like             *
    * genxmlqueryclob or genxmlquery                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * This is a case of memory corruption and can cause the server *
    * to abend or even hang indefinitely.                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IDS 11.50.xC6 and above.                          *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in IDS 11.50.xC6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC62043

  • Reported component name

    IBM IDS ENTRP E

  • Reported component ID

    5724L2304

  • Reported release

    B15

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-15

  • Closed date

    2010-01-22

  • Last modified date

    2010-01-22

  • 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

[{"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:
22 January 2010