SQWareProduction:db2:etc:sqwdb2 GlobalVar.cfg : Différence entre versions
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Ligne 1 : | Ligne 1 : | ||
− | + | Fichier de configuration $gvsqw_D2db2Bin/../etc/sqwdb2_GlobalVar.cfg:<br> | |
{{SQWareProduction_sqwdb2_GlobalVar.cfg_presentation}} | {{SQWareProduction_sqwdb2_GlobalVar.cfg_presentation}} | ||
− | {{ | + | <br> |
− | {{ | + | <br> |
+ | Contenu du fichier: | ||
+ | <pre> | ||
+ | export gvsqw_SqwVersionDbms=2024.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' | ||
+ | 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> | ||
+ | Explication des variables: | ||
+ | <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> |
Version du 31 octobre 2024 à 15:42
Fichier de configuration $gvsqw_D2db2Bin/../etc/sqwdb2_GlobalVar.cfg:
Global var for Db2
Contient les variables operationnelles de SQWareProduction.
Contenu du fichier:
export gvsqw_SqwVersionDbms=2024.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' 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"
Explication des variables:
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 =>