Template:SQWareProduction sqwmsq RebuildIndexDatabase.ksh help

From Wiki_dbSQWare
Revision as of 11:57, 23 January 2012 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 sqwmsq_Global.lib v3.1.04 SQWareProduction for MsSql (dbSQWare GPL v3) ... 

Usage: sqwmsq_RebuildIndexDatabase.ksh [-h] -S <FreeTdsAlias> -D <DatabaseName> [+ options]

DESCRIPTION
   sqwmsq_RebuildIndexDatabase.ksh rebuild index of database
SUPPORT
   MsSql supported versions: 2000 <= v <= 2008

PARAMETERS
     -S  Instance       : Target instance (freeTds alias).
     -D  databasename   : Target database.
OPTIONS
     -h    help         : Display the full usage.
     -s                 : Display samples of usage.
     -IT   listtables   : Tables list for running analyze tables (by default all).
     -ET   listtables   : Tables list to exclude.
     -IL   likeclause   : Like clause to generate tables list (example: 'tbl%').
     -EL   likeclause   : Like clause to exclude tables (example: 'notbl%').
     -WCT  whereclause  : Where clause to generate tables list.
     -FRT  return_code  : Force return code value on error.
     -NoMail            : Desactivate sendmail on error default@dbsqware.com (by default, send on error).
     -Exec              : Execute commands (default, display generated commands)