A fix is available
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
10 November 2011