The trace file shows the executed OCI entries , including their actual parameters and information sent to or received from the interface to the ADABAS kernel. The SQL statements are only recorded for parse requests to the kernel. The parse identification (parseid) can be used to find out which SQL statement is currently executed.
The information contained in the trace file depends on the trace option.
For a simple trace (TRACE SHORT), only the sequence of the executed OCI entries - including their actual parameters, the SQL statements sent to the database kernel and the return code of the OCI entries - are recorded.
Example:
If the detailed form of the trace file is specified (TRACE LONG), the input and output values of the SQL parameters involved and the execution time of the statements are included.
Example:
The option TRACE ALT has the effect that the trace output is made alternately to two files. When doing so, as many executed OCI entries are recorded in each file as are specified in <statement count>. If there are more OCI entries to be executed than indicated by <statement count>, the files will be overwritten cyclically. The trace files are named "ocitrac.pct" and "ocitra2.pct". The long form of the trace is generated.
If the trace output should not be given the default name, the option TRACE FILE can be used to specify another name. If no other trace option was specified, the option TRACE SHORT is simultaneously enabled as a default. The filename must be standardized according to the operating system conventions. The name can also be specified as a character string constant (optional). The option overrides the option passed during the precompiler run. Only trace files with default trace filenames are not buffered on output.
The option TRACE NO DATE/TIME can be used to suppress the output of the date and time values for the start and end of the execution of an OCI entry made into the trace file.
With the option TRACE TIME, only those OCI entries are recorded whose execution time is greater than or equal to <seconds>. The long form of the trace is generated.