Which IDB2 DB2 Subsystem Detail Table includes DB2 SMF Stats Fields?

Article Id: 107097

Status: Published

Updated On: 19-07-2018 08:36

Products:

CA Bind Analyzer for DB2 for z/OS , CA SQL-Ease for DB2 for z/OS , CA Sysview Performance Management Option for DB2 for z/OS , CA Database Detector for DB2 for z/OS , CA Plan Analyzer for DB2 for z/OS , CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction:

Which SYSVIEW/DB2 SUBSYSTEM_DETAIL table columns include the following Db2 SMF statistics fields: SDISMFWR - SMF WRITTEN SDIOP4WR - OP4 WRITTEN SDTOTW - TOTAL WRITTEN SDTOTNW - TOTAL NOT WRITTEN?

Environment:

Release:
Component: CIDB

Resolution:

The data from the QWSB repeating section (IFI stats by destination) of the STATS record wasn't added to the SUBSYSTEM_DETAIL table. For IFI records containing repeating sections, such as the bufferpool sections, separate tables usually need to be made. No request was ever made for that data to be in the archive tables. That data can be seen it for the active subsystem (and in System history) using the standard UI.