#=========================================================================
# Copyright (C) VMware, Inc. 1986-2011.  All Rights Reserved.
#
# Name - medium.conf
#
# Purpose - Example of how to configure a medium database
#
#   Options below are suggested for configuring stone for a medium database
#   The example "medium" configuration is for
#     250 users, 10GB database, 1.5 GB SPC , 8 extents. 
#     Your hardware should have at least 3 GB of Ram.
#
#   See system.conf for a complete list of available options including
#   descriptive comments.
#
# $Id: configmedium.unix,v 1.6 2008-01-09 22:50:40 stever Exp $
#
#=========================================================================

# Set STN_MAX_SESSIONS to number of sessions + number of reclaim GcGem 
# sessions + 1 each for Admin GcGem, Page Manager, Symbol Gem + 10%
STN_MAX_SESSIONS = 280;

# STN_SIGNAL_ABORT_CR_BACKLOG should be about twice the expected number 
# of sessions
STN_SIGNAL_ABORT_CR_BACKLOG = 400;

# STN_CR_BACKLOG_THRESHOLD should greater than STN_SIGNAL_ABORT_CR_BACKLOG 
STN_CR_BACKLOG_THRESHOLD = 500;  

# Increase the Stone's private page cache
STN_PRIVATE_PAGE_CACHE_KB = 16384;

# 1.5 GB shared cache.  Unix kernel must support a shared memory
# region of at least 1550 MB (including cache overhead).
SHR_PAGE_CACHE_SIZE_KB = 1500000;

# Assume 8 extents of 2 GB each, on raw disk partitions.
# Edit this list to specify your actual partition names and sizes.
# For optimal performance, the DBF_EXTENT_SIZES be slightly smaller than
# the actual size of the disk partitions. 
DBF_EXTENT_NAMES = /dev/extent0, /dev/extent1, /dev/extent2, ...;
DBF_EXTENT_SIZES = 1995, 1995, 1995, 1995, ... ;

# Spread the database equally across all extents. For optimal performance
# the weighting factors should be about 10 (instead of 1, 1, 1, ...).
DBF_ALLOCATION_MODE = 10, 10, 10,...;

# Increase the free space STN_FREE_SPACE_THRESHOLD to allow disk full 
# conditions to be handled.
STN_FREE_SPACE_THRESHOLD = 100;

# pre-grow the extents for best performance.
DBF_PRE_GROW = TRUE;

# Use full logging for best performance on most large databases.
STN_TRAN_FULL_LOGGING = TRUE;

# Assume 5 raw partitions of .5 MB each dedicated to tranlogs.
# Edit this list to put in your actual number of partitions and names.
STN_TRAN_LOG_DIRECTORIES = /dev/logPartition1, /dev/logPartition2,
   /dev/logPartition3, /dev/logPartition4, ... ;

# Edit STN_TRAN_LOG_SIZES to match actual sizes of your partitions.
# For best performance, these sizes should be slightly smaller than the
# actual size of the disk partitions.
STN_TRAN_LOG_SIZES = 499, 499, 499, ... ;

# Increase the number of Reclaim GcGem sessions; start with one Reclaim 
# GcGem per 4 extents.
STN_NUM_GC_RECLAIM_SESSIONS = 2;

# Increase the number of free frame page servers.
SHR_NUM_FREE_FRAME_SERVERS = 2;

# Increase the number of aio page servers.
STN_NUM_LOCAL_AIO_SERVERS = 4;

#  end of example options
#=========================================================================

#=========================================================================
#  Options below here have been added, either by the GemStone system
#  administrator, or automatically by the database monitor (Stone).
#=========================================================================

