PM73555: ADMIN_INFO_SQL - ADDITIONAL COLLECTION FEATURES AND ENHANCEMENTS. FIXED SEVERAL PROBLEMS.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 for z/OS who use DSNADMSB       *
  *                 and/or the stored procedure                  *
  *                 ADMIN_INFO_SQL.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: THIS FIX ADDRESSES SEVERAL ISSUES       *
  *                      RELATED TO OUTPUT FROM ADMIN_INFO_SQL   *
  *                      FOR DDL AND STATISTICS. THE SYMPTOMS    *
  *                      USUALLY ARE INCORRECT OUTPUT WHEN       *
  *                      BUILDING THE DDL AND STATS OUTPUT       *
  *                      FILES OR CAN RELATE TO LONG             *
  *                      PROCESSING TIME.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SUMMARY OF ADMIN_INFO_SQL EVENTS:
  
  ADMIN_INFO_SQL was sometimes not producing the
  correct output when creating DDL and STATS output files to
  be used for DB2 problem analysis.
  
  Here are a list of reported issues:
  
  
       Fixed/Added index includes.
       Added V8 when getting stogroup so that an error does not
         occur on V10 CM8
       Fixed VCATNAME reference in stogroup
       Added BCREATOR when getting view/MQT info so that
         set schema is set correctly.
       Fixed double entry in last Partition MAXVALUE.
       New Error message when input parameter
         Tablename = PLAN_TABLE and Plan Info = NONE
         Tablename != PLAN_TABLE and Plan Info != NONE
       Write to log info and version checking moved to top of
         procs for efficiency.
       Updated DSNTEJ6I SAM sample JCL for DSNADMSB.
  
  ADMIN_INFO_SQL had several new features added:
  
       Enhanced PLAN_TABLE collection.
       Enhanced DSN_DETCOST_TABLE.
       Additional support in PLAN_TABLE service data.
       Additional table collection.
       Changed format of STATS output to readable from wrapped
         or compressed. Added STATS input parameter = 'C' to wrap
         STATS the old way to save space for large outputs.
       Collect Alias's related to views.
       Identify View/MQT processing in DDL output. Easier to read.
  

Problem conclusion

Temporary fix

Comments

• PROBLEM CONCLUSION:
  
  The reported ADMIN_INFO_SQL problems are now corrected.
  
  
  ADDITIONAL KEYWORDS:
  SQLSP SQLSTOREDPROC ADMININFOSQL
  ž**** PE13/07/11 FIX IN ERROR. SEE APAR PM85936  FOR DESCRIPTION
  

APAR Information

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

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

  UK83945 UK83946

Modules/Macros

• DSN@DMSB DSN@DMSS DSNADMSB DSNADMSS DSNTEJ6I
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK83945

     UP12/12/18 P F212

• R910 PSY UK83946

     UP12/12/19 P F212

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.