Release 10.1A: OpenEdge Deployment:
Startup Command and Parameter Reference

> ## Database server performance parameters

> Use the parameters listed in Table 3–9 to optimize server performance.

> Table 3–9: Server performance parameters
> Syntax | Parameter | Purpose
> --- | --- | ---
>     -aiarcdir
>     dirlist
> | After-image File Management Archive Directory List | Specify the directories where the AI File Management utility writes the archived after-image files.
>     -aiarcdircreate
> | After-image File Management Archive Directory Create | Direct the AI File Management utility to create the specified directories.
>     -aiarcinterval n
> | After-image File Management Archive Interval | Specify on-demand mode archiving or the extent switch interval for timed-mode archiving.
>     -aibufs n
> | After-image buffers | Specify the number of after-image buffers when running AIW.
>     -aistall
> | After-image stall | Suspend database activity when an empty after-image (AI) file is unavailable.
>     -B n
> | Blocks in database buffers | Specify the number of blocks in the database buffers.
>     -Bpmax
> | Maximum private buffers per connection | Control the number of private buffers a connection can request through the Private Read-only Buffers (`-Bp`) parameter.
>     -bibufs n
> | Before-image buffers | Specify the number of before-image buffers when running BIW.
>     -bistall
> | Threshold stall | Send a message to the log file when the recovery log threshold is reached. Use with `-bithold`.
>     -bithold n
> | Recovery log threshold | Specify the maximum size of the recovery log files.
>     -cluster
>     qualifier
> | Cluster Mode | Startup a cluster-enabled database.
>     -directio
> | Direct I/O (UNIX, Windows only) | Open all files in unbuffered mode.
>     -G n
> | Before-image cluster age | Specify 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 | Specify the number of hash table entries for the buffer pool.
>     -i
> | No crash protection | Run OpenEdge without using database integrity or recovery.
>     -L n
> | Lock table entries | Specify the number of entries in the record locking table.
>     -maxxids n
> | Maximum JTA Transactions | Control the number of JTA transactions simultaneously allowed.
>     -Mf  n
> | Delayed BI file write (UNIX, Windows only) | Delay writing the last before-image (BI) file records.
>     -Mm n
> | Message buffer size | Specify the message buffer size for network client/server protocols.
>     -Mpte
> | VLM page table entry optimization (digital UNIX only) | Allocate shared memory in multiples of 8MB for VLM64 support.
>     -Mxs n
> | Shared-memory overflow size (UNIX, Windows only) | Replace the default value of the shared-memory overflow area.
>     -n n
> | Number of users | Specify the maximum number of users connected to the database.
>     -PendConnTime n
> | Pending Connection Time | Specify the amount of time a client has to connect to a server before the broker clears the client’s reservation.
>     -pinshm
> | Pin shared memory | Prevent the database engine from swapping shared memory contents to disk.
>     -semsets n
> | Semaphore sets (UNIX only) | Change the number of semaphore sets available to a broker.
>     -spin n
> | Spin lock retries (UNIX, Windows only) | Specify the number of times a process tries to acquire a latch before pausing.
>     -SQLCursors
>     value
> | SQL Open Cursors | Specify the maximum number of cursors open at any one time.
>     -SQLStack n
> | SQL stack size | Specify the size, in MB, of the SQL Stack.
>     -SQLStmtCache
>     num_entries
> | SQL statement cache size | Specify 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.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095