IBM Support

PH34050: PREVENT MISLEADING MESSAGE ON SUB-COMPONENT RE-INSTALL

A fix is available

Subscribe

You can track all active APARs for this component.

 

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