Template:SQWareProduction sqwsyb RebuildDatabase.ksh help

From Wiki_dbSQWare
Revision as of 22:46, 8 May 2023 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 v2023.05 SQWareProduction for Sybase (dbSQWare) ... 

Usage: sqwsyb_RebuildDatabase.ksh [-h] -I <dataserver> [+ options]

DESCRIPTION
   sqwsyb_RebuildDatabase.ksh Rebuild of tables
SUPPORT
   Sybase supported versions: 12.0 <= v <= 16.0

PARAMETERS
     -I  dataserver     : Target dataserver.
     -D  database       : Database name.
OPTIONS
     -h  help           : Display the full usage.
     -s                 : Display samples of usage.
     -Online            : Add 'with online' when ASE version >= 15.7 ESD#2 or SP50 and Enterprise edition.
     -NoMail            : Deactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
     -SizeMaxTable Size : Take into account tables <= $lvsqw_SizeMaxTable Mb (by default, 10000 Mb).
     -SizeMinTable Size : Take into account tables >= $lvsqw_SizeMinTable Mb (by default, 1 Mb).
     -CLT RatioMinTable : Min cluster ratio for table (default 80 %).
     -CLI RatioMinIndex : Min cluster ratio for index (default 80 %).
     -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 ).
     -Locale   locale   : Force Locale for help display (fr,en).
     -Exec              : Run reorg (default, display generated commands).