solidDB Help : Programming : Diagnostics and troubleshooting SQL : Observing performance : SQL Info facility
  
SQL Info facility
The SQL Info facility generates information for each SQL statement that is processed by solidDB.
To generate the information, run your application with the SQL Info facility enabled. The SQL Info facility can be enabled in the following ways:
▪ Sql.Info parameter, see SQL section
▪ ADMIN COMMAND 'trace on info' command, see TRACE
▪ SET SQL INFO ON LEVEL statement, see SET SQL
The trace information is output by default to the soltrace.out file in the solidDB working directory. You can also specify the output file by using the SQL.InfoFileName parameter, see SQL section. This is recommended since the soltrace.out file can contain information from several sources.
Examples
[SQL]
Info = 1
InfoFileName = solidsql_trace.txt
The following statement turns on the SQL Info facility at 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 3 FILE 'my_query.txt'
The following SQL statement turns off the SQL Info facility:
SET SQL INFO OFF
Go up to
Observing performance