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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by Expdbtools)
m (Updated by BatchUser)
(3 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
<pre>
 
<pre>
 
#General variables
 
#General variables
−
gvsqw_EdtVersion => SQWareProduction 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_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_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 28: Line 17:
 
gvsqw_ErrorLog => errorlog file name
 
gvsqw_ErrorLog => errorlog file name
 
gvsqw_NbThread => default number of thread for parallelism
 
gvsqw_NbThread => default number of thread for parallelism
−
gvsqw_ExcludeDatabases => Databases to exclude of 'AllDatabases' treatments
+
gvsqw_ExcludeDatabases => Databases to exclude of 'AllDatabases' jobs
−
gvsqw_SshOptions => ssh default options
+
 
−
gvsqw_ScpOptions => scp default options
+
#for indicators
 +
gvsqw_DbAlias => Database Alias
 +
gvsqw_DistGlobalInterfacesFile => XXXXX
 +
gvsqw_GenExcludeDatabasesObjects => XXXXX
 +
gvsqw_GenExcludeDatabasesObjectsExtra => XXXXX
 +
gvsqw_StringReplaceSch => XXXXX
  
−
#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
 
##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 SQWareRepository
 
  
 
#for kill
 
#for kill
 
gvsqw_DefNbAttempt => default number of attempt to kill sessions
 
gvsqw_DefNbAttempt => default number of attempt to kill sessions
  
−
#for dbcc script
+
#for Dbcc script
 
gvsqw_NbThreadDbcc => default number of thread for parallelism for Dbcc
 
gvsqw_NbThreadDbcc => default number of thread for parallelism for Dbcc
 
gvsqw_DefAGR_Dbcc => default aggressiveness for execution of Dbcc
 
gvsqw_DefAGR_Dbcc => default aggressiveness for execution of Dbcc
 
gvsqw_DefAGE_Dbcc => default aggressiveness for check end of Dbcc
 
gvsqw_DefAGE_Dbcc => default aggressiveness for check end of Dbcc
  
−
#for checkstorage script
+
#for Checkstorage script
 
gvsqw_NbThreadCheckstorage => default number of thread for parallelism for Checkstorage
 
gvsqw_NbThreadCheckstorage => default number of thread for parallelism for Checkstorage
 
gvsqw_DefAGR_Checkstorage => default aggressiveness for execution of Checkstorage
 
gvsqw_DefAGR_Checkstorage => default aggressiveness for execution of Checkstorage
 
gvsqw_DefAGE_Checkstorage => default aggressiveness for check end of Checkstorage
 
gvsqw_DefAGE_Checkstorage => default aggressiveness for check end of Checkstorage
  
−
#for rebuild script
+
#for Rebuild script
 
gvsqw_NbThreadRebuild => default number of thread for parallelism for Rebuild
 
gvsqw_NbThreadRebuild => default number of thread for parallelism for Rebuild
 
gvsqw_DefAGR_Rebuild => default aggressiveness for execution of Rebuild
 
gvsqw_DefAGR_Rebuild => default aggressiveness for execution of Rebuild
 
gvsqw_DefAGE_Rebuild => default aggressiveness for check end of Rebuild
 
gvsqw_DefAGE_Rebuild => default aggressiveness for check end of Rebuild
−
gvsqw_CluRatioMinTable => Min cluster ratio of table to make rebuild table
+
gvsqw_CluRatioMinTable => Min cluster ratio of table to make Rebuild table
−
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 stats script old fashion (update statistics table)
+
#for update statisticss script old fashion (update statisticsistics 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 84: Line 59:
 
gvsqw_DefSizeMaxTableStatistics => Max table size in Meg to take into accompte
 
gvsqw_DefSizeMaxTableStatistics => Max table size in Meg to take into accompte
  
−
#for new update stats script (for >=v15 : update index statistics table)
+
#for new update statisticss script (for >=v15 : update index Statistics table)
 
gvsqw_NbThreadUpdtStats => default number of thread for parallelism for UpdtStats
 
gvsqw_NbThreadUpdtStats => default number of thread for parallelism for UpdtStats
 
gvsqw_DefAGR_UpdtStats => default aggressiveness for execution of UpdtStats
 
gvsqw_DefAGR_UpdtStats => default aggressiveness for execution of UpdtStats
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
 
gvsqw_NbThreadDump => default number of thread for parallelism for Dump
 
gvsqw_NbThreadDump => default number of thread for parallelism for Dump
 
gvsqw_DefAGR_Dump => default aggressiveness for execution of Dump
 
gvsqw_DefAGR_Dump => default aggressiveness for execution of Dump
 
gvsqw_DefAGE_Dump => default aggressiveness for check end of Dump
 
gvsqw_DefAGE_Dump => default aggressiveness for check end of Dump
−
gvsqw_RootDump => default dump directory
+
gvsqw_RootDump => default Dump directory
−
gvsqw_RootDumpSource => default dump directory of source dataserver
+
gvsqw_RootDumpSource => default Dump directory of source dataserver
−
gvsqw_DefDumpType => default dump type
+
gvsqw_DefDumpType => default Dump type
 
gvsqw_DefMaxSizeStrip => default max size of stripe in Meg
 
gvsqw_DefMaxSizeStrip => default max size of stripe in Meg
 
gvsqw_DefCompLevel => default compression level
 
gvsqw_DefCompLevel => default compression level
 
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 SQWareWeb
+
#for SQWare Web
−
gvsqw_WebDbaURL => SQWareWeb URL
+
gvsqw_WebDbaUserConn => Connection string ssh user@hostname to SQWare Web
−
gvsqw_WebDbaUserConn => Connection string ssh user@hostname to SQWareWeb
 
 
</pre>
 
</pre>

Revision as of 17:30, 28 December 2021


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 statisticsistics 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=19687"