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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
(One intermediate revision by the same user not shown)
Line 4: Line 4:
 
#General variables
 
#General variables
 
gvsqw_SqwVersion => SQWare Production version
 
gvsqw_SqwVersion => SQWare Production version
−
gvsqw_ConnectDb => if connection to db evalable then Enable else Disable
 
−
gvsqw_Hostname => Hostname for prompt and trace
 
−
gvsqw_GlobalMsgMail => Begining of email subject
 
−
gvsqw_GlobalMail => email adress, put NoNail in gvsqw_GlobalMail 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_SaUser => User with sa role
 
gvsqw_PasswdFile => Password file path
 
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_SuppAlert => number of days to delete archives of alert files
 
gvsqw_BackupServer => method to find backup server name
 
gvsqw_BackupServer => method to find backup server name
Line 29: Line 18:
 
gvsqw_NbThread => default number of thread for parallelism
 
gvsqw_NbThread => default number of thread for parallelism
 
gvsqw_ExcludeDatabases => Databases to exclude of 'AllDatabases' jobs
 
gvsqw_ExcludeDatabases => Databases to exclude of 'AllDatabases' jobs
−
gvsqw_SshOptions => ssh default options
 
−
gvsqw_ScpOptions => scp default options
 
  
−
#Html tags
+
#for indicators
−
gvsqw_CHtmlError => font tag for error
+
gvsqw_DbAlias => Database Alias
−
gvsqw_CHtmlOk => font tag for OK
+
gvsqw_DistGlobalInterfacesFile => XXXXX
−
gvsqw_CHtmlInfo => font tag for info
+
gvsqw_GenExcludeDatabasesObjects => XXXXX
−
gvsqw_CHtmlEnd => end font tag
+
gvsqw_GenExcludeDatabasesObjectsExtra => XXXXX
−
gvsqw_THtmlBegin => table tag
+
gvsqw_StringReplaceSch => XXXXX
−
gvsqw_THtmlEnd => end table tag
+
 
−
gvsqw_THtmlThBegin => th tag
 
−
gvsqw_THtmlThEnd => end th tag
 
−
gvsqw_THtmlThInter => inter th tag
 
−
gvsqw_THtmlTdBegin1 => td tag sqwnc
 
−
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
 
##Globaly forcing return code for scripts
 
gvsqw_ForcedReturnCodeScript_sqwsyb_DumpAllDatabases => To force return code of sqwsyb_DumpAllDatabases.ksh
 
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 SQWare Repository
 
  
 
#for kill
 
#for kill
Line 77: Line 51:
 
gvsqw_CluRatioMinIndex => Min cluster ratio of index to make Rebuild index
 
gvsqw_CluRatioMinIndex => Min cluster ratio of index to make Rebuild index
 
gvsqw_DefSizeMinTable => Min table size in Meg to take into accompte
 
gvsqw_DefSizeMinTable => Min table size in Meg to take into accompte
 +
gvsqw_DefSizeMaxTableRebuild => Max table size in Meg to take into accompte
  
−
#for update statisticss script old fashion (update statisticsistics table)
+
#for update statisticss script old fashion (update statistics table)
 
gvsqw_NbThreadStatistics => default number of thread for parallelism for  
 
gvsqw_NbThreadStatistics => default number of thread for parallelism for  
 
gvsqw_DefAGR_Statistics => default aggressiveness for execution of Statistics
 
gvsqw_DefAGR_Statistics => default aggressiveness for execution of Statistics
Line 91: Line 66:
 
gvsqw_StatsSampleSizeMaxMo => Max data size in Meg to read for dynamic sampling compute
 
gvsqw_StatsSampleSizeMaxMo => Max data size in Meg to read for dynamic sampling compute
 
gvsqw_StatsSamplePctMini => Min sample size
 
gvsqw_StatsSamplePctMini => Min sample size
 +
gvsqw_DefSizeMaxTableUpdtStats => XXXXX
 +
gvsqw_DefUpdtStatsType => XXXXX
 +
gvsqw_MinPctChange => XXXXX
 +
gvsqw_WithHashing => XXXXX
 +
gvsqw_HashSize => XXXXX
  
 
#for Dump script
 
#for Dump script
Line 103: Line 83:
 
gvsqw_DefCompRate => default rate of compression
 
gvsqw_DefCompRate => default rate of compression
 
gvsqw_DefDumpNbGeneration => default number generation of backup to keep online
 
gvsqw_DefDumpNbGeneration => default number generation of backup to keep online
−
gvsqw_NbThreadScp => default number of thread for parallelism for copy Dump files
+
gvsqw_DumpSyntaxType => XXXXX
 +
gvsqw_DumpSyslogins => XXXXX
 +
gvsqw_DumpTruncMasterLog => XXXXX
 +
 
 +
#for copy Dump scripts
 
gvsqw_DefAGR_Scp => default aggressiveness for execution of copy
 
gvsqw_DefAGR_Scp => default aggressiveness for execution of copy
 
gvsqw_DefAGE_Scp => default aggressiveness for check end of copy
 
gvsqw_DefAGE_Scp => default aggressiveness for check end of copy
 +
gvsqw_NbThreadCopyDump => XXXXX
 +
gvsqw_DefAGR_CopyDump => XXXXX
 +
gvsqw_DefAGE_CopyDump => XXXXX
 +
gvsqw_NbThreadScp => default number of thread for parallelism for copy Dump files
 +
gvsqw_ExcludeDatabasesCopy => XXXXX
  
 
#for Load script
 
#for Load script
 
gvsqw_RsyncGap => default gap when resync syslogins/sysusers
 
gvsqw_RsyncGap => default gap when resync syslogins/sysusers
 +
gvsqw_ExcludeDatabasesLoad => XXXXX
 +
gvsqw_DefAGR_Load => XXXXX
 +
gvsqw_DefAGE_Load => XXXXX
 +
gvsqw_NbThreadLoad => XXXXX
  
 
#for SQWare Web
 
#for SQWare Web
−
gvsqw_WebDbaURL => SQWare Web URL
 
 
gvsqw_WebDbaUserConn => Connection string ssh user@hostname to SQWare Web
 
gvsqw_WebDbaUserConn => Connection string ssh user@hostname to SQWare Web
 
</pre>
 
</pre>

Latest revision as of 16:12, 7 April 2024


Variables explanation: 

#General variables
gvsqw_SqwVersion => SQWare Production version
gvsqw_SaUser => User with sa role
gvsqw_PasswdFile => Password file path
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' jobs

#for indicators
gvsqw_DbAlias => Database Alias
gvsqw_DistGlobalInterfacesFile => XXXXX
gvsqw_GenExcludeDatabasesObjects => XXXXX
gvsqw_GenExcludeDatabasesObjectsExtra => XXXXX
gvsqw_StringReplaceSch => XXXXX


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

#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
gvsqw_DefSizeMaxTableRebuild => Max table size in Meg to take into accompte

#for update statisticss 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 statisticss 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
gvsqw_DefSizeMaxTableUpdtStats => XXXXX
gvsqw_DefUpdtStatsType => XXXXX
gvsqw_MinPctChange => XXXXX
gvsqw_WithHashing => XXXXX
gvsqw_HashSize => XXXXX

#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_DumpSyntaxType => XXXXX
gvsqw_DumpSyslogins => XXXXX
gvsqw_DumpTruncMasterLog => XXXXX

#for copy Dump scripts
gvsqw_DefAGR_Scp => default aggressiveness for execution of copy
gvsqw_DefAGE_Scp => default aggressiveness for check end of copy
gvsqw_NbThreadCopyDump => XXXXX
gvsqw_DefAGR_CopyDump => XXXXX
gvsqw_DefAGE_CopyDump => XXXXX
gvsqw_NbThreadScp => default number of thread for parallelism for copy Dump files
gvsqw_ExcludeDatabasesCopy => XXXXX

#for Load script
gvsqw_RsyncGap => default gap when resync syslogins/sysusers
gvsqw_ExcludeDatabasesLoad => XXXXX
gvsqw_DefAGR_Load => XXXXX
gvsqw_DefAGE_Load => XXXXX
gvsqw_NbThreadLoad => XXXXX

#for SQWare Web
gvsqw_WebDbaUserConn => Connection string ssh user@hostname to SQWare Web
Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwsyb_GlobalVar.cfg_explanation&oldid=27182"