PM87084: INCORROUT FOR TEXT SEARCH, SORT IS MISSED WHEN RID COLUMN IS DEFINED AS GENERATED ALWAYS

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This is about Text Search CONTAINS function. The explain
    show that no sort is done though DISTINCT and ORDER BY are
    specified. Then this results in INCORROUT.
    
    If the ROWID column is defined as NOT NULL GENERATED BY DEFAULT,
    then there is sort in access path, and query result is correct.
    but if NOT NULL GENERATED ALWAYS is specified, then there is no
    sort in access path, and query result is incorrect.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 for z/OS users whose query contains  *
    *                 ORDER BY and an OMNIFIND function.           *
    ****************************************************************
    * PROBLEM DESCRIPTION: DB2 may meet incorrect output if the    *
    *                      query satisfies the following           *
    *                      conditions:                             *
    *                                                              *
    *                      1. The query refers to a table with an  *
    *                         OMNIFIND function.                   *
    *                      2. The table with OMNIFIND function is  *
    *                         the leading table with a unique      *
    *                         index.                               *
    *                      3. The columns for ORDER BY are from    *
    *                         this table.                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    DB2 may meet incorrect output when the query with an ORDER BY
    clause refers to a table with an OMNIFIND function.
    
    
    ADDITIONAL KEYWORDS:
    SQLORDERBY  SQLOMNIFIND  SQLINCORROUT SQLINCORR
    INCORROUT DB2INCORR/K
    

Problem conclusion

  • The problems mentioned above are fixed so that DB2 will not
    meet incorrect output again.
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PM87084

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-16

  • Closed date

    2013-05-21

  • Last modified date

    2013-07-03

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

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

    UK94462 UK94463

Modules/Macros

  • DSNXOTS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK94462

       UP13/06/05 P F306 ½

  • R910 PSY UK94463

       UP13/06/05 P F306 ½

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM87084

Modified date:

2013-07-03

Translate my page

Machine Translation

Content navigation