SQWareProduction:ingres:etc:sqwing GlobalVar.cfg: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
m Updated by BatchUser
m Updated by BatchUser
Line 1: Line 1:
Configuration file $gvsqw_IngBin/../etc/sqwing_GlobalVar.cfg:<br>
Configuration file $gvsqw_IngBin/../etc/sqwing_GlobalVar.cfg:<br>
{{SQWareProduction_sqwing_GlobalVar.cfg_presentation}}
{{SQWareProduction_sqwing_GlobalVar.cfg_presentation}}
{{SQWareProduction_sqwing_GlobalVar.cfg_content}}
<br>
{{SQWareProduction_sqwing_GlobalVar.cfg_explanation}}
<br>
File content:
<pre>
export gvsqw_SqwVersionDbms=2023.08
export gvsqw_UserDbaSql=ingres
export gvsqw_RootAdmin='$HOME/${INGRES_SID}'
export gvsqw_RootAdminDisable='$HOME'
export gvsqw_RootCfg='$HOME/${INGRES_SID}/sqwConfig'
export gvsqw_RootDbf='$(ingprenv "II_DATABASE")/ingres/data/default'
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_DbAlias='$INGRES_SID'
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
</pre>
<br>
<br>
Variables explanation:
<pre>
gvsqw_CkpdbNbGeneration =>
gvsqw_DbAlias =>
gvsqw_DumpNbGeneration =>
gvsqw_IngresErrorMsg =>
gvsqw_MysqlErrorMsg =>
gvsqw_NbThreadCkpdb =>
gvsqw_NbThreadDbRefresh =>
gvsqw_NbThreadExportFull =>
gvsqw_RootAdmin =>
gvsqw_RootAdminDisable =>
gvsqw_RootBck =>
gvsqw_RootCfg =>
gvsqw_RootCkpdb =>
gvsqw_RootDbf =>
gvsqw_RootDump =>
gvsqw_RootDumpSource =>
gvsqw_RootJnl =>
gvsqw_SqwVersionDbms =>
gvsqw_UserDbaSql =>
</pre>
{{SQWareProductionSurchargeVar|ingres|Ing|sqwing_GlobalVar.cfg}}
{{SQWareProductionSurchargeVar|ingres|Ing|sqwing_GlobalVar.cfg}}
<br>
<br>

Revision as of 17:57, 6 November 2023

Configuration file $gvsqw_IngBin/../etc/sqwing_GlobalVar.cfg:
Global var for Ingres
It contains the operating variables of SQWareProduction.


File content:

export gvsqw_SqwVersionDbms=2023.08
export gvsqw_UserDbaSql=ingres
export gvsqw_RootAdmin='$HOME/${INGRES_SID}'
export gvsqw_RootAdminDisable='$HOME'
export gvsqw_RootCfg='$HOME/${INGRES_SID}/sqwConfig'
export gvsqw_RootDbf='$(ingprenv "II_DATABASE")/ingres/data/default'
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_DbAlias='$INGRES_SID'
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



Variables explanation:

gvsqw_CkpdbNbGeneration => 
gvsqw_DbAlias => 
gvsqw_DumpNbGeneration => 
gvsqw_IngresErrorMsg => 
gvsqw_MysqlErrorMsg => 
gvsqw_NbThreadCkpdb => 
gvsqw_NbThreadDbRefresh => 
gvsqw_NbThreadExportFull => 
gvsqw_RootAdmin => 
gvsqw_RootAdminDisable => 
gvsqw_RootBck => 
gvsqw_RootCfg => 
gvsqw_RootCkpdb => 
gvsqw_RootDbf => 
gvsqw_RootDump => 
gvsqw_RootDumpSource => 
gvsqw_RootJnl => 
gvsqw_SqwVersionDbms => 
gvsqw_UserDbaSql => 
Note:
You can overload variables contain in $gvsqw_IngBin/../etc/sqwing_GlobalVar.cfg

by the same variables in $gvsqw_IngBin/../etc_cust/sqwing_GlobalVar.cfg for all your environnement
or in $HOME/sqwConfig/sqwing_GlobalVar.cfg specifically for this user.