Specifying options for SQL tracing

SQL Explorer displays detailed information about SQL statements executed at the current server. You can specify what information is traced and available in the SQL Explorer from the Tracing Admin page.

To set SQL Explorer details:

  1. On the menu for the HCL OpenAdmin Tool (OAT) for Informix®, click Performance Analysis > SQL Explorer > Tracing Admin.
  2. Specify the following SQL tracing options:
    • Select the global or user trace mode. This option is displayed for HCL Informix 11.50.xC3 and later. For more information, see Trace Mode.
    • Select the Table Names check box to include names of tables in trace information.
    • Select the Procedure Stacks check box to include procedure stacks in trace information.
    • Select the Host Variables check box to include information about host variables in trace information.
    • Select the Clear Trace Buffer check box to empty the trace buffer when trace options are changed and saved.
    • Enter the number of statements to trace, 500 - 2147483647.
    • Enter the maximum trace size per SQL statement in bytes, 512 - 102400.
  3. Click Save.

Copyright© 2018 HCL Technologies Limited