Template:SQWareProduction sqwsyb StatisticsDatabase.ksh help: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
No edit summary |
||
(24 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<pre> | <pre> | ||
Sourcing sqwsyb_Global.lib | Sourcing sqwsyb_Global.lib v2025.06 SQWareProduction for Sybase (dbSQWare) ... | ||
Usage: sqwsyb_StatisticsDatabase.ksh [-h] -I <dataserver> [+ options] | Usage: sqwsyb_StatisticsDatabase.ksh [-h] -I <dataserver> [+ options] | ||
Line 13: | Line 13: | ||
-D database : Database name. | -D database : Database name. | ||
OPTIONS | OPTIONS | ||
-h | -h : Display the full usage. | ||
-s : Display samples of usage. | -s : Display samples of usage. | ||
-NoMail : Deactivate sendmail on error | -NoMail : Deactivate sendmail on error demo-sqwarebox@dbsqware.com (by default, send on error). | ||
-SizeMaxTable Size : Take into account tables = | -SizeMaxTable Size : Take into account tables <= $lvsqw_SizeMaxTable Mb (by default, 50000 Mb). | ||
-FRT | -FRT code : Force return code value on error. | ||
-AddMail email | -AddMail email : Email address to add at 'demo-sqwarebox@dbsqware.com'. | ||
-SendReport : Send execution log report. | -SendReport : Send execution log report. | ||
-Dist : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser ). | -Dist : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser ). | ||
-Locale | -Locale locale : Force Locale for help display (fr,en). | ||
-Exec : Run update statistics (default, display generated commands). | -Exec : Run update statistics (by default, display generated commands). | ||
</pre> | </pre> |
Latest revision as of 18:53, 1 July 2025
Sourcing sqwsyb_Global.lib v2025.06 SQWareProduction for Sybase (dbSQWare) ... Usage: sqwsyb_StatisticsDatabase.ksh [-h] -I <dataserver> [+ options] DESCRIPTION sqwsyb_StatisticsDatabase.ksh update statistics of tables SUPPORT Sybase supported versions: 12.0 <= v <= 16.0 PARAMETERS -I dataserver : Target dataserver. -D database : Database name. OPTIONS -h : Display the full usage. -s : Display samples of usage. -NoMail : Deactivate sendmail on error demo-sqwarebox@dbsqware.com (by default, send on error). -SizeMaxTable Size : Take into account tables <= $lvsqw_SizeMaxTable Mb (by default, 50000 Mb). -FRT code : Force return code value on error. -AddMail email : Email address to add at 'demo-sqwarebox@dbsqware.com'. -SendReport : Send execution log report. -Dist : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser ). -Locale locale : Force Locale for help display (fr,en). -Exec : Run update statistics (by default, display generated commands).