SQWareProduction:adabas:etc:sqwada GlobalVar.cfg

From Wiki_dbSQWare
Revision as of 17:58, 25 March 2018 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_AdaBin/../etc/sqwada_GlobalVar.cfg:
Global var for Adabas
It contains the operating variables of SQWareProduction.

File content:

#!/bin/bash
###################################################################
# SQWareProduction for Adabas 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 Adabas
## @Copyright	Copyright 2007-2025, dbSQWare (www.dbsqware.com)

#global
export gvsqw_SqwVersionDbms=2025.11
export gvsqw_DbAlias='$DBID'
export gvsqw_RootAdmin='$HOME/admin/${DBID}'
export gvsqw_RootAdminDisable='$HOME'
export gvsqw_RootAdminDist='$HOME/admin/adabas/${DBID}'
export gvsqw_RootCfg='$gvsqw_RootAdmin/sqwConfig'
export gvsqw_RootDbf='/adabas/data/${DBID}'
export gvsqw_CurDate=$(date +%Y%m%d-%H%M%S)

#for indicators
export gvsqw_PathList="HOME;gvsqw_RootAdmin;gvsqw_RootCfg;gvsqw_RootBackup;gvsqw_RootReorg"
export gvsqw_PathListExtra=""

#for delete checkpoints
export gvsqw_DeleteDate=$(echo '(,'$(date -d 'now - 7days' +%e-%^b-%Y:%T)')' | sed -e 's/ //g')

#for backup BCK001=$gvsqw_RootBackup/${gvsqw_BackupPrefix}_$gvsqw_CurDate.dmp
export gvsqw_RootBackup='/backup/adabas/${DBID}'
export gvsqw_BackupPrefix='${DBID}'
export gvsqw_BckNbGeneration=2
export gvsqw_RsyncDefaultSourceDir='/backup/adabas/${DBID}'

#for reorg ORDEXP=$gvsqw_RootReorg/${gvsqw_ReorgPrefix}_$gvsqw_CurDate.dmp
export gvsqw_RootReorg='/backup/adabas/${DBID}'
export gvsqw_ReorgPrefix='ORDEXP_${DBID}'

##Globaly forcing return code for scripts
#export gvsqw_ForcedReturnCodeScript_sqwada_DumpDatabase=0


Variables explanation:

#General variables
gvsqw_SqwVersionDbms => dbsqware version
gvsqw_DbAlias => Database Alias
gvsqw_RootAdmin => admin directory
gvsqw_RootAdminDisable => XXXXX
gvsqw_RootAdminDist => XXXXX
gvsqw_RootCfg => configuration directory
gvsqw_RootDbf => datafiles directory
gvsqw_CurDate => current date

#for delete checkpoints
gvsqw_DeleteDate => XXXXX

#for backup BCK001=$gvsqw_RootBackup/${gvsqw_BackupPrefix}_$gvsqw_CurDate.dmp
gvsqw_RootBackup => default backup directory
gvsqw_BackupPrefix => XXXXX
gvsqw_BckNbGeneration => XXXXX 
gvsqw_RsyncDefaultSourceDir => XXXXX

#for reorg ORDEXP=$gvsqw_RootReorg/${gvsqw_ReorgPrefix}_$gvsqw_CurDate.dmp
gvsqw_RootReorg => XXXXX
gvsqw_ReorgPrefix => XXXXX

##Globaly forcing return code for scripts
gvsqw_ForcedReturnCodeScript_sqwada_DumpDatabase => to force return code of sqwada_DumpDatabase
Note:
You can overload variables contain in $gvsqw_AdaBin/../etc/sqwada_GlobalVar.cfg

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