SQWareProduction:db2:etc:sqwdb2 GlobalVar.cfg: Difference between revisions
Jump to navigation
Jump to search
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_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' | |||
</pre> | |||
<br> | |||
<br> | |||
Variables explanation: | |||
<pre> | |||
gvsqw_BackupRetention => | |||
gvsqw_Compress => | |||
gvsqw_Db2ErrorMsg => | |||
gvsqw_Db2ErrorMsgWarning => | |||
gvsqw_DbAlias => | |||
#gvsqw_ForcedReturnCodeScript_sqwdb2_DumpDatabase => | |||
gvsqw_NbThreadBackup => | |||
gvsqw_NbThreadReorganize => | |||
gvsqw_NbThreadRunStats => | |||
gvsqw_ReorgRunStatsOption => | |||
gvsqw_ReorgStat => | |||
gvsqw_ReorgTypeTable => | |||
gvsqw_RootAdminDisable => | |||
gvsqw_RootAdminDist => | |||
gvsqw_RootAdmin => | |||
gvsqw_RootBackup => | |||
gvsqw_RootCfg => | |||
gvsqw_RootDbf => | |||
gvsqw_RsyncDefaultSourceDir => | |||
gvsqw_RunStatsOption => | |||
gvsqw_SizeMinTableIndicators => | |||
gvsqw_ToolCommand => | |||
gvsqw_ToolType => | |||
gvsqw_TraceBackup => | |||
</pre> | |||
{{SQWareProductionSurchargeVar|db2|D2db2|sqwdb2_GlobalVar.cfg}} | {{SQWareProductionSurchargeVar|db2|D2db2|sqwdb2_GlobalVar.cfg}} | ||
<br> | <br> | ||
Revision as of 16:04, 24 May 2020
Configuration file $gvsqw_D2db2Bin/../etc/sqwdb2_GlobalVar.cfg:
Global var for Db2
It contains the operating variables of SQWareProduction.
File content:
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'
Variables explanation:
gvsqw_BackupRetention => gvsqw_Compress => gvsqw_Db2ErrorMsg => gvsqw_Db2ErrorMsgWarning => gvsqw_DbAlias => #gvsqw_ForcedReturnCodeScript_sqwdb2_DumpDatabase => gvsqw_NbThreadBackup => gvsqw_NbThreadReorganize => gvsqw_NbThreadRunStats => gvsqw_ReorgRunStatsOption => gvsqw_ReorgStat => gvsqw_ReorgTypeTable => gvsqw_RootAdminDisable => gvsqw_RootAdminDist => gvsqw_RootAdmin => gvsqw_RootBackup => gvsqw_RootCfg => gvsqw_RootDbf => gvsqw_RsyncDefaultSourceDir => gvsqw_RunStatsOption => gvsqw_SizeMinTableIndicators => gvsqw_ToolCommand => gvsqw_ToolType => gvsqw_TraceBackup =>
