SQWareProduction:db2:etc:sqwdb2 GlobalVar.cfg
Configuration file $gvsqw_D2db2Bin/../etc/sqwdb2_GlobalVar.cfg:
Global var for Db2
It contains the operating variables of SQWareProduction.
File content:
export gvsqw_SqwVersionDbms=2023.03 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' export gvsqw_SizeMinTableIndicators=10 export gvsqw_NbThreadRunStats=2 export gvsqw_RunStatsOption='WITH DISTRIBUTION AND DETAILED INDEXES ALL' export gvsqw_NbThreadReorganize=2 export gvsqw_ReorgStat='UPDATE' export gvsqw_ReorgTypeTable='USER' export gvsqw_ReorgRunStatsOption='WITH DISTRIBUTION AND DETAILED INDEXES ALL' export gvsqw_NbThreadBackup=2 export gvsqw_RootBackup='/backup/db2/$lvsqw_InstanceParam' export gvsqw_BackupRetention=30 export gvsqw_ToolCommand='USE TSM' export gvsqw_ToolType='TSM' export gvsqw_Compress='COMPRESS' export gvsqw_RsyncDefaultSourceDir='/backup/db2/$lvsqw_InstanceParam' export gvsqw_TraceBackup=enable #export gvsqw_ForcedReturnCodeScript_sqwdb2_DumpDatabase=0 export gvsqw_DbAlias='$lvsqw_InstanceParam' # export gvsqw_DB2_Type='DB2i' # Put this line in .profile of unixODBC user than can connect to DB2i export gvsqw_DistPasswdFileDB2i="$HOME/.passwd_DB2i"
Variables explanation:
gvsqw_BackupRetention => gvsqw_Compress => gvsqw_Db2ErrorMsg => gvsqw_Db2ErrorMsgWarning => # gvsqw_DB2_Type => gvsqw_DbAlias => gvsqw_DistPasswdFileDB2i => #gvsqw_ForcedReturnCodeScript_sqwdb2_DumpDatabase => gvsqw_NbThreadBackup => gvsqw_NbThreadReorganize => gvsqw_NbThreadRunStats => gvsqw_ReorgRunStatsOption => gvsqw_ReorgStat => gvsqw_ReorgTypeTable => gvsqw_RootAdmin => gvsqw_RootAdminDisable => gvsqw_RootAdminDist => gvsqw_RootBackup => gvsqw_RootCfg => gvsqw_RootDbf => gvsqw_RsyncDefaultSourceDir => gvsqw_RunStatsOption => gvsqw_SizeMinTableIndicators => gvsqw_SqwVersionDbms => gvsqw_ToolCommand => gvsqw_ToolType => gvsqw_TraceBackup =>