Which IDB2 DB2 Subsystem Detail Table includes DB2 SMF Stats Fields?
book
Article ID: 107097
calendar_today
Updated On:
Products
Bind Analyzer for DB2 for z/OSSQL-Ease for DB2 for z/OSSYSVIEW Performance Management Option for DB2 for z/OSPlan Analyzer for DB2 for z/OSSubsystem 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.