Difference between revisions of "Template:SQWareProduction sqwsyb GlobalVar.cfg explanation"
Expdbtools (talk | contribs) (Created page with '<br> Variable explanation: <pre> gvsqw_BackupServer => gvsqw_CHtmlEnd => gvsqw_CHtmlError => gvsqw_CHtmlInfo => gvsqw_CHtmlOk => gvsqw_CluRatioMinIndex => gvsqw_CluRatioMin…') |
m (Updated by Expdbtools) |
||
Line 1: | Line 1: | ||
<br> | <br> | ||
− | + | File explanation: | |
<pre> | <pre> | ||
− | + | #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_Colors => | + | 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 | |
− | gvsqw_StatsSampleSizeMaxMo => | + | |
− | + | #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_WebDbaURL => | + | 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 | ||
</pre> | </pre> |
Revision as of 17:41, 2 January 2011
File 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