Template:SQWareProduction sqwmsq RebuildIndexDatabase.ksh help

From Wiki_dbSQWare
Revision as of 22:24, 17 December 2012 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to: navigation, search
Sourcing sqwmsq_Global.lib v3.1.12 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)