Difference between revisions of "Template:SQWareProduction sqwdb2 GlobalVar.cfg content"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Line 20: | Line 20: | ||
#global | #global | ||
− | export gvsqw_SqwVersionDbms=2024. | + | export gvsqw_SqwVersionDbms=2024.06 |
export gvsqw_RootAdmin='$HOME/admin/${lvsqw_InstanceParam}' | export gvsqw_RootAdmin='$HOME/admin/${lvsqw_InstanceParam}' | ||
export gvsqw_RootAdminDisable='$HOME' | export gvsqw_RootAdminDisable='$HOME' |
Revision as of 17:38, 15 September 2024
File content:
#!/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.06 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"