Which Sysview for Db2 Subsystem Detail table includes Db2 SMF Stats Fields

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Which Sysview Performance Management Option for Db2 for z/OS (IDB2) Subsystem Detail table columns include the following Db2 SMF statistics fields:

SDISMFWR - SMF WRITTEN
SDIOP4WR - OP4 WRITTEN
SDTOTW - TOTAL WRITTEN
SDTOTNW - TOTAL NOT WRITTEN

Resolution

The data from the QWSB repeating section (IFI stats by destination) of the STATS record was not added to the SUBSYSTEM_DETAIL table.

For IFI records containing repeating sections, such as the bufferpool sections, separate tables usually need to be made.
That data can be seen it for the active subsystem (and in System history) using the standard UI.