Difference between revisions of "Template:SQWareProduction sqwsyb GlobalVar.cfg explanation"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by Expdbtools)
m (Updated by Expdbtools)
Line 1: Line 1:
 
<br>
 
<br>
File explanation:
+
Variables explanation:
 
<pre>
 
<pre>
 
#General variables
 
#General variables

Revision as of 17:41, 2 January 2011


Variables explanation:

#General variables
gvsqw_EdtVersion => SQWareProduction version
gvsqw_ConnectDb => if connection to db evalable then Enable else Disable
gvsqw_Hostname => Hostname for prompt and trace
gvsqw_MailMsg_sybase => Begining of email subject
gvsqw_Mail_sybase => email adress, put NoNail in gvsqw_Mail_sybase if you don't want to send mail on error
gvsqw_SendmailHtmlFormat => Html format for email, put disable in gvsqw_SendmailHtmlFormat if you don't want to send mail in html format
gvsqw_PreFormatHtlml => enable if file is already formated
gvsqw_Colors => enable, put disable in gvsqw_Colors if you don't want to print in color
gvsqw_TraceJobDb => enable, put disable in gvsqw_TraceJobDb if you don't want to trace job execution in SQWareRepository
gvsqw_SaUser => User with sa role
gvsqw_PasswdFile => Password file path
gvsqw_EgrepIvFs => for 'egrep -v' on 'df' command
gvsqw_SuppLogsHisto => number of days to delete log files
gvsqw_GzipLogsHisto => number of days to compress log files
gvsqw_SuppAlert => number of days to delete archives of alert files
gvsqw_BackupServer => method to find backup server name
gvsqw_RootAdmin => admin directory
gvsqw_RootCfg => configuration directory
gvsqw_RootDev => devices directory
gvsqw_RunFile => run file name
gvsqw_RunFilePath => run file directory
gvsqw_ConfigFilePath => config directory
gvsqw_ErrorLogPath => errorlog directory
gvsqw_ErrorLog => errorlog file name
gvsqw_NbThread => default number of thread for parallelism
gvsqw_ExcludeDatabases => Databases to exclude of 'AllDatabases' treatments
gvsqw_SshOptions => ssh default options
gvsqw_ScpOptions => scp default options

#Html tags
gvsqw_CHtmlError => font tag for error
gvsqw_CHtmlOk => font tag for OK
gvsqw_CHtmlInfo => font tag for info
gvsqw_CHtmlEnd => end font tag
gvsqw_THtmlBegin => table tag
gvsqw_THtmlEnd => end table tag
gvsqw_THtmlThBegin => th tag
gvsqw_THtmlThEnd => end th tag
gvsqw_THtmlThInter => inter th tag
gvsqw_THtmlTdBegin1 => td tag edtnc
gvsqw_THtmlTdBegin2 => td tag sqwc_
gvsqw_THtmlTdEnd => end td tag
gvsqw_THtmlTdInter => inter td tag
gvsqw_THtmlPre => tag for pre formated text
gvsqw_THtmlPreEnd => end tag for pre formated text
gvsqw_HtmlCss => CSS style

##Globaly forcing return code for scripts
gvsqw_ForcedReturnCodeScript_sqwsyb_DumpAllDatabases => To force return code of sqwsyb_DumpAllDatabases.ksh
...

#for indicators
gvsqw_SizeMinTableIndicators => Size min in Meg of table to insert into SQWareRepository

#for kill
gvsqw_DefNbAttempt => default number of attempt to kill sessions

#for dbcc script
gvsqw_NbThreadDbcc => default number of thread for parallelism for Dbcc
gvsqw_DefAGR_Dbcc => default aggressiveness for execution of Dbcc
gvsqw_DefAGE_Dbcc => default aggressiveness for check end of Dbcc

#for checkstorage script
gvsqw_NbThreadCheckstorage => default number of thread for parallelism for Checkstorage
gvsqw_DefAGR_Checkstorage => default aggressiveness for execution of Checkstorage
gvsqw_DefAGE_Checkstorage => default aggressiveness for check end of Checkstorage

#for rebuild script
gvsqw_NbThreadRebuild => default number of thread for parallelism for Rebuild
gvsqw_DefAGR_Rebuild => default aggressiveness for execution of Rebuild
gvsqw_DefAGE_Rebuild => default aggressiveness for check end of Rebuild
gvsqw_CluRatioMinTable => Min cluster ratio of table to make rebuild table
gvsqw_CluRatioMinIndex => Min cluster ratio of index to make rebuild index
gvsqw_DefSizeMinTable => Min table size in Meg to take into accompte

#for update stats script old fashion (update statistics table)
gvsqw_NbThreadStatistics => default number of thread for parallelism for 
gvsqw_DefAGR_Statistics => default aggressiveness for execution of Statistics
gvsqw_DefAGE_Statistics => default aggressiveness for check end of Statistics
gvsqw_DefSizeMaxTableStatistics => Max table size in Meg to take into accompte

#for new update stats script (for >=v15 : update index statistics table)
gvsqw_NbThreadUpdtStats => default number of thread for parallelism for UpdtStats
gvsqw_DefAGR_UpdtStats => default aggressiveness for execution of UpdtStats
gvsqw_DefAGE_UpdtStats => default aggressiveness for check end of UpdtStats
gvsqw_StatsSizeMoMin100Pct => Min table size in Meg to not sampling
gvsqw_StatsSampleSizeMaxMo => Max data size in Meg to read for dynamic sampling compute
gvsqw_StatsSamplePctMini => Min sample size

#for dump script
gvsqw_NbThreadDump => default number of thread for parallelism for Dump
gvsqw_DefAGR_Dump => default aggressiveness for execution of Dump
gvsqw_DefAGE_Dump => default aggressiveness for check end of Dump
gvsqw_RootDump => default dump directory
gvsqw_RootDumpSource => default dump directory of source dataserver
gvsqw_DefDumpType => default dump type
gvsqw_DefMaxSizeStrip => default max size of stripe in Meg
gvsqw_DefCompLevel => default compression level
gvsqw_DefCompRate => default rate of compression
gvsqw_DefDumpNbGeneration => default number generation of backup to keep online
gvsqw_NbThreadScp => default number of thread for parallelism for copy dump files
gvsqw_DefAGR_Scp => default aggressiveness for execution of copy
gvsqw_DefAGE_Scp => default aggressiveness for check end of copy

#for load script
gvsqw_RsyncGap => default gap when resync syslogins/sysusers

#for SQWareWeb
gvsqw_WebDbaURL => SQWareWeb URL
gvsqw_WebDbaUserConn => Connection string ssh user@hostname to SQWareWeb