IBM Support

IT28596: QUERY WITH INDEX SCAN ON A COLUMNAR TABLE WHICH IS UNDER A UNIONMAY GET INCORRECT RESULT

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

  • If Query has a Plan where UNION has a leg with Index Scan on a
    Columnar Table, then it is possible to get incorrect result.
    Example problem portion of the Plan:
    
                             UNION
                                  |
                       /-------+-------\
               TBSCAN                     FETCH
               from                         /----+-----\
              Table A                  IXSCAN   CO-TABLE: Table B
                                                |
                                        INDEX: Index_Table_B
    

Local fix

  • db2set  DB2_REDUCED_OPTIMIZATION="COL_IXSCAN_ALL_V1133 OFF"
    -im option can be used, BUT Static sql will need to be reboud
    and already compiled dynamic sql re-compiled as well.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * COLUMNAR TABLES WITH INDEXES ONLY                            *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please, See Error Description and Install this Fix.          *
    ****************************************************************
    

Problem conclusion

  • Please, See Error Description and Install this Fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT28596

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-03-27

  • Closed date

    2019-11-29

  • Last modified date

    2019-11-29

  • 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 PSY

       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:
29 November 2019