Activating object tracking

To track a user's object usage on a data source, you must activate object tracking for their resource limits group.

About this task

You can activate object tracking for a resource limits group on a data source when you define or update the schedules for the resource limits group.

Note: If your user ID has the required authority, you can query the detail and summary tracking tables directly using QMF for Workstation or QMF for WebSphere® and see any tracking information contained within those tables.

To activate object tracking for a data source:

Procedure

  1. Right-click a data source from either the Repositories or Repository Explorer views. Select Properties from the pop-up menu. The Properties for [data source] window opens. Click the Resource Limits folder. The Resource Limits window opens. There are two pages. Click the Resource Limits tab.
  2. Select a resource limits group from the list of available resource limits groups. Click Edit. The Edit Resource Limits Group window opens.
  3. All of the schedules that have been defined for this resource limits group are listed in the Schedule List list box. To edit the resource limits group schedule, select the schedule from the Schedule List list box and click Edit. The Edit Resource Limits Group Schedule window opens.
  4. Select the Object Tracking tab.
  5. Check the type of object tracking that you want to activate. Your choices are:
    • Enable summary object tracking: Select this check box to activate summary object tracking. Summary object checking tracks an object and keeps a summarized record of actions that pertain to the record.
    • Enable detailed object tracking: Select this check box to activate detailed object tracking. Detailed object checking keeps a detailed record of each action taken using an object.
    • Enable ad hoc object tracking: Select this check box to keep a record of each ad hoc SQL query and the SQL text of that query. Detailed object tracking must be activated in order to use ad hoc object tracking.
    • Enable SQL text tracking: Select this check box to specify that a record of the SQL text of each SQL query is kept. Detailed object tracking must be activated in order to use SQL text tracking.
  6. Click OK.