DB2 graphic  QMF Version 8

Object Tracking

Use the Object Tracking page to activate object tracking. With object tracking enabled you can collect the tracking data that will be used to run object tracking reports. Object tracking reports can help you locate unused objects, locate frequently accessed data sources such as tables or columns and spot potential problem areas.

Table 24. Resource Limits - Object Tracking Fields
Field Description
Enable summary object tracking Whether the object's use is tracked. Enable this option to track the number of times an object has been run, and the most recent times it was run and modified.

This information is kept in Q.OBJ_ACTIVITY_SUMM.

Enable detailed object tracking Whether to keep a detailed record of each action taken using the object. Enable this option to keep a record of each time an object has been run, who ran it, and the results.
Note:
This option must be enabled to use ad hoc object tracking or SQL text tracking.

A large amount of data can be inserted into the Q.OBJ_ACTIVITY_DTL table if you enable this option.

Enable ad hoc object tracking Whether to keep a record of each ad hoc query. Enable this option to keep a record of each ad hoc query, and the SQL text of that query.
Note:
Check "Detailed object tracking" to use Ad hoc object tracking.
Enable SQL text tracking Whether to keep a record of the SQL text of each query.
Note:
Check "Detailed object tracking" to use SQL text tracking.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004