|
Property
|
Description
|
|
Blocks in database buffers (primary)
|
The number of blocks in the database buffers. The optimum value for this property depends on your application.
The default value is 0.
|
|
Alternate buffer pool
|
The number of blocks in the alternate buffer pool. The optimum value depends on your application.
If you specify Alternate buffer pool blocks for a Replication target database, the property setting is ignored.
Note: Alternate buffer pool functionality requires an Enterprise database license. For more information about alternate buffer pools, see OpenEdge Data Management: Database Administration.
|
|
Hash table entries
|
The number of hash table entries to use for the buffer pool. The default value is 0.
Note: Do not edit this property unless directed to do so by Progress Software Technical Support.
|
|
Lock table entries
|
The number of entries in the record locking table. If you specify a value that is not a multiple of 32, the value is rounded to the next highest multiple of 32. Each record that is accessed by any user takes one entry.
The default value is 8192.
|
|
Tenant Lock Table Governors(%)
|
Specifies the percentage of the lock table that any tenant can occupy. The valid values are 1 through 100. The default value is 100.
Note: This parameter applies to only multi-tenant databases. In addition, this applies to only the default tenant and regular tenant. The super tenants do not use the governors parameters.
You can also monitor this parameter using PROMON utility.
|
|
Max users
|
The maximum number of users on the system for the database.
After the maximum number of users have connected to the database, additional user connect attempts are rejected.
The default value is 20.
|
|
Tenant Max. User Governor
|
Specifies the maximum number of users that may login for any tenant. The valid values are 1 through the maximum number of users (32000).
The default value is the maximum number of users (-n).
Note: This parameter applies to only multi-tenant databases. In addition, this applies to only the default tenant and regular tenant. The super tenants do not use the governors parameters.
You can also monitor this parameter using the PROMON utility.
|
|
Max servers
|
The maximum number of remote client servers that can be started by the broker process.
Use the Max servers property to limit the number of remote user servers that can be started on the system. The performance trade-off to consider is swapping overhead for many servers versus overloading (slowing down) a server with too many clients.
Note: This parameter pertains only to the OpenEdge® Workgroup RDBMS and the OpenEdge® Enterprise RDBMS. In addition, this parameter applies only to databases that are accessed from remote network nodes.
|
|
Maximum private database buffers per user
|
Controls the number of private buffers a connection can request through the Private Read-only Buffers (-Bp) parameter.
|
|
Direct I/O
|
Enables the Direct I/O property, which opens all files in unbuffered mode. Direct I/O enables the database to use an I/O technique that bypasses the operating system buffer pool and transfers data directly from a buffer to disk.
This technique has some advantages over buffered reads and writes, such as avoiding the overhead of maintaining the operating system buffer pool, and eliminating competition for operating system buffers between the database and other programs. The operating system buffer-pool algorithms are designed for efficient sequential file access; the OpenEdge buffer-pool algorithms are more efficient for access to an OpenEdge RDBMS.
The Direct I/O check box is cleared by default.
|
|
Other arguments
|
Any other arguments for which there is no defined property available.
|