IBM Support

IT34250: 901/TRAP WHEN DB2 QUERY HAS GROUP BY AND OJ WITH UNION

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

  • Db2 query may generate 901/trap when the following conditions
    are met:
    - there is an Outer Join
    - a UNION is referenced in the Null Producing side of Outer Join
    - there is a Group By above UNION
    - the Tuple Preserving side of Outer Join is smaller than Null
    Producing Side
    
    Similar messages can be seen in the db2diag.log
    sqlcaid : SQLCA    sqlcabc: 136  sqlcode: -901  sqlerrml: 20
    sqlerrmc: columnZval not found
    --
    sqlcaid : SQLCA    sqlcabc: 136  sqlcode: -901  sqlerrml: 24
    sqlerrmc: qncData.doptqncp is null
    ---
    sqlcaid : SQLCA    sqlcabc: 136  sqlcode: -901  sqlerrml: 41
    sqlerrmc: Order cols removed from sort output cols.
    --
    sqlcaid : SQLCA    sqlcabc: 136  sqlcode: -901  sqlerrml: 21
    sqlerrmc: Found zero CLOB.reset
    ----
    

Local fix

  • Use of one of the following setting either in instance level or
    with optguidelines:
    DB2COMPOPT=NO_GBPU
    or
    DB2_EXTENDED_OPTIMIZATION='GBPU_EXT OFF'
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT34250

  • 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

    2020-09-17

  • Closed date

    2021-03-15

  • Last modified date

    2021-03-15

  • 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

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

Document Information

Modified date:
16 March 2021