SQWareProduction:db2:etc:sqwdb2 CreInst Jobs.cfg

From Wiki_dbSQWare
Jump to: navigation, search

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