The conmgr.properties file

The conmgr.properties file, another file whose values you might localize, stores properties of databases, configurations, and servergroups. This table shows the corresponding parameter name and default value for each property.

Table 1. Localizable properties in the conmgr.properties file
Property Corresponding startup parameter Description Default value
afterimagebuffers -aibufs Specifies the number of after-image buffers. 1
afterimagestall -aistall Suspends database activity if all AI files are filled. false
alternatebufferpool -aistall Specifes the number of blocks in the alternate buffer pool.
archivaldir -aistall Specifes the directories where the AI File Management utility writes the archived after-image files.
archivaldircreate -aiarcdircreate Directs the AI File Management utility to create the specified directories. 0
archivalinterval -aiarcinterval Specifes the extent switch interval for timed-mode archiving.
baseindex -baseindex Specifes the range of indexes for which you want to collect statistics.
basetable -baseindex Specifes the range of tables for which you want to collect statistics.
beforeimagebufferedwrites -r Enable or disable buffered I/O to the before-image file. false
beforeimagebuffers -bibufs Specifes the number of before-image buffers. This parameter is useful only when running the Before-image Writer (BIW). 5
beforeimageclusterage -G Specifies the number of seconds before OpenEdge reuses a before-image cluster. 60
beforeimagedelaywrites -Mf Specifes the value in seconds of the delay before the database engine writes out to disk the last before-image (BI) file records at the end of each transaction. 3
beforeimagestall -bistall Used with -bithold to quiet the database when the recovery log threshold is reached, without performing an emergency shutdown. false
bithold -bithold Sets the maximum size to which recovery log files can grow. 3
blocksindatabasebuffers -B Specifes the number of blocks in the database buffers. The optimum value depends on your application. 0
casetablename -cpcase Specifies the name of the case table used by the OpenEdge database server and the OpenEdge client.
classpath -classpath Identifies the Java classpath to use when starting an SQL server.
collationtable -cpcoll Specifies the name of a collation table within the convmap.cp file, or the name of a collation in the International Components for Unicode (ICU) library, used by the OpenEdge database server and the OpenEdge client
conversionmap -convmap Specifies the name and path of the compiled CONVMAP file used by the OpenEdge database server and the OpenEdge client
crashprotection -i Tells OpenEdge to run without using database integrity or database recovery. true
dbservicecommareasize -pica Sets the size of the database service communications area in Kb.
directio -directio Tell OpenEdge to open all files in unbuffered mode. false
eventlevel -evtlevel Specifies the level of information that OpenEdge writes to the Windows Application Event Log.
groupdelay -groupdelay Used to increase performance when Delayed BI File Write (-Mf) is set to zero. 0
hashtableentries -hash Specifies the number of hash table entries to use for a buffer pool. 0
indexrangesize -indexrangesize Specifies the number of indexes for which you want to collect statistics.
internalcodepage -cpinternal Specifies the name of the code page used internally by the OpenEdge database server
locktableentries -L Specifies the limits of the record locking table. 10000
tenantlocktablegovernor -LGovernor Specifies the percentage of the lock table that a tenant can occupy in a multi-tenant database. 100
locktablehasttablesize -lkhash Specifies the size of the hash table that controls access to the lock table.
logcharacterset -cplog Specifies the name of the code page used by the OpenEdge database's log file
maximumareas -maxAreas Specifies the highest area number available.
maxjtatransaction -maxxids Specifies the number of simultaneous JTA transactions allowed.
maxprivbuffersperuser -Bpmax Specifies the number of private buffers a connection can request through the private read-only buffers (-Bp) parameter.
maxservers -Mn Specifies the number of remote user servers that can be started by the broker process. 4
maxusers -n Specifies the total number of concurrent connections permitted. 20
napincrement -napinc Specifies the nap increment value. (Enterprise database only)
napmax -napmax Specifies the maximum time (in milliseconds) to sleep (nap) after the -spin value is exhausted due to failure to acquire a latch. 1
napsteps -napstep Specifies the nap time steps between nap time (-napstep)
pagewritermaxbuffers -pwwmax Specifies the maximum number of modified database buffers to write to disk during a buffer scan cycle. 25
pagewriterqueuedelay -pwqdelay Specifies the number of milliseconds between scans of the page writer queue. 100
pagewriterqueuemin -pwqmin Specifies the minimum number of buffers required on the page writer queue before an APW writes them to disk. 1
pagewriterscan -pwscan Specifies the number of buffers that an APW should scan during a buffer scan cycle. 1
pagewriterscandelay -pwsdelay -pwqdelay is a self-tuning parameter. When the database encounters heavy loads, -pwqdelay decreases its value so that the APW writes more often. When the demand on the database lessens, -pwqdelay increases its value so that the APW writes less often. 1
pendconnecttimeout -PendConnTime Specifies the number of seconds allowed the client to connect to a server.
semaphoresets -semsets Specifies the number of semaphore sets available to the OpenEdge broker. 1
sharedmemoryoverflowsize -semsets Specifies the size of the shared-memory overflow area in kilobytes.
sharedmemorypin -pinshm Used to prevent the database engine from swapping shared memory contents to disk, which can help improve performance.
sharedmemorysegmentsize -shmsegsize Specifies the size of the largest shared memory segment the server can allocate. -0g
spinlockretries -spin Specifies the number of times a process tries to acquire a latch before pausing. 0
sqlcursors -SQLCursors Specifies the maximum number of cursors open at any one time.
sqlstack -SQLStack Specifies the size of the SQL stack (an internal memory area used by SQL program modules).
sqlstmtcache -SQLStmtCache Specifies the number of statements that can be stored in the SQL cache.
sqltempbuff -SQLTempBuff Specifies the amount of memory to use as a data buffer for each SORT operation.
sqltempdisk -SQLTempDisk Specifies the size of the temporary file for backup storage for SORT and temp-table operations.
sqltemppgsize -SQLTempPgSize Specifies the size of the temporary table data page.
sqlyearoffset -yy Specifies the start of the 100-year period in which a date with a two-digit year is valid. 0
ssldisablesessioncache -nosessioncache Enables and disables TLS session caching.
sslenable -ssl Specifies a Transport Layer Security (TLS) connection to all database and client connections for data privacy.
sslkeyalias -keyalias Specifies a TLS keystore other than the default.
sslkeyaliaspassword -keyaliaspassword Specifies the encrypted TLS key alias password to use to access the server's keystore entry.
storageobjectsize -omsize Specifies the size of the object cache for all database objects. 1024
tablerangesize -tablerangesize Specifies the number of tables for which you want to track access statistics.
tenantmaxusergovernor -nGovernor Specifies the maximum number of users who can login for a tenant in a multi-tenant database. 32000
txecommitlockskiplimit -TXESkipLimit Specifies the number of number of times a connection will re-try to obtain TXE lock after a 1ms nap before getting queued.
usemuxlatches -mux Controls the granularity of access to large database resources in shared memory.
databasename -db Specifies the physical database name to connect to when an OpenEdge session is started.
host -H Specifies the name (address) of the database server machine. localhost
ipver -ipver Specifies the IP version for network connections. ipv4
maxclientsperserver -Ma Specifies the maximum number of remote users per database server. 0
maxdynamicport -maxport Specifies the highest port number in a specified range of port numbers accessible to a client. 0
messagebuffersize -Mm Specifies the standard message buffer size, in bytes. 1024
minclientsperserver -Mi Specifies the number of remote users on a server before the broker starts another server (up to the maximum number of servers). 1
mindynamicport -minport Specifies the lowest port number in a specified range of port numbers accessible to a client. 0
numberofservers -Mpb Specifies the maximum number of servers that multiple brokers can start to serve remote users for any one protocol. 0
port -S Specifies the service or port number to be used when connecting to a broker process or used by a broker process on the host machine. 0
reportinginterval -rptint Specifies the interval, in minutes, at which the server polls for license usage statistics that are reported in the usage report file. 1
Note: Do not edit the conmgr.properties file directly. Instead, use Progress Explorer. For more information on Progress Explorer, see its online help.

For more information on the conmgr.properties file, see Manage the OpenEdge Database.