SQWareProduction:ingres:etc:sqwing GlobalVar.cfg: Difference between revisions
Jump to navigation
Jump to search
m Updated by Expdbtools |
m Updated by Expdbtools |
||
Line 5: | Line 5: | ||
File content: | File content: | ||
<pre> | <pre> | ||
export gvsqw_EdtVersion=1.2.10 | |||
export gvsqw_EdtVersion=1.2. | |||
export gvsqw_ConnectDb=Enable | export gvsqw_ConnectDb=Enable | ||
export gvsqw_UserDbaSql=ingres | export gvsqw_UserDbaSql=ingres | ||
export gvsqw_Hostname=$(hostname|cut -d '.' -f1) | export gvsqw_Hostname=$(hostname|cut -d '.' -f1) | ||
export gvsqw_MailMsg_ingres='TrtIngAuto' | export gvsqw_MailMsg_ingres='TrtIngAuto' | ||
export gvsqw_Mail_ingres='dba' | export gvsqw_Mail_ingres='dba' | ||
export gvsqw_SendmailHtmlFormat=enable | export gvsqw_SendmailHtmlFormat=enable | ||
export gvsqw_PreFormatHtlml=enable | export gvsqw_PreFormatHtlml=enable | ||
export gvsqw_Colors=enable | export gvsqw_Colors=enable | ||
export gvsqw_TraceJobDb=enable | export gvsqw_TraceJobDb=enable | ||
export gvsqw_EgrepIvFs='Filesystem|Disponible' | export gvsqw_EgrepIvFs='Filesystem|Disponible' | ||
Line 61: | Line 30: | ||
export gvsqw_SshOptions="-q -o BatchMode=yes -o StrictHostKeyChecking=no" | export gvsqw_SshOptions="-q -o BatchMode=yes -o StrictHostKeyChecking=no" | ||
export gvsqw_ScpOptions="-o BatchMode=yes -o StrictHostKeyChecking=no" | export gvsqw_ScpOptions="-o BatchMode=yes -o StrictHostKeyChecking=no" | ||
export gvsqw_RootJnl='$(ingprenv "II_JOURNAL")/ingres/jnl/default' | export gvsqw_RootJnl='$(ingprenv "II_JOURNAL")/ingres/jnl/default' | ||
export gvsqw_RootCkpdb='$(ingprenv "II_CHECKPOINT")/ingres/ckp/default' | export gvsqw_RootCkpdb='$(ingprenv "II_CHECKPOINT")/ingres/ckp/default' | ||
Line 68: | Line 35: | ||
export gvsqw_CkpdbNbGeneration=2 | export gvsqw_CkpdbNbGeneration=2 | ||
export gvsqw_NbThreadCkpdb=2 | export gvsqw_NbThreadCkpdb=2 | ||
export gvsqw_RootDump='/$(echo ${HOME}|cut -d/ -f2)/ing_dump/$INGRES_SID' | export gvsqw_RootDump='/$(echo ${HOME}|cut -d/ -f2)/ing_dump/$INGRES_SID' | ||
export gvsqw_NbThreadExportFull=2 | export gvsqw_NbThreadExportFull=2 | ||
export gvsqw_RootDumpSource='/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/ing_dump/${lvsqw_InstanceSource}' | |||
export gvsqw_NbThreadDbRefresh=2 | |||
export gvsqw_DumpNbGeneration=2 | export gvsqw_DumpNbGeneration=2 | ||
export gvsqw_NbDaysFull=7 | export gvsqw_NbDaysFull=7 | ||
export gvsqw_CHtmlError='<font color="#FF0000">' | export gvsqw_CHtmlError='<font color="#FF0000">' | ||
export gvsqw_CHtmlOk='<font color="#00FF00">' | export gvsqw_CHtmlOk='<font color="#00FF00">' | ||
Line 94: | Line 57: | ||
export gvsqw_THtmlPreEnd="</pre>" | export gvsqw_THtmlPreEnd="</pre>" | ||
export gvsqw_HtmlCss="<html><head> | export gvsqw_HtmlCss="<html><head> | ||
export gvsqw_WebDbaURL="http://webdba" | export gvsqw_WebDbaURL="http://webdba" | ||
#export gvsqw_WebDbaUserConn='Connection string ssh user@hostname' | #export gvsqw_WebDbaUserConn='Connection string ssh user@hostname' | ||
#export gvsqw_WebDbaDirSlowQuery='Directory to store SlowQuery files' | #export gvsqw_WebDbaDirSlowQuery='Directory to store SlowQuery files' | ||
</pre> | </pre> | ||
<br> | <br> | ||
Line 130: | Line 65: | ||
Variable explanation: | Variable explanation: | ||
<pre> | <pre> | ||
gvsqw_CHtmlEnd => | |||
gvsqw_CHtmlError => | |||
gvsqw_CHtmlInfo => | |||
gvsqw_CHtmlOk => | |||
gvsqw_CkpdbNbGeneration => | |||
gvsqw_Colors => | |||
gvsqw_ConnectDb => | |||
gvsqw_DumpNbGeneration => | |||
gvsqw_EdtVersion => | |||
gvsqw_EgrepIvFs => | |||
gvsqw_GzipLogsHisto => | |||
gvsqw_Hostname => | |||
gvsqw_HtmlCss => | |||
gvsqw_IngresErrorMsg => | |||
gvsqw_Mail_ingres => | |||
gvsqw_MailMsg_ingres => | |||
gvsqw_MysqlErrorMsg => | |||
gvsqw_NbDaysFull => | |||
gvsqw_NbThread => | |||
gvsqw_NbThreadAnalyze => | |||
gvsqw_NbThreadCkpdb => | |||
gvsqw_NbThreadDbRefresh => | |||
gvsqw_NbThreadExportFull => | |||
gvsqw_NbThreadOptimize => | |||
gvsqw_PreFormatHtlml => | |||
gvsqw_RootAdmin => | |||
gvsqw_RootBck => | |||
gvsqw_RootCfg => | |||
gvsqw_RootCkpdb => | |||
gvsqw_RootDbf => | |||
gvsqw_RootDump => | |||
gvsqw_RootDumpSource => | |||
gvsqw_RootJnl => | |||
gvsqw_ScpOptions => | |||
gvsqw_SendmailHtmlFormat => | |||
gvsqw_SshOptions => | |||
gvsqw_SuppArchAlert => | |||
gvsqw_SuppArchSlow => | |||
gvsqw_SuppLogsHisto => | |||
gvsqw_THtmlBegin => | |||
gvsqw_THtmlEnd => | |||
gvsqw_THtmlPreEnd => | |||
gvsqw_THtmlPre => | |||
gvsqw_THtmlTdBegin1 => | |||
gvsqw_THtmlTdBegin2 => | |||
gvsqw_THtmlTdEnd => | |||
gvsqw_THtmlTdInter => | |||
gvsqw_THtmlThBegin => | |||
gvsqw_THtmlThEnd => | |||
gvsqw_THtmlThInter => | |||
# gvsqw_WebDbaDirSlowQuery= | gvsqw_TraceJobDb => | ||
gvsqw_UserDbaSql => | |||
# gvsqw_WebDbaUserConn= | #gvsqw_WebDbaDirSlowQuery => | ||
gvsqw_WebDbaURL => | |||
#gvsqw_WebDbaUserConn => | |||
</pre> | </pre> | ||
{{SQWareProductionSurchargeVar|ingres|Ing|sqwing_GlobalVar.cfg}} | {{SQWareProductionSurchargeVar|ingres|Ing|sqwing_GlobalVar.cfg}} | ||
<br> | <br> |
Revision as of 00:38, 23 December 2010
Configuration file $gvsqw_IngBin/../etc/sqwing_GlobalVar.cfg:
Global var for Ingres
It contains the operating variables of SQWareProduction.
File content:
export gvsqw_EdtVersion=1.2.10 export gvsqw_ConnectDb=Enable export gvsqw_UserDbaSql=ingres export gvsqw_Hostname=$(hostname|cut -d '.' -f1) export gvsqw_MailMsg_ingres='TrtIngAuto' export gvsqw_Mail_ingres='dba' export gvsqw_SendmailHtmlFormat=enable export gvsqw_PreFormatHtlml=enable export gvsqw_Colors=enable export gvsqw_TraceJobDb=enable export gvsqw_EgrepIvFs='Filesystem|Disponible' export gvsqw_SuppLogsHisto=30 export gvsqw_GzipLogsHisto=7 export gvsqw_SuppArchAlert=30 export gvsqw_SuppArchSlow=30 export gvsqw_RootAdmin='$HOME/${INGRES_SID}' export gvsqw_RootCfg='$HOME/${INGRES_SID}/edtConfig' export gvsqw_RootDbf='$(ingprenv "II_DATABASE")/ingres/data/default' export gvsqw_NbThread=2 export gvsqw_NbThreadOptimize=2 export gvsqw_NbThreadAnalyze=2 export gvsqw_MysqlErrorMsg="^ERROR|^FAILED" export gvsqw_IngresErrorMsg="^E_[0-9A-Z][0-9A-Z][0-9A-Z][0-9A-Z][0-9A-Z][0-9A-Z]" export gvsqw_SshOptions="-q -o BatchMode=yes -o StrictHostKeyChecking=no" export gvsqw_ScpOptions="-o BatchMode=yes -o StrictHostKeyChecking=no" export gvsqw_RootJnl='$(ingprenv "II_JOURNAL")/ingres/jnl/default' export gvsqw_RootCkpdb='$(ingprenv "II_CHECKPOINT")/ingres/ckp/default' export gvsqw_RootBck='$(ingprenv "II_CHECKPOINT")/bck' export gvsqw_CkpdbNbGeneration=2 export gvsqw_NbThreadCkpdb=2 export gvsqw_RootDump='/$(echo ${HOME}|cut -d/ -f2)/ing_dump/$INGRES_SID' export gvsqw_NbThreadExportFull=2 export gvsqw_RootDumpSource='/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/ing_dump/${lvsqw_InstanceSource}' export gvsqw_NbThreadDbRefresh=2 export gvsqw_DumpNbGeneration=2 export gvsqw_NbDaysFull=7 export gvsqw_CHtmlError='<font color="#FF0000">' export gvsqw_CHtmlOk='<font color="#00FF00">' export gvsqw_CHtmlInfo='<font color="#0000FF">' export gvsqw_CHtmlEnd='</font>' export gvsqw_THtmlBegin='<table class="edt">' export gvsqw_THtmlEnd='</table>' export gvsqw_THtmlThBegin='<tr class="edtth"><th>' export gvsqw_THtmlThEnd='</th></tr>' export gvsqw_THtmlThInter='</th><th>' export gvsqw_THtmlTdBegin1='<tr class="edtnc"><td>' export gvsqw_THtmlTdBegin2='<tr class="sqwc_"><td>' export gvsqw_THtmlTdEnd='</td></tr>' export gvsqw_THtmlTdInter='</td><td>' export gvsqw_THtmlPre="<pre class='edt'>" export gvsqw_THtmlPreEnd="
"
export gvsqw_HtmlCss="<html><head> export gvsqw_WebDbaURL="http://webdba"
- export gvsqw_WebDbaUserConn='Connection string ssh user@hostname'
- export gvsqw_WebDbaDirSlowQuery='Directory to store SlowQuery files'
Variable explanation:
gvsqw_CHtmlEnd => gvsqw_CHtmlError => gvsqw_CHtmlInfo => gvsqw_CHtmlOk => gvsqw_CkpdbNbGeneration => gvsqw_Colors => gvsqw_ConnectDb => gvsqw_DumpNbGeneration => gvsqw_EdtVersion => gvsqw_EgrepIvFs => gvsqw_GzipLogsHisto => gvsqw_Hostname => gvsqw_HtmlCss => gvsqw_IngresErrorMsg => gvsqw_Mail_ingres => gvsqw_MailMsg_ingres => gvsqw_MysqlErrorMsg => gvsqw_NbDaysFull => gvsqw_NbThread => gvsqw_NbThreadAnalyze => gvsqw_NbThreadCkpdb => gvsqw_NbThreadDbRefresh => gvsqw_NbThreadExportFull => gvsqw_NbThreadOptimize => gvsqw_PreFormatHtlml => gvsqw_RootAdmin => gvsqw_RootBck => gvsqw_RootCfg => gvsqw_RootCkpdb => gvsqw_RootDbf => gvsqw_RootDump => gvsqw_RootDumpSource => gvsqw_RootJnl => gvsqw_ScpOptions => gvsqw_SendmailHtmlFormat => gvsqw_SshOptions => gvsqw_SuppArchAlert => gvsqw_SuppArchSlow => gvsqw_SuppLogsHisto => gvsqw_THtmlBegin => gvsqw_THtmlEnd => gvsqw_THtmlPreEnd => gvsqw_THtmlPre => gvsqw_THtmlTdBegin1 => gvsqw_THtmlTdBegin2 => gvsqw_THtmlTdEnd => gvsqw_THtmlTdInter => gvsqw_THtmlThBegin => gvsqw_THtmlThEnd => gvsqw_THtmlThInter => gvsqw_TraceJobDb => gvsqw_UserDbaSql => #gvsqw_WebDbaDirSlowQuery => gvsqw_WebDbaURL => #gvsqw_WebDbaUserConn =>