Difference between revisions of "Template:SQWareProduction sqwsyb LoadDatabase.ksh presentation"
m (Updated by Expdbtools) |
m (Updated by BatchUser) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <br>Standard database | + | <br>Standard database Load sybase |
| − | <br>script dynamically find dump files to | + | <br>script dynamically find dump files to Load |
| − | <br>You can choose type of | + | <br>You can choose type of Load (by 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( | + | <br>You can choose to online database or not(default on): |
* on -> online | * on -> online | ||
* off -> not online | * off -> not online | ||
* 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 |
Latest revision as of 16: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
