SQWareProduction:db2:etc:sqwdb2 CreInst Jobs.cfg: Difference between revisions
Jump to navigation
Jump to search
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 18: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