Progress
Database Administration
Guide and Reference


Database Server Performance Parameters

Use the parameters listed in Table 18–1 to optimize server performance.

Table 18–1: Server Performance Parameters
Parameter
Syntax
Purpose
After-image Buffers
-aibufs n
Specifies the number of after-image buffers when running AIW.
After-image Stall
-aistall
Suspends database activity when an empty after-image (AI) file is unavailable.
Blocks in Database Buffers
-B n
Specifies the number of blocks in the database buffers.
Before-image Buffers
-bibufs n
Specifies the number of before-image buffers when running BIW.
Threshold Stall
-bistall
Quiets a database and sends a message to the log file when the recovery log threshold is reached. Use with -bithold.
Recovery Log Threshold
-bithold n
Specifies the maximum size of the recovery log files in MB.
Direct I/O
-directio
Opens all files in unbuffered mode.
Event Level
-evtlevel
Specifies the level of information written to the NT Application Event Log.
Before-image Cluster Age
-G n
Specifies the number of seconds before Progress reuses a before-image cluster.
Group Delay
-groupdelay n
Specifies the number of milliseconds a transaction waits before committing.
Hash Table Entries
-hash
Specifies the number of hash table entries for the buffer pool.
No Crash Protection
-i
Runs Progress without using database integrity or recovery.
Lock Table Entries
-L n
Specifies the number of entries in the record locking table.
Delayed BI File Write
-Mf n
Delays writing the last before-image (BI) file records.
VLM Page Table Entry Optimization1
-Mpte
Allocates shared memory in multiples of
8 MB for VLM64 support.
Shared-memory Overflow Size
-Mxs n
Replaces the default value of the shared-memory overflow area.
Number of Users
-n n
Specifies the maximum number of users connected to the database.
Pin Shared Memory
-pinshm
Prevents the database engine from swapping shared memory contents to disk.
Semaphore Sets2
-semsets n
Changes the number of semaphore sets available to a broker.
Spin Lock Retries
-spin n
Specifies the number of times a process tries to acquire a latch before pausing.
  1. Compaq Tru64 only.
  2. UNIX only.


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