bts_tracefile() function

The bts_tracefile() function specifies the location where the trace file is written. Use this function together with the bts_tracelevel() function to trace basic text search-related events.

Syntax


1  bts_tracefile ( filename )
filename
The full path and name of the file to which trace information is appended. The file must be writable by user informix. If no file name is provided, a standard session_id.trc file is placed in the $ONEDB_HOME/tmp directory.

Usage

Use the bts_tracefile() function to troubleshoot events related to the basic text searches.

For the syntax for bts_tracelevel(), see bts_tracelevel() function.

For more details about tracing, see the HCL OneDB™ Guide to SQL: Reference.

Example

The following example specifies a trace log named bts_select.log in the /tmp directory:
EXECUTE FUNCTION bts_tracefile('/tmp/bts_select.log');