Template:SQWareProduction sqwmng CopyDumpAllDatabases.ksh example: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
m Updated by BatchUser |
||
Line 1: | Line 1: | ||
<pre> | <pre> | ||
Sourcing sqwmng_Global.lib v2021. | Sourcing sqwmng_Global.lib v2021.06 SQWareProduction for MongoDB (dbSQWare) ... | ||
#Standard help for script sqwmng_CopyDumpAllDatabases.ksh: | #Standard help for script sqwmng_CopyDumpAllDatabases.ksh: | ||
# XXXXX : -RD | |||
# XXXXX : -RDS | |||
# XXXXX : -UUS | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -h | |||
#Display online help for this script | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -NoMail | |||
#Deactivate sendmail on error to $gvsqw_GlobalMail (by default, send on error) | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -Locale en -h | |||
#Display online help for this script with forcing of the 'fr' locale (default locale managed by the variable gvsqw_Locale) | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -s | |||
#Display usage examples for this script | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -AddMail 'mymail1@mydomaine.com,mymail2@mydomaine.com' | |||
#Add the mail list to the default address managed by the variable gvsqw_GlobalMail | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -SendReport | |||
#Send the log by email at the end of the treatment even if there is no error | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -AGR 20 | |||
#Set the waiting time in seconds between two command run, 20s here | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -AGE 30 | |||
#Set the waiting time in seconds between two end checks, 30s here | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -HI <NumberOfGenerations> -Exec | |||
#Changes the number of backup generations to keep | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -IS <InstanceSource> -US <HostnameSource> | |||
#Generate commands but don't execute them ! | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -FRT <NumericValue> -Exec | |||
#Force return code to '<NumericValue>' on error (if no error, exit 0!) | |||
#You can also force return code of this script on all your | |||
#environnement if you set the variable: $gvsqw_ForcedReturnCodeScript_sqwmng_CopyDumpAllDatabases=<NumericValue> | |||
#in configuration file $gvsqw_MngBin/../etc_cust/sqwmng_GlobalVar.cfg | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -P <NumericValue> -Exec | |||
#Run sqwmng_CopyDumpAllDatabases.ksh script with a parallel degree of '<NumericValue>' | |||
#Use by default the variable gvsqw_NbThreadXXX in $gvsqw_MgBin/../etc/sqwmng_GlobalVar.cfg | |||
#You can change this default on all your environnement if you set this variable | |||
#in configuration file $gvsqw_MngBin/../etc_cust/sqwmng_GlobalVar.cfg | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -ID <listdb> | |||
#Generate database list with 'in list': | |||
#=> and name in ('$ListInclude') | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -ED <listdb> -Dist | |||
#Generate database list with 'not in list': | |||
#=> and name not in ('$ListExclude') | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -IL <likeclause> | |||
#Generate database list with 'like': | |||
#=> and name like 'LikeClause' | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -EL <likeclause> | |||
#Generate database list with 'not like': | |||
#=> and name not like 'NotLikeClause' | |||
$gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -WCD <whereclause> | |||
#Generate database list with 'where clause': | |||
#=> and 'WhereClause' | |||
</pre> | </pre> |
Revision as of 21:34, 27 September 2021
Sourcing sqwmng_Global.lib v2021.06 SQWareProduction for MongoDB (dbSQWare) ... #Standard help for script sqwmng_CopyDumpAllDatabases.ksh: # XXXXX : -RD # XXXXX : -RDS # XXXXX : -UUS $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -h #Display online help for this script $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -NoMail #Deactivate sendmail on error to $gvsqw_GlobalMail (by default, send on error) $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -Locale en -h #Display online help for this script with forcing of the 'fr' locale (default locale managed by the variable gvsqw_Locale) $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -s #Display usage examples for this script $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -AddMail 'mymail1@mydomaine.com,mymail2@mydomaine.com' #Add the mail list to the default address managed by the variable gvsqw_GlobalMail $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -SendReport #Send the log by email at the end of the treatment even if there is no error $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -AGR 20 #Set the waiting time in seconds between two command run, 20s here $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -AGE 30 #Set the waiting time in seconds between two end checks, 30s here $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -HI <NumberOfGenerations> -Exec #Changes the number of backup generations to keep $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -IS <InstanceSource> -US <HostnameSource> #Generate commands but don't execute them ! $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -FRT <NumericValue> -Exec #Force return code to '<NumericValue>' on error (if no error, exit 0!) #You can also force return code of this script on all your #environnement if you set the variable: $gvsqw_ForcedReturnCodeScript_sqwmng_CopyDumpAllDatabases=<NumericValue> #in configuration file $gvsqw_MngBin/../etc_cust/sqwmng_GlobalVar.cfg $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -P <NumericValue> -Exec #Run sqwmng_CopyDumpAllDatabases.ksh script with a parallel degree of '<NumericValue>' #Use by default the variable gvsqw_NbThreadXXX in $gvsqw_MgBin/../etc/sqwmng_GlobalVar.cfg #You can change this default on all your environnement if you set this variable #in configuration file $gvsqw_MngBin/../etc_cust/sqwmng_GlobalVar.cfg $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -ID <listdb> #Generate database list with 'in list': #=> and name in ('$ListInclude') $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -ED <listdb> -Dist #Generate database list with 'not in list': #=> and name not in ('$ListExclude') $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -IL <likeclause> #Generate database list with 'like': #=> and name like 'LikeClause' $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -EL <likeclause> #Generate database list with 'not like': #=> and name not like 'NotLikeClause' $gvsqw_MngBin/sqwmng_CopyDumpAllDatabases.ksh -I $MNG_SID -WCD <whereclause> #Generate database list with 'where clause': #=> and 'WhereClause'