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

Document ID : KB000107097
Last Modified Date : 19/07/2018
Show Technical Document Details
Issue:
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? 
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.