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

From Wiki_dbSQWare
Jump to: navigation, search
(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>
Variable explanation:
+
File explanation:
 
<pre>
 
<pre>
gvsqw_BackupServer =>  
+
#General variables
gvsqw_CHtmlEnd =>  
+
gvsqw_EdtVersion => SQWareProduction version
gvsqw_CHtmlError =>  
+
gvsqw_ConnectDb => if connection to db evalable then Enable else Disable
gvsqw_CHtmlInfo =>  
+
gvsqw_Hostname => Hostname for prompt and trace
gvsqw_CHtmlOk =>  
+
gvsqw_MailMsg_sybase => Begining of email subject
gvsqw_CluRatioMinIndex =>  
+
gvsqw_Mail_sybase => email adress, put NoNail in gvsqw_Mail_sybase if you don't want to send mail on error
gvsqw_CluRatioMinTable =>  
+
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_ConfigFilePath =>  
+
gvsqw_Colors => enable, put disable in gvsqw_Colors if you don't want to print in color
gvsqw_ConnectDb =>  
+
gvsqw_TraceJobDb => enable, put disable in gvsqw_TraceJobDb if you don't want to trace job execution in SQWareRepository
gvsqw_DefAGE_Checkstorage =>  
+
gvsqw_SaUser => User with sa role
gvsqw_DefAGE_Dbcc =>  
+
gvsqw_PasswdFile => Password file path
gvsqw_DefAGE_Dump =>  
+
gvsqw_EgrepIvFs => for 'egrep -v' on 'df' command
gvsqw_DefAGE_Rebuild =>  
+
gvsqw_SuppLogsHisto => number of days to delete log files
gvsqw_DefAGE_Scp =>  
+
gvsqw_GzipLogsHisto => number of days to compress log files
gvsqw_DefAGE_Statistics =>  
+
gvsqw_SuppAlert => number of days to delete archives of alert files
gvsqw_DefAGE_UpdtStats =>  
+
gvsqw_BackupServer => method to find backup server name
gvsqw_DefAGR_Checkstorage =>  
+
gvsqw_RootAdmin => admin directory
gvsqw_DefAGR_Dbcc =>  
+
gvsqw_RootCfg => configuration directory
gvsqw_DefAGR_Dump =>  
+
gvsqw_RootDev => devices directory
gvsqw_DefAGR_Rebuild =>  
+
gvsqw_RunFile => run file name
gvsqw_DefAGR_Scp =>  
+
gvsqw_RunFilePath => run file directory
gvsqw_DefAGR_Statistics =>  
+
gvsqw_ConfigFilePath => config directory
gvsqw_DefAGR_UpdtStats =>  
+
gvsqw_ErrorLogPath => errorlog directory
gvsqw_DefCompLevel =>  
+
gvsqw_ErrorLog => errorlog file name
gvsqw_DefCompRate =>  
+
gvsqw_NbThread => default number of thread for parallelism
gvsqw_DefDumpNbGeneration =>  
+
gvsqw_ExcludeDatabases => Databases to exclude of 'AllDatabases' treatments
gvsqw_DefDumpType =>  
+
gvsqw_SshOptions => ssh default options
gvsqw_DefMaxSizeStrip =>  
+
gvsqw_ScpOptions => scp default options
gvsqw_DefNbAttempt =>  
+
 
gvsqw_DefSizeMaxTableStatistics =>  
+
#Html tags
gvsqw_DefSizeMinTable =>  
+
gvsqw_CHtmlError => font tag for error
gvsqw_EdtVersion =>  
+
gvsqw_CHtmlOk => font tag for OK
gvsqw_EgrepIvFs =>  
+
gvsqw_CHtmlInfo => font tag for info
gvsqw_ErrorLog =>  
+
gvsqw_CHtmlEnd => end font tag
gvsqw_ErrorLogPath =>  
+
gvsqw_THtmlBegin => table tag
gvsqw_ExcludeDatabases =>  
+
gvsqw_THtmlEnd => end table tag
#gvsqw_ForcedReturnCodeScript_sqwsyb_DumpAllDatabases =>  
+
gvsqw_THtmlThBegin => th tag
gvsqw_GzipLogsHisto =>  
+
gvsqw_THtmlThEnd => end th tag
gvsqw_Hostname =>  
+
gvsqw_THtmlThInter => inter th tag
gvsqw_HtmlCss =>  
+
gvsqw_THtmlTdBegin1 => td tag edtnc
gvsqw_MailMsg_sybase =>  
+
gvsqw_THtmlTdBegin2 => td tag sqwc_
gvsqw_Mail_sybase =>  
+
gvsqw_THtmlTdEnd => end td tag
gvsqw_NbThread =>  
+
gvsqw_THtmlTdInter => inter td tag
gvsqw_NbThreadCheckstorage =>  
+
gvsqw_THtmlPre => tag for pre formated text
gvsqw_NbThreadDbcc =>  
+
gvsqw_THtmlPreEnd => end tag for pre formated text
gvsqw_NbThreadDump =>  
+
gvsqw_HtmlCss => CSS style
gvsqw_NbThreadRebuild =>  
+
 
gvsqw_NbThreadScp =>  
+
##Globaly forcing return code for scripts
gvsqw_NbThreadStatistics =>  
+
gvsqw_ForcedReturnCodeScript_sqwsyb_DumpAllDatabases => To force return code of sqwsyb_DumpAllDatabases.ksh
gvsqw_NbThreadUpdtStats =>  
+
...
gvsqw_PasswdFile =>  
+
 
gvsqw_PreFormatHtlml =>  
+
#for indicators
gvsqw_RootAdmin =>  
+
gvsqw_SizeMinTableIndicators => Size min in Meg of table to insert into SQWareRepository
gvsqw_RootCfg =>  
+
 
gvsqw_RootDev =>  
+
#for kill
gvsqw_RootDump =>  
+
gvsqw_DefNbAttempt => default number of attempt to kill sessions
gvsqw_RootDumpSource =>  
+
 
gvsqw_RsyncGap =>  
+
#for dbcc script
gvsqw_RunFile =>  
+
gvsqw_NbThreadDbcc => default number of thread for parallelism for Dbcc
gvsqw_RunFilePath =>  
+
gvsqw_DefAGR_Dbcc => default aggressiveness for execution of Dbcc
gvsqw_SaUser =>  
+
gvsqw_DefAGE_Dbcc => default aggressiveness for check end of Dbcc
gvsqw_ScpOptions =>  
+
 
gvsqw_SendmailHtmlFormat =>  
+
#for checkstorage script
gvsqw_SizeMinTableIndicators =>  
+
gvsqw_NbThreadCheckstorage => default number of thread for parallelism for Checkstorage
gvsqw_SshOptions =>  
+
gvsqw_DefAGR_Checkstorage => default aggressiveness for execution of Checkstorage
gvsqw_StatsSamplePctMini =>  
+
gvsqw_DefAGE_Checkstorage => default aggressiveness for check end of Checkstorage
gvsqw_StatsSampleSizeMaxMo =>  
+
 
gvsqw_StatsSizeMoMin100Pct =>  
+
#for rebuild script
gvsqw_SuppAlert =>  
+
gvsqw_NbThreadRebuild => default number of thread for parallelism for Rebuild
gvsqw_SuppLogsHisto =>  
+
gvsqw_DefAGR_Rebuild => default aggressiveness for execution of Rebuild
gvsqw_THtmlBegin =>  
+
gvsqw_DefAGE_Rebuild => default aggressiveness for check end of Rebuild
gvsqw_THtmlEnd =>  
+
gvsqw_CluRatioMinTable => Min cluster ratio of table to make rebuild table
gvsqw_THtmlPreEnd =>  
+
gvsqw_CluRatioMinIndex => Min cluster ratio of index to make rebuild index
gvsqw_THtmlPre =>  
+
gvsqw_DefSizeMinTable => Min table size in Meg to take into accompte
gvsqw_THtmlTdBegin1 =>  
+
 
gvsqw_THtmlTdBegin2 =>  
+
#for update stats script old fashion (update statistics table)
gvsqw_THtmlTdEnd =>  
+
gvsqw_NbThreadStatistics => default number of thread for parallelism for
gvsqw_THtmlTdInter =>  
+
gvsqw_DefAGR_Statistics => default aggressiveness for execution of Statistics
gvsqw_THtmlThBegin =>  
+
gvsqw_DefAGE_Statistics => default aggressiveness for check end of Statistics
gvsqw_THtmlThEnd =>  
+
gvsqw_DefSizeMaxTableStatistics => Max table size in Meg to take into accompte
gvsqw_THtmlThInter =>  
+
 
gvsqw_TraceJobDb =>  
+
#for new update stats script (for >=v15 : update index statistics table)
gvsqw_WebDbaURL =>  
+
gvsqw_NbThreadUpdtStats => default number of thread for parallelism for UpdtStats
#gvsqw_WebDbaUserConn =>  
+
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