Difference between revisions of "SQWareProduction:adabas:etc:sqwada GlobalVar.cfg"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 1: Line 1:
 
Configuration file $gvsqw_AdaBin/../etc/sqwada_GlobalVar.cfg:<br>
 
Configuration file $gvsqw_AdaBin/../etc/sqwada_GlobalVar.cfg:<br>
 
{{SQWareProduction_sqwada_GlobalVar.cfg_presentation}}
 
{{SQWareProduction_sqwada_GlobalVar.cfg_presentation}}
<br>
+
{{SQWareProduction_sqwada_GlobalVar.cfg_content}}
<br>
+
{{SQWareProduction_sqwada_GlobalVar.cfg_explanation}}
File content:
 
<pre>
 
export gvsqw_SqwVersionDbms=2024.03
 
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)
 
export gvsqw_PathList="HOME;gvsqw_RootAdmin;gvsqw_RootCfg;gvsqw_RootBackup;gvsqw_RootReorg"
 
export gvsqw_PathListExtra=""
 
export gvsqw_DeleteDate=$(echo '(,'$(date -d 'now - 7days' +%e-%^b-%Y:%T)')' | sed -e 's/ //g')
 
export gvsqw_RootBackup='/backup/adabas/${DBID}'
 
export gvsqw_BackupPrefix='${DBID}'
 
export gvsqw_BckNbGeneration=2
 
export gvsqw_RsyncDefaultSourceDir='/backup/adabas/${DBID}'
 
export gvsqw_RootReorg='/backup/adabas/${DBID}'
 
export gvsqw_ReorgPrefix='ORDEXP_${DBID}'
 
#export gvsqw_ForcedReturnCodeScript_sqwada_DumpDatabase=0
 
</pre>
 
<br>
 
<br>
 
Variables explanation:
 
<pre>
 
gvsqw_BackupPrefix =>
 
gvsqw_BckNbGeneration =>
 
gvsqw_CurDate =>
 
gvsqw_DbAlias =>
 
gvsqw_DeleteDate =>
 
#gvsqw_ForcedReturnCodeScript_sqwada_DumpDatabase =>
 
gvsqw_PathListExtra =>
 
gvsqw_PathList =>
 
gvsqw_ReorgPrefix =>
 
gvsqw_RootAdmin =>
 
gvsqw_RootAdminDisable =>
 
gvsqw_RootAdminDist =>
 
gvsqw_RootBackup =>
 
gvsqw_RootCfg =>
 
gvsqw_RootDbf =>
 
gvsqw_RootReorg =>
 
gvsqw_RsyncDefaultSourceDir =>
 
gvsqw_SqwVersionDbms =>
 
</pre>
 
 
{{SQWareProductionSurchargeVar|adabas|Ada|sqwada_GlobalVar.cfg}}
 
{{SQWareProductionSurchargeVar|adabas|Ada|sqwada_GlobalVar.cfg}}
 
<br>
 
<br>

Revision as of 15:16, 26 April 2024

Configuration file $gvsqw_AdaBin/../etc/sqwada_GlobalVar.cfg:
Global var for Adabas
It contains the operating variables of SQWareProduction.

File content:

#!/bin/ksh
###################################################################
# 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 2010-2024, dbSQWare (www.dbsqware.com)

#global
export gvsqw_SqwVersionDbms=2024.07
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
Nuvola apps information.png
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.