You display the permitted command options for restricting the trace output of the internal database components when creating the text version of the database trace (see: trace_prot).
The system displays a list with the names and descriptions of these command options.
You have the server authorization DBInfoRead or DBFileRead.
trace_protopt
OK
name,option
<name>,<option>
<name>,<option>
...
Value | Description |
---|---|
<name> | Options for generating the log file of the database trace Possible values are: a | b | k | m | e | s | t | x |
<option> | Description of option |
Option |
What Is Written to the Log File |
---|---|
a |
Trace outputs of the order interface |
b |
Trace outputs of the data record interface |
k |
Trace outputs of the table interface |
m |
Message buffer |
e |
Number of the trace page and the position of the block on the page for the order interface and the message buffer |
s |
Information about the processing strategy |
t |
Results of internal time measurements |
x |
Additional trace outputs |
Call the Database Manager CLI, log on as operator OLEG with the password MONDAY, connect to the database instance DEMODB, display the options for creating a text version of the database trace:
>dbmcli -d DB -u dbm,dbm trace_protopt
OK name,option a Order Interface (AK) b Record Interface (BD) k Show Message Block (KB) m Message Block e No Entrypos Output s Strategy t Time x Switch Output (Slow Kernel)
Database Administration, Traces