A fix is available
APAR status
Closed as program error.
Error description
In the DB2 Component, tables D_DB2_DATABASE_H and D_DB2_SYSTEM_H in Subcomponent '2b Address Space Delta Statistics' and table D_DB2_BUFF_POOL_H in Subcomponent '3b Buffer Pool Delta Statistics' have a timestamp field defined in the key. These fields prevent the data from rolling up correctly from the corresponding _T tables.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of Component DB2 Subcomponent * * '2b Address Space Delta Statistics' or * * '3b Buffer Pool Delta Statistics' in * * IBM Z Decision Support or * * IBM Z Performance and Capacity Analytics. * **************************************************************** * PROBLEM DESCRIPTION: The _H tables are not rolling up the * * data from the _T tables correctly. * **************************************************************** * RECOMMENDATION: Apply the provided PTF(s). * **************************************************************** The _H tables have a timestamp field in the key.
Problem conclusion
Tables D_DB2_DATABASE_H, D_DB2_SYSTEM_H and D_DB2_BUFF_POOL_H have the TIMESTAMP field removed.
Temporary fix
Comments
APAR Information
APAR number
PH41767
Reported component name
TDS FOR Z/OS
Reported component ID
569510100
Reported release
C01
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-11-02
Closed date
2021-12-14
Last modified date
2022-01-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI78562 UI78563
Modules/Macros
DRLJD2DD DRLTD2BD DRLTD2DD DRLTD2SA DRLUD2BD DRLUD2DD DRLUD2SA
Fix information
Fixed component name
TDS FOR Z/OS
Fixed component ID
569510100
Applicable component levels
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":"C01"}]
Document Information
Modified date:
05 January 2022