Show TOC

 SQL Trace File AdministrationLocate this document in the navigation structure

Use

Each time you switch the SQL Trace on, the system generates a new XML file to store the trace records, thereby enabling you to check older traces if necessary. By default, a maximum of 10 files by 10,000,000 bytes each can be created.

You can set the maximum number of trace files and the maximum size of each file. You can also download the available traces to an XML file, and delete unnecessary trace files manually.

Prerequisites

You must be granted administrator permissions for the J2EE Engine.

Activities
  • To set the number of trace files and the maximum size of each file:
    1. Launch the Offline Configuration Editor or the runtime screen of the Configuration Adapter Service in the Visual Administrator.
    2. Browse to Configurations → Open SQL and open Propertysheet SQLTrace for editing.
    3. Set custom values for MaxFileNumber and MaxFileSize . Although the property sheet accepts all values, the SQLTrace allows at least 5 and at most 1,000 files for each trace. The value of the MaxFileSize is minimum 10,000 bytes and maximum 10 9 bytes. The changes take effect after you restart the relevant server process.
      Note

      Normally, the default values should not be changed. However, if they are inappropriate for your purposes, we recommend that you increase the number of files rather than the size of each file.

  • To download a trace file:
    1. Launch the SQL Trace .
    2. Follow the link Use SQLTrace File Administration.
    3. To download particular traces, select them and choose Download. You can choose the location and the name of the archive.

      The traces in XML format are stored in a ZIP file, which also contains the document type definition (DTD) for the XML files. You can view the downloaded traces using a third-party program such as Microsoft Excel, for example.

  • To delete a trace file manually:
    1. Launch the SQL Trace.
    2. Follow the link Use SQLTrace File Administration.
    3. To delete particular traces, select them and choose Delete Selected.
    4. To delete all traces, choose Delete ALL.