IBM Support

PH61756: The update for column DB2_TCB_CURRENT is using the incorrect function.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The updates for column DB2_TCB_CURRENT are using the SUM
    function instead of the AVG function when updating
    tables CICS_S_DB2CONN_D and CICS_S_DB2CONN_DP.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All IBM Z Decision Support 1.9.0 and         *
    *                 IBM Z Performance and Capacity Analytics     *
    *                 3.1.0 users who use the CICS Statistics      *
    *                 component or the CICS Statistics Partitioned *
    *                 component.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: The value in column DB2_TCB_CURRENT     *
    *                      exceeds the value in DB2_TCB_HWM for    *
    *                      tables CICS_S_DB2CONN_D and             *
    *                      CICS_S_DB2CONN_DP.                      *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF(s).                   *
    ****************************************************************
    When aggregating data from CICS_S_DB2CONN_T, _TP to the
    CICS_S_DB2CONN_D, _DP tables, a function of SUM is used for
    column DB2_TCB_CURRENT.
    

Problem conclusion

  • Updates CICS_S_DB2CONN_D and CICS_S_DB2CONN_DP will use a
    function of AVG when aggregating the data for column
    DB2_TCB_CURRENT.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH61756

  • Reported component name

    TDS FOR Z/OS

  • Reported component ID

    569510100

  • Reported release

    CA2

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2024-06-10

  • Closed date

    2024-07-01

  • Last modified date

    2024-08-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI97532 UI97533

Modules/Macros

  • DRLTC828 DRLTS3P5
    

Fix information

  • Fixed component name

    TDS FOR Z/OS

  • Fixed component ID

    569510100

Applicable component levels

  • R9A2 PSY UI97533

       UP24/07/25 P F407

  • RCA2 PSY UI97532

       UP24/07/25 P F407

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":"BU048","label":"IBM Software"},"Product":{"code":"SS2DUM","label":"IBM Z Decision Support"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"CA2","Line of Business":{"code":"LOB70","label":"Z TPS"}}]

Document Information

More support for:
IBM Z Decision Support

Software version:
CA2

Document number:
7159357

Modified date:
01 August 2024