Template:SQWareProduction sqwmsq RebuildIndexDatabase.ksh help

From Wiki_dbSQWare
Revision as of 22:37, 18 December 2010 by Exploit (talk | contribs) (Updated by Expdbtools)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Sourcing sqwmsq_Global.lib v1.2.09 SQWareProduction for MsSql (expdbTools 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 dba (by default, send on error).
     -Exec              : Execute commands (default, display generated commands)