sql server未经确认的dbcc命令

nosilence

相关英文：
（2000和7中支持的dbcc命令）http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocDBCC.htm
http://www.windowsitlibrary.com/Content/77/21/1.html



下面这些dbcccommand有些是没有官方支持的，不建议初学者使用。切记小心使用，不过有很多还是非常有用，有兴趣的可以测试看看！ （这些命令似乎在sql server6.5中可用）



Unauthorized
ofSybaseDBCCCommands

<script type="text/javascript"><!--              google_ad_client = "pub-1572879403720716";              google_ad_width = 336;              google_ad_height = 280;              google_ad_format = "336x280_as";              google_ad_type = "text_image";              google_ad_channel ="6686853775";              google_alternate_ad_url ="http://www.qqread.com/0000js/google336.htm";              google_color_border = "EDF0F5";                       google_color_bg = "EDF0F5";              google_color_link = "0000FF";              google_color_url = "008000";          google_color_text = "000000";              //--></script><script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript">              </script><iframe width="336" scrolling="no" height="280" frameborder="0" allowtransparency="true" hspace="0" vspace="0" marginheight="0" marginwidth="0" src="http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-1572879403720716&amp;dt=1167381268140&amp;lmt=1157009408&amp;alternate_ad_url=http%3A%2F%2Fwww.qqread.com%2F0000js%2Fgoogle336.htm&amp;prev_fmts=468x15_0ads_al_s&amp;format=336x280_as&amp;output=html&amp;channel=6686853775&amp;url=http%3A%2F%2Fwww.qqread.com%2Fsybase%2Fc108125052.html&amp;color_bg=EDF0F5&amp;color_text=000000&amp;color_link=0000FF&amp;color_url=008000&amp;color_border=EDF0F5&amp;ad_type=text_image&amp;ref=http%3A%2F%2Fsearch.cn.yahoo.com%2Fsearch%3Flp%3DDBCC%2Blog%2B%2528%2527rsxx%2527%252C%2B2%2529%26p%3DDBCC%2Blog%26ei%3DUTF-8%26pid%3Dysearch%26meta%3D&amp;cc=2&amp;u_h=768&amp;u_w=1024&amp;u_ah=734&amp;u_aw=1024&amp;u_cd=32&amp;u_tz=480&amp;u_his=1&amp;u_java=true&amp;u_nplug=14&amp;u_nmime=72" name="google_ads_frame"></iframe>

Usethematyourownrisk!



dbccallocdump(dbid,page)
Displaysallextentsonanallocationpage.
Parameters
dbiddatabaseID
pageallocationpagenumber




dbccallocmap(dbid,one_all,allocpg,bit_stat)
Displayormodifystatusofallocationbitmapsusedtodetectfullallocation
pages.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
one_allbitmap(s)tocheck/modify0entireallocationmap
1singleallocationmap
allocpgallocationpage,ifone_all=1
bit_statstatusofthebits0checkthestatus
1setthebit(s)
2clearthebit(s)




dbccbhash(print,bucket_limit)
Checkintegrityofandoptionallyprintthebufferhashtable.
Parameters
ParamDescriptionValidValues
printprintoptionprint_bufsdisplayallbuffers(default)
no_printdisplayonlybufferswithproblems
bucket_limitnumberofbuffersallowedinabucket.default=0




dbccbufcount(n_chains)
Printupto10longestbufferchainsandaveragechainlength.
Parameters
ParamDescriptionValidValues
n_chainsthenumberofchainstoprint1-10




dbccbuffer([dbid][,objid][,nbufs],printopt,buftype)
Printsbufferheadersandpagesfromthebuffercache.
Parameters
ParamDescriptionValidValues
dbid(optional)databasenameordatabaseID0willshowdataforall
databases.
objid(optional)objectID0willshowdataforallobjects.
nbufs(optional)numberofbufferstoexamine.Ifpositive,thenbufs
bufferswhichmeettheothercriteria(dbid,objid)areprintedinMRUto
LRUorder.Ifnegative,thelastnbufsbufferswhichmeetthecriteriaare
printedinLRUtoMRUorder.If0,allbufferswillbeprintedinMRUto
LRUorder.
printoptprintoption0printoutonlythebufferheaderandpageheader
(default)
1printouteachrowseparatelyandtheoffsettable
2printouteachrowasawholeandtheoffsettable
buftypebuffertypetoprintCanbenumericorasymboliccharacter
string.Seetablebelowforpossiblestringsandtheirhexadecimal
equivalents


BufferTypes
ParamHexDescription
BUF_DIRTY1Bufferincachediffersfromdiskimage.
BUF_IO2Bufferisbeingreadorwritten.
BUF_PINNED4Thelogmustbewrittenbeforethisbufferis.
BUF_KEPT8Someprocessisusingthisbuffer.
BUF_RLOCK10Thebufferisresourcelocked.
BUF_TRIP20Thebufferagesoutofcachemoreslowly.
BUF_NEW40Buffercontainsanewpageandhasneverbeenwritten.
BUF_RWAIT80Theprocessiswaitingforrlock.
BUF_IOERR100Therewasanerrorwritingtisbuffer.
BUF_SPECIAL200Ifthisbufferiswritten,updaterelevantdescriptors.
BUF_WQUEUE400Thisbufferisqueuedforanout-of-sequencedatabasedump.

BUF_NOTHASHED800Thisbufferisnothashed.
BUF_HASHED1000Thisbufferishashed.
BUF_DIAG2000Thisisaspecialbufferusedfordiagnosticsonly.
BUF_FILTHY4000ThebufferwasdirtiedwhileinI/O(logonly).
BUF_NORELEASE8000Thisisusedforcoordinatingreleasesofrlockson
allocationpages.




dbccbytes(startaddress,length)
Dumpoutbytesfromspecificaddress.
Parameters
ParamDescription
startaddressstartingaddresstodump
lengthnumberofbytestodump




dbcccacheremove(dbname,objectname)
Removesobjectfromcache.
Parameters
ParamDescription
dbnamedatabasename
objnameobjectname




dbcccapture_tds(spid)
CapturesTabularDataStreamintoafilecalled$SYBASE/install/TDSDUMP.File
containsfullstream,includingpasswords--chmodthefiletoprotectthis
information.



dbcccheckalloc[(dbname[,option])]
Checkdataandindexpagesagainstcorrespondingextentstructures(earlier
newalloc).
Parameters
ParamDescriptionValidValues
dbname(optional)databasename
option(optional)fixoptionfixreportandfixdescrepancies
nofixreportdecrepanciesonly(default)




dbcccheckcatalog[(dbname)]
Checkconsistencyofsystemcatalogstablesfordatabasenamed.
Parameters
ParamDescription
dbname(optional)databasename;defaultiscurrentdb




dbcccheckdb[(dbname[,skip_ncindex])]
Checkconsistencyofdataandindexpages.
Parameters
ParamDescription
dbname(optional)databasename;defaultiscurrentdb
skip_ncindex(optional)skipcheckonnonclusteredindexesforthe
database




dbccchecktable(tabid[,skip_ncindex])
Checkconsistencyofdataandindexpages.
Parameters
ParamDescription
tabidtablenameortableID
skip_ncindex(optional)skipcheckonnonclusteredindexesforthetable.





dbccchgdbname(dbname,newname)
ChangesdatabasenameinDBINFOonly.
Parameters
ParamDescription
dbnameexistingdatabasename
newnamenewdatabasename




dbccchgobjname(objname,newname)
Changesobjectnameincacheonly.
Parameters
ParamDescription
objnameexistingobjectname
newnamenewobjectname




dbcccursorinfo(cursor_level,cursor_name)
Displayscursorinformation.
Parameters
ParamDescription
cursor_levellevelnumber;-1togetcursorinfoforallnestinglevels
cursor_namenameofthecursor




dbccdbinfo[(dbname)]
PrintDBINFOstructureforspecifieddatabase.
Parameters
ParamDescription
dbname(optional)databasename




dbccdbrecover(dbname)
Thiswillhaverecoveryrunonasuspectdatabasewithoutrebootingtheserver.
Parameters
ParamDescription
dbnamedatabasename




dbccdbrepair(db,option[,table][,index])
Repairsystemtables.
Parameters
ParamDescriptionValidValues
dbdatabaseIDordatabasename
optionrepairoptiondropdbdropthespecifieddatabase
findstrandeddisplaystrandedobjects
fixindexrebuildthespecifiedindex;usedonsystemcatalogsonly
fixsysindexcorrectpfreeoffvalueforsysindexes
newthresholdrebuildthedatabasethresholdtable
remapupdatethein-coreimageofthedatabaseusagemaptable
repairindexrepairindexforusertables
table(optional)tablename
index(optional)indexID




dbccdbtable(dbid)
PrintoutthecontentsoftheDBTABLEstructure.
Parameters
ParamDescription
dbiddatabaseID




dbccdelbuff(dbid,page,dirty_flush,kept_flag,rlock_flag)
Removebufferfromcache,optionallyflushtodisk.
Parameters
ParamDescription
dbiddatabaseID
pagethelogicalpagenumberofthepagetoberemoved
dirty_flushif1,thenflushthepagetodiskifDIRTY
kept_flagif1,thendonotunkeepbufferifKEPT
rlock_flagif1,thendonotremoveRESOURCELOCK




dbccdelete_row(dbid,page,delete_by_row,rownum)
Deleteanindexordatarowbyeitherarownumberoranoffsetonapage.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
pagethelogicalpagenumber
delete_by_rowdeletelocation;byroworbyoffset1nextparameteris
interpretedasrownumber
0nextparameterisinterpretedasoffsetonthepage
rownumeitherarownumberoroffset




dbccdes[([dbid][,objid])]
PrintsthecontentsofthespecifiedDES(descriptor).
Parameters
ParamDescription
dbid(optional)databaseID
objid(optional)objectID




dbccdescount(n_chains)
Printupto10longestDESchains.P>Parameters
ParamDescription
n_chainsthenumberofchainstoprint,upto10.




dbccdesdiag(dbid,option)
ProduceDESdiagnosticreports.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
optiondiagnostictorun-4DisplayHashTableGraph
-3DisplayDiagnosticMaps
-2Runallthetests(1-4)
-1Returntocaller-Exit
0Redisplaythismenu
1CheckFreeDesChain
2CheckDbtableDESchain
3CheckDesKept/Unkeptchain
4CheckDesName/Idhashtable
5Display'lost'descriptors
6Runtests(1-4),kepaniconerrors







dbccengine(engine,func)
Parameters
ParamDescription
engineenginenumber
func"online"
"offline"




dbccextentchain(dbid,objid,indexid,sort,display,[,order])
Displaysorcountsextentsfollowingthechain,checkingchainintegrity.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
objidobjectID
indexidindexID
sortreportonstateofthesortbit0don'tincludethisinfo
1doreportonsortbitstatus
displaywhattoreport0displaythecountonly
1displaytheextents
order(optional)ordertofollowthechain0descending
1ascending




dbccextentcheck(dbid,objid,indexid,sort)
Examineallextentsonallocationpagesforspecifiedobject.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
objidobjectID
indexidindexID
stateofthesortbit0don'treportthis
1reportsortbitstatus




dbccextentdump(dbid,page)
Displayanextent.
Parameters
ParamDescription
dbiddatabaseID
pagethenumberofapagecontrolledbytheextentinquestion




dbccextentzap(dbid,objid,indexid,sort)
Clearallextentsmatchingtheparametervalues.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
objidobjectID
indexidindexID
sortstateofthesortbit0
1




dbccfindnotfullextents(dbid,objid,indexid,sort)
Findallnotfullextentsonallallocationpagesforthespecifiedobject.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
objidobjectID
indexidindexID
sortstateofthesortbit0
1




dbccfix_al[(dbname)]
Makeallocationbitmapsmatchthepagechains.
Parameters
ParamDescription
dbname(optional)databasename




dbccfix_text(table)
Toupgradetextvaluesafterconvertingtheservertoamulti-bytecharacter
set.
Parameters
ParamDescription
tabletablenameortableID




dbccgettrunc()
ReplicationServerrelated:PrintscurrentLTM(LogTransferManager)
informationforthedatabase.



dbcchelp(dbcc_command)
Givesyntaxonspecificdbcccommand.
Parameters
ParamDescription
dbcc_commandthecommandforwhichsyntaxhelpisdesired




dbccind(dbid,objid,printopt)
Printeachindexpageforaspecifiedtable.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
objidobjectID
printoptprintoption0printoutonlythebufferheaderandpageheader
(default)
1printpageheaders,pagedatainrowformat,andoffsettables
2printpageheaders,unformattedpagedata,andoffsettables




dbccindexalloc(table,indid[,report][,fix])
Parameters
ParamDescriptionValidValues
tabletablenameortableID
indidindexID
report(optional)reportstylefullcompletedetails
optimizedessentialdetails(default)
fastquickreport
fix(optional)fixflagfixfixallocationerrorsontraversal(default)
nofixdonotfixallocationerrors




dbccis_replication_enabled
ReturnsTrue/Falsevia@@errorvalue.Immediatelyafterrunningthiscommand,
select@@error.If@@error=0,replicationisenabled,elsereplicationisnot
enabled.



dbcclistoam(db,objid,indid)
Listsobjectallocationinformation.
Parameters
ParamDescription
dbdatabaseIDordatabasename
objidobjectID
indid(optional)indexID




dbcclocateindexpgs(dbid,objid,page,indexid,level)
Printallreferencesintheindextothespecifiedpage.
Parameters
ParamDescription
dbiddatabaseID
objidobjectID
pagelogicalpagenumberofthepageforwhichindexreferencesarebeing
searched
indexidindexID
levellevelwithintheindextosearchforreferences




dbcclock
Printoutlockchains.



dbcclockunit(file_name)
Parameters
ParamDescription
file_namefilein$SYBASE/install




dbcclog([dbid][,objid][,pagenum][,rownum][,nrecords][,type],printopt)
Printlogrecords.
Parameters
ParamDescriptionValidValues
dbid(optional)databaseID
objid(optional)objectID
pagenum(optional)pagenumberORifgivenwithnorownum
transactionIDifrownumissupplied
rownum(optional)transactionIDifgivenwithpagenum
nrecords(optional)numberofrecordstoexamineIfpositive,thefirst
nrecordslogentrieswhichmeetthecriteria(dbid,objid,pagenum,
rownum)areprintedinforwardorder.
Ifnegative,thelastnrecordswhichmeetthecriteriaareprintedin
reverseorder.
type(optional)typeofrecordtoprint-1Printallrecords
0XREC_BEGINXACT
1XREC_CHSYSIND
2XREC_SWITCHTO
3XREC_RETURN
4XREC_INSERT
5XREC_DELETE
6XREC_INSIND
7XREC_IINSERT
8XREC_IDELETE
9XREC_MODIFY
10XREC_NOOP
11XREC_INOOP
12XREC_DNOOP
13XREC_ALLOC
14XREC_DBNEXTID
15XREC_EXTENTAllocateextentswithoutpagesallocated.
16XREC_SPLIT
17XREC_CHECKPOINT
18XREC_SAVEXACT
19XREC_CMD
20XREC_DEXTENTDeallocateextents.
21XREC_DEALLOCDeallocatepage.
22XREC_DROPEXTSDeleteallextentsonanallocationpage.
23XREC_AEXTENTSAllocateextentandmarkallpagesused.
24XREC_SALLOCAllocatefornewpageofasplit.
25XREC_PGCHGSYSINDDirectchangetosysindexes.
27XREC_SORT
28XREC_SODEALLOC
29XREC_ALTDB
30XREC_ENDXACT
31XREC_SORTTS
32XREC_TEXTDirectinserts.
33XREC_INOOPTEXTDeferredTEXTinsert.
34XREC_DNOOPTEXTDeferredTEXTdelete.
35XREC_ISINDTEXTIndirectinsert.
36XREC_TEXTDELETEDeletetext
printoptprintoption0printoutheaderinformationonly(default)
1printoutheaderanddatainformation.




dbcclogtransfer('reserve','context')
dbcclogtransfer('scan',{'normal'|'repeat'|'continue'})
RefertoyourRepServermanual.



dbccmemusage
Displaydetailedinformationonserver'smemoryusage.



dbccmonitor(task,group,option)
AllowsamoredetailedmonitoringoftheSQLServer.[Hint:Rundbcc
traceon(8399)first,toenabledescriptivenamesforgroups.]
Parameters
ParamValuePurpose
task"clear"clearearliergatheredstatistics
"sample"gatherfreshstatistics
"select"enablestatisticstobedisplayed
group"all"allgroups'statisticsaregathered/displayed
group_namenameofthegroupforwhichstatisticsaretobe
gathered/displayed
option"on"enablemonitoring
"off"discontinuemonitoring




dbccnetmemshow([option])
Printsnetworkmemoryallocations.
Parameters
ParamValuePurpose
option(optional)1summaryinformation
2or3allinformation(default)




dbccnetmemusage
Printsmemoryusagedetails.



dbccnewalloc(dbname,option)
Reportsonpagesandextentsinuse.
Parameters
ParamDescription
dbnamedatabasename
option1,2,or3








CaveatEmptor!!
Usethematyourownrisk!



dbccpage(dbid,pagenum[,printopt][,cache][,logical])
Printsthecontentsofthespecifiedpage.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
pagenumthelogicalorvirtualpagenumber
printopt(optional)printoption0printoutonlythebufferheaderand
pageheader(default)
1printbufferheaders,pageheader,eachrowseparatelyandtheoffset
table
2printoutbufferandpageheaders,pageasawholeandtheoffsettable.

cache(optional)handlingofpagesincache0printoutthepageasfound
ondisk
1printoutthepageasfoundincacheifitresidesincache,otherwise
retrievethepagefromdiskandprint(default).
logical(optional)typeofpage0pagenumistakentoavirtualpage
number
1pagenumistakentobealogicalpagenumber(default)




dbccpglinkage(dbid,start,number,printopt,target,order)
Displaythepagechain,performingintegritychecksduringtraversal.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
startpagenumberwithwhichtostart
numbernumberofpagestoexamine,or0iftargetisspecified
printoptprintoption0displayonlythecountofpagesscanned
1displayinformationaboutthelast16pagesscanned
2displayallpagenumbersinthescan
targettheparticularpagewearelookingfor,or0ifnumberisspecified
Specifyingatargetwillcontinuetosearchinthespecifieddirection
untilthetargetpageortheendofthechainisfound.
ordertraversalorder0descending
1ascending




dbccpktmemshow([spid])
Listsnetworkbuffersforactiveprocesses.
Parameters
ParamDescription
spid(optional)serverprocessID




dbccprocbuf([dbid][,objid][,nbufs][,printopt])
Printprocedurebufferheadersandproc-headersfromtheprocedurecache.
Parameters
ParamDescriptionValidValues
dbid(optional)databaseID
objid(optional)objectID
nbufs(optional)numberofbufferstoprint
printopt(optional)printoption0printoutonlytheprocbuffandproc
header(default)
1printoutprocbuff,procheaderandcontentsofbuffer.




dbccprocdiag(dbid,option)
Producediagnosticsonprocedurebuffers
Parameters
ParamDescriptionValidValues
dbiddatabaseID
optiondiagnostictorun0displayoptionmenu
1displaydiagbitmaps
2displayprocbufsincache
3runsummarydiagnosticsonentirecache




dbccprtipage(dbid,objid,indexid,indexpage)
Printthepagenumberpointedtobyeachrowonthespecifiedindexpage.
Parameters
ParamDescription
dbiddatabaseID
objidobjectID
indexidindexID
indexpagethelogicalpagenumberoftheindexpagetodump




dbccpss(suid,spid,printopt)
PrintsthecontentsofthespecifiedPSSstructure.
Parameters
ParamDescriptionValidValues
suid(optional)serveruserID
spid(optional)serverprocessID
printoptprintoption0standardoutput
1allopenDES'sandcurrentsequencetree
2printalllocksheldbytheprocesstotheerrorlog.




dbccrebuild_log(dbname,rebuild,all)
Generatesanewlogcontainingasinglecheckpointrecord.
Parameters
ParamDescriptionValidValues
dbnamedatabasename
rebuildrebuildlogflag0donotcreateanewlog
1createanewlog
allremovelogflag0oldpreservedlogremoved
1oldpreservedandnewlogremoved




dbccrebuildextents(dbid,objid,indexid,sort,override)
Rebuildanobject'sextentchain.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
objidobjectID
indexidindexID
sortstateofthesortbit0sorted
1notsorted
overrideoverrideoption0rebuildonlyifdatabaseisnotopen
1rebuildeventhoughdatabaseisalreadyopen




dbccreindex(tablename)
Rebuildsindexes.
Parameters
ParamDescription
tablenametablewhoseindexesaretoberebuilt




dbccremap(objid,dbname,1)
Remapsastoredproc,trigger,rule,default,orviewtobecompatiblewith
release10.0.
Parameters
ParamDescription
objidobjectID
dbnamedatabasename




dbccreport_al[(dbname)]
Reportondifferencesbetweenallocationbitmapsandpagechains.
Parameters
ParamDescription
dbname(optional)databasename




dbccresource
PrintouttheRESOURCEstructure.



dbccsave_rebuild_log(dbname)
Generateanewlogcontainingasinglecheckpointrecordandpreserveoldlog
extentsbychangingtheobjectID.
Parameters
ParamDescription
dbnamedatabasename




dbccsetkeepalive(#minutes)
ForuseonNovellTCP/IPonly.



dbccsetreplicate(replicate_name,dbccbit)
Updatethereplicationstatusoftheobjectincacheonly.
Parameters
ParamDescriptionValidValues
replicate_nameobjectname
dbccbitnewstatus0false
1true




dbccsettrunc("ltm",option[,generation_num])
ReplicationServerrelated:modifiesLTM(LogTransferManager)informationfor
thedatabase."ltm"isenteredasaliteralstring.
Options
OptionDescriptionValidValues
truncationoptionShouldlogbeallowedtobetruncated.Canbeeither:
"valid"setlogtruncationoff--Theservercannottruncatetranlog
recordsthathavenotbeentransferredtoRepServeryet.
"ignore"allowlogtobetruncated(viadumptranwithno_log,etc.)
generationidoptionresetsthedatabasegenerationnumberto
generation_num.Usedtoincrementnumberafteradumprestoretoprevent
RepServerfromrejectingtransactionsasduplicates"gen_id",
generation_num




dbccshow_bucket(dbid,page,lookup_type)
Lookforspecifiedpageinthebuffercache.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
pagelogicalpagenumberofpagebeinglookedfor
lookup_typehowtoconductsearch1usehashalgorithmtolookinthe
bucketthepageshouldbein
2scantheentirebuffercache




dbccshowtext(db,page)
Displaystextorimagedatacontainedonaspecifiedpage.
Parameters
ParamDescription
dbdatabasenameordatabaseID
pagelogicalpagenumber




dbcctab(dbid,objid,printopt)
Printsoutthecontentsofeachdatapageforthegiventable.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
objidobjectID
printoptprintoption0printoutonlythepageheader(default)
1printouteachrowseparatelyandtheoffsettable
2printoutthepageasawholeandoffsettable




dbcctablealloc(tablename[,option][,mode])
Checkdataandindexpagesagainstcorrespondingextentstructuresforatable.
Parameters
ParamDescriptionValidValues
tablenametablenameortableID
option(optional)cantakethefollowingfullfullycheckallocation
optimizedcheckallocationpageslistedinOAM(default)
fastexceptionreportreferencedbutnotallocated
nullasoptimized
mode(optional)cantakethefollowingfixfixerrorsontraversal
(defaultforusertables)
nofixdonotfixerrors(defaultforsystemtables)




dbccthresholds(db)
Providesthresholdsinformationonthedatabase.
Parameters
ParamDescription
dbdatabasenameordatabaseID




dbcctraceoff(tracenum[,tracenum]...)
Turnoffspecifiedtraceflags.
Parameters
ParamDescription
tracenumnumberofthetraceflagtoturnoff




dbcctraceon(tracenum[,tracenum]...)
Turnonspecifiedtraceflags.
Parameters
ParamDescription
tracenumnumberofthetraceflagtoturnon

Traceflagscanbethefollowing:
TraceFlags
NumberDescription
200"Before"imageofquerytree
201"After"imageofquerytree
260Toprevent"done_in_proc"messages
302Informationinindexselection
310Informationinjoinselection
317Completeinformationinjoinselection(voluminous)
320Turnoffjoinorderheuristic
1204Printoutdeadlockchainsandvictim
1205Printoutstacktracesofdeadlockedpids.Useinconjuctionwith
1204
2512Bypasssyslogswhendoingcheckalloc
1603UseonlystandardunixcallsfordiskI/O
1610Disablepacketbatching
3300Displayeachlogrecordasitisprocessedbyrecovery(voluminous)
3402Doaallocupgradeduringloaddbrecovery
3604Senddbccoutputtoscreen
3605Senddbccoutputtoerrorlog
3607Donotrecoveranydatabase,cleartempdb,orstartupcheckpoint
3608Recovermasteronly.Donotcleartempdb,orstartupcheckpoint
3609Recoveralldatabases.Donotcleartempdb,orstartupcheckpoint
3620Donotkillinfectedprocesses
3701Allowsdroppingandcreatingofsystemindexes(DANGEROUS!)
4000Crashserveratnextloopforrecoverytesting
4012Bootwithoutstartingupcheckpointprocess
4013Placearecordintoerrorlogeachtimesomeonelogsintotheserver
5101Engine0willperformalldiskandnetworkI/O.
5102Preventsengine0fromrunninganynon-affinitiedtasks
8399Enabledescriptivenamesforgroups(dbccmonitor)




dbcctune("parameter",value[,tablename])
Setsbuildmasterparameters.ProbablynotnecessaryasofSystem11,wherethe
oldbuildmasterparametersarenowincorporatedintosysconfigures(see
documentationonsp_configure).



dbccundo(dbid,pgnum,rownum)



dbccupdate_tmode(procname,tranmode)
Updatetransaction-modeinbothsysobjectsandDESforstoredprocedures.
Parameters
ParamDescriptionValidValues
procnamestoredprocedurename
tranmodetransactionmodeunchained
chained
anymode




dbccusedextents(dbid,devtype,display)
Countordisplaythestatusofused/unusedextentsonspecifieddevices.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
devtypetypeofdevicetocheckallshowallextents
logshowextentsofallocationforthelog
nonlogshowextentsofnonlogallocations
displaywhattoreporton0informationabouttheextents
1countoftheextents