Difference between revisions of "SQWareProduction:sybase:etc:sqwsyb Template.cfg"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Line 24: | Line 24: | ||
# For information : contact@dbsqware.com or www.dbsqware.com | # For information : contact@dbsqware.com or www.dbsqware.com | ||
################################################################### | ################################################################### | ||
− | ## @Synopsis Template for | + | ## @Synopsis Template for overLoad default paramaters of 'All' scripts |
− | ## @Copyright Copyright 2010- | + | ## @Copyright Copyright 2010-2014, OctopusDBA (www.octopusdba.com) |
## @License GPL v3 | ## @License GPL v3 | ||
− | |||
− | |||
################## | ################## | ||
Line 35: | Line 33: | ||
################## | ################## | ||
− | ##Disable update | + | ##Disable update Statisticsistics treatment for this database |
− | # | + | #Statistics=no |
− | # | + | #Statistics_SizeMaxTable=1024 (size max in Mo for tables to take into account) |
################## | ################## | ||
− | ##Disable | + | ##Disable update index Statisticsistics treatment for this database |
− | # | + | #UpdtStats=no |
− | # | + | #UpdtStats_SizeMaxTable=102400 (size max in Mo for tables to take into account) |
− | # | + | #UpdtStats_DefUpdtStatsType=index ('',index,table,all) |
− | # | + | #UpdtStats_MinPctChange=10 |
################## | ################## | ||
− | ##Disable | + | ##Disable Rebuild treatment for this database |
− | # | + | #Rebuild=no |
− | # | + | #Rebuild_SizeMinTable=1024 (size min in Mo for tables to take into account) |
− | # | + | #Rebuild_SizeMaxTable=102400 (size max in Mo for tables to take into account) |
− | + | #Rebuild_CluRatioMinTable=80 (Rebuild table when cluster ratio of table is lower than) | |
− | # | + | #Rebuild_CluRatioMinIndex=90 (Rebuild index or table for ASE<15 when cluster ratio of index is lower than) |
− | # | ||
################## | ################## | ||
− | ##Disable | + | ##Disable Dump treatment for this database |
− | # | + | #Dump=no |
+ | #Dump_CompLevel=1 (Compression level) | ||
+ | #Dump_CompRate=25 (Estimated rate of compression) | ||
+ | #Dump_NbGeneration=4 (Nb of generations to keep) | ||
+ | #Dump_NbStripe=5 (Nb of strip) | ||
+ | #Dump_MaxSizeStrip=4096 (size max of a strip) | ||
+ | #Dump_DumpSyslogins=no (no Dump syslogins table) | ||
− | ##Disable | + | ################## |
− | # | + | ##Disable Dbcc treatment for this database |
+ | #Dbcc=no | ||
+ | |||
+ | ##Disable Checkstoragestorage treatment for this database | ||
+ | #Checkstorage=no | ||
</pre> | </pre> | ||
<br> | <br> |
Revision as of 17:35, 5 April 2014
Configuration file $gvsqw_SybBin/../etc/sqwsyb_Template.cfg:
Template for overLoad default paramaters of 'All' scripts
File content:
#!/bin/ksh ################################################################### # SQWareProduction for Sybase module of dbSQWare is developped with GPL License 3.0 : # # This program is free software: you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation, either version 3 of the License, or # (at your option) any later version. # # dbSQWare is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS for a PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program. If not, see <http://www.gnu.org/licenses/>. # # For information : contact@dbsqware.com or www.dbsqware.com ################################################################### ## @Synopsis Template for overLoad default paramaters of 'All' scripts ## @Copyright Copyright 2010-2014, OctopusDBA (www.octopusdba.com) ## @License GPL v3 ################## ##Disable all treatment for this database #all=no ################## ##Disable update Statisticsistics treatment for this database #Statistics=no #Statistics_SizeMaxTable=1024 (size max in Mo for tables to take into account) ################## ##Disable update index Statisticsistics treatment for this database #UpdtStats=no #UpdtStats_SizeMaxTable=102400 (size max in Mo for tables to take into account) #UpdtStats_DefUpdtStatsType=index ('',index,table,all) #UpdtStats_MinPctChange=10 ################## ##Disable Rebuild treatment for this database #Rebuild=no #Rebuild_SizeMinTable=1024 (size min in Mo for tables to take into account) #Rebuild_SizeMaxTable=102400 (size max in Mo for tables to take into account) #Rebuild_CluRatioMinTable=80 (Rebuild table when cluster ratio of table is lower than) #Rebuild_CluRatioMinIndex=90 (Rebuild index or table for ASE<15 when cluster ratio of index is lower than) ################## ##Disable Dump treatment for this database #Dump=no #Dump_CompLevel=1 (Compression level) #Dump_CompRate=25 (Estimated rate of compression) #Dump_NbGeneration=4 (Nb of generations to keep) #Dump_NbStripe=5 (Nb of strip) #Dump_MaxSizeStrip=4096 (size max of a strip) #Dump_DumpSyslogins=no (no Dump syslogins table) ################## ##Disable Dbcc treatment for this database #Dbcc=no ##Disable Checkstoragestorage treatment for this database #Checkstorage=no