The figure shows the various monitoring facilities that you can use in a Db2® environment. These facilities are organized into a flow chart, which flows from data source to data writer to reporting tool to output to reduction and history. In most cases, not all five steps in the flow chart are filled for a specific instance. For example, the Db2 DISPLAY command points directly to its online output, skipping the data writer and reporting tool steps in the flow. Table 1 shows the flow chart of monitoring tools in a Db2 environment in tabular format.
Table 1. Monitoring tools in a Db2 environment
Data source Data writer Reporting tool Output Reduction and history
CICS® monitoring facility SMF or CICS journal Performance reporter for z/OS®   Performance reporter for z/OS
CICS monitoring facility   Performance reporter for z/OS   Performance reporter for z/OS
IMS monitor        
    IMS DFSUTR20 utility Reports  
IMS log records IMS log
  • IMS PA
Reports  
  DBFULTA0 Reports  
Db2 trace facility 1 SMF or GTF Tivoli® Tivoli OMEGAMON® XE for Db2 Performance Expert on z/OS XE forDb2 Performance Expert and online monitor Reports and graphics  
Db2 RUNSTATS utility 1        
Db2 STOSPACE facility 1        
Db2 EXPLAIN statement 1        
Db2 DISPLAY command 1     Online  
Db2 catalog queries 1        
CICS attachment statistics *        
RMF SMF RMF monitor I Reports  
  RMF monitor II Online or reports  
    RMF monitor III Online or reports  
GTF       Performance reporter for z/OS
Note:
  1. Facilities that are available with the Db2 product.