PI69565: ENHANCE ADMIN_INFO_SQL TO GENERATE PREDICATE, TABLE AND COMPOSITE LEVEL COUNTS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Enhance ADMIN_INFO_SQL to generate predicate, table and
  composite level counts.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
  *                 customers who use the stored procedure       *
  *                 SYSPROC.ADMIN_INFO_SQL, either directly      *
  *                 with the SQL CALL statement, or indirectly   *
  *                 using the Query Environment Capture          *
  *                 feature of Data Studio or Optim Query        *
  *                 Workload Tuner, or from the batch program    *
  *                 DSNADMSB.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Predicate, table, and composite         *
  *                      level counts are required to            *
  *                      improve the efficiency of query         *
  *                      performance analysis.                   *
  ****************************************************************
  * RECOMMENDATION: Apply PTF                                    *
  ****************************************************************
  Predicate, table, and composite level counts are required
  to improve the efficiency of query performance analysis.
  

Problem conclusion

Temporary fix

Comments

• This APAR modifies ADMIN_INFO_SQL and DSNADMSB to add a
  Generated Counts Report at the bottom of the EXPL file.
  This report consists of Local Predicate Counts, One Table
  Composite Counts and Composite Level Counts.
  

APAR Information

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

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

  PI69657 UI42704 UI42705

Modules/Macros

• DSN@DMSS DSNADMSS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI42704

     UP16/12/07 P F612

• RB10 PSY UI42705

     UP16/12/07 P F612

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.