trace_show 
You display which activities of the database instance are currently logged by the database trace.
Prerequisites
You have the server authorization 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 the Database Manager CLI, log on as operator OLEG with password MONDAY, connect to the database instance DEMODB, 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