Use the parameters listed in the following table to optimize server performance.

Syntax Parameter Purpose
-aiarcdir dirlist After-image File Management Archive Directory List (-aiarcdir)

Specifies the directories where the AI File Management utility writes the archived after-image files
-aiarcdircreate After-image File Management Archive Directory Create (-aiarcdircreate) Directs the AI File Management utility to create the specified directories
-aiarcinterval n After-image File Management Archive Interval (-aiarcinterval) Specifies on-demand mode archiving or the extent switch interval for timed-mode archiving
-aibufs n After-image Buffers (-aibufs) Specifies the number of after-image buffers when running AIW
-aistall After-image Stall (-aistall)l Suspends database activity when an empty after-image (AI) file is unavailable
-B n Blocks in Database Buffers -B) Specifies the number of blocks in the database buffers
-B2 n Blocks in Alternate Buffer Pool (-B2) Specifies the number of buffers in the database Alternate Buffer Pool
-Bpmax Maximum Private Buffers per Connection (-Bpmax) Controls the number of private buffers a connection can request through the Private Read-only Buffers (-Bp) parameter
-bibufs n Before-image Buffers (-bibufs) Specifies the number of before-image buffers when running BIW
-bistall Threshold Stall (-bistall) Sends a message to the log file when the recovery log threshold is reached. Use with -bithold.
-bithold n Recovery Log Threshold (-bithold) Specifies the maximum size of the recovery log files
-cluster qualifier Cluster Mode (-cluster) Starts up a cluster-enabled database
-directio Direct I/O (-directio) Opens all files in unbuffered mode
-G n Before-image Truncate Interval (-G) Specifies the number of seconds before OpenEdge reuses a before-image cluster
-groupdelay n Group delay (-groupdelay) Specifies the number of milliseconds a transaction waits before committing
-hash Hash Table Entries (-hash) Specifies the number of hash table entries for the buffer pool
-hashLatchFactor Buffer Hash Latch Factor (-hashLatchFactor) Specifies the latches allocated for the Buffer pool Hash Table (BHT) entries
-i No Crash Protection (-i) Runs OpenEdge without using database integrity or recovery
-LGovernor n Lock Governor (-LGovernor) Specifies the percentage of the lock table that a tenant can occupy
-L n Lock Table Entries (-L) Specifies the number of entries in the record locking table
-lkhash n Lock Table Hash Size (-lkhash) Specifies the size of the hash table controlling access to the lock table
-lkrela Lock release (-lkrela) Uses the original lock release mechanism installed from previous OpenEdge versions
-lruskips LRU force skips (-lruskips) Specify the number of times a buffer in the buffer pool is accessed before it is placed on the Most Recently Used (MRU) end of the LRU chain
-lru2skips LRU alternate buffer pool force skips (-lru2skips) Specify the number of times a buffer in the alternate buffer pool is accessed before it is placed on the Most Recently Used (MRU) end of the LRU chain
-maxAreas n Maximum area number (-maxAreas) Specifies the maximum area number available
-maxxids n Maximum JTA Transactions (-maxxids) Controls the number of JTA transactions simultaneously allowed
-Mf n Delayed BI File Write (-Mf) Delays writing the last before-image (BI) file records
-Mm n Message Buffer Size (-Mm) Specifies the message buffer size for network client/server protocols
-Mpte VLM Page Table Entry Optimization (digital UNIX only) Allocates shared memory in multiples of 8MB for VLM64 support
-mux n User MUX latches Specifies the granularity of access to large database resources in shared memory
-Mxs n Shared-memory Overflow Size (-Mxs) (UNIX, Windows only) Replaces the default value of the shared-memory overflow area
-n n Number of Users Specifies the maximum number of users connected to the database
-napinc n Naptime Increment Specifies the nap time increment
-napmax n Nap Maximum (-napmax) Specifies the maximum time (in milliseconds) to sleep (nap) after the -spin value is exhausted due to failure to acquire a latch
-napstep n Nap Time Steps (-napstep) Specifies the steps between the nap increments
-nGovernor n Login Governor (-nGovernor) Specifies the maximum number of users that may login for a tenant
-Nmsgwait n Message Wait (-Nmsgwait) Specifies the number of seconds a server waits for a remote network message
-omsize n Storage Object Cache Size (-omsize) Specifies the size of the object cache for all database objects
-Passphrase Prompt for Passphrase When connecting to a database enabled for Transparent Data Encryption, specifies that the user must be prompted for the key store passphrase
Note: The -Passphrase parameter is required for each command on a database enabled for Transparent Data Encryption.
-PendConnTime n Pending Connection Time (-PendConnTime) Specifies the amount of time a client has to connect to a server before the broker clears the client's reservation
-pica Database Service Communication Area Size (-pica) For OpenEdge Replication, specifies the size of the database service communications area in KB
-picanap n Database PICA Queue Nap Time (-picanap) For OpenEdge Replication, specifies the time in ms a process must wait before it may attempt to gain control of the PICA queue.
-pinshm Pin Shared Memory (-pinshm) Prevents the database engine from swapping shared memory contents to disk
-prefetchDelay Prefetch delay (-prefetchDelay) Enable a delay when sending the first network message for queries with prefetch capabilities
-prefetchFactor n Prefetch Factor (-prefetchFactor) Specify a percentage of a network message required to contain prefetched data
-prefetchNumRecs n Prefetch Num Recs (-prefetchNumRecs) Specify the number of prefetch records placed in a network message
-prefetchPriority n Prefetch Priority (-preFetchPriority) Specify the number of prefetch records to add to an in-process query without polling
-schlockwq Schema Lock Wait Queue (-schlockwq) Alters the schema locking algorithm so that the schema lock scheduler forces a shared schema lock request to wait when an exclusive schema lock request is queued
-semsets n Semaphore Sets (-semsets) (UNIX only) Changes the number of semaphore sets available to a broker
-shmsegsize n Shared memory segment size (-shmsegsize) Specifies the maximum shared memory segment size
-spin n Spin Lock Retries (-spin) (UNIX, Windows only) Specifies the number of times a process tries to acquire a latch before pausing
-SQLCursors value SQL Open Cursors (-SQLCursors) Specifies the maximum number of cursors open at any one time
-SQLStack n SQL Stack Size (-SQLStack) Specifies the size, in KB, of the SQL Stack
-SQLStmtCache num-entries SQL Statement Cache Size (-SQLStmtCache) Specifies the number of statements allowed in the SQL statement cache
-SQLTempBuff value SQL Sorting Memory (-SQLTempBuff) Defines the size of the temporary table buffer in memory
-SQLTempDisk value SQL Sorting on Disk (-SQLTempDisk) Defines the size of the temporary table for backup storage
-SQLTempPgSize value SQL Temp Table Data Page (-SQLTempPageSize) Defines the size of the temporary table data page
-ssj Server-side join (-ssj) Specifies whether the server will process Server-side join requests from remote clients.
-threadedServer Threaded Server Specifies whether the servers spawned by the broker are threaded. The default is enabled.
-threadedServerStack Threaded Server Stack Sets the size, in Kb, of a stack reserved for each thread of a threaded server.
-TXERetryLimit n Transaction End (TXE) Lock Retry Limit (-TXERetryLimit) Sets the number times a connection will re-try to obtain TXE lock after a 1ms nap before getting queued.
-SQLTruncateTooLargevalue Authorized Data Truncation (-SQLTruncateTooLarge) Can be set to ON or ALL to truncate data exceeding the column size. If the parameter is set to OFF, no data is truncated and SQL displays an error. If the parameter is set to OUTPUT, only the output is truncated. SQL also displays an error if the SQLTruncateTooLarge parameter is not specified at all in case of data exceeding the column size. The default value for the SQLTruncateTooLarge parameter is OFF.
-SQLWidthUpdate value Autonomus Schema Update (-SQLWidthUpdate) Helps resolve the SQL width problem by updating the SQL column width in schema automatically when Authorized Data Truncation (ADT) occurs for data in a column. To use this feature, provide the value of the -SQLWidthUpdate parameter as ON during startup. After the value of the parameter is set, it is remembered for the lifetime of the server and for all connections. If the value of the -SQLWidthUpdate parameter is set to ON during startup, the Authorized Data Truncation (ADT) parameter is also enabled irrespective of whether ADT was enabled during startup unless specified otherwise using connection URL. When this parameter is set to ON, the value for SQLTruncateTooLarge is ON/ALL by default.
Note: This parameter can be provided only during server startup and not in the client connection URL.
-SQLLockWaitTimeout Lock Wait Timeout Use this parameter (-SQLLockWaitTimeout) to specify the number of seconds to wait when a lock conflict occurs. This value applies to all conflicts that occur while using SQL applications. The default value is five seconds.
Note: Progress recommends changing the value of Lock Wait Timeout ( -SQLLockWaitTimeout) if your installation encounters a lot of conflicts.