A fix is available
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
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:
01 September 2011