IBM Support

IT25841: DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CSES AND CORRELATED SUB-QUERIES

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 might abend when running a query contains the following
    characteristics:
    
    1. a CSE consumed by different join sides or different UNION
    branches
    2. at least one consumer of the CSE contains a correlated
    predicate
    3. all consumers of the CSE contain a predicate equivalent to
    the correlated predicate
    
    
    The stack will show like below:
    
    000000C9FE425DC0 00007FF9862ADF8F 0000000000000001
    000000C9F9376150 0000000000000000 0000000000000000 offset:
    000000000000175F in <sqlno_analyze_relop>
    <S:\db2_v111m3fp3\ntx64\s1803021700\engn\sqno\sqlno_scan_assign.
    C:9350>
    000000C9FE425FD0 00007FF9862A9BCA 0000000000000000
    000000C999369208 000000C99A7DAF00 0000000000000000 offset:
    00000000000003DA in <sqlno_analyze_pred_expr>
    <S:\db2_v111m3fp3\ntx64\s1803021700\engn\sqno\sqlno_scan_assign.
    C:10848>
    000000C9FE426080 00007FF9862A8C94 000000C99A7E3ED8
    0000000000007CF8 00000000001F5000 00000000001F50A8 offset:
    0000000000000304 in <sqlno_assign_optprd>
    <S:\db2_v111m3fp3\ntx64\s1803021700\engn\sqno\sqlno_scan_assign.
    C:7835>
    000000C9FE4260F0 00007FF9862A88CA 000000C99A53A568
    0000000000000000 000000000000294D 00007FF9B6C22000 offset:
    000000000000005A in <sqlno_assign_prd>
    <S:\db2_v111m3fp3\ntx64\s1803021700\engn\sqno\sqlno_scan_assign.
    C:4640>
    000000C9FE4261C0 00007FF98636988D 0000000000000000
    0000000000000000 0000000000000000 0000000000000000 offset:
    00000000000000ED in <sqlno_call_sf>
    <S:\db2_v111m3fp3\ntx64\s1803021700\engn\include\sqlno_scan.h:12
    18>
    000000C9FE426480 00007FF9863610BD 000000C99A5FE768
    00007FF985613237 000000C99A7DACA0 000000C992E20E60 offset:
    000000000000016D in <sqlno_each_opr>
    <S:\db2_v111m3fp3\ntx64\s1803021700\engn\sqno\sqlno_scan_utils.C
    :842>
    000000C9FE426580 00007FF9862B634B 0000000000000000
    0000000000000000 0000000000000000 0000000000000000 offset:
    000000000000023B in <sqlno_assign_walk_quns_and_ff>
    <S:\db2_v111m3fp3\ntx64\s1803021700\engn\include\sqlno_scan.h:12
    18>
    000000C9FE426840 00007FF986361ACE 000000C9993487D0
    00007FF985613237 000000C99A7DACA0 000000C992E20E60 offset:
    0000000000000B7E in <sqlno_each_opr>
    <S:\db2_v111m3fp3\ntx64\s1803021700\engn\include\sqlno_scan.h:12
    18>
    000000C9FE426940 00007FF9862B634B 0000000000000000
    0000000000000000 0000000000000000 0000000000000000 offset:
    000000000000023B in <sqlno_assign_walk_quns_and_ff>
    <S:\db2_v111m3fp3\ntx64\s1803021700\engn\include\sqlno_scan.h:12
    18>
    ......
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 v11.1m4fp6.                                   *
    ****************************************************************
    

Problem conclusion

  • Fixed in Db2 v11.1m4fp6 and later.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT25841

  • 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-07-29

  • Closed date

    2021-03-23

  • Last modified date

    2021-03-23

  • 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:
24 March 2021