Specifying filter criteria

The LOADLOG table holds report and trace interval data for loaded data. You can use the trace start and end time, and the ID of the job step as criteria for filtering rules of thumb. This can be useful if you want to analyze only those trace records loaded by a specific user for a particular step at a certain time.

To specify filter criteria:
  1. On the Options page of the Rules-of-Thumb Analysis window, click Time in the folders pane.

    The Time setting area is displayed in the lower-right corner of the contents pane.

    This area shows information from the LOADLOG table. It contains the user ID of the user that loaded the data, the trace interval data, and the load-job step ID associated with the load job. For more information about this table, refer to The LOADLOG table.

  2. Select a row that holds the appropriate trace-start time, trace-end time, or step-log ID and click Start time, End time, or LOAD step.

    If more than one table is referenced, the Select Table window is displayed. Select a table from the list and click OK.

    The corresponding filter expression is displayed in the text field. You can combine expressions using the AND, OR, and NOT operators.

    For example, if you clicked Start time, the filter expression comprises the table name, the trace-start time column name, and the value of the trace-start time for the selected row in the time-setting table.

    If you clicked LOAD step, the filter expression comprises the table name, the step-log ID column name, and the value of the step-log ID for the selected row in the time-setting table.

  3. Click Apply. The filter expression is inserted in the Variables context field directly after the WHERE clause.
  4. To remove the filter expression from the WHERE clause, click Reset.