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
|
Blocks in Database Alternate Buffer Pool
|
-B2 n
|
Specifies the number of blocks in the database Alternate Buffer Pool.
|
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 Windows Application Event Log
|
Before-image Cluster Age
|
-G n
|
Specifies the number of seconds before the database 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 the database without integrity or recovery
|
Increase parameters online
|
-increaseto
|
Increases certain predefined server startup parameters while the database is online
|
Lock Governor
|
-LGovernor n
|
Specifies the percentage of the lock table that a tenant can occupy
Note: This parameter is applicable to only the default tenant and regular tenant in multi-tenant databases; this parameter does not apply to a super-tenant
|
Lock Table Entries
|
-L n
|
Specifies the number of entries in the record locking table
|
Lock release
|
-lkrela
|
Use the original lock release mechanism installed from previous OpenEdge versions
|
LRU force skips
|
-lruskips n
|
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
|
LRU alternate buffer pool force skips
|
-lru2skips n
|
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
|
Maximum area number
|
-maxAreas n
|
Specify the maximum area number available
|
Delayed BI File Write
|
-Mf n
|
Delays writing the last before-image (BI) file records
|
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
|
Nap maximum
|
-napmax n
|
Specifies the maximum time (in milliseconds) to sleep (nap) after the -spin value is exhausted due to failure to acquire a latch
|
Login Governor
|
-nGovernor n
|
Specifies the maximum number of users that may login for a tenant
Note: This parameter is applicable to only the default tenant and regular tenant in multi-tenant databases; this parameter does not apply to a super-tenant
|
Message wait
|
-Nmsgwait n
|
Specifies the number of seconds a server waits for a remote network message
|
Pin Shared Memory
|
-pinshm
|
Prevents the OS from swapping shared memory contents to disk
|
Prefetch delay
|
-prefetchDelay
|
Enable a delay when sending the first network message for queries with prefetch capabilities
|
Prefetch factor
|
-prefetchFactor n
|
Specify a percentage of a network message required to contain prefetched data
|
Prefetch num recs
|
-prefetchNumRecs n
|
Specify the number of prefetch records placed in a network message
|
Prefetch priority
|
-prefetchPriority n
|
Specify the number of prefetch records to add to an in-process query without polling
|
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
|
Semaphore Sets1
|
-semsetsn
|
Changes the number of semaphore sets available to a broker
|
Shared memory segment size
|
-shmsegsize n
|
Specify the maximum shared memory segment size
|
Spin Lock Retries
|
-spin n
|
Specifies the number of times a process tries to acquire a latch before pausing
|
Transaction End (TXE) Retry Limit
|
-TXERetryLimit n
|
Specifies the number of times a connection will re-try to obtain TXE lock after a 1ms nap before getting queued
|
Authorized Data Truncation
|
SQLTruncateTooLarge value
|
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.
|
Autonomous Schema Update
|
-SQLWidthUpdate value
|
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.
Note: This parameter can be provided only during server startup and not in the client connection URL.
|
Lock Wait Timeout
|
-SQLLockWaitTimeout
|
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 Software Corporation recommends changing the value of Lock Wait Timeout( -SQLLockwaitTimeout) if your installation encounters a lot of conflicts.
|