SQWareProduction:db2:etc:sqwdb2 GlobalVar.cfg : Différence entre versions
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Ligne 1 : | Ligne 1 : | ||
| − | + | Configuration file $gvsqw_D2db2Bin/../etc/sqwdb2_GlobalVar.cfg:<br> | |
{{SQWareProduction_sqwdb2_GlobalVar.cfg_presentation}} | {{SQWareProduction_sqwdb2_GlobalVar.cfg_presentation}} | ||
| − | + | {{SQWareProduction_sqwdb2_GlobalVar.cfg_content}} | |
| − | + | {{SQWareProduction_sqwdb2_GlobalVar.cfg_explanation}} | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{{SQWareProductionSurchargeVar|db2|D2db2|sqwdb2_GlobalVar.cfg}} | {{SQWareProductionSurchargeVar|db2|D2db2|sqwdb2_GlobalVar.cfg}} | ||
<br> | <br> | ||
Version du 8 mai 2023 à 22:41
Configuration file $gvsqw_D2db2Bin/../etc/sqwdb2_GlobalVar.cfg:
Global var for Db2
Contient les variables operationnelles de SQWareProduction.
Contenu du fichier:
#!/bin/ksh
###################################################################
# SQWareProduction for Db2 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 Db2
## @Copyright Copyright 2010-2024, dbSQWare (www.dbsqware.com)
#global
export gvsqw_SqwVersionDbms=2024.07
export gvsqw_RootAdmin='$HOME/admin/${lvsqw_InstanceParam}'
export gvsqw_RootAdminDisable='$HOME'
export gvsqw_RootAdminDist='$HOME/admin/db2/${lvsqw_InstanceParam}'
export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig'
export gvsqw_RootDbf='${HOME}/${DB2INSTANCE}'
export gvsqw_Db2ErrorMsg='^SQL[0-9][0-9]*'
export gvsqw_Db2ErrorMsgWarning='^SQL[0-9][0-9]*W'
export gvsqw_DbAlias='$lvsqw_InstanceParam'
#for indicators
export gvsqw_SizeMinTableIndicators=10
export gvsqw_PathList="HOME;gvsqw_RootAdmin;gvsqw_RootCfg;gvsqw_RootBackup"
export gvsqw_PathListExtra=""
#For RUNSTAT
export gvsqw_NbThreadRunStats=2
export gvsqw_RunStatsOption='WITH DISTRIBUTION AND DETAILED INDEXES ALL'
#For reorg
export gvsqw_NbThreadReorganize=2
#CURRENT or UPDATE
export gvsqw_ReorgStat='UPDATE'
#USER ALL SYSTEM
export gvsqw_ReorgTypeTable='USER'
#Put off to desactivate RUNSTAT after reorg
export gvsqw_ReorgRunStatsOption='WITH DISTRIBUTION AND DETAILED INDEXES ALL'
#for Dump scripts
export gvsqw_NbThreadBackup=2
export gvsqw_RootBackup='/backup/db2/$lvsqw_InstanceParam'
export gvsqw_BackupRetention=30
#'USE TSM' 'TO DISK' 'USE XBSA'
export gvsqw_ToolCommand='USE TSM'
export gvsqw_ToolType='TSM'
export gvsqw_Compress='COMPRESS'
export gvsqw_RsyncDefaultSourceDir='/backup/db2/$lvsqw_InstanceParam'
#Put disable in gvsqw_TraceBackup if you don't want to trace backup execution in SQWareRepository
export gvsqw_TraceBackup=enable
##Globaly forcing return code for scripts
#export gvsqw_ForcedReturnCodeScript_sqwdb2_DumpDatabase=0
#PK for indicators, if DB2INSTANCE not unique, put for example gvsqw_DbAlias='$lvsqw_InstanceParam:$(hostname|cut -d '.' -f1)'
export gvsqw_DbAlias='$lvsqw_InstanceParam'
######################
## For DB2i (AS400)
# export gvsqw_DB2_Type='DB2i' # Put this line in .profile of unixODBC user than can connect to DB2i
export gvsqw_DistPasswdFileDB2i="$HOME/.passwd_DB2i"
Explication de variables:
#General variables gvsqw_SqwVersion => SQWare Production version gvsqw_RootAdmin => admin directory gvsqw_RootCfg => configuration directory gvsqw_RootDbf => datafiles directory gvsqw_NbThread => default number of thread for parallelism gvsqw_Db2ErrorMsg => format of MySQL errors #for Dump scripts gvsqw_NbThreadBackup => default number of thread for parallelism for backup gvsqw_RootBackup => default backup directory #Put disable in gvsqw_TraceBackup if you don't want to trace backup execution in SQWareRepository gvsqw_TraceBackup => to trace backup execution in SQWare repository gvsqw_BackupRetention => backup retention in days gvsqw_ToolCommand => Support backup 'USE TSM' 'TO DISK' 'USE XBSA' gvsqw_Compress => for backup compression #for reorg scripts gvsqw_NbThreadReorganize => default number of thread for parallelism for reorg gvsqw_ReorgStat => for reorgchk CURRENT or UPDATE gvsqw_ReorgTypeTable => type of table to reorg USER ALL SYSTEM gvsqw_ReorgRunStatsOption => RUNSTAT option after reorg (Put off to deactivate) #for analyse scripts gvsqw_NbThreadRunStats => default number of thread for parallelism for runStatistics gvsqw_RunStatsOption => RUNSTAT option ##Globaly forcing return code for scripts gvsqw_ForcedReturnCodeScript_sqwdb2_BackupDatabase => To force return code of sqwdb2_BackupDatabase.ksh #PK for indicators, if DB2INSTANCE not unique gvsqw_DbAlias => Database Alias
