Go to: Synopsis. Return value. Keywords. Flags. MEL examples.

Synopsis

dbtrace [-filter string] [-info] [-keyword string] [-mark] [-off] [-output string] [-timed boolean] [-title string] [-verbose]

dbtrace is NOT undoable, queryable, and NOT editable.

The dbtrace command is used to manipulate trace objects. The keyword is the only mandatory argument, indicating which trace object is to be altered. You can use the query mode to find out which keywords are currently active (query with no arguments) or inactive (query with the off argument). You can enhance that query with or without a keyword argument to find out where their output is going (query with the output argument), out what filters are currently applied (query with the filter argument), or if their output will be timestamped (query with the timed argument).

Return value

None

In query mode, return type is based on queried flag.

Keywords

debug, trace, filter

Flags

filter, info, keyword, mark, off, output, timed, title, verbose
Long name (short name) Argument types Properties
-filter(-f) string createquery
Set the filter object for these trace objects (see 'dgfilter')
-info(-i) query
In query mode return a brief description of the trace object.
-keyword(-k) string createquerymultiuse
Keyword of the trace objects to affect

In query mode, this flag can accept a value.
-mark(-m) create
Display a mark for all outputs of defined trace objects
-off(-) create
Toggle the traces off. If omitted it will turn them on.
-output(-o) string createquery
Destination file of the affected trace objects. Use the special names stdout and stderr to redirect to your command window. The special name msdev is available on Windows to direct your output to the debug tab in the output window of Visual Studio.
-timed(-tm) boolean createquery
Turn on/off timing information in the output of the specified trace objects.
-title(-t) string create
Display a title mark for all outputs of defined trace objects
-verbose(-v) create
Include all traces in output and filter queries, not just those turned on.
Flag can appear in Create mode of command Flag can appear in Edit mode of command
Flag can appear in Query mode of command Flag can be used more than once in a command.

MEL examples

// The default action is to turn the trace object on.  This action can be
// changed using one of the -off, -output, -filter, -mark, or -title.
dbtrace -off;        // turns all active tracing off
dbtrace -k "key";    // turns on all tracing for keyword "key"
dbtrace -o "FRED";   // sends all active tracing output to the file "FRED"
// Inserts a title line in all active trace destinations having keyword 'key'
dbtrace -k "key" -t "This is a Title";
// Only turn on traces with keyword "key" in Transform nodes
dbtrace -k "key" -f "transform";
// Show where output is going for all levels of trace objects having keyword "fooTrace"
dbtrace -q -k "fooTrace" -o