Template:SQWareProduction sqwsyb CopyDumpAllDatabases.ksh help

From Wiki_dbSQWare
Revision as of 08:56, 26 September 2019 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 v2019.05 SQWareProduction for Sybase (dbSQWare) ... 

Usage: sqwsyb_CopyDumpAllDatabases.ksh [-h] -S|-I <dataserver> -SS <SourceDataserver> [ -US <SourceHostname> | -Local ] [+ options]

DESCRIPTION
   sqwsyb_CopyDumpAllDatabases.ksh copy of Dump all databases in //
SUPPORT
   Sybase supported versions: 12.5 <= v <= 16.0

PARAMETERS
     -S|-I  dataserver  : Target dataserver.
     -SS dataserver     : Source dataserver.
     -US hostname       : Source hostname.
OPTIONS
     -P  Nb threads     : Number of threads in parallel (by default 2).
     -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%').
     -HI   Nb           : Nb of generations to keep (by default 1).
     -RD   directory    : Directory to find Dump file (default /$(echo ${HOME}|cut -d/ -f2)/syb_dump/$DSQUERY).
     -RDS  directory    : Directory to find source Dump file (default /$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/syb_dump/$lvsqw_DataserverSource).
     -UUS  username     : User unix source(by default, same of target).
     -WCD  whereclause  : Where clause to generate databases list.
     -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).
     -FRT  return_code  : Force return code value on error.
     -Type type         : Dump type full,inc,stb,fstb (defaut full).
     -Local             : use local copy (cp) instead of remote copy (scp).
     -NoMail            : Desactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
     -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.
     -Locale   locale   : Force Locale for help display (fr,en).
     -Exec              : Execute commands (default, display generated commands)