SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  ROW_CACHE
    Syntax options:

    ROW CACHE IS ENABLED | ROW CACHE IS DISABLED

    Specifies whether or not the row caching feature is enabled.

    Enabling row caching does not affect database operations until a
    cache is created and assigned to one or more storage areas.

    When row caching is disabled, all previously created and assigned
    caches remain and will be available if row caching is enabled
    again.

    The following conditions must be true in order to use row caches:

    o  The number of cluster nodes is one

    o  After-image journaling is enabled

    o  Fast commit is enabled

    o  One or more cache slots are reserved

    o  Row caching is enabled

    Use the RMU Dump Header command to check if you have met the
    requirements for using row caches. The following command output
    displays a warning for every requirement that is not met:

       .
       .
       .
    Row Caches...

    - Active row cache count is 0

    - Reserved row cache count is 1

    - Sweep interval is 1 second

    - Default cache file directory is ""

    - WARNING: Maximum node count is 16 instead of 1

    - WARNING: After-image journaling is disabled

    - WARNING: Fast commit is disabled

       .
       .
Close Help