Blocks in Database Buffers (-B)
- Last Updated: July 21, 2022
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
| Operating system and syntax | UNIX / Windows |
|
||
|---|---|---|---|---|
| Use with | Maximum value | Minimum value | Single-user default | Multi-user default |
| CC, DBS | 1,000,000,000 or 125,000,000 | 10 | 20 | Maximum of (8 * users) or 3000 |
- n
- The number of blocks in the database buffers.
Use Blocks in Database Buffers (-B) to
specify the number of blocks in the database buffers. The optimum value depends on your
application. Validations to ensure database consistency in both index and data blocks during
forward processing.using -B can be run online as part of
routine health checks. For more information, see PROUTIL Utility
Note: On the AIX platform,
when starting a database with large shared memory requirements (for instance, when the
-B exceeds the allotted system paging space), the system
may become unstable if the PSALLOC=early environment
variable is not set. For more information, see OpenEdge Getting
Started: Installation and Configuration.To modify this parameter while the database is online, use PROUTIL INCREASETO.
You can use this parameter to support continuous operation of the database. For more information, see Change database parameters while the database is running.
1 The maximum value of the sum of -B + -B2: 1,000,000,000 for 64-bit platforms; 125,000,000 for 32-bit platforms. The maximum is system dependent and limited by available memory.
2 The users value is specified by the Number of Users (
-n) parameter.