ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS 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. 
Powered by Wolken Software