Template:SQWareProduction sqwsyb LoadDatabase.ksh presentation: Difference between revisions
Jump to navigation
Jump to search
m Updated by Expdbtools |
m Updated by BatchUser |
||
| Line 1: | Line 1: | ||
<br>Standard database | <br>Standard database Load sybase | ||
<br>script dynamically find | <br>script dynamically find Dump files to Load | ||
<br>You can choose type of | <br>You can choose type of Load (default full): | ||
* full -> | * full -> Load full Dump | ||
* inc -> | * inc -> Load Dump tran | ||
* stb -> | * stb -> Load Dump tran for standby | ||
* fstb -> | * fstb -> Load full Dump plus Dump tran for standby | ||
<br>You can choose to online database or not(defaut on): | <br>You can choose to online database or not(defaut on): | ||
* on -> online | * on -> online | ||
| Line 11: | Line 11: | ||
* ostb -> online for standby access | * ostb -> online for standby access | ||
<br>The script can also: | <br>The script can also: | ||
* kill connected sessions on the database to | * kill connected sessions on the database to Load | ||
* make a synchronisation of syslogins/sysusers | * make a synchronisation of syslogins/sysusers | ||
* run shell script before | * run shell script before Load | ||
* run shell script after | * run shell script after Load | ||
Revision as of 18:47, 5 April 2014
Standard database Load sybase
script dynamically find Dump files to Load
You can choose type of Load (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(defaut 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