Difference between revisions of "SQWareProduction:ingres:etc:sqwing Jobs.cfg"
m (Updated by Expdbtools) |
m (Updated by BatchUser) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 18: | Line 18: | ||
BckJnl:$gvsqw_IngBin/sqwing_CkpdbAllDatabases.ksh -I $INGRES_SID -Jnl -Exec | BckJnl:$gvsqw_IngBin/sqwing_CkpdbAllDatabases.ksh -I $INGRES_SID -Jnl -Exec | ||
| − | #Stats : update | + | #Stats : update Statisticss tables for all databases |
Stats:$gvsqw_IngBin/sqwing_OptimizeAllDatabases.ksh -I $INGRES_SID -Exec | Stats:$gvsqw_IngBin/sqwing_OptimizeAllDatabases.ksh -I $INGRES_SID -Exec | ||
| Line 36: | Line 36: | ||
ExportFull:$gvsqw_IngBin/sqwing_ExpFullAllDatabases.ksh -I ING_CAPPRI_DBA -Exec | ExportFull:$gvsqw_IngBin/sqwing_ExpFullAllDatabases.ksh -I ING_CAPPRI_DBA -Exec | ||
</pre> | </pre> | ||
| − | |||
<br> | <br> | ||
Latest revision as of 17:33, 5 April 2014
Configuration file $gvsqw_IngBin/../etc/sqwing_Jobs.cfg:
File content:
#IndicDba: Gather DBAs indicators IndicDba:$gvsqw_IngBin/sqwing_GatherIndicators.ksh -I $INGRES_SID #CheckInd: Check des indicateurs DBAs CheckInd:$gvsqw_IngBin/sqwing_CheckIndicators.ksh -I $INGRES_SID #CkpdbFull: ckpdb (full) for all databases CkpdbFull:$gvsqw_IngBin/sqwing_CkpdbAllDatabases.ksh -I $INGRES_SID -Exec #BckJnl: backup journal files for all databases BckJnl:$gvsqw_IngBin/sqwing_CkpdbAllDatabases.ksh -I $INGRES_SID -Jnl -Exec #Stats : update Statisticss tables for all databases Stats:$gvsqw_IngBin/sqwing_OptimizeAllDatabases.ksh -I $INGRES_SID -Exec #Reorg : reorg tables for all databases Reorg:$gvsqw_IngBin/sqwing_UsermodAllDatabases.ksh -I $INGRES_SID -Exec #DbmsClose: close of all dbms DbmsClose:$gvsqw_IngBin/../tools/sqwing_DbmsClose.ksh #DbmsOpen: open of all dbms DbmsOpen:$gvsqw_IngBin/../tools/sqwing_DbmsOpen.ksh #KillSessions: kill of all sessions for all databases KillSessions:$gvsqw_IngBin/../tools/sqwing_KillSessions.ksh #ExportFull: Export Full for all databases ExportFull:$gvsqw_IngBin/sqwing_ExpFullAllDatabases.ksh -I ING_CAPPRI_DBA -Exec
