SQL Guide : Diagnostics and troubleshooting for SQL : Observing performance : SQL Info facility
  
SQL Info facility
The SQL Info facility generates information for each SQL statement processed by solidDB®.
To generate the SQL Info, you run your application with the SQL Info facility enabled. The SQL Info facility can be enabled in the following ways:
▪Sql.Info=<info_level> parameter
▪ADMIN COMMAND 'trace on info <info_level>' command
▪SET SQL INFO ON LEVEL info_level FILE file_name statement
The tracing level (info_level) is defined as an integer between 0 (no tracing) and 8 (solidDB® info from every fetched row).
Info level
Description
0
no output
1
table, index, and view info in SQL format
2
SQL execution graphs (technical support use only)
3
some SQL estimate info, solidDB® selected key name
4
all SQL estimate info, solidDB® selected key info
5
solidDB® info also from discarded keys
6
solidDB® table level info
7
SQL info from every fetched row
8
solidDB® info from every fetched row
The trace information is output by default to the soltrace.out file in the solidDB® working directory. You can also specify the output file using the SQL.InfoFileName parameter. This is recommended since the soltrace.out file may contain information from several sources.
Examples
[SQL]
Info = 1
InfoFileName = solidsql_trace.txt
The following command turns on the SQL Info facility on level 3, outputting the trace information to a my_query.txt file in the working directory. This SQL Info facility is turned on only for the client that executes the statement.
SET SQL INFO ON LEVEL 1 FILE ’my_query.txt’
The following SQL statement turns off the SQL Info facility:
SET SQL INFO OFF
See also
Observing performance