Template:SQWareProduction sqwsyb DbccAllDatabases.ksh help

From Wiki_dbSQWare
Revision as of 17:58, 25 March 2018 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Sourcing sqwsyb_Global.lib v4.0.04 SQWareProduction for Sybase (dbSQWare) ... 

Usage: sqwsyb_DbccAllDatabases.ksh [-h] -S|-I <dataserver> [+ options]

DESCRIPTION
   sqwsyb_DbccAllDatabases.ksh Dbcc all databases in //
SUPPORT
   Sybase supported versions: 12.0 <= v <= 16.0

PARAMETERS
     -S|-I  dataserver  : Target dataserver to Dbcc.
OPTIONS
     -ID   listdb       : Databases list for running analyze tables (by default all).
     -ED   listdb       : Databases list to exclude.
     -IL   likeclause   : Like clause to generate databases list (example: 'db%').
     -EL   likeclause   : Like clause to exclude databases (example: 'nodb%').
     -WCD  whereclause  : Where clause to generate databases list.
     -FRT  return_code  : Force return code value on error.
     -P  Nb threads     : Number of threads in parallel (by default 2).
     -AGR  Nb sec       : Nb of seconds between two run (by default 10s).
     -AGE  Nb sec       : Nb of seconds between two check of end (by default 30s).
     -NoMail            : Desactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
     -Dist              : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser ).
     -AddMail email     : Email Address to add at 'pmexpdba@gmail.com'.
     -SendReport        : Send execution log report.
     -h  help           : Display the full usage.
     -s                 : Display samples of usage.
     -Exec              : Execute commands (default, display generated commands)