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

Obtain the fix for this APAR.

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