PM85936: ADMIN_INFO_SQL - ADDITIONAL COLLECTION FEATURES AND ENHANCEMENTS. FIXED SEVERAL PROBLEMS. 13/07/30 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Fixed several problems with collection
    ADMIN_INFO_SQL -  ADDITIONAL COLLECTION FEATURES AND
    ENHANCEMENTS. FIXED SEVERAL PROBLEMS.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 for z/OS who use DSNADMSB       *
    *                 and/or the stored procedure                  *
    *                 ADMIN_INFO_SQL who have PM73555 applied      *
    *                 (UK83945 for V10; UK83946 for V9)            *
    ****************************************************************
    * 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:                                              *
    ****************************************************************
    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 is a list of reported issues:
    
      - Ignore DB errors from Accelerator tables
      - Check ZPARM ACCEL for Accelerator existence
      - Bad input parameter message now in the log
      - Zero out error msg_var when DSNADMMW is called
      - PLAN_TABLE APPLNAME column from 9 to 24 bytes
      - Business time check constraint display problem
      - Remove duplicate call to SYSTABLES to get Clone/Base
        relationship
      - SQLCODE514 problems for V10 CM8
    
    ADMIN_INFO_SQL has several new features added:
    
      - Allow Test for input parameters
      - Collect DSN_FILTER_TABLE collection
      - Collect PACKAGE information from BIND collection
      - Collect Synonym info for Views
      - Added check for alias PLAN_TABLE input
      - Recoded ZPARM collection for speed
      - Collect QUERYINFO table only when accelerator is on
    

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    PM85936

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-29

  • Closed date

    2013-07-29

  • Last modified date

    2013-09-03

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

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

    UK96219 UK96220

Modules/Macros

  •    DSN@DMSB DSN@DMSS DSNADMSB DSNADMSS HDBAA10J
    HDB9910J
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK96219

       UP13/08/14 P F308

  • R910 PSY UK96220

       UP13/08/14 P F308

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:

A10

Reference #:

PM85936

Modified date:

2013-09-03

Translate my page

Machine Translation

Content navigation