Modèle:SQWareProduction sqwdb2 GlobalVar.cfg content
Révision datée du 27 septembre 2023 à 17:51 par BatchUser (discussion | contributions) (Updated by BatchUser)
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-2023, dbSQWare (www.dbsqware.com) #global export gvsqw_SqwVersionDbms=2023.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"