Difference between revisions of "SQWareProduction:db2:etc:sqwdb2 CreInst Jobs.cfg"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
Line 17: Line 17:
 
#RunStats : RUNSTATS tables for all databases
 
#RunStats : RUNSTATS tables for all databases
 
RunStats:$gvsqw_Db2Bin/sqwdb2_RunStatsDatabase.ksh -I <lvsqw_InstanceParam> -Exec
 
RunStats:$gvsqw_Db2Bin/sqwdb2_RunStatsDatabase.ksh -I <lvsqw_InstanceParam> -Exec
 +
 +
#NetBackup: run user backup command
 +
NetBackup:$gvsqw_Db2Bin/sqwdb2_NetBackup.ksh -I <lvsqw_InstanceParam> -Policy <Policy> -Schedule  <Schedule> -Exec
 
</pre>
 
</pre>
 
<br>
 
<br>

Latest revision as of 17:59, 5 October 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

#NetBackup: run user backup command
NetBackup:$gvsqw_Db2Bin/sqwdb2_NetBackup.ksh -I <lvsqw_InstanceParam> -Policy <Policy> -Schedule  <Schedule> -Exec