Difference between revisions of "Template:SQWareProduction sqwsyb LoadDatabase.ksh presentation"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
Line 1: Line 1:
 
<br>Standard database Load sybase
 
<br>Standard database Load sybase
 
<br>script dynamically find dump files to Load
 
<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 dump
 
* full -> Load full dump
 
* inc  -> Load dump tran
 
* inc  -> Load dump tran

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