A fix is available
APAR status
Closed as program error.
Error description
Allow partitioning by range on CEC Workload/MIPS tables
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All customers installing or migration to * * IZPCA V310. * **************************************************************** * PROBLEM DESCRIPTION: When installing the * * Capacity Planning - z/OS component, * * the CP_CEC_WKLD and CP_CEC_MIPS tables * * are no able to be RANGE partitioned * * because the tables do not have the * * MVS_SYSTEM_ID field in the tables. * * * * When installing the * * Capacity Planning - z/OS for IZPCA 310 * * and using RANGE Partitioning on * * table spaces. * * * * The following errors occur: * * * * DSNT408I SQLCODE = -205, ERROR: * * MVS_SYSTEM_ID IS NOT A COLUMN OF TABLE * * DRLP3.CP_CEC_WKLD_H * * DSNT408I SQLCODE = -660, ERROR: * * * * DSNT408I SQLCODE = -205, ERROR: * * MVS_SYSTEM_ID IS NOT A COLUMN OF TABLE * * DRLP3.CP_CEC_WKLD_M * * DSNT408I SQLCODE = -660, ERROR: * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** The CP_CEC_WKLD and CP_CEC_MIPS tables cannot have the MVS_SYSTEM_ID column required for partitioning. This will cause contention issues running with partitioning.
Problem conclusion
The CP_CEC_WKLD and CP_CEC_MIPS tables are replaced with views which gives the same result set without contention issues.
Temporary fix
Comments
APAR Information
APAR number
PH25347
Reported component name
TDS FOR Z/OS
Reported component ID
569510100
Reported release
CA8
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-05-13
Closed date
2020-05-19
Last modified date
2020-06-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI69605
Modules/Macros
DRLICPZO DRLJCP05 DRLSCPCL DRLTKZH3
Fix information
Fixed component name
TDS FOR Z/OS
Fixed component ID
569510100
Applicable component levels
RCA8 PSY UI69605
UP20/05/21 P F005 ¢
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS2DUM","label":"IBM Z Decision Support"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
02 June 2020