SQWareProduction:generic:etc:sqwgen GlobalVar.cfg : Différence entre versions
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Ligne 1 : | Ligne 1 : | ||
− | + | Configuration file $gvsqw_GenBin/../etc/sqwgen_GlobalVar.cfg:<br> | |
{{SQWareProduction_sqwgen_GlobalVar.cfg_presentation}} | {{SQWareProduction_sqwgen_GlobalVar.cfg_presentation}} | ||
− | + | {{SQWareProduction_sqwgen_GlobalVar.cfg_content}} | |
− | + | {{SQWareProduction_sqwgen_GlobalVar.cfg_explanation}} | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
{{SQWareProductionSurchargeVar|generic|Gen|sqwgen_GlobalVar.cfg}} | {{SQWareProductionSurchargeVar|generic|Gen|sqwgen_GlobalVar.cfg}} | ||
<br> | <br> |
Version du 23 juin 2019 à 20:28
Configuration file $gvsqw_GenBin/../etc/sqwgen_GlobalVar.cfg:
Generic global var
Contient les variables operationnelles de SQWareProduction.
Contenu du fichier:
#!/bin/ksh ################################################################### # SQWareProduction Generic module of dbSQWare # # dbSQWare is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # CGU/CGA for more details. # # You should have received a copy of the CGU/CGA # along with this program. If not, see <http://www.dbsqware.com/licenses/>. # # For information : contact@dbsqware.com or www.dbsqware.com ################################################################### ## @Synopsis Generic global var ## @Copyright Copyright 2010-2024, dbSQWare (www.dbsqware.com) if [ "$gvsqw_Debug" != "" ] then echo $gvsqw_EchoOpt "RdbmsName = $gvsqw_RdbmsName" echo $gvsqw_EchoOpt "RdbmsType = $gvsqw_RdbmsType" echo $gvsqw_EchoOpt "RdbmsTrigram = $gvsqw_RdbmsTrigram" echo $gvsqw_EchoOpt "RdbmsRoot = $gvsqw_RdbmsRoot" echo $gvsqw_EchoOpt "sourcing cfg file : .../SQWareProduction/generic/etc/sqwgen_GlobalVar.cfg" fi #global export gvsqw_SqwVersion=2024.06 if [ -w /var/tmp ] then export gvsqw_GlobalTmpDir='/var/tmp' else export gvsqw_GlobalTmpDir='/tmp' fi #export LANG='en_US.UTF-8' #Force a case for instance name parameter, put UpperCase or LowerCase or NoCase export gvsqw_InstanceNameForceCase='UpperCase' #export gvsqw_Locale='en' change default Locale (en,fr) export gvsqw_DistPasswdFile="$HOME/.passwd_$gvsqw_RdbmsType" export gvsqw_SslCipher="-aes-256-cbc" export gvsqw_SslPassFile="$HOME/sqwConfig/.ssl" export gvsqw_GlobalMsgMail="Trt${gvsqw_RdbmsTrigram}Auto${gvsqw_Env}" #To force mail sender, ex : gvsqw_MailSender='toto@mydomain.com' or gvsqw_MailSender=`id| cut -d')' -f1| cut -d'(' -f2`'@'`hostname -f` export gvsqw_MailSender='' #Force a case for mail subject, put UpperCase or LowerCase or NoCase, to avoid quarantine (like rule ODD_CASE of spamassassin) export gvsqw_MailSubjetForceCase='NoCase' export gvsqw_UserExec=`id| cut -d')' -f1| cut -d'(' -f2` export gvsqw_ConnectDb=Enable export gvsqw_Hostname=$(hostname|cut -d '.' -f1) #Put NoNail in gvsqw_GlobalMail if you don't want to send mail on error export gvsqw_GlobalMail='default@dbsqware.com' #Put disable in gvsqw_SendmailHtmlFormat if you don't want to send mail in html format export gvsqw_SendmailHtmlFormat=enable export gvsqw_PreFormatHtlml=enable #Put disable in gvsqw_Colors if you don't want to print in color export gvsqw_Colors=enable #Put disable in gvsqw_TraceJobDb if you don't want to trace job execution in SQWareRepository export gvsqw_TraceJobDb=enable #Put disable in gvsqw_UpLoadLogFile if you don't want to upLoad log of job execution in SQWareRepository export gvsqw_UpLoadLogFile=enable #Put disable in gvsqw_TraceBackup if you don't want to backup execution in SQWareRepository export gvsqw_TraceBackup=enable export gvsqw_UpLoadLogFileMaxLine=200 export gvsqw_UpLoadMailFileMaxLine=400 export gvsqw_SendMailFileMaxLine=2000 export gvsqw_EgrepIvFs='Filesystem|Disponible' export gvsqw_SuppLogsHisto=30 export gvsqw_GzipLogsHisto=3 export gvsqw_SuppBckCfg=30 export gvsqw_SuppArchAlert=30 export gvsqw_SuppTapeFilesLists=5 export gvsqw_InitInstanceSourceCommand='. ~/.profile' export gvsqw_NbThread=2 export gvsqw_MysqlErrorMsg="ERROR |FAILED |ERREUR |ECHEC | ERROR:| FAILED:| ERREUR:| ECHEC:|Couldn.t execute |unknown option | doesn.t exist" export gvsqw_SshOptions="-q -o BatchMode=yes -o StrictHostKeyChecking=no" export gvsqw_SshOptionsNoQuiet="-o BatchMode=yes -o StrictHostKeyChecking=no" export gvsqw_SshOptionsInteractive="-o StrictHostKeyChecking=no -o ServerAliveInterval=60 -o ServerAliveCountMax=10" export gvsqw_ScpOptions="-o BatchMode=yes -o StrictHostKeyChecking=no" export gvsqw_RsyncOptions="ssh -o BatchMode=yes -o StrictHostKeyChecking=no" export gvsqw_DisplayNumberBlank=" 0" export gvsqw_LockFileWaitTimeOut=3600 #Put enable for full display log in sqw*_RunJob.ksh scripts export gvsqw_RunJobFullOutput=disable #Html tags export gvsqw_CHtmlH1='<br/><h1 style="font-size:18px; font-family:Helvetica,Geneva,sans-serif,Courier,Arial; color:#f6761f; background-color:white; border-bottom:1px solid #fec060;">' export gvsqw_CHtmlH2='<br/><h2 style="font-size:16px; font-family:Comic Sans MS,Cursive,Helvetica,Sans-Serif,Arial; color:#424666; background-color:white; text-decoration:underline; margin-left: 10px;">' export gvsqw_CHtmlH3='<h3 style="font-size:14px; font-family:Courier,Helvetica,Sans-Serif,Arial; color:#424666; background-color:white; text-decoration:underline; margin-left: 20px;">' export gvsqw_CHtmlError='<font color="#FF0000">' export gvsqw_CHtmlOk='<font color="#27d827">' export gvsqw_CHtmlInfo='<font color="#0000FF">' export gvsqw_CHtmlNotFound='<font color="#9d00ff">' export gvsqw_CHtmlWarning='<font color="#ff9100">' export gvsqw_CHtmlEnd='</font>' #export gvsqw_THtmlBegin='<table cellpadding="5px;" rules="all" style="font-size:12px; font-family:Verdana,Helvetica,Sans-Serif,Arial; color:#424666; margin-left: 50px; border:solid 1px #424666;">' export gvsqw_THtmlBegin='<table cellpadding="5px;" rules="all" style="font-size:12px; font-family:Verdana,Helvetica,Sans-Serif,Arial; color:#424666; margin-left: 50px;">' export gvsqw_THtmlEnd='</table>' export gvsqw_THtmlThBegin='<tr style="font-weight:normal; font-style:italic; background-color:#afafaf; text-align:left; white-space:nowrap; color:#fff;"><th>' export gvsqw_THtmlThEnd='</th></tr>' export gvsqw_THtmlThInter='</th><th>' export gvsqw_THtmlTdBegin1='<tr style="background-color:white; vertical-align:top;"><td style="white-space:nowrap; border-color: #424666;">' export gvsqw_THtmlTdBegin2='<tr style="background-color:#f5f5f5; vertical-align:top;"><td style="white-space:nowrap; border-color: #424666;">' export gvsqw_THtmlTdEnd='</td></tr>' export gvsqw_THtmlTdInter='</td><td style="white-space:nowrap; border-color: #424666;">' export gvsqw_THtmlTdInterRight='</td><td style="text-align:right; white-space:nowrap; border-color: #424666;">' export gvsqw_THtmlUl='<ul style="font-size:14px; font-family:Helvetica,Geneva,sans-serif,Courier,Arial; color:black; background-color:white;">' export gvsqw_THtmlUlEnd="</ul>" export gvsqw_THtmlPre='pre style="font-size:12px; font-family:Consolas,Sans-Serif,Arial; background-color:white; color:#424666;">' export gvsqw_THtmlPreFooter='pre style="font-size:10px; font-family:Helvetica,Sans-Serif,Arial; color:#f6761f; background-color:white;">' export gvsqw_THtmlPreEnd="/pre>" export gvsqw_THtmlABegin='<a style="color:#424666;"' export gvsqw_THtmlABeginFooter='<a style="color:#979797;"' export gvsqw_HtmlCss='<html><body style="font-size:12px; font-family:Verdana, Helvetica,Sans-Serif,Arial; color:#424666; background-color:white;">' ##################################################### ##For indicators export gvsqw_SizeMinTableIndicators=10 #For NetBackup script export gvsqw_NetBackupPath='/usr/openv/netbackup' #For Rsync script export gvsqw_RsyncDefaultSourceDir='ToBeDefine' export gvsqw_RsyncDefaultTargetDir='ToBeDefine' export gvsqw_RsyncDefaultUser='$gvsqw_UserExec@RsyncHost' export gvsqw_RsyncWaitTimeOut=3600 ##Globaly forcing return code for scripts #export gvsqw_ForcedReturnCodeScript_sqwmys_DumpDatabase=0 #for webdba export gvsqw_WebDbaURL="http://webdba" export gvsqw_WebDbaUser='dbsqware@SQWareWebHost' #export gvsqw_WebDbaDirSlowQuery='Directory to store SlowQuery files' #export gvsqw_WebDbaDirAwr='Directory to store AWR reports' ################################################################################################### ################################################################################################### # Source generic custom eval lvsqw_Tmp="\$gvsqw_${gvsqw_RdbmsTrigram}Bin" if [ -r $gvsqw_GenPath/../../generic/etc_cust/sqwgen_GlobalVar.cfg ] then if [ "$gvsqw_Debug" != "" ] then echo $gvsqw_EchoOpt "sourcing cfg file : $gvsqw_GenPath/../../generic/etc_cust/sqwgen_GlobalVar.cfg" fi . $gvsqw_GenPath/../../generic/etc_cust/sqwgen_GlobalVar.cfg elif [ -r $lvsqw_Tmp/../../generic/etc_cust/sqwgen_GlobalVar.cfg ] then if [ "$gvsqw_Debug" != "" ] then echo $gvsqw_EchoOpt "sourcing cfg file : $lvsqw_Tmp/../../generic/etc_cust/sqwgen_GlobalVar.cfg" fi . $lvsqw_Tmp/../../generic/etc_cust/sqwgen_GlobalVar.cfg fi # For not normed environnement if [ -r $HOME/sqwConfig/sqwgen_GlobalVar.cfg ] then if [ "$gvsqw_Debug" != "" ] then echo $gvsqw_EchoOpt "sourcing cfg file : $HOME/sqwConfig/sqwgen_GlobalVar.cfg" fi . $HOME/sqwConfig/sqwgen_GlobalVar.cfg fi if [ "$gvsqw_RdbmsType" != "generic" ] then # Source rdbms global if [ -r $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg ] then if [ "$gvsqw_Debug" != "" ] then echo $gvsqw_EchoOpt "sourcing cfg file : $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg" fi . $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg elif [ -r $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg ] then if [ "$gvsqw_Debug" != "" ] then echo $gvsqw_EchoOpt "sourcing cfg file : $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg" fi . $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg fi # Source rdbms custom if [ -r $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg ] then if [ "$gvsqw_Debug" != "" ] then echo $gvsqw_EchoOpt "sourcing cfg file : $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg" fi . $gvsqw_GenPath/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg elif [ -r $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg ] then if [ "$gvsqw_Debug" != "" ] then echo $gvsqw_EchoOpt "sourcing cfg file : $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg" fi . $lvsqw_Tmp/../../$gvsqw_RdbmsType/etc_cust/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg fi # For not normed environnement if [ -r $HOME/sqwConfig/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg ] then if [ "$gvsqw_Debug" != "" ] then echo $gvsqw_EchoOpt "sourcing cfg file : $HOME/sqwConfig/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg" fi . $HOME/sqwConfig/sqw${gvsqw_RdbmsRoot}_GlobalVar.cfg fi fi
Explication de variables:
#General variables gvsqw_InstanceNameForceCase => Force a case for instance name parameter, put UpperCase or LowerCase or NoCase 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_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_SuppArchAlert => number of days to delete archives of alert files gvsqw_SuppBckCfg => number of days to delete archives of init and control files gvsqw_RootAdmin => admin directory gvsqw_RootCfg => configuration directory gvsqw_RootDbf => datafiles directory gvsqw_NbThread => default number of thread for parallelism gvsqw_SshOptions => ssh default options gvsqw_ScpOptions => scp default options gvsqw_MailSender => to force the sender of the mail gvsqw_MailSubjetForceCase => Force a case for mail subject, put UpperCase or LowerCase or NoCase, to avoid quarantine (like rule ODD_CASE of spamassassin) gvsqw_RunJobFullOutput => for full display log in sqw*_RunJob.ksh scripts #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 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 #for SQWare Web gvsqw_WebDbaURL => SQWareWeb URL gvsqw_WebDbaUser => Connection string ssh user@hostname to SQWareWeb gvsqw_WebDbaDirAwr => Directory to store AWR reports on SQWareWeb