Database server performance parameters

-aiarcdir dirlist

After-image File Management Archive Directory List

Specifies the directories where the AI File Management utility writes the archived after-image files

-aiarcdircreate

After-image File Management Archive Directory Create

Directs the AI File Management utility to create the specified directories

-aiarcinterval n

After-image File Management Archive Interval

Specifies on-demand mode archiving or the extent switch interval for timed-mode archiving

-aibufs n

After-image Buffers

Specifies the number of after-image buffers when running AIW

-aistall

After-image Stall

Suspends database activity when an empty after-image (AI) file is unavailable

-B n

Blocks in Database Buffers

Specifies the number of blocks in the database buffers

-B2 n

Blocks in Alternate Buffer Pool

Specifies the number of buffers in the database Alternate Buffer Pool

-Bpmax

Maximum Private Buffers per Connection

Controls the number of private buffers a connection can request through the Private Read-only Buffers (-Bp) parameter

-bibufs n

Before-image Buffers

Specifies the number of before-image buffers when running BIW

-bistall

Threshold Stall

Sends a message to the log file when the recovery log threshold is reached. Use with -bithold.

-bithold n

Recovery Log Threshold

Specifies the maximum size of the recovery log files

-cluster qualifier

Cluster Mode

Starts up a cluster-enabled database

-direction

Direct I/O (UNIX, Windows only)

Opens all files in unbuffered mode

-G n

Before-image Cluster Age

Specifies the number of seconds before OpenEdge reuses a before-image cluster

-groupdelay n

Group Delay

Specifies the number of milliseconds a transaction waits before committing

-hash

Hash Table Entries

Specifies the number of hash table entries for the buffer pool

-i

No Crash Protection

Runs OpenEdge without using database integrity or recovery

-LGovernor n

Lock Governor

Specifies the percentage of the lock table that a tenant can occupy

-L n

Lock Table Entries

Specifies the number of entries in the record locking table

-lkhash n

Lock Table Hash Size

Specifies the size of the hash table controlling access to the lock table

-lkrela

Lock Release

Uses the original lock release mechanism installed from previous OpenEdge versions

-lruskips

LRU force skips

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

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

Specifies the maximum area number available

-maxxids n

Maximum JTA Transactions

Controls the number of JTA transactions simultaneously allowed

-Mf n

Delayed BI File Write (UNIX, Windows only)

Delays writing the last before-image (BI) file records

-Mm n

Message Buffer Size

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 (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

Specifies the maximum time (in milliseconds) to sleep (nap) after the -spin value is exhausted due to failure to acquire a latch

-napstep n

Naptime Steps

Specifies the steps between the nap increments

-nGovernor n

Login Governor

Specifies the maximum number of users that may login for a tenant

-Nmsgwait n

Message wait

Specifies the number of seconds a server waits for a remote network message

-omsize n

Storage Object Cache Size

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

-PendConnTime n

Pending Connection Time

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

For OpenEdge Replication, specifies the size of the database service communications area in KB

-pinshm

Pin Shared Memory

Prevents the database engine from swapping shared memory contents to disk

-prefetchDelay

Prefetch delay

Enable a delay when sending the first network message for queries with prefetch capabilities

-prefetchFactor n

Prefetch factor

Specify a percentage of a network message required to contain prefetched data

-prefetchNumRecs n

Prefetch num recs

Specify the number of prefetch records placed in a network message

-prefetchPriority n

Prefetch priority

Specify the number of prefetch records to add to an in-process query without polling

-schlockwq

Schema Lock Wait Queue

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 (UNIX only)

Changes the number of semaphore sets available to a broker

-shmsegsize n

Shared Memory Segment Size

Specifies the maximum shared memory segment size

-spin n

Spin Lock Retries (UNIX, Windows only)

Specifies the number of times a process tries to acquire a latch before pausing

-SQLCursors value

SQL Open Cursors

Specifies the maximum number of cursors open at any one time

-SQLStack n

SQL Stack Size

Specifies the size, in KB, of the SQL Stack

-SQLStmtCache num-entries

SQL Statement Cache Size

Specifies the number of statements allowed in the SQL statement cache

-SQLTempBuff value

SQL Sorting Memory

Defines the size of the temporary table buffer in memory

-SQLTempDisk value

SQL Sorting on Disk

Defines the size of the temporary table for backup storage

-SQLTempPgSize value

SQL Temp Table Data Page

Defines the size of the temporary table data page

-TXERetryLimit n

Transaction End (TXE) Lock Retry Limit

Sets the number times a connection will re-try to obtain TXE lock after a 1ms nap before getting queued.

-SQLTruncateTooLarge value

Authorized Data Truncation

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

Autonomous Schema Update

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. Once 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.

-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.