A fix is available
APAR status
Closed as program error.
Error description
The following columns appear to contain accumulating values instead of incremental ones. WF_STOR_PREF_4K & WF_STOR_PREF_32K in D_DB2_DATABASE_T. DSN3EXIT, SSI_CALLS, PHYSICAL_SUSPENDS, and WRITES_FORCE in D_DB2_SYSTEM_T.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All users of the DB2 Delta Statistics * * Component in IBM Z Decision Support or * * IBM Z Performance and Capacity Analytics. * **************************************************************** * PROBLEM DESCRIPTION: Some columns are accumulated values * * and should be delta values. * **************************************************************** * RECOMMENDATION: Apply the provided PTF(s). * **************************************************************** 6 fields are not flagged for delta statistics processing.
Problem conclusion
This APAR enables 6 fields to be processed for Delta Statistics. This means that the following fields will contain delta values in: 1) tables D_DB2_DATABASE_T, _H and D_KPM_DB2_DBASE_T, _H: WF_STOR_PREF_4K and WF_STOR_PREF_32K. 2) tables D_DB2_SYSTEM_T, _H: DSN3EXIT, SSI_CALLS, PHYSICAL_SUSPENDS, WRITES_FORCE.
Temporary fix
Comments
APAR Information
APAR number
PH42743
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-12-13
Closed date
2022-01-12
Last modified date
2022-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI78899 UI78900 UI78901 UI78902
Modules/Macros
DRLSD64D DRLUD2DD DRLUD2SA DRLUKD15
Fix information
Fixed component name
TDS FOR Z/OS
Fixed component ID
569510100
Applicable component levels
R901 PSY UI78901
UP22/01/19 P F201
R9A0 PSY UI78902
UP22/01/19 P F201
RC01 PSY UI78899
UP22/01/19 P F201
RCA0 PSY UI78900
UP22/01/19 P F201
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:
02 February 2022