Library /sys$common/syshlp/SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  USER_LIMIT
    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.
Close Help