Managing the SQL Trace

Use

You use this procedure to switch on the SQL Trace for a particular cluster node. You can also set trace options, delete, and download traces.

Prerequisites

You are in Start of the navigation pathTroubleshooting Next navigation step Database Next navigation step Open SQL Monitors Next navigation step SQL Trace AdministrationEnd of the navigation path.

Procedure

Activating and Deactivating the SQL Trace

  1. Select a cluster node from the list in the Current SQL Trace Status per Cluster Node area.

  2. To activate the SQL trace for the cluster node, choose the Switch Trace On button in the Trace Administration area.

    The SQL Trace is activated for the selected cluster node.

  3. To evaluate the trace, choose the SQL Trace Evaluation function.

    More information: Evaluating SQL Traces

  4. To set additional options for the trace, you use the Trace Options screen area:

    • To add stack trace information to every written trace record, select the Add Stack Trace checkbox.

    • To add stack trace information to trace records that take longer than a certain time period in microseconds only, enter the appropriate value in the Threshold in Microseconds field.

    • To add stack trace information to trace records that contain matching method name calls only, enter the appropriate value in the Method Name Contains field.

  5. To deactivate the SQL trace for the cluster node, choose the Switch Trace Off button.

Working with the SQL Trace File

Each time you switch the SQL trace on, the system generates a new set of files to store trace records so that you can check older traces if necessary. By default, a maximum of 10 files by 10,000,000 bytes each can be created for a single trace.

  1. To manage trace files, choose the Administrate Traces tab in the Trace Administration screen area.

  2. To delete one or more traces, select these traces in the list, then choose the Delete .

  3. To download particular traces, select the traces and choose Download .