Difference between revisions of "SQWareProduction:db2:etc:sqwdb2 GlobalVar.cfg"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Line 1: | Line 1: | ||
Configuration file $gvsqw_D2db2Bin/../etc/sqwdb2_GlobalVar.cfg:<br> | Configuration file $gvsqw_D2db2Bin/../etc/sqwdb2_GlobalVar.cfg:<br> | ||
{{SQWareProduction_sqwdb2_GlobalVar.cfg_presentation}} | {{SQWareProduction_sqwdb2_GlobalVar.cfg_presentation}} | ||
| − | {{ | + | <br> |
| − | {{ | + | <br> |
| + | File content: | ||
| + | <pre> | ||
| + | export gvsqw_SqwVersionDbms=2024.01 | ||
| + | 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_PathList="HOME;gvsqw_RootAdmin;gvsqw_RootCfg;gvsqw_RootBackup" | ||
| + | export gvsqw_PathListExtra="" | ||
| + | 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" | ||
| + | </pre> | ||
| + | <br> | ||
| + | <br> | ||
| + | Variables explanation: | ||
| + | <pre> | ||
| + | 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_PathListExtra => | ||
| + | gvsqw_PathList => | ||
| + | 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 => | ||
| + | </pre> | ||
{{SQWareProductionSurchargeVar|db2|D2db2|sqwdb2_GlobalVar.cfg}} | {{SQWareProductionSurchargeVar|db2|D2db2|sqwdb2_GlobalVar.cfg}} | ||
<br> | <br> | ||
Revision as of 21:40, 25 February 2024
Configuration file $gvsqw_D2db2Bin/../etc/sqwdb2_GlobalVar.cfg:
Global var for Db2
It contains the operating variables of SQWareProduction.
File content:
export gvsqw_SqwVersionDbms=2024.01
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_PathList="HOME;gvsqw_RootAdmin;gvsqw_RootCfg;gvsqw_RootBackup"
export gvsqw_PathListExtra=""
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_PathListExtra => gvsqw_PathList => 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 =>
