Difference between revisions of "SQWareProduction:teradata:etc:sqwter GlobalVar.cfg"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 1: Line 1:
 
Configuration file $gvsqw_TerBin/../etc/sqwter_GlobalVar.cfg:<br>
 
Configuration file $gvsqw_TerBin/../etc/sqwter_GlobalVar.cfg:<br>
 
{{SQWareProduction_sqwter_GlobalVar.cfg_presentation}}
 
{{SQWareProduction_sqwter_GlobalVar.cfg_presentation}}
{{SQWareProduction_sqwter_GlobalVar.cfg_content}}
+
<br>
{{SQWareProduction_sqwter_GlobalVar.cfg_explanation}}
+
<br>
 +
File content:
 +
<pre>
 +
export gvsqw_SqwVersionDbms=2024.07
 +
export gvsqw_PasswdFile="$HOME/.passwd"
 +
export gvsqw_RootAdmin='$HOME/${TER_SID}'
 +
export gvsqw_RootAdminDisable='$HOME'
 +
export gvsqw_RootAdminDist='$HOME/admin/teradata/${TER_SID}'
 +
export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig'
 +
export gvsqw_BteqErrorMsg="Error:"
 +
export gvsqw_SizeMinDatabaseDetailledIndicators=1
 +
export gvsqw_SizeMinDatabaseIndicators=10
 +
export gvsqw_SizeMinDatabaseDetailledRate=60
 +
export gvsqw_SizeMinTableSkew=100
 +
export gvsqw_SizeMinTablePerAMP=10
 +
export gvsqw_SkewFactor=50
 +
export gvsqw_DbAlias='$TER_SID'
 +
</pre>
 +
<br>
 +
<br>
 +
Variables explanation:
 +
<pre>
 +
gvsqw_BteqErrorMsg =>
 +
gvsqw_DbAlias =>
 +
gvsqw_PasswdFile =>
 +
gvsqw_RootAdmin =>
 +
gvsqw_RootAdminDisable =>
 +
gvsqw_RootAdminDist =>
 +
gvsqw_RootCfg =>
 +
gvsqw_SizeMinDatabaseDetailledIndicators =>
 +
gvsqw_SizeMinDatabaseDetailledRate =>
 +
gvsqw_SizeMinDatabaseIndicators =>
 +
gvsqw_SizeMinTablePerAMP =>
 +
gvsqw_SizeMinTableSkew =>
 +
gvsqw_SkewFactor =>
 +
gvsqw_SqwVersionDbms =>
 +
</pre>
 
{{SQWareProductionSurchargeVar|teradata|Ter|sqwter_GlobalVar.cfg}}
 
{{SQWareProductionSurchargeVar|teradata|Ter|sqwter_GlobalVar.cfg}}
 
<br>
 
<br>

Revision as of 15:52, 31 October 2024

Configuration file $gvsqw_TerBin/../etc/sqwter_GlobalVar.cfg:
Global var for Teradata
It contains the operating variables of SQWareProduction.


File content:

export gvsqw_SqwVersionDbms=2024.07
export gvsqw_PasswdFile="$HOME/.passwd"
export gvsqw_RootAdmin='$HOME/${TER_SID}'
export gvsqw_RootAdminDisable='$HOME'
export gvsqw_RootAdminDist='$HOME/admin/teradata/${TER_SID}'
export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig'
export gvsqw_BteqErrorMsg="Error:"
export gvsqw_SizeMinDatabaseDetailledIndicators=1
export gvsqw_SizeMinDatabaseIndicators=10
export gvsqw_SizeMinDatabaseDetailledRate=60
export gvsqw_SizeMinTableSkew=100
export gvsqw_SizeMinTablePerAMP=10
export gvsqw_SkewFactor=50
export gvsqw_DbAlias='$TER_SID'



Variables explanation:

gvsqw_BteqErrorMsg => 
gvsqw_DbAlias => 
gvsqw_PasswdFile => 
gvsqw_RootAdmin => 
gvsqw_RootAdminDisable => 
gvsqw_RootAdminDist => 
gvsqw_RootCfg => 
gvsqw_SizeMinDatabaseDetailledIndicators => 
gvsqw_SizeMinDatabaseDetailledRate => 
gvsqw_SizeMinDatabaseIndicators => 
gvsqw_SizeMinTablePerAMP => 
gvsqw_SizeMinTableSkew => 
gvsqw_SkewFactor => 
gvsqw_SqwVersionDbms => 
Nuvola apps information.png
Note:
You can overload variables contain in $gvsqw_TerBin/../etc/sqwter_GlobalVar.cfg

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