Undocumented Sybase Server Flags
| Code
| Description
|
| 200
| displays messages about BEFORE IMAGE of query-tree.
|
| 201 | displays messages about AFTER IMAGE of query-tree.
|
| 241 | compress all query-trees whenever the server
the brought up
|
| 302 | Print info about the optimizer's index selection
|
| 310 | Print info about the optimzer's join selection
|
| 320 | Turn off the join order heuristic
|
| 1204 | Deadlock detects to errorlog
|
| 1603 | Use standard disk I/O (turn off async I/O)
|
| 1608 | Startup *only* engine 0; use dbcc engine(online) to
incrementally bring up additional engines until the
maximum number of configured engines.
|
| 1610 | SQL Server booted with TCP_NODELAY enabled.
|
| 1611 | Lock shared memory
|
| 1613 | Set affinity of the dataserver engine's onto particular CPUs
|
| 3300 | Display each log record that is being processed during
recovery. You may wanna redirect stdout 'cuz it can be
a *lot* of info
|
| 3604 | Send dbcc output to screen
|
| 3605 | Send dbcc output to errorlog
|
| 3607 | Do not recover any database, clear tempdb, or start up
checkpoint
|
| 3608 | Recover master only. Do not clear tempdb or start up
checkpoint
|
| 3609 | Recover all databases. Do not clear tempdb or start up
checkpoint
|
| 3620 | Do not kill infected processes
|
| 4013 | Place a record in the errorlog for each login to the
dataserver
|
| 5101 | Forces all I/O requests to go thru engine 0. This
removes the contention between processors but could
create a bottleneck if engine 0 becomes busy with
non-I/O tasks.
|
| 5102 | forces engine 0 to do I/O tasks ONLY.
|