trace_show 
With this command you can display which database activities are currently logged by the database trace.
Prerequisites
You have the server permission DBInfoRead or DBFileRead.
Structure
trace_show [verbose]
Option |
Description |
|---|---|
verbose |
Extended description for database kernel activities logged with the help of the database trace |
Result
OK
<name> <state> <level> <short description>[,<long description>]
<value> <value> <value> <value>
...
...
Value |
Description |
|---|---|
<name> |
Name of activity |
<state> |
Status of logging function Possible values are: ON | OFF ON: activity is logged OFF: activity is not logged |
<level> |
Logging level, can be specified for several activities. Possible values are 1 to 9. The default value is 5. |
<short_description> |
Short description of activity |
<long_description> |
Extended description of activity |
<value> |
Value |
Example
Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the database DEMODB, and display the database kernel activities currently logged with the extended description:
>dbmcli -u OLEG,MONDAY -d DEMODB trace_show verbose
OK
Name State Level Description
TRACE_AK OFF - Defines whether tracing
of all order packets is switched on (YES/NO)
TRACE_DEFAULT OFF - Defines whether default
tracing is switched on (YES/NO)
TRACE_DELETE OFF - Defines whether tracing
of complete message buffer of DELETE is switched on (YES/NO)
TRACE_INDEX OFF - Defines whether tracing
...
...
More Information
Database Administration, Traces