Template:SQWareProduction sqwora GenerateStatspack.ksh help: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
m Updated by BatchUser
m Updated by BatchUser
Line 1: Line 1:
<pre>
<pre>
Sourcing sqwora_Global.lib v3.1.01 SQWareProduction for Oracle (dbSQWare GPL v3) ...  
Sourcing sqwora_Global.lib v3.1.12 SQWareProduction for Oracle (dbSQWare GPL v3) ...  


Usage: sqwora_GenerateStatspack.ksh [-h] -I <instance> [+ options]
Usage: sqwora_GenerateStatspack.ksh [-h] -I <instance> [+ options]
Line 7: Line 7:
   sqwora_GenerateStatspack.ksh Statspack reports generation
   sqwora_GenerateStatspack.ksh Statspack reports generation
SUPPORT
SUPPORT
   Oracle supported versions: 9iR2 <= v <= 9iR2
   Oracle supported versions: 9iR2 <= v <= 11gR2


PARAMETERS
PARAMETERS
Line 15: Line 15:
     -s                : Display samples of usage.
     -s                : Display samples of usage.
     -F  FileName      : Config file with date for generate reports.
     -F  FileName      : Config file with date for generate reports.
    -Pdb    pdb_name  : pdb_name for multitenant.
     -Snaps  begin-end  : Generate report between the two naps. Break in -NoDel and -Local automatically.
     -Snaps  begin-end  : Generate report between the two naps. Break in -NoDel and -Local automatically.
     -DIR  directory    : Directory to store reports.
     -DIR  directory    : Directory to store reports.
Line 20: Line 21:
     -AddMail email    : Email Address to add at 'pmexpdba@gmail.com'.
     -AddMail email    : Email Address to add at 'pmexpdba@gmail.com'.
     -SendReport        : Send execution log report.
     -SendReport        : Send execution log report.
     -Local            : Don't copy reports on .
     -Local            : Don't copy reports on dbsqware@SQWareWebHost.
     -Dist              : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser@$ORACLE_SID ).
     -Dist              : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser@$ORACLE_SID ).
     -NoDel            : Don't remove local reports.
     -NoDel            : Don't remove local reports.

Revision as of 15:52, 8 March 2017

Sourcing sqwora_Global.lib v3.1.12 SQWareProduction for Oracle (dbSQWare GPL v3) ... 

Usage: sqwora_GenerateStatspack.ksh [-h] -I <instance> [+ options]

DESCRIPTION
   sqwora_GenerateStatspack.ksh Statspack reports generation
SUPPORT
   Oracle supported versions: 9iR2 <= v <= 11gR2

PARAMETERS
     -I  instance       : Target instance for generation
OPTIONS
     -h  help           : Display the full usage.
     -s                 : Display samples of usage.
     -F  FileName       : Config file with date for generate reports.
     -Pdb    pdb_name   : pdb_name for multitenant.
     -Snaps  begin-end  : Generate report between the two naps. Break in -NoDel and -Local automatically.
     -DIR  directory    : Directory to store reports.
     -FRT return_code   : Force return code value on error.
     -AddMail email     : Email Address to add at 'pmexpdba@gmail.com'.
     -SendReport        : Send execution log report.
     -Local             : Don't copy reports on dbsqware@SQWareWebHost.
     -Dist              : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser@$ORACLE_SID ).
     -NoDel             : Don't remove local reports.
     -Force             : Bypass version check.
     -NoMail            : Desactivate sendmail on error to pmexpdba@gmail.com (by default, send on error).