Blocks in Database Buffers (-B)
- Last Updated: March 30, 2020
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
Blocks in Database Buffers (-B)
Use Blocks in Database Buffers (-B) to specify the number of blocks in the
database buffers. The optimum value depends on your application.
| Operating system and syntax | UNIX / Windows |
-B
n
|
||
|---|---|---|---|---|
| Use with | Maximum value | Minimum value | Single-user default | Multi-user default2 |
| Client Connection, Database Server | 1,000,000,000 or 125,000,0001 | 10 | 20 | Maximum value of 3000 or 8 * users, whichever is higher |
- n
- The number of blocks in the database buffers.
Blocks in Database Buffers (
-B) can be changed while the database is online with the PROUTIL INCREASETO utility.Note:On the AIX platform, when starting a database with large shared memory requirements (for instance, when the -
Bexceeds the allotted system paging space), the system may become unstable if thePSALLOC=earlyenvironment variable is not set.OpenEdge RDBMS internal validations can used to ensure database consistency in both index and data blocks during forward processing. Validations using PROUTIL can be run online as part of routine health checks. For more information, see Manage the OpenEdge Database.
Note: