PH68881: QUERIES PROVIDED IN ++HOLD OF PH67463/UO04475 SHOULD BE REVISED 25/12/03 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The queries provided in ++HOLD of PH67463/UO04475 help identify
  inconsistency between catalog tables and SPTR. The queries
  return correct results but may have bad performance with large
  size of catalog data.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 13 for z/OS users of FREE PACKAGE    *
  *                 with PLANMGMTSCOPE(INACTIVE) and             *
  *                 INVALIDONLY(YES) with PH67463/UO04475        *
  *                 applied.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: In the ++HOLD text of PH67463/UO04475,  *
  *                      The two queries for identifying         *
  *                      inconsistency between catalog tables    *
  *                      and directory tables are correct but    *
  *                      could have bad performance when         *
  *                      running against catalog and directory   *
  *                      tables of huge size.                    *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  Db2 used a non-matching index scan for the queries in the
  ++HOLD text because the predicate on the leading column of the
  index was not provided.
  

Problem conclusion

• Queries in the ++HOLD text have been modified with the
  predicate on the leading column of the index. This allows Db2
  to choose a matching index scan which provides much better
  performance.
  

Temporary fix

Comments

APAR Information

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

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

  UO06353

Modules/Macros

• DSN@HOLD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UO06353

     UP25/12/31 I 1000 {

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.