要详细
谢谢！freebob 回复于:2002-12-05 09:50:00
startserver
Description
StartsanAdaptiveServeroraBackupServer.startserverislocatedin$SYBASE/ASE-12_5/bin.
ThisutilityisnotavailableforWindowsNT.
Syntax
startserver[[-frunserverfile][-m]]...
Parameters
-frunserverfile
spec
iestherelativepathnameofarunserverfile,whichisusedasareferenceeachtimeyoustartanAdaptiveServerorBackupServer.Bydefault,therunserverfileis
hecurrentdirectoryandisnamedRUN_servername.IfyoustartasecondAdaptiveServeronthesamemachine,startservercreatesa
runserverfilenamedRUN_servername.-m
startsAdaptiveServerinsingle-usermode,allowingonlyone
Administratortologin,andturnstheallowupdatestosystemtablesconfigurationparameteron.U
hismodetorestorethemasterdatabase.TheAdministratorcanuhedbouseonlyparameterofsp_dboptionforsystemadministrationactivitiesthatrequiremorethanoneprocess,suchasbulkcopyingorusingthedatadictionary.startservernormallystartsuponlyoneserverpernode.The-mparametercreatesanm_RUNSERVERfileandoverwritesanyexistingm_RUNSERVERfile.
Examples
Example1
StartsanAdaptiveServernamedSYBASEfromtherunserverfilenamedRUN_servername
hecurrentdirectory:startserver
Example2
StartsanAdaptiveServernamedMYSERVERandaBackupServernamedSYB_BACKUP:
startserver-fRUN_MYSERVER-fRUN_SYB_BACKUP
Example3
StartsonlytheBackupServerSYB_BACKUP:
startserver-fRUN_SYB_BACKUP
Usage
startserverusestheinformation
herunserverfiletostartanAdaptiveServerorBackupServer.ThemasterdevicemustbewritablebytheuserwhostartsAdaptiveServer.ThestartservercommandcreatestheAdaptiveServererrorlogfile(namederrorlog)
hedirectorywheretheserverisstarted,andaddsthisinformationaspartofthe-eparameterheAdaptiveServerexecutablelineherunserverfile.IfasecondAdaptiveServerisstartedonthesamemachine,aerrorlognamederrorlog_servernameiscreated;thisinformationisaddedtothatserver\'srunserverfile.Theusermusthaveexecutepermissiononthespeciedrunserverfile.Youcanstartmultipleserversbyspec
yingmorethanonerunserverfile,asshowninexample2.Youcanspecy-maftereach-frunserverfile.AdaptiveServerderivesitsrunningenvironmentfromvalues
heconfigfile.Runsp_configureoredittheconfigfiletoseeorchangeconfigurationparameters.Toensurethe
egrityofyourAdaptiveServer,itisimportantthatyouapplyappropriateoperating-systemprotectionstothestartserverexecutableandtherunserverfile.Therunserverfile
Therunserverfile,whichiscreatedbysrvbuildduring
ation,containsthedataservercommandtostartAdaptiveServerorthebackupservercommandtostartBackupServer.Bydefault,therunserverfileishecurrentdirectoryandisnamedRUN_servername.Youcanedittherunserverfiletocorrecttheoptionsandparametersforthecommands.Thefollowingexampleshowstwosamplerunserverfiles.
RunserverfileforserverMYSERVER:
#!/bin/sh##
AdaptiveServerInformation:#
name:/MYSERVER#
masterdevice:/remote/Masters/myserver_dat#
masterdevicesize:10752#
errorlog:/remote/serverdev/
/errorlog#erfaces:/remote/serverdev/erfaces##/remote/serverdev/bin/dataserver-d/remote/Masters/myserver_dat\\
-sMYSERVER-e/remote/serverdev/
/MYSERVER_errorlog\\-i/remote/serverdev&
RunserverfileforbackupserverSYB_BACKUP:
#!/bin/sh##
BackupServerInformation:#
name:SYB_BACKUP#
errorlog:/remote/serverdev/
/backup.log#erfaces:/remote/serverdev/erfaces#locationofmultibuf:/remote/serverdev/bin/sybmultbuf#
language:us_english#
character
:iso_1#tapeconfigurationfile:/remote/serverdev/backup_tape.cfg##
/remote/serverdev/bin/backupserver-SSYB_BACKUP\\
-e/remote/serverdev/
/backup.log\\-I/remote/serverdev/
erfaces\\-M/remote/serverdev/bin/sybmultbuf-Lus_english-Jiso_1\\
-c/remote/serverdev/backup_tape.cfg
杉菜 回复于:2002-12-05 09:59:47谢谢
不过好象还有参数-T如何没有详细介绍说明比如-T3604是不检查日志启动我想要这方面资料freebob 回复于:2002-12-05 10:32:20
Traceflags
我可以贴出来
不过这些都是unsupportedfunctionility,如果
这出问题了sybase是不会帮你
定要小心使用!!!!!!!!!!!!!!!!!!!!!!!!!!Traceflagscanbe
throughdbcctraceon/traceofforaddedtotheRUN_SERVERfile(i.e."-T292"
292-reducesnetworktrafficbysuppressingserver-to-client"done-in-proc"network
packetsincombinationwithdbcctune(“doneinproc”,0).(Note:inprevious
versionsofthisQuickRef,traceflag260wasmistakenlymentionedhere;however,
260wasforASEversion10,andhasbeenreplacedwithtraceflag292).
299-don\'trecompilestoredprocsinheritingatemptablefromaparentproc
302-pr
infoabouttheoptimizer\'sindexselection310-pr
infoabouttheoptimizer\'sjoinselection(forbetterjoinorders)317-pr
infoabouttheoptimizer\'sjoinselection(forrejectedjoinorders)319-pr
infoonreformattingdecisionsduringqueryprocessing1204-replacedbyconfigoption"pr
deadlockinformation"
1213-usedwithdbccobject_stats;seethere
(12.0)1608-startsonlyengine0;forusewithdbccengine("online"
1610-replacedbyconfigoption"tcpnodelay"
2512-dbcccheckallocwillskipsyslogstosuppressspuriousalloc.errors
3300-pr
sdetailedinfowhenperformingrecovery(canbevoluminous)3502-logcheckpo
ingofdatabasesheservererrorlog3604-redirectdbccoutputtoclientsession
3605-redirectdbccoutputtotheservererrorlog
3607-opensonlymasterdevice;"master"dbisaccessiblebutnotrecovered
3608-recoveringonly"master"db;otherdatabasesareaccessiblebutnot
recovered;toavoid"logsuicide",use"shutdownwithnowait"anddonotcheckpo
.3609-alldatabasesarerecovered,buttempdbisnotre-initialised
3610-divide-by-zeroresultsinNULL(asinversion4.x),insteadofanerror
4001-writeeveryloginrecordtotheservererrorlog
4012-don\'tstartcheckpo
process4013-writeloginname,spidandkpidtotheservererrorlogforeverylogin
4044-allowstolog
oserveras"sa"whenthisloginislocked8003-pr
sinfoonRPCcalls8203-displaylockinginfowhendeadlockoccurs
8399-usedbydbccmonitortofillsysmonitorstable
11201-LogsCISclientconnect-/disconnect-andattentionevents
11202-LogsCISclientlanguage,cursordeclare,dynamicprepare,anddynamic
execute-immediatetext
11203-LogsCISclientrpcevents
11204-LogsallCISmessagesroutedtoclient
11205-LogsallCIS
eractionwithremoteservers11209-For"updatestatistics"onproxytables,onlygetrowcounts,notcomplete
distributionstatistics
11218-Cursorsinvolvingproxytableswillbe"readonly"bydefault
杉菜 回复于:2002-12-05 10:46:24太感谢了
这方面资料太少了般都找不到jazy 回复于:2002-12-05 19:57:32好！真是好资料！谢谢FreeBob兄！
置为精华了！
最新评论