Background documentationtrace_off Locate this document in the navigation structure

 

With this command you can determine which activities of the database are no longer to be logged, or you completely deactivate the database trace.

Prerequisites

You have the serverpermission DBInfoRead or DBFileRead.

Structure

trace_off <command_option>

<command_option> :: = <activity_list> | ALL

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

Options

Option

Description

ALL

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

<activity>

Activity for which logging is to be turned off.

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

Result

OK

In the event of errors, see Reply Format.

Example

Call Database Manager CLI, log on as the user OLEG with the password MONDAY, connect to the DEMODB database, 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