Blocks in Alternate Buffer Pool (-B2)
- Last Updated: July 8, 2022
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
| Operating system and syntax | UNIX / Windows |
|
||
|---|---|---|---|---|
| Use with | Maximum valueBlocks in Alternate Buffer Pool (-B2) | Minimum value | Single-user default | Multi-user defaultBlocks in Alternate Buffer Pool (-B2) |
| CC, DBS | 1,000,000,000 or 125,000,000 | 10 | 0 | 0 |
- n
- The number of blocks allocated in the alternate buffer pool.
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.
You cannot specify Blocks in Alternate Buffer Pool for a Replication target database.
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.