Blocks in Alternate Buffer Pool (-B2)
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
Use Blocks in Alternate Buffer Pool (-B2) to
specify the number of blocks in the alternate buffer pool. The optimum value depends on your
application.
| Operating system and syntax | UNIX / Windows |
-B2
n
|
||
|---|---|---|---|---|
| Use with | Maximum value | Minimum value | Single-user default | Multi-user default2 |
| CC, DBS | 1,000,000,000 or 125,000,0001 | 10 | 0 | 0 |
- n
- The number of blocks allocated in the alternate buffer pool.
The Alternate Buffer Pool is a collection of buffers in shared memory that are logically separate from the primary buffer pool. Management of the buffers in the Alternate Buffer Pool is independent of the primary buffer pool. Assigning specific database areas or objects to occupy buffers in the Alternate Buffer Pool may improve your buffer hit rate, thereby reducing the need to read and write buffers to and from disk, possibly improving performance.
You cannot specify Blocks in Alternate Buffer Pool for a Replication target database.
Blocks in Alternate Buffer Pool (-B2) can
be changed while the database is online with the PROUTIL INCREASETO utility.
For more information on the Alternate Buffer Pool and PROUTIL, see Manage the OpenEdge Database.