PM31303: ADDED MODELING, QUERYINFO COLLECTION, INDEX PROBING, RTS COLLECT ION AND SEVERAL FIXES 11/11/10 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• ADDED MODELING, QUERYINFO COLLECTION, INDEX PROBING,
  RTS COLLECTION AND SEVERAL FIXES
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 for z/OS who need to send       *
  *                 environment re-creation information to the   *
  *                 DB2 service team when requested for a        *
  *                 problem related to DB2 query processing.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: THIS FIX ADDRESSES SEVERAL ISSUES       *
  *                      RELATED TO DDL AND STATS OUTPUT FILES   *
  *                      GENERATED FROM THE                      *
  *                      SYSPROC.ADMIN_INFO_SQL STORED           *
  *                      PROCEDURE.                              *
  *                      THE SYMPTOMS USUALLY ARE INCORRECT      *
  *                      OUTPUT WHEN BUILDING THE DDL AND        *
  *                      STATS OUTPUT FILES.                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  SUMMARY OF ADMIN_INFO_SQL EVENTS:
  
  The ADMIN_INFO_SQL stored procedure captures statistics
  about a DB2 subsystem, its objects, and applications and
  returns the results in a data set or as a result set.
  This information can help IBM Software Support recreate
  and troubleshoot problems, like a poorly performing SQL query.
  
  ADMIN_INFO_SQL was sometimes not producing the correct output
  when creating the DDL and STATS output files that are used
  by DB2 service to re-create a problem related to query
  processing.  Here are a list of reported issues:
  
  - ADMIN_INFO_SQL syntax problem with newline causing problems
    with Java result sets.
  
  - ADMIN_INFO_SQL not closing the cursors when calling
    ADMIN_COMMAND_DB2 stored procedure.
  
  - ADMIN_INFO_SQL formatted STATS_FORMAT in SYSKEYTARGETS
    incorrectly.
  
  - Reduced code and data segment size for ADMIN_INFO_SQL.
  
  - Several array sizes were incorrect and could cause an
    overlay.
  
  - Wrapping EXPLAIN information when using job DSNTEJ6I
    to call DSNADMSB. Added DCB=(RECFM=VB,LRECL=4096) to
    SYSPRINT.
  
  ADMIN_INFO_SQL had several new features added:
  
  - Get foreign key dependencies.
  
  - Index probing and real-time statistics (RTS) collection.
  
  - Production modeling.
  
  - DSN_QUERYINFO_TABLE collection.
  
  - Now gets MEPL information.
  

Problem conclusion

Temporary fix

Comments

• PROBLEM CONCLUSION:
  
  The reported ADMIN_INFO_SQL DDL and STATS problems
  are now corrected.
  
  
  ADDITIONAL KEYWORDS:
  SQLSP SQLSTOREDPROC ADMININFOSQL INDEXPROBING
  

APAR Information

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

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

  UK67425 UK67426

Modules/Macros

• DSN@DMSB DSN@DMSS DSNADMSA DSNADMSB DSNADMSJ
  DSNADMSN DSNADMSO DSNADMSP DSNADMSS DSNTEJ6I
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK67425

     UP11/05/19 P F105

• R910 PSY UK67426

     UP11/05/19 P F105

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.