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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by Expdbtools)
 
m (Updated by BatchUser)
Line 1: Line 1:
<br>Generate dump database
+
<br>Generate Dump database
<br>You can choose type of dump (default full):
+
<br>You can choose type of Dump (default full):
* full -> full dump
+
* full -> full Dump
* inc  -> dump tran
+
* inc  -> Dump tran
* stb  -> dump tran for standby
+
* stb  -> Dump tran for standby
* fstb -> full dump plus dump tran for standby
+
* fstb -> full Dump plus Dump tran for standby
 
<br>Script automatically determine how many stripes
 
<br>Script automatically determine how many stripes
<br>Makes backup of master..syslogins (permet to make synchronisation on load)
+
<br>Makes backup of master..syslogins (permet to make synchronisation on Load)
<br>Makes purges of dump generations
+
<br>Makes purges of Dump generations
 
<br>You can change default values:
 
<br>You can change default values:
 
* compression level
 
* compression level
 
* force number of stripes
 
* force number of stripes
 
* size max of a stripe
 
* size max of a stripe
* number of dump generations to keep online
+
* number of Dump generations to keep online

Revision as of 18:47, 5 April 2014


Generate Dump database
You can choose type of Dump (default full):

  • full -> full Dump
  • inc -> Dump tran
  • stb -> Dump tran for standby
  • fstb -> full Dump plus Dump tran for standby


Script automatically determine how many stripes
Makes backup of master..syslogins (permet to make synchronisation on Load)
Makes purges of Dump generations
You can change default values:

  • compression level
  • force number of stripes
  • size max of a stripe
  • number of Dump generations to keep online