trace_show

Use

You display which activities of the database instance are currently logged by the database trace.

See also:

Glossary, Database Trace

Prerequisites

You have the server authorization DBInfoRead or DBFileRead.

Syntax

trace_show [verbose]

verbose

Extended description for database kernel activities logged with the help of the database trace

Reply

OK

<name>   <state>  <level>  <short description>[,<long description>]

<value>  <value>  <value>  <value>

...

...

Values for the Reply Fields

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

...

...