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.