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

From Wiki_dbSQWare
Jump to navigation Jump to search
Exploit (talk | contribs)
0 edits
m Updated by Expdbtools
 
m Updated by BatchUser
 
(17 intermediate revisions by 2 users not shown)
Line 5: Line 5:
File content:
File content:
<pre>
<pre>
#!/bin/ksh
#!/bin/bash
###################################################################
###################################################################
# SQWareProduction for Sybase module of expdbTools is developped with GPL Licence 3.0 :
# SQWareProduction for Sybase module of dbSQWare
# trademark => dbSQWare�
#
# 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.
#  
#  
# This program is distributed in the hope that it will be useful,
# dbSQWare is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS for a PARTICULAR PURPOSE.  See the
# MERCHANTABILITY or FITNESS for a PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
# CGU/CGA for more details.
#  
#  
# You should have received a copy of the GNU General Public License
# You should have received a copy of the CGU/CGA
# along with this program.  If not, see <http://www.gnu.org/licenses/>.
# along with this program.  If not, see <http://www.dbsqware.com/licenses/>.
#  
#  
# For information : contact@dbsqware.com or www.dbsqware.com
# For information : contact@dbsqware.com or www.dbsqware.com
###################################################################
###################################################################
## @Synopsis Template for overload default paramaters of 'All' scripts
## @Synopsis Template for overLoad default paramaters of 'All' scripts
## @Copyright Copyright 2010-2011, Michel PAYAN
## @Copyright Copyright 2007-2025, dbSQWare (www.dbsqware.com)
## @License GPL v3
## SVN : $URL$
## SVN : $Id$


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


##################
##################
##Disable update statistices treatment for this database
##Disable update statistics job for this database
#stat=no
#Statistics=no
#stat_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 rebuild treatment for this database
##Disable update index statistics job for this database
#rebuild=no
#UpdtStats=no
#rebuild_SizeMinTable=1024  (size min in Mo for tables to take into account)
#UpdtStats_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)
#UpdtStats_DefUpdtStatsType=index ('',index,table,all)
#rebuild_CluRatioMinIndex=90 (rebuild index or table for ASE<15 when cluster ratio of index is lower than)
#UpdtStats_MinPctChange=10


##################
##################
##Disable dump treatment for this database
##Disable Rebuild job for this database
#dump=no
#Rebuild=no
#dump_CompLevel=1      (Compression level)
#Rebuild_SizeMinTable=1024  (size min in Mo for tables to take into account)
#dump_CompRate=25      (Estimated rate of compression)
#Rebuild_SizeMaxTable=102400 (size max in Mo for tables to take into account)
#dump_NbGeneration=4    (Nb of generations to keep)
#Rebuild_CluRatioMinTable=80 (Rebuild table when cluster ratio of table is lower than)
#dump_NbStripe=5        (Nb of strip)
#Rebuild_CluRatioMinIndex=90 (Rebuild index or table for ASE<15 when cluster ratio of index is lower than)
#dump_MaxSizeStrip=4096 (size max of a strip)


##################
##################
##Disable dbcc treatment for this database
##Disable Dump job for this database
#dbcc=no
#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 checkstorage treatment for this database
##################
#check=no
##Disable Dbcc job for this database
#Dbcc=no
 
##Disable Checkstorage job for this database
#Checkstorage=no
</pre>
</pre>
{{SQWareProductionSurchargeEtc|sybase|Syb|sqwsyb_Template.cfg}}
<br>
<br>

Latest revision as of 16:03, 23 February 2025

Configuration file $gvsqw_SybBin/../etc/sqwsyb_Template.cfg:
Template for overLoad default paramaters of 'All' scripts


File content: 

#!/bin/bash
###################################################################
# 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 2007-2025, 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


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:sybase:etc:sqwsyb_Template.cfg&oldid=30132"