SQWareProduction:teradata:etc:sqwter GlobalVar.cfg
Configuration file $gvsqw_TerBin/../etc/sqwter_GlobalVar.cfg:
Global var for Teradata
It contains the operating variables of SQWareProduction.
File content:
#!/bin/ksh
###################################################################
# SQWareProduction for Teradata 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 Global var for Teradata
## @Copyright Copyright 2010-2024, dbSQWare (www.dbsqware.com)
#global
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:
#General variables gvsqw_SqwVersionDbms => dbsqware version gvsqw_PasswdFile => Password file path gvsqw_RootAdmin => admin Directory gvsqw_RootAdminDisable => XXXXX gvsqw_RootAdminDist => XXXXX gvsqw_RootCfg => configuration directory gvsqw_BteqErrorMsg => XXXXX gvsqw_SizeMinDatabaseDetailledIndicators => XXXXX gvsqw_SizeMinDatabaseIndicators => XXXXX gvsqw_SizeMinDatabaseDetailledRate => XXXXX gvsqw_SizeMinTableSkew => XXXXX gvsqw_SizeMinTablePerAMP => XXXXX gvsqw_SkewFactor => XXXXX gvsqw_DbAlias => Database alias
