A fix is available
APAR status
Closed as program error.
Error description
When running CP z/OS ISPF green screen reports the reports fail with SQL Error occurred in module 'DRLERDIR'. SQL return code -206 at line nnn. DSNT408I SQLCODE = -206, ERROR: aaaa IS NOT VALID IN THE CONTEXT WHERE IT IS USED
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All IBM Z Performance and Capacity Analytics * * users of the CPU reports for the Capacity * * Planning - z/OS Component when run via * * ISPF. * **************************************************************** * PROBLEM DESCRIPTION: CPU reports for the Capacity Planning - * * z/OS Component, when run via ISPF, may * * fail with SQLCODE -206. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** The report queries defined for the CPU subcomponent of the Capacity Planning - z/OS component refer to undefined column names in the following views: CP_CPU_CEC_TV CP_CPU_CEC_HV CP_CPU_CEC_DV CP_CPU_CEC_WV CP_CPU_LPAR_TV CP_CPU_LPAR_HV CP_CPU_LPAR_DV CP_CPU_LPAR_WV CP_CPU_WKLD_TV CP_CPU_WKLD_DV CP_CPU_WKLD_HV CP_CPU_WKLD_WV CP_CPU_WKLDA_TV CP_CPU_WKLDA_HV CP_CPU_WKLDA_DV CP_CPU_WKLDA_WV CP_CPU_WKLDB_TV CP_CPU_WKLDB_HV CP_CPU_WKLDB_DV CP_CPU_WKLDB_WV As a result, the following reports fail to run: CPCPU01 CP CEC MIPS Hourly CPCPU02 CP LPAR MIPS Hourly CPCPU03 CP LPAR MIPS by CEC Average Hourly CPCPU04 CP LPAR MIPS by CEC Peak Hourly CPCPU05 CP CEC MIPS Daily CPCPU06 CP CEC MIPS Weekly CPCPU10 CP CEC MIPS Forecast Weekly CPCPU07 CP LPAR MIPS Daily CPCPU08 CP LPAR MIPS Weekly CPCPU12 CP LPAR MIPS Forecast Weekly CPCPU13 CP Workload MIPS Hourly CPCPU14 CP Serv Class MIPS Hourly CPCPU15 CP Application MIPS Hourly CPCPU16 CP Serv Class MIPS by Workload Avg Hourly CPCPU17 CP Serv Class MIPS by Workload Peak Hourly CPCPU18 CP Workload MIPS Daily CPCPU19 CP Workload MIPS Weekly CPCPU20 CP Serv Class MIPS Daily CPCPU21 CP Application MIPS Daily CPCPU22 CP Serv Class MIPS Weekly CPCPU23 CP Application MIPS Weekly CPCPU25 CP Workload MIPS Forecast Weekly CPCPU28 CP Serv Class MIPS Forecast Weekly CPCPU29 CP Application MIPS Forecast Weekly CPCPU30 CP LPAR MIPS by CEC Average Daily CPCPU31 CP LPAR MIPS by CEC Peak Daily CPCPU32 CP LPAR MIPS by CEC Average Weekly CPCPU33 CP LPAR MIPS by CEC Peak Weekly CPCPU34 CP Serv Class MIPS by Workload Avg Daily CPCPU35 CP Serv Class MIPS by Workload Peak Daily CPCPU36 CP Serv Class MIPS by Workload Avg Weekly CPCPU37 CP Serv Class MIPS by Workload Peak Weekly CPCPU41 CP CEC MIPS Timestamp CPCPU42 CP LPAR MIPS Timestamp CPCPU43 CP LPAR MIPS by CEC Timestamp CPCPU45 CP Workload MIPS Timestamp CPCPU46 CP Serv Class MIPS Timestamp CPCPU47 CP Application MIPS Timestamp CPCPU48 CP Serv Class MIPS by Workload Timestamp CPCPU49 CP Workload MIPS by LPAR Average Daily CPCPU50 CP Workload MIPS by LPAR Average Hourly CPCPU51 CP Workload MIPS by LPAR Average Weekly CPCPU52 CP Workload MIPS by LPAR Peak Daily CPCPU53 CP Workload MIPS by LPAR Peak Hourly CPCPU54 CP Workload MIPS by LPAR Peak Weekly CPCPU55 CP Workload MIPS by LPAR Timestamp This problem affects reports run via the ISPF interface, ELK and Splunk - Cognos reporting is not affected.
Problem conclusion
IBM Z Performance and Capacity Analytics report queries for the CPU subcomponent of the Capacity Planning - z/OS component are updated to refer to columns MIPS_USED_AVG and MIPS_PEAK for reports: CPCPU01 CP CEC MIPS Hourly CPCPU02 CP LPAR MIPS Hourly CPCPU03 CP LPAR MIPS by CEC Average Hourly CPCPU04 CP LPAR MIPS by CEC Peak Hourly CPCPU05 CP CEC MIPS Daily CPCPU06 CP CEC MIPS Weekly CPCPU10 CP CEC MIPS Forecast Weekly CPCPU07 CP LPAR MIPS Daily CPCPU08 CP LPAR MIPS Weekly CPCPU12 CP LPAR MIPS Forecast Weekly CPCPU13 CP Workload MIPS Hourly CPCPU14 CP Serv Class MIPS Hourly CPCPU15 CP Application MIPS Hourly CPCPU16 CP Serv Class MIPS by Workload Avg Hourly CPCPU17 CP Serv Class MIPS by Workload Peak Hourly CPCPU18 CP Workload MIPS Daily CPCPU19 CP Workload MIPS Weekly CPCPU20 CP Serv Class MIPS Daily CPCPU21 CP Application MIPS Daily CPCPU22 CP Serv Class MIPS Weekly CPCPU23 CP Application MIPS Weekly CPCPU25 CP Workload MIPS Forecast Weekly CPCPU28 CP Serv Class MIPS Forecast Weekly CPCPU29 CP Application MIPS Forecast Weekly CPCPU30 CP LPAR MIPS by CEC Average Daily CPCPU31 CP LPAR MIPS by CEC Peak Daily CPCPU32 CP LPAR MIPS by CEC Average Weekly CPCPU33 CP LPAR MIPS by CEC Peak Weekly CPCPU34 CP Serv Class MIPS by Workload Avg Daily CPCPU35 CP Serv Class MIPS by Workload Peak Daily CPCPU36 CP Serv Class MIPS by Workload Avg Weekly CPCPU37 CP Serv Class MIPS by Workload Peak Weekly CPCPU41 CP CEC MIPS Timestamp CPCPU42 CP LPAR MIPS Timestamp CPCPU43 CP LPAR MIPS by CEC Timestamp CPCPU45 CP Workload MIPS Timestamp CPCPU46 CP Serv Class MIPS Timestamp CPCPU47 CP Application MIPS Timestamp CPCPU48 CP Serv Class MIPS by Workload Timestamp CPCPU49 CP Workload MIPS by LPAR Average Daily CPCPU50 CP Workload MIPS by LPAR Average Hourly CPCPU51 CP Workload MIPS by LPAR Average Weekly CPCPU52 CP Workload MIPS by LPAR Peak Daily CPCPU53 CP Workload MIPS by LPAR Peak Hourly CPCPU54 CP Workload MIPS by LPAR Peak Weekly CPCPU55 CP Workload MIPS by LPAR Timestamp
Temporary fix
Comments
APAR Information
APAR number
PH27816
Reported component name
TDS FOR Z/OS
Reported component ID
569510100
Reported release
CA8
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-07-27
Closed date
2020-09-07
Last modified date
2020-10-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI71431
Modules/Macros
DRLOCPCP DRLQCP01 DRLQCP02 DRLQCP03 DRLQCP04 DRLQCP05 DRLQCP06 DRLQCP08 DRLQCP09 DRLQCP10 DRLQCP12 DRLQCP13 DRLQCP14 DRLQCP15 DRLQCP16 DRLQCP17 DRLQCP18 DRLQCP19 DRLQCP20 DRLQCP21 DRLQCP22 DRLQCP23 DRLQCP25 DRLQCP28 DRLQCP29 DRLQCP30 DRLQCP31 DRLQCP32 DRLQCP33 DRLQCP34 DRLQCP35 DRLQCP36 DRLQCP37 DRLQCP41 DRLQCP42 DRLQCP43 DRLQCP45 DRLQCP46 DRLQCP47 DRLQCP48 DRLQCP49 DRLQCP50 DRLQCP51 DRLQCP52 DRLQCP53 DRLQCP54 DRLQCP55
Fix information
Fixed component name
TDS FOR Z/OS
Fixed component ID
569510100
Applicable component levels
RCA8 PSY UI71431
UP20/09/10 P F009
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":"CA8"}]
Document Information
Modified date:
05 October 2020