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

From Wiki_dbSQWare
Jump to: navigation, 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 18: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


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:adabas:etc:sqwada_CreInst_Jobs.cfg&oldid=9569"