Difference between revisions of "SQWareProduction:sybase:bin:sqwsyb LoadDatabase.ksh"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Line 10: | Line 10: | ||
| | | | ||
<pre> | <pre> | ||
− | + | Not sending mail because you are in connected mode !!! | |
− | + | Lack 'dataserver' parameter | |
− | |||
</pre> | </pre> | ||
| | | | ||
{{SQWareProduction_sqwsyb_LoadDatabase.ksh_example}} | {{SQWareProduction_sqwsyb_LoadDatabase.ksh_example}} | ||
}} | }} |
Latest revision as of 15:44, 2 July 2021
Contents
Presentation
Script $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh :
Standard database Load sybase
script dynamically find dump files to Load
You can choose type of Load (by default full):
- full -> Load full dump
- inc -> Load dump tran
- stb -> Load dump tran for standby
- fstb -> Load full dump plus dump tran for standby
You can choose to online database or not(default on):
- on -> online
- off -> not online
- ostb -> online for standby access
The script can also:
- kill connected sessions on the database to Load
- make a synchronisation of syslogins/sysusers
- run shell script before Load
- run shell script after Load
Online help
The online help is available for most scripts with the -h option.
Ex: $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -h
Content of this assistance :
Sourcing sqwsyb_Global.lib v2024.07 SQWareProduction for Sybase (dbSQWare) ... Usage: sqwsyb_LoadDatabase.ksh [[-h]] -I <dataserver> -DT <DatabaseTarget> [[+ options]] DESCRIPTION sqwsyb_LoadDatabase.ksh load $lvsqw_LoadType SUPPORT Sybase supported versions: 12.5 <= v <= 16.0 PARAMETERS -I dataserver : Target dataserver. -DT DatabaseTarget : Target database. OPTIONS -h : Display the full usage. -s : Display samples of usage. -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. -DS DatabaseSource : Source database (by default same than -DT). -O on,off,ostb : Type online (by default on). -F file : Dump file to load (by default take the latest). -DD date_dump : Dump date to load (by default take the latest). -RD directory : Directory holding dump file (by default /$(echo ${HOME}|cut -d/ -f2)/syb_dump/$DSQUERY). -FRT code : Force return code value on error. -Before script : Script to execute before load. -After script : Script to execute after load. -Type type : Type de load full,inc,stb,fstb (by default full). -Chk : Check database size before load. -Lock : Lock all logins during load. -Kill : Kill connexion on loaded database. -Shut : Run "dbcc dbreboot('shutdown_load',dbname)" before load database (12.5.4 ESD1 and 15.0.2). -Rsync : Synchronize sysusers and sysalternates with master..syslogins (by default no). -LtmIgnore : Execute 'dbcc settrunc (ltm,ignore)' after load. -CrossPlatform : Execute sp_post_xpload after load. -AddFlagName mflag : Search dumps with '.mflag' at end of name. -Upgrade : Execute sp_checkreswords,sp_checksource,dbcc upgrade_object after load. -Locale locale : Force Locale for help display (fr,en). -Exec : Run load $lvsqw_LoadType (by default, display generated commands).
Error management
Errors passing arguments
This type of message is generated:
Lack 'dataserver' parameter, Usage: sqwsyb_LoadDatabase.ksh [[-h]] -I <dataserver> -DT <DatabaseTarget> [[+ options]] For full help : sqwsyb_LoadDatabase.ksh -h
If you are connecting through a terminal, no mail will be sent and you will have more this kind of message:
Not sending mail because you are in connected mode !!! Lack 'dataserver' parameter
If you are not connected to a terminal, the error message appears and is sent by mail to the address contained in the variable $gvsqw_GlobalMail (See help customize this variable). The subject line will always start by "$gvsqw_MailMsg_sybase : " (See help customize this variable).
Execution errors
Whether you are or not connected to a terminal, the error message appears and an email containing a summary of treatment errors is sent to the address contained in the variable $gvsqw_Mail_sybase (See help customize this variable). The subject line will always start by "$gvsqw_MailMsg_sybase : " (See help customize this variable).
Usage examples
Sourcing sqwsyb_Global.lib v2024.07 SQWareProduction for Sybase (dbSQWare) ... #Standard help for script sqwsyb_LoadDatabase.ksh: $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -h #Display online help for this script $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -Locale en -h #Display online help for this script with forcing of the 'en' locale (by default locale managed by $gvsqw_Locale) $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -s #Display usage examples for this script $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> #Generate commands but don't execute them ! $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -Exec #Load the dump for only one database $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -RD <DirName> -O <Type> -Exec #Specifies the dump path, and the type of target database (on/off/ostb. By default, on) $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -DS <DataserverSource> -Exec #Spedifies dataserver source of dump $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -DD <Date> -After <script> -Exec Specifies the date of the dump to be loaded (by default, the lastest), then executes a script after loading. $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -Chk -Before <script> -Exec #Check the database size, and executes a script before loading the dump $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -Lock -Exec #Lock all logins during dump's loading $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -Shut -Exec #Execute \"dbcc dbreboot('shutdown_load',dbname)\" before loading $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -CrossPlatform -Exec #Execute sp_post_xpload after loading $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -AddFlagName -Exec #Load dump file whose name end by '.mflag' $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -Upgrade -Exec Execute sp_checkreswords,sp_checksource,dbcc upgrade_object after loading $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -Type <TypedeDump> -F <File> -Exec #Execute a load database of type <TypedeDump> of the target database with the specified file <File>. $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -Kill -Rsync -Exec #Kill users connection before Load and made synchronisation of syslogins/sysusers $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -AddMail 'mymail1@mydomaine.com,mymail2@mydomaine.com' -Exec #Add the mail list to the default address managed by the variable gvsqw_GlobalMail $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -SendReport -Exec #Send the log by email at the end of the treatment even if there is no error $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -NoMail -Exec #Disables sending an email on error to $gvsqw_GlobalMail (by default, send on error) $gvsqw_SybBin/sqwsyb_LoadDatabase.ksh -I $DSQUERY -DT <DbName> -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_sqwsyb_LoadDatabase=<NumericValue> #in configuration file $gvsqw_SybBin/../etc_cust/sqwsyb_GlobalVar.cfg