IBM Support

LI74088: 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 affected: This issue is specific for Linux and SunOS only.
    
    Problem Description: Instance ABEND can occur when trusted UDF
    and trusted scalar function are used in the same query like
    
    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.
    
    Problem Summary:
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.1, FixPak 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74088

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-12-22

  • Closed date

    2009-05-04

  • Last modified date

    2009-05-04

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

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

    LI74111

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R910 PSY

       UP

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 October 2021