Template:SQWareProduction sqwdb2 RunStatsDatabase.ksh help

From Wiki_dbSQWare
Revision as of 15:49, 27 May 2022 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 v2022.03 SQWareProduction for Db2 (dbSQWare) ... 

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

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

PARAMETERS
     -I  database       : Target database 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            : Deactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
     -Locale   locale   : Force Locale for help display (fr,en).
     -Exec              : Execute commands (default, display generated commands)