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 |
|---|---|
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. (global) |
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 only row counts rather than complete distribution statistics, from a remote table. (spid) |
11210 |
Disables the 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 queries are not 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 that are “out of sync.” (spid) |
11223 |
Disables proxy table index creation during create existing table or create proxy_table command execution. If this flag is set on, no index metadata is imported from the remote site referenced by the proxy table, and no indexes for the proxy table are created. This trace flag should be used with care and turned off when no longer necessary. (global) |
