SQWareProduction:db2:etc:sqwdb2 CreInst Jobs.cfg

From Wiki_dbSQWare
Revision as of 22:19, 17 December 2012 by BatchUser (talk | contribs) (Updated by BatchUser)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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 <DB2INSTANCE>

#Backup: backup all databases with db2dump
Backup:$gvsqw_Db2Bin/sqwdb2_BackupAllDatabases.ksh -I <DB2INSTANCE> -Exec

#Reorganize : optimize tables for all databases
Reorganize:$gvsqw_Db2Bin/sqwdb2_ReorganizeAllDatabases.ksh -I <DB2INSTANCE> -Exec

#RunStats : RUNSTATS tables for all databases
RunStats:$gvsqw_Db2Bin/sqwdb2_RunStatsAllDatabases.ksh -I <DB2INSTANCE> -Exec