SQWareProduction:teradata:etc:sqwter GlobalVar.cfg : Différence entre versions

De WikiFr_dbSQWare
Aller à : navigation, rechercher
m (Updated by BatchUser)
m (Updated by BatchUser)
Ligne 1 : Ligne 1 :
Fichier de configuration $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}}
<br>
+
{{SQWareProduction_sqwter_GlobalVar.cfg_content}}
<br>
+
{{SQWareProduction_sqwter_GlobalVar.cfg_explanation}}
Contenu du fichier:
 
<pre>
 
export gvsqw_SqwVersionDbms=2024.01
 
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>
 
Explication des variables:
 
<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>

Version du 25 février 2024 à 22:39

Configuration file $gvsqw_TerBin/../etc/sqwter_GlobalVar.cfg:
Global var for Teradata
Contient les variables operationnelles de SQWareProduction.

Contenu du fichier:

#!/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.03
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'


Explication de variables:

#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
Information.png
Information:
Vous pouvez surcharger les variables contenues dans $gvsqw_TerBin/../etc/sqwter_GlobalVar.cfg

en mettant les memes noms de variables dans $gvsqw_TerBin/../etc_cust/sqwter_GlobalVar.cfg pour tous vos environnements
ou dans $HOME/sqwConfig/sqwter_GlobalVar.cfg pour cet utilisateur specialement.