Template:SQWareProduction sqwdb2 RunStatsDatabase.ksh help

From Wiki_dbSQWare
Revision as of 09:59, 20 July 2014 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Sourcing sqwdb2_Global.lib v3.1.03 SQWareProduction for Db2 (dbSQWare GPL v3) ... 

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

DESCRIPTION
   sqwdb2_RunStatsDatabase.ksh RUNSTATS tables of database
SUPPORT
   Db2 supported versions: 8.2 <= v <= 10.1

PARAMETERS
     -I  instance       : Target instance for RUNSTATS tables.
OPTIONS
     -h    help         : Display the full usage.
     -s                 : Display samples of usage.
     -Opt  option       : Option for RUNSTATS (default: 'WITH DISTRIBUTION AND DETAILED INDEXES ALL').
     -FRT  return_code  : Force return code value on error.
     -AddMail email     : Email Address to add at 'pmexpdba@gmail.com'.
     -SendReport        : Send execution log report.
     -Dist              : For distant connection to database (change $gvsqw_ConnectString to $gvsqw_DistConnectString ).
     -NoMail            : Desactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
     -Exec              : Execute commands (default, display generated commands)