Syntax option:
USER LIMIT IS max-glo-buffers
Specifies the maximum number of global buffers each user
allocates. Because global buffer pools are shared by all users,
you must define an upper limit on how many global buffers a
single user can allocate. This limit prevents a user from
defining RDM$BIND_BUFFERS to use all the buffers in the global
buffer pool. The user limit cannot be greater than the total
number of global buffers. The default is 5 global buffers.
Decide the maximum number of global buffers a user can allocate
by dividing the total number of global buffers by the total
number of users for whom you want to guarantee access to the
database. For example, if the total number of global buffers is
200 and you want to guarantee access to the database for at least
10 users, set the maximum number of global buffers per user to
20.
For maximum performance on a VMScluster system, tune the two
global buffer parameters on each node in the cluster using the
RMU Open command with the Global_Buffers qualifier.
Although you can change the USER LIMIT IS parameter on line, the
change does not take effect until the next time the database is
opened.
The NUMBER IS and USER LIMIT IS parameters are the only two
buffer parameters specific to global buffers. They are in effect
on a per node basis rather than a per process basis.