IBM Support

LI74111: INSTANCE ABEND CAN OCCUR WHEN TRUSTED UDF AND TRUSTED SCALAR FUNCTION ARE USED IN THE SAME QUERY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The following SQL statement is an example of a statement that
    may trigger this condition.
    SELECT RIGHT(PATH,9) FROM SYSIBMADM.DBPATHS or SELECT
    LEFT(PATH,9) FROM SYSIBMADM.DBPATHS
    where SYSIBMADM.DBPATHS is a view on top of the table function
    SYSPROC.ADMIN_LIST_DB_PATHS() UDF
    RIGHT is a scalar function.
    
    This query leads to instance termination and the following stack
    dump can be observed in case of an ABEND
    
    _Z20sqleUCtrustedLvlTermP15sql_static_dataP8sqlrr_cbP18sqleUCtru
    stedStackP10sqlri_ufob + 0x02b6
    _Z28sqlri_close_udf_ufob_cleanupP10sqlri_ufobP5sqlcaP8sqlrr_cb +
    0x0a0c
    _Z19sqlri_close_udf_eosP25sqlra_sql_context_siblingiP8sqlrr_cb +
    000001FFFFFEF4F0
    _Z16sqlricls_complexP8sqlrr_cbilll + 0x238c
    _Z16sqljs_ddm_clsqryP14db2UCinterfaceP14sqljsDDMObject + 0x1670
    
    A key condition for this problem to occur is that the UDF code
    needs to attach to the instance.
    ( This is not the case for all UDF's. )
    The problem also does not appear on AIX and has so far only been
    observed on Linux and Solaris.
    

Local fix

  • n/a
    

Problem summary

  • Users Affrected: Aix
    
    Problem Description:
    
    Problem summary:
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74111

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-01-12

  • Closed date

    2009-06-14

  • Last modified date

    2009-06-14

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

    LI74088

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

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
14 June 2009