SQWareProduction:teradata:etc:sqwter GlobalVar.cfg

From Wiki_dbSQWare
Revision as of 16:41, 18 October 2020 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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


File content:

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_RootAdminDisable => 
gvsqw_RootAdminDist => 
gvsqw_RootAdmin => 
gvsqw_RootCfg => 
gvsqw_SizeMinDatabaseDetailledIndicators => 
gvsqw_SizeMinDatabaseDetailledRate => 
gvsqw_SizeMinDatabaseIndicators => 
gvsqw_SizeMinTablePerAMP => 
gvsqw_SizeMinTableSkew => 
gvsqw_SkewFactor => 
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.