Difference between revisions of "Template:SQWareProduction sqwpg AnalyzeDatabase.ksh help"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 1: Line 1:
 
<pre>
 
<pre>
Sourcing sqwpg_Global.lib v3.1.13 SQWareProduction for PostgreSQL (dbSQWare GPL v3) ...  
+
Sourcing sqwpg_Global.lib v3.1.14 SQWareProduction for PostgreSQL (dbSQWare GPL v3) ...  
  
 
Usage: sqwpg_AnalyzeDatabase.ksh [-h] -I instance -D databasename [+ options]
 
Usage: sqwpg_AnalyzeDatabase.ksh [-h] -I instance -D databasename [+ options]

Revision as of 11:14, 20 March 2013

Sourcing sqwpg_Global.lib v3.1.14 SQWareProduction for PostgreSQL (dbSQWare GPL v3) ... 

Usage: sqwpg_AnalyzeDatabase.ksh [-h] -I instance -D databasename [+ options]

DESCRIPTION
   sqwpg_AnalyzeDatabase.ksh analyze tables of database
SUPPORT
   PostgreSQL supported versions: 9.0 <= v <= 9.2

PARAMETERS
     -I  instance       : Target instance for analyze tables.
     -D  databasename   : Database for analyze tables.
OPTIONS
     -h    help         : Display the full usage.
     -s                 : Display samples of usage.
     -FRT  return_code  : Force return code value on error.
     -Opt  option       : Additional option for command line, ex:
                             - 'VERBOSE'
                             - 'FULL'
                             - 'FULL ANALYZE'
                             - 'FULL VERBOSE ANALYZE'
     -Dist              : For distant connection to database (change $gvsqw_ConnectString to $gvsqw_DistConnectString ).
     -NoMail            : Desactivate sendmail on error default@dbsqware.com (by default, send on error).
     -Exec              : Execute commands (default, display generated commands)