Difference between revisions of "Template:SQWareProduction sqwsyb RebuildDatabase.ksh help"
m (Updated by Expdbtools) |
m (Updated by BatchUser) |
||
Line 1: | Line 1: | ||
<pre> | <pre> | ||
− | Sourcing sqwsyb_Global.lib | + | Sourcing sqwsyb_Global.lib v3.1.b1 SQWareProduction for Sybase (dbSQWare GPL v3) ... |
Usage: sqwsyb_RebuildDatabase.ksh [-h] -S <dataserver> [+ options] | Usage: sqwsyb_RebuildDatabase.ksh [-h] -S <dataserver> [+ options] | ||
Line 15: | Line 15: | ||
-h help : Display the full usage. | -h help : Display the full usage. | ||
-s : Display samples of usage. | -s : Display samples of usage. | ||
− | -NoMail : Desactivate sendmail on error | + | -NoMail : Desactivate sendmail on error default@dbsqware.com (by default, send on error). |
-SMT SizeMinTable : Take into account tables >= $lvsqw_SizeMinTable Mo (by default, 1 Mo). | -SMT SizeMinTable : Take into account tables >= $lvsqw_SizeMinTable Mo (by default, 1 Mo). | ||
-CLT RatioMinTable : Min cluster ratio for table (default 80 %). | -CLT RatioMinTable : Min cluster ratio for table (default 80 %). | ||
-CLI RatioMinIndex : Min cluster ratio for index (default 80 %). | -CLI RatioMinIndex : Min cluster ratio for index (default 80 %). | ||
-FRT return_code : Force return code value on error. | -FRT return_code : Force return code value on error. | ||
+ | -Dist : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser ). | ||
-Exec : Run reorg (default, display generated commands). | -Exec : Run reorg (default, display generated commands). | ||
</pre> | </pre> |
Revision as of 21:37, 24 May 2011
Sourcing sqwsyb_Global.lib v3.1.b1 SQWareProduction for Sybase (dbSQWare GPL v3) ... Usage: sqwsyb_RebuildDatabase.ksh [-h] -S <dataserver> [+ options] DESCRIPTION sqwsyb_RebuildDatabase.ksh rebuild of tables SUPPORT Sybase supported versions: 12.0 <= v <= 15.5 PARAMETERS -S dataserver : Target dataserver. -D database : Database name. OPTIONS -h help : Display the full usage. -s : Display samples of usage. -NoMail : Desactivate sendmail on error default@dbsqware.com (by default, send on error). -SMT SizeMinTable : Take into account tables >= $lvsqw_SizeMinTable Mo (by default, 1 Mo). -CLT RatioMinTable : Min cluster ratio for table (default 80 %). -CLI RatioMinIndex : Min cluster ratio for index (default 80 %). -FRT return_code : Force return code value on error. -Dist : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser ). -Exec : Run reorg (default, display generated commands).