SQL$HELP_OLD72.HLB  —  CREATE  CACHE  Arguments  CHECKPOINT
    Syntax options:

       CHECKPOINT ALL ROWS TO BACKING FILE
       CHECKPOINT UPDATED ROWS TO BACKING FILE
       CHECKPOINT UPDATED ROWS TO DATABASE

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

    If the target of the checkpoint operation is BACKING FILE, then
    the row cache server (RCS) process writes the 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 the updated rows (only UPDATED
    ROWS is allowed) 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.

    This CHECKPOINT clause overrides the database-level CHECKPOINT
    clause.
Close Help