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.
| 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 |
|
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:
- Facilities that are available with the Db2 product.