Command recording facility

Command Recording is a sophisticated tracing facility. It notes into a CMS recorder file:

- detailed execution characteristics and resource consumption for all SQL statements executing in the database
- the scheduling, the start and the endtime of each DB2 checkpoint (1)
- the resource consumption during checkpoint processing

In order to achieve acceptable performance, recording is done into a dataspace, which is asynchronously written to disk.

The recorder facility may run continuously or "on-demand". In the latter case, SQL/MF commands are used to start and stop recording.

Sample Recorder Report

(1) Using the scheduling and the start time, checkpoint delays can be detected.