Difference between revisions of "SQWareProduction:sybase:etc:sqwsyb Template.cfg"
m (Updated by Expdbtools) |
m (Updated by BatchUser) |
||
| (16 intermediate revisions by 2 users not shown) | |||
| Line 7: | Line 7: | ||
#!/bin/ksh | #!/bin/ksh | ||
################################################################### | ################################################################### | ||
| − | # SQWareProduction for Sybase module of | + | # 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 | # 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 | ||
| − | # | + | # CGU/CGA for more details. |
# | # | ||
| − | # You should have received a copy of the | + | # You should have received a copy of the CGU/CGA |
| − | # along with this program. If not, see <http://www. | + | # 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 | + | ## @Synopsis Template for overLoad default paramaters of 'All' scripts |
| − | ## @Copyright Copyright 2010- | + | ## @Copyright Copyright 2010-2024, dbSQWare (www.dbsqware.com) |
| − | |||
| − | |||
| − | |||
################## | ################## | ||
| − | ##Disable all | + | ##Disable all job for this database |
#all=no | #all=no | ||
################## | ################## | ||
| − | ##Disable update | + | ##Disable update statistics job for this database |
| − | # | + | #Statistics=no |
| − | # | + | #Statistics_SizeMaxTable=1024 (size max in Mo for tables to take into account) |
################## | ################## | ||
| − | ##Disable | + | ##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 | + | ##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 | + | ##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 | + | ################## |
| − | # | + | ##Disable Dbcc job for this database |
| + | #Dbcc=no | ||
| + | |||
| + | ##Disable Checkstorage job for this database | ||
| + | #Checkstorage=no | ||
</pre> | </pre> | ||
| − | |||
<br> | <br> | ||
Latest revision as of 21:19, 25 February 2024
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-2024, 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
