Example 1

    The following example sets the slot count on cache "mycache".

    $ RMU/SET ROW_CACHE/ALTER=(NAME=mycache, SLOT_COUNT=8888)

    Example 2

    This command disables all caches.

    $ RMU/SET ROW_CACHE/DISABLE

    Example 3

    The following sample specifies that cache "cache2" should use RAD
    2.

    $ RMU/SET ROW_CACHE/ALTER=(NAME=cache2, SHARED_MEM=(TYPE=RESIDENT, -
    _$ RAD_HINT=2)

    Example 4

    This example drops cache "seacache".

    $ RMU/SET ROW_CACHE/ALTER=(NAME=seacache, DROP)

    Example 5

    This example shows multiple uses of the Alter qualifier.

    $ RMU /SET ROW_CACHE MF_PERSONNEL/ALTER=(NAME = RDB$SYS_CACHE, -
    _$ SLOT_COUNT = 800, WINDOW_COUNT = 25) -
    _$ /ALTER= (NAME = RESUMES,SLOT_SIZE=500,WORKING_SET_COUNT = 15)

    Example 6

    The following example modifies the database MYDB to set the
    snapshot slot count for the cache EMPL_IDX to 25000 slots and
    disables snapshots in cache for the SALES cache.

    $ RMU /SET ROW_CACHE DGA0:[DB]MYDB.RDB -
    _$ /ALTER=(NAME=EMPL_IDX, SNAPSHOT_SLOT_COUNT=25000) -
    _$ /ALTER=(NAME=SALES, SNAPSHOT_SLOT_COUNT=0)

    Example 7

    The following example alters two caches:

    $ RMU /SET ROW_CACHE MF_PERSONNEL -
            /ALTER= (   NAME = RDB$SYS_CACHE,
                        SLOT_COUNT = 800) -
            /ALTER= (   NAME = RESUMES, -
                        SLOT_SIZE=500, -
                        WORKING_SET_COUNT = 15)

    Example 8

    The following command alters caches named FOOD and FOOT (and
    any other cache with a 4 character name with the first three
    characters of "FOO" defined in the database):

    $ RMU /SET ROW_CACHE MF_PERSONNEL -
            /ALTER= (   NAME = FOO%,
                        BACKING_STORE_LOCATION=DISK$RDC:[RDC])