IBM Support

IT16869: SELECT ROW CHANGE TOKEN WILL RETURN WRONG RESULT WHEN USING RIDSCAN (ROW IDENTIFIER SCAN)

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SELECT ROW CHANGE TOKEN will return wrong result when using
    RIDSCAN (Row Identifier Scan)
    
    e.g.: following sql will return wrong result when using RIDSCAN
    ( (Row Identifier Scan)
    
    
    => db2 "select row change token for  bas.QUEUEINFO_20160723 FROM
    bas.QUEUEINFO_20160723 where id < 4467"
    
    1
    --------------------
                       0
                       0
                       0
                       0
                       0
                       0
                       0
                       0
                       0
                       0
    
    ...
                       0
                       0
    
      140 record(s) selected.
    
    Access Plan like following:
    -----------
            Total Cost:             36.5867
            Query Degree:           1
    
                   Rows
                  RETURN
                  (   1)
                   Cost
                    I/O
                    |
                  140.456
                  FETCH
                  (   2)
                  36.5629
                    33
               /----+-----\
           140.456         4922
           RIDSCN     TABLE: BAS
           (   3)   QUEUEINFO_20160723
           6.9544           Q1
              1
             |
           140.456
           SORT
           (   4)
           6.95392
              1
             |
           140.456
           IXSCAN
           (   5)
           6.91635
              1
             |
            4922
       INDEX: SYSIBM
     SQL160808050052790
             Q1
    

Local fix

  • Use an optimizer guideline to choose a different access, like
    IXSCAN:
    <IXSCAN TABLE='tablename_in_query'/>
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * 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

    IT16869

  • 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

    2016-09-01

  • Closed date

    2018-07-16

  • Last modified date

    2018-07-16

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

    IT16693

  • 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

[{"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 June 2020