db2trcoff - Trace OFF options for db2trc command

The db2trcoff command issues the db2trc command with the off option. This command makes it easy to generate the dump, flow, and format files by you having to execute less commands than if you were to use the db2trc command.

The db2trcoff command supports all the parameters of the db2trc command. And the db2trcoff command can be found under the sqllib/pd directory.

Authorization

To trace a Db2® instance on a UNIX operating system, you must possess one of the following authorizations:
  • sysadm
  • sysctrl
  • sysmaint
To trace the Db2 Administration Server on a UNIX operating system:
  • dasadm

Command syntax

Read syntax diagramSkip visual syntax diagramdb2trcoff-flw-fmt-help

Command parameters

-flw
Generates a trace flow report. The name of the flow files are db2trcoff.<time-stamp>.flw. The value of <time-stamp> has the following format, hours_minutes_seconds.
-fmt
Generates a trace format report. The name of the format files are db2trcoff.<time-stamp>.fmt. The value of <time-stamp> has the following format, hours_minutes_seconds.
-help
Displays help information.

Example

To turn the db2trc command off and generate both format and flow files, issue:
db2trcoff -flw -fmt

Usage notes

The db2trcoff command always generates a dump file. The name of the dump file is db2trcoff.<time-stamp>.dmp. The value of <time-stamp> has the following format, hours_minutes_seconds.