Trace flags

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:

Table 3-1: Component Integration Services trace flags

Trace flag

Description

11201

Logs client connect events, disconnect events, and attention events. (global). Events sent to error log only.

11202

Logs client language, cursor declare, dynamic prepare, and dynamic execute-immediate text (global). Text sent to error log only.

11203

Logs client RPC events (global). Events sent to error log only.

11204

Logs all messages routed to client (global). Messages sent to only the error log.

11205

Logs all interaction with remote server (global). Interaction sent to error log only.

11206

Logs file/directory processing steps. (global)

11207

Logs text and image processing. (global)

11208

Prevents the create index and drop index 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)

11211

Prevents the drop table syntax from being forwarded to remote servers if the table was created using the create table at location syntax.

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)

11216

Disables quickpass. (spid)

11217

Disables quickpass. (global)

11218

Makes cursors involving Component Integration Services tables updateable by default.

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)

11228

Disables proxy table mapping to RPCs.

11229

Instructs Component Integration Services to use pre-Adaptive Server version 12.5.3 methods of gathering statistics data.

11299

Allows connection information to be logged when a connection to a remote server fails.