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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by Expdbtools)
 
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(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 load
+
* kill connected sessions on the database to Load
 
* make a synchronisation of syslogins/sysusers
 
* make a synchronisation of syslogins/sysusers
* run shell script before load
+
* run shell script before Load
* run shell script after load
+
* 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