Enabling historical data collection

The enhanced 3270UI is designed for investigation of current problems or those that have occurred in the recent past.

Therefore, near-term history data can be displayed in the enhanced 3270UI workspaces. The near-term history supports Db2® statistics, DSNZPARM, Db2 critical messages, Db2 connect server and object analysis.

Each workspace consists of one or multiple attribute groups. The history collection for the corresponding attribute groups must be started in order to see the history data in a workspace. Attribute groups that you need to enable historical collection for the workspaces are shown below.

Table 1. Workspace and attribute group cross reference for history collection for Db2 Subsystems

History collection for attribute group Db2 Group Coupling Facility must be started to see history data for Data Sharing Groups.

For example, if you want to view the Group Buffer Pools history, you must start history collection for attribute group Db2 Group Coupling Facility and DSG_GBP_Pool. Later, if you also want to see Global Buffer Pools history, then you start history collection for attribute group DSG_GBP_CF_Status.

Workspace Attribute group

Db2 Main Screen
All Active Db2 Data Sharing Groups

Db2 Group Coupling Facility
Group Buffer Pools DSG_GBP_Pool
Global Buffer Pools DSG_GBP_CF_Stats
Coupling Facility Details Db2 Group Coupling Facility
Group Object Analysis

Group Object Analysis
Group Object Spacename

Group Object Analysis Volume

GOA Volume Summary
GOA Volume Database Summary

Group Object Analysis Database Activity Group Object Activity Summary
DSG DSNZPARMs DSG Db2 Parameters
DSG SQL Counts DSG SQL Count
Table 2. Workspace and attribute group cross reference for history collection for Db2 Subsystems

History collection for attribute group Db2 System Status must be started to see history data for Db2 subsystems.

For example, if you want to see Subsystem Management history, you must start history collection for attribute group Db2 System Status, Db2 SRM Subsystem Statistics and Db2 SRM Subsystem. Later if you also want to see Group Buffer Pools history, then you start history collection for attribute group Db2 GBP Pool.

Workspace Attribute group

Enterprise summary
All Active Db2 Subsystems  
Db2 Main Screen  
All Active Db2 Subsystems

Db2 System Status
Key Performance Indicators

Db2 System Status
DB2_Memory
DB2_Memory_DBM1_DIST

Subsystem Management

Db2 SRM Subsystem Statistics
  Db2 SRM Subsystem

Log Management

LOG Stats ( Db2 Version 11)
   Db2 SRM Log Statistics
   Db2 SRM Log Manager

EDM Pool

EDM Pool Statistics (Db2 Version 11)
EDM STATS (Db2 Version 11)
Db2 SRM EDM Statistics    
EDM POOL

Buffer Pools

Db2 BP Statistics (Db2 v12)
Db2 BP Attributes (Db2 v12)
Db2 SRM BPM
Db2 SRM BPD  

Group Buffer Pools Db2 GBP Pool
Global Buffer Pools Db2 GBP CF Stats
Db2 Connect™ Server

Db2 CONNECT TASKLIST  
Db2 CONNECT PACKAGE    
Db2 CONNECT SERVER  

Storage Consumption

Db2 Memory DBM1 DIST    
Db2 Memory
MVS™ Storage

DSNZPARMs Db2 Parameters
System SQL Counts

Stat SQL Count
SQL COUNTER

z/OS® System Statistics ZOS System Statistics
Accelerators Accelerator Statistics
Lock Statistics Lock Statistics
DP aggregated accounting DP aggregated accounting
DP PROFILE MONITOR DP PROFILE MONITOR
DP DDF Statistics DP DDF Statistics
DP DDFLoc Stats DP DDFLoc Stats
DP Bind Stats DP Bind Stats
Db2 Command Information DP Db2 COMMAND
DP DM Stats DP DM Stats
DP App Stats DP App Stats
DP User Stats DP User Stats
Db2 Message Db2 Message
Db2 Anomaly Db2 Anomaly
Db2 Interval Statistics Db2 Interval Statistics