Background documentationtrace_off Locate this document in the navigation structure

 

You determine which activities of the database instance are no longer to be logged, or you completely deactivate the database trace.

You define which activities are no longer to be logged by specifying a command option.

Prerequisites

You have the server authorization DBInfoRead or DBFileRead.

Structure

trace_off <command_option>

<command_option> :: = <activity_list> | ALL

<activity_list> :: = <activity> | <activity> <activity> ...

Options

Option

Description

ALL

No more activities of the database instance are logged. The database trace is fully deactivated.

<activity>

Activity for which logging is to be turned off.

To display currently logged activities and the corresponding command options, see trace_show.

Result

OK

In the event of errors, see Reply Format.

Example

Call the Database Manager CLI, log on as user OLEG with password MONDAY, connect to the DEMODB database instance, switch off the database trace for the areas CHECK_IOMAN and CHECK_LOGPAGE:

>dbmcli -u OLEG,MONDAY -d DEMODB trace_off CHECK_IOMAN CHECK_LOGPAGE

OK

More Information

Database Administration, Traces