A fix is available
APAR status
Closed as new function.
Error description
Enhance ADMIN_INFO_SQL to generate predicate, table and composite level counts.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS * * customers who use the stored procedure * * SYSPROC.ADMIN_INFO_SQL, either directly * * with the SQL CALL statement, or indirectly * * using the Query Environment Capture * * feature of Data Studio or Optim Query * * Workload Tuner, or from the batch program * * DSNADMSB. * **************************************************************** * PROBLEM DESCRIPTION: Predicate, table, and composite * * level counts are required to * * improve the efficiency of query * * performance analysis. * **************************************************************** * RECOMMENDATION: Apply PTF * **************************************************************** Predicate, table, and composite level counts are required to improve the efficiency of query performance analysis.
Problem conclusion
Temporary fix
Comments
This APAR modifies ADMIN_INFO_SQL and DSNADMSB to add a Generated Counts Report at the bottom of the EXPL file. This report consists of Local Predicate Counts, One Table Composite Counts and Composite Level Counts.
APAR Information
APAR number
PI69565
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-09-21
Closed date
2016-11-17
Last modified date
2017-01-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
PI69657 UI42704 UI42705
Modules/Macros
DSN@DMSS 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":"10.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":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 January 2017