Template:SQWareProduction sqwsyb StatisticsDatabase.ksh help

From Wiki_dbSQWare
Revision as of 17:55, 9 December 2018 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 sqwsyb_Global.lib v2019.01 SQWareProduction for Sybase (dbSQWare) ... 

Usage: sqwsyb_StatisticsDatabase.ksh [-h] -S|-I <dataserver> [+ options]

DESCRIPTION
   sqwsyb_StatisticsDatabase.ksh update statistics of tables
SUPPORT
   Sybase supported versions: 12.0 <= v <= 16.0

PARAMETERS
     -S|-I  dataserver  : Target dataserver.
     -D  database       : Database name.
OPTIONS
     -h  help           : Display the full usage.
     -s                 : Display samples of usage.
     -NoMail            : Desactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
     -SizeMaxTable Size : Take into account tables =< $lvsqw_SizeMaxTable Mb (by default, 50000 Mb).
     -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_DbaUser to $gvsqw_DistDbaUser ).
     -Exec              : Run update statistics (default, display generated commands).