SQWareProduction:ingres:etc:sqwing GlobalVar.cfg : Différence entre versions
m (Updated by BatchUser) |
m (Updated by BatchUser) |
(25 révisions intermédiaires par le même utilisateur non affichées) | |
(Aucune différence)
|
Version actuelle datée du 31 octobre 2024 à 15:49
Configuration file $gvsqw_IngBin/../etc/sqwing_GlobalVar.cfg:
Global var for Ingres
Contient les variables operationnelles de SQWareProduction.
Contenu du fichier:
#!/bin/ksh ################################################################### # SQWareProduction for Ingres 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 Ingres ## @Copyright Copyright 2010-2024, dbSQWare (www.dbsqware.com) #global export gvsqw_SqwVersionDbms=2024.07 export gvsqw_UserDbaSql=ingres export gvsqw_RootAdmin='$HOME/${INGRES_SID}' export gvsqw_RootAdminDisable='$HOME' export gvsqw_RootCfg='$HOME/${INGRES_SID}/sqwConfig' export gvsqw_RootDbf='$(ingprenv "II_DATABASE")/ingres/data/default' export gvsqw_MysqlErrorMsg="^ERROR|^FAILED" export gvsqw_IngresErrorMsg="^E_[0-9A-Z][0-9A-Z][0-9A-Z][0-9A-Z][0-9A-Z][0-9A-Z]" export gvsqw_DbAlias='$INGRES_SID' #for ckpdb scripts export gvsqw_RootJnl='$(ingprenv "II_JOURNAL")/ingres/jnl/default' export gvsqw_RootCkpdb='$(ingprenv "II_CHECKPOINT")/ingres/ckp/default' export gvsqw_RootBck='$(ingprenv "II_CHECKPOINT")/bck' export gvsqw_CkpdbNbGeneration=2 export gvsqw_NbThreadCkpdb=2 #for dump scripts export gvsqw_RootDump='/$(echo ${HOME}|cut -d/ -f2)/ing_Dump/$INGRES_SID' export gvsqw_NbThreadExportFull=2 export gvsqw_RootDumpSource='/$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/ing_Dump/${lvsqw_InstanceSource}' export gvsqw_NbThreadDbRefresh=2 export gvsqw_DumpNbGeneration=2
Explication de variables:
#General variables gvsqw_UserDbaSql => Ingres user to DBA connection gvsqw_RootAdmin => admin directory gvsqw_RootCfg => configuration directory gvsqw_RootDbf => datafiles directory gvsqw_NbThread => default number of thread for parallelism gvsqw_IngresErrorMsg => format of Ingres errors #for ckpdb scripts gvsqw_RootJnl => jnls directory gvsqw_RootCkpdb => ckpdb directory gvsqw_RootBck => backup directory gvsqw_CkpdbNbGeneration => default number generation of ckpdb to keep online gvsqw_NbThreadCkpdb => default number of thread for parallelism for ckpdb #for Dump scripts gvsqw_RootDump => unLoad directory gvsqw_NbThreadExportFull => default number of thread for parallelism for export full gvsqw_RootDumpSource => unLoad directory for source gvsqw_NbThreadDbRefresh => default number of thread for parallelism for refresh gvsqw_DumpNbGeneration => default number generation of export full to keep online #for SQWare Web gvsqw_WebDbaUserConn => Connection string ssh user@hostname to SQWare Web