Syntax options:

    CHECKPOINT UPDATED ROWS TO BACKING FILE

    CHECKPOINT UPDATED ROWS TO DATABASE

    CHECKPOINT ALL ROWS TO BACKING FILE

    Specifies the default source and target during checkpoint
    operations for all row caches. If ALL ROWS is specified, then the
    source records written during each checkpoint operation are both
    the modified and the unmodified rows in a row cache. If UPDATED
    ROWS is specified, then just the modified rows in a row cache are
    checkpointed each time.

    If the target of the checkpoint operation is BACKING FILE,
    then the RCS process writes the source row cache entries to
    the backing (.rdc) files. The row cache LOCATION, ALLOCATION,
    and EXTENT clauses are used to create the backing files. Upon
    recovery from a node failure, the database recovery process is
    able to repopulate the row caches in memory from the rows found
    in the backing files.

    If the target is DATABASE, then updated row cache entries
    are written back to the database. The row cache LOCATION,
    ALLOCATION, and EXTENT clauses are ignored. Upon recovery from
    a node failure, the database recovery process has no data on the
    contents of the row cache. Therefore, it does not repopulate the
    row caches in memory.

    The CHECKPOINT clause of the CREATE CACHE, ADD CACHE, or ALTER
    CACHE clause overrides this database-level CHECKPOINT clause.