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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM31303

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED UR1

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-01-26

  • Closed date

    2011-05-04

  • Last modified date

    2011-11-10

  • 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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM31303

Modified date:

2011-11-10

Translate my page

Machine Translation

Content navigation