SQWareProduction:sybase:etc:sqwsyb Template.cfg

From Wiki_dbSQWare
Revision as of 16:53, 9 December 2018 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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
# 
# 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
# CGU/CGA for more details.
# 
# You should have received a copy of the CGU/CGA
# along with this program.  If not, see <http://www.dbsqware.com/licenses/>.
# 
# For information : contact@dbsqware.com or www.dbsqware.com
###################################################################
## @Synopsis	Template for overLoad default paramaters of 'All' scripts
## @Copyright	Copyright 2010-2019, dbSQWare (www.dbsqware.com)

##################
##Disable all job for this database
#all=no

##################
##Disable update statistics job for this database
#Statistics=no
#Statistics_SizeMaxTable=1024 (size max in Mo for tables to take into account)

##################
##Disable update index statistics job 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 job 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 job 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 job for this database
#Dbcc=no

##Disable Checkstorage job for this database
#Checkstorage=no