The dbcc traceon option allows the System Administrator to turn on trace flags within Component Integration Services. Trace flags enable the logging of certain events when they occur within Component Integration Services. Each trace flag is uniquely identified by a number. Some are global to Component Integration Services while others are spid-based and affect only the user who enabled the trace flag. dbcc traceoff turns off trace flags.
The syntax is:
dbcc traceon (traceflag [, traceflag...])
Trace flags and their meanings are shown in Table 3-1:
Trace Flag |
Description |
|---|---|
3703 |
Disables proxy table index creation during create existing table or create proxy_table command execution. If this flag is set on, then no index metadata will be imported from the remote site referenced by the proxy table, and no indexes for the proxy table will be created. This trace flag is global and should be used with care and turned off when no longer necessary. (global) |
11201 |
Logs client connect events, disconnect events, and attention events. (global) |
11202 |
Logs client language, cursor declare, dynamic prepare, and dynamic execute-immediate text. (global) |
11203 |
Logs client rpc events. (global) |
11204 |
Logs all messages routed to client. (global) |
11205 |
Logs all interaction with remote server. (global) |
11206 |
Logs file/directory processing steps |
11207 |
Logs text and image processing. (global) |
11208 |
Prevents the create index and drop table statements from being transmitted to a remote server. sysindexes is updated anyway. (spid) |
11209 |
Instructs update statistics to obtain just row counts rather than complete distribution statistics, from a remote table. (spid) |
11210 |
Disables Component Integration Services enhanced remote query optimization. (spid) |
11211 |
Not used. |
11212 |
Prevents escape on underscores (“_”) in table names. (spid) |
11213 |
Prevents generation of column and table constraints. (spid) |
11214 |
Disables Component Integration Services recovery at start-up. (global) |
11215 |
Sets enhanced remote optimization for servers of class db2. (global) |
11216 |
Disables enhanced remote optimization. (spid) |
11217 |
Disables enhanced remote optimization. (global) |
11220 |
Disables constraint checking of remote tables on the local server. This avoids duplicate checking. Setting this trace flag ON ensures that a query won’t be rejected by the quickpass mode because of constraints. (spid) |
11221 |
Disables alter table commands to the remote server when ON. This allows users to modify type, length and nullability of columns in a local table without changing columns in the remote table. Use trace flag 11221 with caution. It may lead to tables which are “out of sync.” (spid) |
