Specifying Buffers for All Databases

Go Up to Setting Database Cache Buffers

To specify the same number of buffers for all databases, use CONNECT ALL with the CACHE <n> parameter. For example, the following statements connect to two databases, EMP, and EMP2, and allot 400 buffers to each of them:

. . .
EXEC SQL
SET DATABASE EMP = 'employee.ib';
EXEC SQL
SET DATABASE EMP2 = 'test.ib';
EXEC SQL
CONNECT ALL CACHE 400;
. . .

The same effect can be achieved by specifying the same amount of cache for individual databases:

. . .
EXEC SQL
CONNECT EMP CACHE 400, TEST CACHE 400;
. . .