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
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 $INFORMIXDIR/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');