Template:SQWareProduction sqwsyb LoadDatabase.ksh presentation: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
m Updated by BatchUser |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
<br>Standard database Load sybase | <br>Standard database Load sybase | ||
<br>script dynamically find | <br>script dynamically find dump files to Load | ||
<br>You can choose type of Load (default full): | <br>You can choose type of Load (by default full): | ||
* full -> Load full | * full -> Load full dump | ||
* inc -> Load | * inc -> Load dump tran | ||
* stb -> Load | * stb -> Load dump tran for standby | ||
* fstb -> Load full | * fstb -> Load full dump plus dump tran for standby | ||
<br>You can choose to online database or not( | <br>You can choose to online database or not(default on): | ||
* on -> online | * on -> online | ||
* off -> not online | * off -> not online | ||
Latest revision as of 17:12, 7 April 2024
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