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 (default full):
* full -> Load full Dump
+
* full -> Load full dump
* inc  -> Load Dump tran
+
* inc  -> Load dump tran
* stb  -> Load Dump tran for standby
+
* stb  -> Load dump tran for standby
* fstb -> Load full Dump plus Dump tran for standby
+
* 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(default on):
 
* on  -> online
 
* on  -> online
 
* off  -> not online
 
* off  -> not online

Revision as of 19:37, 8 March 2020


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(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