Difference between revisions of "SQWareProduction:sybase:etc:sqwsyb Template.cfg"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 23: Line 23:
  
 
##################
 
##################
##Disable all treatment for this database
+
##Disable all job for this database
 
#all=no
 
#all=no
  
 
##################
 
##################
##Disable update statistics treatment for this database
+
##Disable update statistics job for this database
 
#Statistics=no
 
#Statistics=no
 
#Statistics_SizeMaxTable=1024 (size max in Mo for tables to take into account)
 
#Statistics_SizeMaxTable=1024 (size max in Mo for tables to take into account)
  
 
##################
 
##################
##Disable update index statistics treatment for this database
+
##Disable update index statistics job for this database
 
#UpdtStats=no
 
#UpdtStats=no
 
#UpdtStats_SizeMaxTable=102400 (size max in Mo for tables to take into account)
 
#UpdtStats_SizeMaxTable=102400 (size max in Mo for tables to take into account)
Line 39: Line 39:
  
 
##################
 
##################
##Disable Rebuild treatment for this database
+
##Disable Rebuild job for this database
 
#Rebuild=no
 
#Rebuild=no
 
#Rebuild_SizeMinTable=1024  (size min in Mo for tables to take into account)
 
#Rebuild_SizeMinTable=1024  (size min in Mo for tables to take into account)
Line 47: Line 47:
  
 
##################
 
##################
##Disable Dump treatment for this database
+
##Disable Dump job for this database
 
#Dump=no
 
#Dump=no
 
#Dump_CompLevel=1      (Compression level)
 
#Dump_CompLevel=1      (Compression level)
Line 57: Line 57:
  
 
##################
 
##################
##Disable Dbcc treatment for this database
+
##Disable Dbcc job for this database
 
#Dbcc=no
 
#Dbcc=no
  
##Disable Checkstorage treatment for this database
+
##Disable Checkstorage job for this database
 
#Checkstorage=no
 
#Checkstorage=no
 
</pre>
 
</pre>
 
<br>
 
<br>

Revision as of 21:40, 9 September 2018

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-2018, 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