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.
You have the server authorization DBInfoRead or DBFileRead.
trace_off <command_option>
<command_option> :: = <activity_list> | ALL
<activity_list> :: = <activity> | <activity> <activity> ...
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. |
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
Database Administration, Traces