IBM Support

IT26992: DETERMINISTIC UDF CAN CAUSE INSTANCE TO TRAP

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

  • A geospatial query can cause DB2 to trap.
    
    The trap file produced will show a stack like this:
    
    0x00001016EFFED0C0 0x000010000F436C7C
    0x00001016EFFED200 0x000010000F4353CC
    _Z15sqlriusf_commonP8sqlrr_cbP10sqlri_ufob + 0x040c
    0x00001016EFFED390 0x000010000F434E8C _Z8sqlriusfP8sqlrr_cb +
    0x005c
    0x00001016EFFED3E0 0x000010000F346760
    _Z14sqlriNljnPipedP8sqlrr_cb + 0x0600
    0x00001016EFFED4E0 0x000010000F29A410
    _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x0400
    0x00001016EFFED630 0x000010000EB5964C
    _Z16sqlrr_dss_routerP8sqlrr_cb + 0x09ec
    0x00001016EFFED880 0x000010000EB582C8
    _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x0eb8
    0x00001016EFFEDB90 0x000010000B74BBE0
    0x00001016EFFEDDF0 0x000010000B746378
    _Z21sqleProcessSubRequestP8sqeAgent + 0x22c8
    0x00001016EFFEE200 0x000010000B7C3298 _ZN8sqeAgent6RunEDUEv +
    0x09d8
    0x00001016EFFEE3D0 0x00001000105270C4 _ZN9sqzEDUObj9EDUDriverEv
    + 0x0344
    0x00001016EFFEE440 0x0000100010526D5C _Z10sqlzRunEDUPcj + 0x001c
    0x00001016EFFEE460 0x000010000E2D15B4 sqloEDUEntry + 0x0334
    0x00001016EFFEE790 0x0000100000088AF4
    0x00001016EFFEEA10 0x00001000169C8814 clone + 0x00e4
    
    A few conditions that need to be fullfilled:
    - More than 2 input parameters
    - Many variations of input parameters
    The problem is more likely when VARCHAR/VARBINARY input data
    types are used.
    
    BLU users might be affected since Db2 V11.1 M3FP3, non BLU users
    starting with M4FP4.
    

Local fix

  • Disable UDF caching.
    ROW: db2set DB2_RUNTIME_DEBUG_FLAGS=10000000 (since M4FP4)
    BLU: db2set DB2_CDE_FLAGS=288230376151711744
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT26992

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-11-15

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-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

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 January 2020