Background documentationtrace_protopt Locate this document in the navigation structure

 

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.

Prerequisites

You have the server authorization DBInfoRead or DBFileRead.

Structure

trace_protopt

Result

OK

name,option

<name>,<option>

<name>,<option>

...

Values for the Reply Fields

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

Database Trace: Options for Generating the Log File

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

Example

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)

More Information

Database Administration, Traces