Configuring Database Tracing Options


Overview

Tasks

Included with

Tivoli Service Desk

Overview

Database tracing options

TDT supports a rich set of database tracing options. The basic options are configured in the Trace Setup dialog box. For information on advanced options, see Configuring Advanced Options for Data Sources and Trace Files.

Database trace file

Currently, the database tracing facilities of TDT are not source-specific. All database tracing entries are stored in a single text file.

The trace file is overwritten each time TDT's SQL system is initialized, unless the advanced option TRACE_APPEND is set to TRUE. For more information on advanced options, see Configuring Advanced Options for Data Sources and Trace Files.

Trace Setup dialog box

Use the Trace Setup dialog box to specify the name of the database trace file and to enable database tracing. For more information, see Setting up the Database Tracing File.

Tasks

Setting up the database tracing file

You may want to trace database activity to provide report information for debugging.

To set up the database tracing file:

  1. In the SQL Configuration Editor dialog box, choose Trace Setup.
  2. In the Trace Setup dialog box, in the Trace File box, enter the name of the text file where the log entries are stored.
    Note: The default file name is sql_trc.log. The trace file is created in the current directory. You can by provide a different file name (including a complete path, if desired). For more information, see Database Trace File.
  3. Do one of the following:
    • Select the Enabled check box to turn on database tracing.
      Result: The database trace file is created the next time TDT's SQL system is initialized and database trace entries are recorded.
    • Clear the Enabled check box to turn off database tracing.
      Result: The database trace file is not created the next time TDT's SQL system is initialized. No database trace entries are recorded.
  4. Do one of the following:
    • Choose OK to save the database trace setup information.
    • Choose Cancel to exit the Trace Setup dialog box without saving the database trace setup information.
    • Choose Advanced to configure advanced trace file options. For more information, see Configuring Advanced Options for Data Sources and Trace Files.