Difference between revisions of "Template:SQWareProduction sqwmsq RebuildIndexDatabase.ksh help"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 1: Line 1:
 
<pre>
 
<pre>
Sourcing sqwmsq_Global.lib v3.1.02 SQWareProduction for MsSql (dbSQWare GPL v3) ...  
+
Sourcing sqwmsq_Global.lib v3.1.03 SQWareProduction for MsSql (dbSQWare GPL v3) ...  
  
 
Usage: sqwmsq_RebuildIndexDatabase.ksh [-h] -S <FreeTdsAlias> -D <DatabaseName> [+ options]
 
Usage: sqwmsq_RebuildIndexDatabase.ksh [-h] -S <FreeTdsAlias> -D <DatabaseName> [+ options]

Revision as of 20:44, 25 November 2011

Sourcing sqwmsq_Global.lib v3.1.03 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)