dbcc setkeepalive (#minutes)
For use on Novell TCP/IP only.
dbcc setreplicate ( replicate_name, dbccbit )
Update the replication status of the object in cache only.
Parameters
ParamDescriptionValid Values
replicate_name object name
dbccbit new status 0 false
1 true
dbcc settrunc ( "ltm", option [, generation_num] )
Replication Server related: modifies LTM (Log Transfer Manager) information for
the database. "ltm" is entered as a literal string.
Options
OptionDescriptionValid Values
truncation option Should log be allowed to be truncated. Can be either:
"valid" set log truncation off -- The server cannot truncate tran log
records that have not been transferred to Rep Server yet.
"ignore" allow log to be truncated (via dump tran with no_log, etc.)
generation id option resets the database generation number to
generation_num. Used to increment number after a dump restore to prevent
Rep Server from rejecting transactions as duplicates "gen_id",
generation_num
dbcc show_bucket ( dbid, page, lookup_type )
Look for specified page in the buffer cache.
Parameters
ParamDescriptionValid Values
dbid database ID
page logical page number of page being looked for
lookup_type how to conduct search 1 use hash algorithm to look in the
bucket the page should be in
2 scan the entire buffer cache
dbcc showtext ( db, page )
Displays text or image data contained on a specified page.
Parameters
ParamDescription
db database name or database ID
page logical page number
dbcc tab ( dbid, objid, printopt )
Prints out the contents of each data page for the given table.
Parameters
ParamDescriptionValid Values
dbid database ID
objid object ID
printopt print option 0 print out only the page header (default)
1 print out each row separately and the offset table
2 print out the page as a whole and offset table
dbcc tablealloc ( tablename [, option][, mode] )
Check data and index pages against corresponding extent structures for a table.
Parameters
ParamDescriptionValid Values
tablename table name or table ID
option (optional) can take the following full fully check allocation
optimized check allocation pages listed in OAM (default)
fast exception report referenced but not allocated
null as optimized
mode (optional) can take the following fix fix errors on traversal
(default for user tables)
nofix do not fix errors (default for system tables)
dbcc thresholds ( db )
Provides thresholds information on the database.
Parameters
ParamDescription
db database name or database ID
dbcc traceoff ( tracenum [, tracenum ] ... )
Turn off specified trace flags.
Parameters
ParamDescription
tracenum number of the trace flag to turn off
dbcc traceon( tracenum [, tracenum ] ... )
Turn on specified trace flags.
Parameters
ParamDescription
tracenum number of the trace flag to turn on
Trace flags can be the following:
Trace Flags
NumberDescription
200 "Before" image of query tree
201 "After" image of query tree
260 To prevent "done_in_proc" messages
302 Information in index selection
310 Information in join selection
317 Complete information in join selection (voluminous)
320 Turn off join order heuristic
1204 Print out deadlock chains and victim
1205 Print out stack traces of deadlocked pids. Use in conjuction with
1204
2512 Bypass syslogs when doing checkalloc
1603 Use only standard unix calls for disk I/O
1610 Disable packet batching
3300 Display each log record as it is processed by recovery (voluminous)
3402 Do a alloc upgrade during loaddb recovery
3604 Send dbcc output to screen
3605 Send dbcc output to errorlog
3607 Do not recover any database, clear tempdb, or startup checkpoint
3608 Recover master only. Do not clear tempdb, or startup checkpoint
3609 Recove