Template:SQWareProduction sqwsyb CopyDumpAllDatabases.ksh help

From Wiki_dbSQWare
Revision as of 20:15, 2 June 2024 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 v2024.04 SQWareProduction for Sybase (dbSQWare) ... 

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

DESCRIPTION
   sqwsyb_CopyDumpAllDatabases.ksh copy dump all databases in parallel
SUPPORT
   Sybase supported versions: 12.5 <= v <= 16.0

PARAMETERS
     -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       : List of databases to copy (by default all).
     -ED   listdb       : List of databases 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 holding dump files (by default /$(echo ${HOME}|cut -d/ -f2)/syb_dump/$DSQUERY).
     -RDS  directory    : Directory holding source dump files (by default /$(echo ~$lvsqw_UserUnixSource|cut -d/ -f2)/syb_dump/$lvsqw_DataserverSource).
     -UUS  username     : Source unix user(by default, same as target).
     -WCD  whereclause  : Where clause to generate databases list.
     -AGR Nb_sec        : Nb of seconds between two runs (by default 10s).
     -AGE Nb_sec        : Nb of seconds between two checks of end (by default 30s).
     -FRT       code    : Force return code value on error.
     -Type type         : Dump type full,inc,finc,stb,fstb (by default full).
     -Local             : use local copy (cp) instead of remote copy (rsync).
     -NoMail            : Deactivate 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.
     -AddFlagName mflag : Search dumps with '.mflag' at end of name.
     -h                 : Display the full usage.
     -s                 : Display samples of usage.
     -Locale    locale  : Force Locale for help display (fr,en).
     -Exec              : Execute commands (by default, display generated commands).