PM39871: ADD PROFILE TABLE ENHANCEMENT, COLLECT USER OBJECTS RELATED TO S YSTEM OBJECTS AND SEVERAL FIXES.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

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 when creating stogroup
      DDL.
    
    - "DROP TABLESPACE" DDL did not include the database.
    
    - Not collecting user created indexes, synonyms and aliases
      as well as stats for catalog tables used in queries.
    
    - Add // to the end of each JCL file created.
    
    - Backward compatibility with RTS tables V10 -> V9 inserts
      SYSTABLESPACESTATS and SYSINDEXSPACESTATS tables.
    
    ADMIN_INFO_SQL has these new features added:
    
    - Added three new columns for DSN_PROFILE_TABLE collection.
    
    - Added ability to shutoff Foreign Key and View dependency
      collection which can be voluminous.
    

Problem conclusion

Temporary fix

Comments

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

APAR Information

  • APAR number

    PM39871

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-23

  • Closed date

    2011-08-01

  • Last modified date

    2011-09-01

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

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

    UK70375 UK70376

Modules/Macros

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

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK70375

       UP11/08/16 P F108

  • R910 PSY UK70376

       UP11/08/16 P F108

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 #:

PM39871

Modified date:

2011-09-01

Translate my page

Machine Translation

Content navigation