Difference between revisions of "SQWareProduction:db2:etc:sqwdb2 CreInst Jobs.cfg"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Line 7: | Line 7: | ||
#IndicDba: Gather DBAs indicators | #IndicDba: Gather DBAs indicators | ||
| − | IndicDba:$gvsqw_Db2Bin/sqwdb2_GatherIndicators.ksh -I < | + | IndicDba:$gvsqw_Db2Bin/sqwdb2_GatherIndicators.ksh -I <lvsqw_InstanceParam> |
| − | #Backup: backup all databases with | + | #Backup: backup all databases with db2Dump |
| − | Backup:$gvsqw_Db2Bin/ | + | Backup:$gvsqw_Db2Bin/sqwdb2_BackupDatabase.ksh -I <lvsqw_InstanceParam> -Exec |
#Reorganize : optimize tables for all databases | #Reorganize : optimize tables for all databases | ||
| − | Reorganize:$gvsqw_Db2Bin/ | + | Reorganize:$gvsqw_Db2Bin/sqwdb2_ReorganizeDatabase.ksh -I <lvsqw_InstanceParam> -Exec |
#RunStats : RUNSTATS tables for all databases | #RunStats : RUNSTATS tables for all databases | ||
| − | RunStats:$gvsqw_Db2Bin/ | + | RunStats:$gvsqw_Db2Bin/sqwdb2_RunStatsDatabase.ksh -I <lvsqw_InstanceParam> -Exec |
</pre> | </pre> | ||
<br> | <br> | ||
Revision as of 17:33, 5 April 2014
Configuration file $gvsqw_D2db2Bin/../etc/sqwdb2_CreInst_Jobs.cfg:
File content:
#IndicDba: Gather DBAs indicators IndicDba:$gvsqw_Db2Bin/sqwdb2_GatherIndicators.ksh -I <lvsqw_InstanceParam> #Backup: backup all databases with db2Dump Backup:$gvsqw_Db2Bin/sqwdb2_BackupDatabase.ksh -I <lvsqw_InstanceParam> -Exec #Reorganize : optimize tables for all databases Reorganize:$gvsqw_Db2Bin/sqwdb2_ReorganizeDatabase.ksh -I <lvsqw_InstanceParam> -Exec #RunStats : RUNSTATS tables for all databases RunStats:$gvsqw_Db2Bin/sqwdb2_RunStatsDatabase.ksh -I <lvsqw_InstanceParam> -Exec
