Operating system and syntax UNIX / Windows
-B2 n
Use with Maximum value1 Minimum value Single-user default Multi-user default2
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.