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.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |