PM78062: INCORRECT QUERY 51 IN DSNTESQ. CLONE TABLE IS NOT TAKEN IN CONSIDERATION. TYPE 'C' IN SYSTABLES.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • INCORRECT QUERY 51 IN DSNTESQ. CLONE TABLE IS NOT TAKEN IN
    CONSIDERATION. TYPE 'C' IN SYSTABLES.
    

Local fix

  • N.A.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of the query 51 in DSNTESQ         *
    *                 sample.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: Query 51 did not take clone tables      *
    *                      into account and returned incorrect     *
    *                      rows for views that reference clone     *
    *                      tables.                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    DSNTESQ provides queries to identify logical inconsistency in
    the catalog. Query 51 did not take clone tables into account and
    returned incorrect rows for views that reference clone tables.
    The same problem would also happen if there were views that
    reference history tables.
    

Problem conclusion

  • DSNTESQ Query 51 has been updated to correct the problem.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM78062

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-29

  • Closed date

    2013-03-11

  • Last modified date

    2013-05-06

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

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

    UK92420

Modules/Macros

  •    DSNTESQ
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK92420

       UP13/03/27 P F303

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

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM78062

Modified date:

2013-05-06

Translate my page

Machine Translation

Content navigation