A fix is available
APAR status
Closed as new function.
Error description
KPM Db2
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1. All IBM Z Decision Support and IBM Z * * Performance and Capacity Analytics * * users who want out-of-the-box reports * * on Key Performance Metrics for DB2. * * 2. All IBM Z Performance and Capacity * * Analytics users of the Key Performance * * Metrics for z/OS component (KPMz). * **************************************************************** * PROBLEM DESCRIPTION: 1. Reporting on Key Performance * * Metrics for DB2 is not available * * in Cognos. * * 2. Improvements made to IBM Z * * Decision Support KPMz Cognos * * reports are not applied to IBM Z * * Performance and Capacity Analytics. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** 1. The Key Performance Metrics for DB2 component does not have out-of-the-box reporting available in Cognos. 2. Improvements made to IBM Z Decision Support KPMz Cognos reports are not applied to IBM Z Performance and Capacity Analytics. Problem Conclusion ------------------ 1. IBM Z Decision Support and IBM Z Performance and Capacity Analytics are enhanced to provide the following out-of-the- box Cognos reports for the KPM DB2 component: KPMDB201 KPM DB2 Plan Analysis KPMDB202 KPM DB2 Plan Trend by Week KPMDB203 KPM DB2 Plan Trend by Day KPMDB204 KPM DB2 Plan Trend by Hour KPMDB205 KPM DB2 Package Analysis KPMDB206 KPM DB2 Package Trend by Week KPMDB207 KPM DB2 Package Trend by Day KPMDB208 KPM DB2 Package Trend by Hour KPMDB209 KPM DB2 Package Detail by Week KPMDB210 KPM DB2 Package Detail by Day KPMDB211 KPM DB2 Package Detail by Hour KPMDB212 KPM DB2 User Transaction Trend by Week KPMDB213 KPM DB2 User Transaction Trend by Day KPMDB214 KPM DB2 User Transaction Trend by Hour KPMDB215 KPM DB2 User Transaction Detail by Week KPMDB216 KPM DB2 User Transaction Detail by Day KPMDB217 KPM DB2 User Transaction Detail by Hour Furthermore, the reports contain the following drill-throughs: KPM DB2 Plan Analysis -> KPM DB2 Plan Trend -> KPM DB2 Package Analysis -> KPM DB2 Package Trend -> KPM DB2 User Transaction Trend -> KPM DB2 User Transaction Detail -> KPM DB2 Package Analysis -> KPM DB2 Package Trend -> KPM DB2 Package Detail -> KPM DB2 Package Detail 2. IBM Z Performance and Capacity Analytics is enhanced to provide the following improvements for KPMz Cognos reports: Date range filters added to the following reports: KPMZOS LPAR 4 Hour MSU Utilization Hourly KPMZOS LPAR MSU Statistics Hourly New drill-throughs added to KPMz: KPMZOS CEC CPU Busy -> KPMZOS LPAR 4 Hour MSU Utilization Hourly -> KPMZOS LPAR MSU Statistics Hourly -> KPMZOS Job Highest CPU Hourly -> KPMZOS Workload Busy (specific date only)
Problem conclusion
Temporary fix
Comments
1. IBM Z Decision Support and IBM Z Performance and Capacity Analytics are enhanced to provide the following out-of-the- box Cognos reports for the KPM DB2 component: KPMDB201 KPM DB2 Plan Analysis KPMDB202 KPM DB2 Plan Trend by Week KPMDB203 KPM DB2 Plan Trend by Day KPMDB204 KPM DB2 Plan Trend by Hour KPMDB205 KPM DB2 Package Analysis KPMDB206 KPM DB2 Package Trend by Week KPMDB207 KPM DB2 Package Trend by Day KPMDB208 KPM DB2 Package Trend by Hour KPMDB209 KPM DB2 Package Detail by Week KPMDB210 KPM DB2 Package Detail by Day KPMDB211 KPM DB2 Package Detail by Hour KPMDB212 KPM DB2 User Transaction Trend by Week KPMDB213 KPM DB2 User Transaction Trend by Day KPMDB214 KPM DB2 User Transaction Trend by Hour KPMDB215 KPM DB2 User Transaction Detail by Week KPMDB216 KPM DB2 User Transaction Detail by Day KPMDB217 KPM DB2 User Transaction Detail by Hour Furthermore, the reports contain the following drill-throughs: KPM DB2 Plan Analysis -> KPM DB2 Plan Trend -> KPM DB2 Package Analysis -> KPM DB2 Package Trend -> KPM DB2 User Transaction Trend -> KPM DB2 User Transaction Detail -> KPM DB2 Package Analysis -> KPM DB2 Package Trend -> KPM DB2 Package Detail -> KPM DB2 Package Detail 2. IBM Z Performance and Capacity Analytics is enhanced to provide the following improvements for KPMz Cognos reports: Date range filters added to the following reports: KPMZOS LPAR 4 Hour MSU Utilization Hourly KPMZOS LPAR MSU Statistics Hourly New drill-throughs added to KPMz: KPMZOS CEC CPU Busy -> KPMZOS LPAR 4 Hour MSU Utilization Hourly -> KPMZOS LPAR MSU Statistics Hourly -> KPMZOS Job Highest CPU Hourly -> KPMZOS Workload Busy (specific date only)
APAR Information
APAR number
PH29885
Reported component name
TDS FOR Z/OS
Reported component ID
569510100
Reported release
901
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-09-24
Closed date
2020-10-19
Last modified date
2020-11-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI72123 UI72124
Modules/Macros
DRLWC17M DRLWC31M DRLWCKPD DRLWCPCA
Fix information
Fixed component name
TDS FOR Z/OS
Fixed component ID
569510100
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.
[{"Line of Business":{"code":"LOB35","label":"Mainframe SW"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS2DUM","label":"IBM Z Decision Support"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"901"}]
Document Information
Modified date:
03 November 2020