SQWareProduction:adabas:etc:sqwada CreInst Jobs.cfg: Difference between revisions

From Wiki_dbSQWare
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_AdaBin/sqwada_GatherIndicators.ksh -I <ADA_SID>
IndicDba:$gvsqw_AdaBin/sqwada_GatherIndicators.ksh -I <DBID>


#Dump: backup all databases with adabasDump
#Backup: backup (adabck) DBID
Dump:$gvsqw_AdaBin/sqwada_DumpAllDatabases.ksh -I <ADA_SID> -Exec
Backup:$gvsqw_AdaBin/sqwada_Backup.ksh -I <DBID> -Exec


#Optimize : optimize tables for all databases
#DeleteCheckpoints : delete checkpoint for DBID
Optimize:$gvsqw_AdaBin/sqwada_OptimizeAllDatabases.ksh -I <ADA_SID> -Exec
DeleteCheckpoints:$gvsqw_AdaBin/DeleteCheckpoints.ksh -I <DBID> -Exec


#Analyse : analyze tables for all databases
#Reorg : Reorg (adaord) DBID
Analyze:$gvsqw_AdaBin/sqwada_AnalyzeAllDatabases.ksh -I <ADA_SID> -Exec
Reorg:$gvsqw_AdaBin/sqwada_Reorg.ksh -I <DBID> -Exec
 
#SlowQuery: Rotate log slow query
SlowQuery:$gvsqw_AdaBin/sqwada_RotateLogSlowQuery.ksh -I <ADA_SID>
 
#PurgeAlert: Rotate error log
PurgeAlert:$gvsqw_AdaBin/sqwada_PurgeAlert.ksh -I <ADA_SID>
 
#NetBackup: run user backup command
NetBackup:$gvsqw_AdaBin/sqwada_NetBackup.ksh -I <ADA_SID> -Policy <Policy> -Schedule  <Schedule> -Exec
</pre>
</pre>
<br>
<br>

Latest revision as of 19:51, 23 February 2018

Configuration file $gvsqw_AdaBin/../etc/sqwada_CreInst_Jobs.cfg:



File content:


#IndicDba: Gather DBAs indicators
IndicDba:$gvsqw_AdaBin/sqwada_GatherIndicators.ksh -I <DBID>

#Backup: backup (adabck) DBID
Backup:$gvsqw_AdaBin/sqwada_Backup.ksh -I <DBID> -Exec

#DeleteCheckpoints : delete checkpoint for DBID
DeleteCheckpoints:$gvsqw_AdaBin/DeleteCheckpoints.ksh -I <DBID> -Exec

#Reorg : Reorg (adaord) DBID
Reorg:$gvsqw_AdaBin/sqwada_Reorg.ksh -I <DBID> -Exec