Try OpenEdge Now
skip to main content
Startup Command and Parameter Reference
Startup Parameter Descriptions : Blocks in Alternate Buffer Pool (-B2)
 

Blocks in Alternate Buffer Pool (-B2)

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 default1
CC, DBS
1,000,000,000 or 125,000,0002
10
0
0
1 The users value is specified by the Number of Users (-n) parameter.

2 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.

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 OpenEdge Data Management: Database Administration.