A fix is available
APAR status
Closed as program error.
Error description
Re-install of the Capacity Planning z/OS CPU sub-component completes, but returns misleading message CC=8 with -803 (duplicate Key error). .
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM Z Performance and Capacity * * Analytics who get CC=8 on re-install of * * Capacity Planning z/OS - CPU subcomponent. * **************************************************************** * PROBLEM DESCRIPTION: Sample SQL is re-executed generating * * misleading message CC=8 with -803 * * (duplicate Key error) when * * re-installing the Capacity * * Planning z/OS CPU sub-component. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** On re-install of Capacity Planning z/OS CPU sub-component a condition code 8 will appear with a SQLCODE -803. Message states that an inserted or updated value is invalid. This is due to the re-execution of the SQL provide for CP_EVENT_TYPE and CP_EVENT_DATE,
Problem conclusion
Tablespace definitions for CP_EVENT_TYPE and CP_EVENT_DATE have been moved into DRLSCPL6 member. Re-install of Capacity Planning z/OS component will no longer run the sample SQL if it has already been applied. Spurious messages will no longer appear on re-install of this component.
Temporary fix
Comments
APAR Information
APAR number
PH34050
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
2021-02-02
Closed date
2021-02-25
Last modified date
2021-03-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI74144
Modules/Macros
DRLICPZO DRLSCPL6 DRLTCPF1
Fix information
Fixed component name
TDS FOR Z/OS
Fixed component ID
569510100
Applicable component levels
RCA8 PSY UI74144
UP21/02/27 P F102
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:
06 March 2021