Dbcc traceflags - Revision history

Psap at 08:49, 26 October 2012

2012-10-26T08:49:16Z

Psap at 08:39, 26 October 2012

2012-10-26T08:39:35Z

Show changes

Psap: /* List of known traceflags */

2010-03-16T14:42:02Z

‎List of known traceflags

Psap: /* List of known traceflags */

2009-11-23T18:56:46Z

‎List of known traceflags

Psap: /* List of known traceflags */

2009-10-30T12:55:01Z

‎List of known traceflags

Psap: /* List of known traceflags */

2008-11-16T19:39:17Z

‎List of known traceflags

Psap: /* List of known traceflags */

2008-06-06T14:33:46Z

‎List of known traceflags

Psap at 14:06, 6 June 2008

2008-06-06T14:06:40Z

Psap: /* List of known traceflags */

2008-04-16T17:10:02Z

‎List of known traceflags

Larissa: /* List of known traceflags */

2008-04-16T14:57:40Z

‎List of known traceflags

@@ Line 429: / Line 429: @@
 |-
 | 11202
-| Logs client language, cursor declare, dynamic prepare, and dynamic execute-immediate text. '''Very useful for tracing incoming statements.''' Supported by Sybase, [http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc32702.1570/html/omni_ug/CHDJIJEC.htm see documentation] || || || ||
+| Logs client language, cursor declare, dynamic prepare, and dynamic execute-immediate text. '''Very useful for tracing incoming statements into the ASE errorlog.''' Supported by Sybase, [http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc32702.1570/html/omni_ug/CHDJIJEC.htm see documentation] || || || ||
 |-
 | 11203

@@ Line 282: / Line 282: @@
 | 2703
 | When using update statistics with sampling and the index/column does not have existing statistics, set join density and total density to values from the sample rather then to defaults.||15.0 ESD 2|| || ||
 |-
 | 3100

@@ Line 177: / Line 177: @@
 | 615
 | When a read of a page does not indicate it's right identity a second read is done. When the identity is now correct the related device is suspect and ASE turns on additional diagnostic checks. The check can be turned off with the traceflag.||12.5.3 ESD 5 and 15.0 ESD 2|| ||Y||Y
 |-
 | 646
@@ Line 252: / Line 255: @@
 | 1642
 | Reserve one third of the sockets for EJB.|| || || ||
 |-
 | 1656
-| (Sun only) ASE will not boot when Intimate Shared Memory is not available.||15.0.2 ESD 6|| || ||
+| (Sun only) ASE will not boot when Intimate Shared Memory is not available.||12.5.4 ESD 10, 15.0.2 ESD 6|| || ||
 |-
 | 2205
@@ Line 261: / Line 270: @@
 | 2209
 | Used when upgrading ASE configured with high availability|| || || ||
 |-
 | 2512
@@ Line 309: / Line 321: @@
 | 3620
 | Do not kill infected processes.|| || || ||
 |-
 | 3706
@@ Line 314: / Line 329: @@
 |-
 | 3710
-| Improve the performance of DROP INDEX and CREATE INDEX by releasing the system catalog locks when not in DDL-IN-TRAN mode after the commit of the transaction but before post commit work started.||15.0.2 ESD 4|| ||Y||Y
+| Improve the performance of DROP INDEX and CREATE INDEX by releasing the system catalog locks when not in DDL-IN-TRAN mode after the commit of the transaction but before post commit work started.||12.5.4 ESD 10, 15.0.2 ESD 4|| ||Y||Y
 |-
 | 4001
@@ Line 339: / Line 354: @@
 | 4080
 | When an UPDATE using tsequal() is done within a stored procedure, tsequal() no longer returns a timestamp value unless the trace flag is set.||12.5.3 ESD 5 + 15.0 ESD 2|| || ||
 |-
 | 4084
-| Console logging will be disabled if setting console to nonblocking fails.||15.0.2 ESD 5|| ||Y||N
+| Console logging will be disabled if setting console to nonblocking fails.||12.5.4 ESD 10, 15.0.2 ESD 5|| ||Y||N
 |-
 | 4413
@@ Line 367: / Line 388: @@
 | 7738
 | Support plan sharing of cached statements across different users.||15.0.2 ESD 2|| || ||
 |-
 | 7815
@@ Line 376: / Line 400: @@
 | 7844
 | Enable/disable concurrent Kerberos authentication|| || || ||
 |-
 | 8003
@@ Line 466: / Line 493: @@
 | 11232
 | A 2762 error, "CREATE TABLE command is not allowed within multiple statement transaction" may be reported when executing a SQL INSERT..SELECT from proxy table mapped to a RPC. This traceflag has to be turned on to allow CREATE TABLE command in the remote procedure (serverwide)||12.5.3. ESD 5 and 15.0 ESD 2|| || ||
 |-
 | 11299
@@ Line 484: / Line 514: @@
 | 15322
 | Use 12.5 behaviour when assigning variables in combination with subqueries.||15.0.2 ESD 6|| || ||
 |-
 | 15381

@@ Line 86: / Line 86: @@
 |-
 | 302
-| Print trace information on index selection, supported by Sybase, [http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20022_1251/html/monitoring/X24199.htm see documentation]|| || 12.5 || ||Y
+| Print trace information on index selection, supported by Sybase, [http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20022_1251/html/monitoring/X24199.htm see documentation]|| ||12.5 unless using compatibility mode in ASE 15|| ||Y
 |-
 | 303
@@ Line 95: / Line 95: @@
 |-
 | 310
-| Show the plan as choosen by the optimizer, as well as I/O costs. Supported by Sybase [http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20022_1251/html/monitoring/X24199.htm see documentation] || ||12.5|| ||Y
+| Show the plan as choosen by the optimizer, as well as I/O costs. Supported by Sybase [http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20022_1251/html/monitoring/X24199.htm see documentation] || ||12.5 unless using compatibility mode in ASE 15|| ||Y
 |-
 | 311
-| Display optimizers expected I/O cost|| ||12.5|| ||Y
+| Display optimizers expected I/O cost|| ||12.5 unless using compatibility mode in ASE 15|| ||Y
 |-
 | 317
-| Show all considered plans. Supported by Sybase, [http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20022_1251/html/monitoring/X37588.htm see documentation] || ||12.5 || ||Y
+| Show all considered plans. Supported by Sybase, [http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20022_1251/html/monitoring/X37588.htm see documentation] || ||12.5 unless using compatibility mode in ASE 15|| ||Y
 |-
 | 319
-| Display optimizer reformatting strategy|| ||12.5 || ||Y
+| Display optimizer reformatting strategy|| ||12.5 unless using compatibility mode in ASE 15.|| ||Y
 |-
 | 320
@@ Line 110: / Line 110: @@
 |-
 | 321
-| Display optimizers reformatting strategy briefly|| ||12.5 || ||
+| Display optimizers reformatting strategy briefly|| ||12.5 unless using compatibility mode in ASE 15.|| ||
 |-
 | 324
@@ Line 125: / Line 125: @@
 |-
 | 334
-| Enable merge joins|| ||12.5|| ||
+| Enable merge joins|| ||12.5 unless using compatibility mode in ASE 15.|| ||
 |-
 | 353
@@ Line 137: / Line 137: @@
 |-
 | 384
-| Enable JTC|| || || ||
+| Enable JTC||12.0||12.5 unless using compatibility mode in ASE 15.|| ||
 |-
 | 396
 | Use min-max optimization for single table queries.|| || || ||
 |-
 | 450
@@ Line 150: / Line 156: @@
 | 467
 | Do not cache a statement in the statement cache when a temp tables is referenced.||15.0.2 ESD 5|| || ||
 |-
 | 516

@@ Line 68: / Line 68: @@
 |-
 | 244
-| When set, the maximum length of the returned value of str_replace() is 16384, otherwise it is 255|| || || ||
+| When set, the maximum length of the returned value of str_replace() is 16384, otherwise it is 255. When Msg 511 is incorrectly raised with this flag on, upgrade to 15.0.2 ESD 6.|| || || ||
 |-
 | 260
@@ Line 144: / Line 144: @@
 | 450
 | Sort a group by operation in the order of the groups||15|| || ||
 |-
 | 516
@@ Line 237: / Line 243: @@
 | 1642
 | Reserve one third of the sockets for EJB.|| || || ||
 |-
 | 2205
@@ Line 321: / Line 330: @@
 | 4080
 | When an UPDATE using tsequal() is done within a stored procedure, tsequal() no longer returns a timestamp value unless the trace flag is set.||12.5.3 ESD 5 + 15.0 ESD 2|| || ||
 |-
 | 4413
@@ Line 351: / Line 363: @@
 |-
 | 7841
-| Make ASE IPv6 aware|| || || ||
+| Make ASE IPv6 aware. No longer needed since 15.0.2 ESD 5|| ||15.0.2 ESD 5|| ||
 |-
 | 7844
@@ Line 460: / Line 472: @@
 | 15303
 | Possible performance improvement on a SELECT statement when a BIT column is involved in the WHERE clause.||15.0 ESD 2|| || ||
 |-
 | 15381

@@ Line 57: / Line 57: @@
 | 208
 | Show types of locks taken                                             ||      || || ||
 |-
 | 241
@@ Line 147: / Line 150: @@
 | 526
 | Print semi-graphical execution operator tree when showplan is enabled. Supported by Sybase, [http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc34982_1500/html/mig_gde/mig_gde161.htm see documentation] || || || ||
 |-
 | 602
@@ Line 337: / Line 343: @@
 | 7717
 | Disable check of client compatibility in ASE 15. See [[Version 15 client compatibility]] ||15.0.1|| || ||
 |-
 | 7815
@@ Line 343: / Line 352: @@
 | 7841
 | Make ASE IPv6 aware|| || || ||
 |-
 | 8003
@@ Line 355: / Line 367: @@
 | 9217
 | When set, RepAgent will not stop after reporting error 9289 due to an inconsistent log record found. Instead it will attempt to continue after reporting error 9290 in the error log. Supported by Sybase, [http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc00729_1500/html/errMessageAdvRes/BABDABEI.htm see documentation] ||15.0 ESD 2|| || ||
 |-
 | 11201
@@ Line 448: / Line 463: @@
 | 15381
 | When set, the warning message 307, "Index <index_name> specified as optimizer hint in the FROM clause of table <table_name> does not exist. Optimizer will choose another index instead." is disabled.||15.0.2 ESD 4|| || ||
 |-
 | 15556

@@ Line 288: / Line 288: @@
 | 3706
 | Performance improvement of drop table in tempdb.||15.0 ESD 2|| ||Y||Y
 |-
 | 4001
@@ Line 442: / Line 445: @@
 | 15303
 | Possible performance improvement on a SELECT statement when a BIT column is involved in the WHERE clause.||15.0 ESD 2|| || ||
 |-
 | 15556

@@ Line 318: / Line 318: @@
 |-
 | 4419
-| In some cases, outer join on view or derived table with CASE expression may perform slower
+| In some cases, outer join on view or derived table with CASE expression may perform slower due to view materialization.The workaround is to use traceflag 4419.||12.5.4 ESD#6|| || ||
 due to view materialization.The workaround is to use traceflag 4419.||12.5.4 ESD#6 || || ||
 |-
 | 5101