Which IDB2 DB2 Subsystem Detail Table includes DB2 SMF Stats Fields?
Article ID: 107097
CA Bind Analyzer for DB2 for z/OSCA DetectorCA SQL-Ease for DB2 for z/OSCA Sysview Performance Management Option for DB2 for z/OSCA Database Detector for DB2 for z/OSCA Plan Analyzer for DB2 for z/OSCA Subsystem Analyzer for DB2 for z/OS
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?
Release: Component: CIDB
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.