Background documentationtrace_show Locate this document in the navigation structure

 

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]

Options

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>

...

...

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

...

...

More Information

Database Administration, Traces