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

From Wiki_dbSQWare
Jump to navigation Jump to search
← Older editNewer edit →
m Updated by BatchUser
m Updated by BatchUser
Line 1: Line 1:
<pre>
<pre>
Sourcing sqwmsq_Global.lib v2019.05 SQWareProduction for MsSql (dbSQWare) ...  
Sourcing sqwmsq_Global.lib v2020.01 SQWareProduction for MsSql (dbSQWare) ...  


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


DESCRIPTION
DESCRIPTION
   sqwmsq_RebuildIndexDatabase.ksh Rebuild index of database
   sqwmsq_RebuildIndexDatabase.ksh Rebuild index of database
SUPPORT
SUPPORT
   MsSql supported versions: 2000 <= v <= 2017
   MsSql supported versions: 2000 <= v <= 2019


PARAMETERS
PARAMETERS
     -S|-I Instance   : Target instance (freeTds alias).
     -I   Instance     : Target instance (freeTds alias).
     -D  databasename  : Target database.
     -D   databasename : Target database.
OPTIONS
OPTIONS
     -h    help        : Display the full usage.
     -h    help        : Display the full usage.
     -s                : Display samples of usage.
     -s                : Display samples of usage.
     -IT  listtables  : Tables list for running analyze tables (by default all).
     -IT  listtables  : List of tables to run update statistics on (by default all).
     -ET  listtables  : Tables list to exclude.
     -ET  listtables  : Tables list to exclude.
     -IL  likeclause  : Like clause to generate tables list (example: 'tbl%').
     -IL  likeclause  : Like clause to generate tables list (example: 'tbl%').
Line 21: Line 21:
     -WCT  whereclause  : Where clause to generate tables list.
     -WCT  whereclause  : Where clause to generate tables list.
     -FRT  return_code  : Force return code value on error.
     -FRT  return_code  : Force return code value on error.
     -AddMail email    : Email Address to add at 'pmexpdba@gmail.com'.
     -AddMail email    : Email address to add at 'pmexpdba@gmail.com'.
     -RebuildType  type  : Type of rebuild, 'all' for table, 'index' for indexes (default 'all').
     -RebuildType  type  : Type of rebuild, 'all' for table, 'index' for indexes (default 'all').
     -MinRatioReb ratio : Min avg_fragmentation_in_percent before rebuild (default 30 %).
     -MinRatioReb ratio : Min avg_fragmentation_in_percent before rebuild (default 30 %).
Line 29: Line 29:
     -Online            : Rebuild with option online=on.
     -Online            : Rebuild with option online=on.
     -Force            : Force Rebuild offline if necessary when -Online.
     -Force            : Force Rebuild offline if necessary when -Online.
     -NoMail            : Desactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
     -NoMail            : Deactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
     -Locale  locale  : Force Locale for help display (fr,en).
     -Locale  locale  : Force Locale for help display (fr,en).
     -Exec              : Execute commands (default, display generated commands)
     -Exec              : Execute commands (default, display generated commands)


</pre>
</pre>

Revision as of 18:36, 8 March 2020

Sourcing sqwmsq_Global.lib v2020.01 SQWareProduction for MsSql (dbSQWare) ... 

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

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

PARAMETERS
     -I   Instance      : Target instance (freeTds alias).
     -D   databasename  : Target database.
OPTIONS
     -h    help         : Display the full usage.
     -s                 : Display samples of usage.
     -IT   listtables   : List of tables to run update statistics on (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.
     -AddMail email     : Email address to add at 'pmexpdba@gmail.com'.
     -RebuildType  type  : Type of rebuild, 'all' for table, 'index' for indexes (default 'all').
     -MinRatioReb ratio : Min avg_fragmentation_in_percent before rebuild (default 30 %).
     -MinRatioRgz ratio : Min avg_fragmentation_in_percent before reorganize (default 10 %).
     -SendReport        : Send execution log report.
     -SortInTempdb      : Rebuild with option sort_in_tempdb=on.
     -Online            : Rebuild with option online=on.
     -Force             : Force Rebuild offline if necessary when -Online.
     -NoMail            : Deactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
     -Locale   locale   : Force Locale for help display (fr,en).
     -Exec              : Execute commands (default, display generated commands)
Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwmsq_RebuildIndexDatabase.ksh_help&oldid=14659"