Difference between revisions of "Template:SQWareProduction sqwsyb CopyDumpAllDatabases.ksh help"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Line 1: | Line 1: | ||
<pre> | <pre> | ||
− | Sourcing sqwsyb_Global.lib v4.0. | + | Sourcing sqwsyb_Global.lib v4.0.04 SQWareProduction for Sybase (dbSQWare) ... |
Usage: sqwsyb_CopyDumpAllDatabases.ksh [-h] -S|-I <dataserver> -SS <SourceDataserver> [ -US <SourceHostname> | -Local ] [+ options] | Usage: sqwsyb_CopyDumpAllDatabases.ksh [-h] -S|-I <dataserver> -SS <SourceDataserver> [ -US <SourceHostname> | -Local ] [+ options] |
Revision as of 17:58, 25 March 2018
Sourcing sqwsyb_Global.lib v4.0.04 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. -Exec : Execute commands (default, display generated commands)