CHECKPOINT
Purpose
CHECKPOINT places a bookmark in a permanent journal or prepares a permanent journal for archiving.
Syntax
where
Syntax Element |
Description |
(dbname) |
Name of the database with the journal table to checkpoint |
ALL |
Indicates that the operation affects the journals in the named database and all the descendants |
(dbname.tablename) |
Name of a specific journal table to checkpoint All tables should be distinct within the list. Duplicate tables are ignored. |
EXCLUDE |
Prevents journal tables from being check pointed |
(dbname) |
Name of database excluded from the checkpoint operation |
ALL |
Excludes the named database and its descendants |
(dbname1) TO (dbname2) |
Alphabetic list of client databases The delimiting database names need not identify actual databases. Database DBC is not included as part of a range. |
WITH SAVE |
Logically moves the contents of the active subtable of the identified journals to the saved subtable |
USE ACCESS LOCK or USE READ LOCK |
Applies an access or read lock on data tables that contribute journal rows to the journal tables on which Teradata ARC is setting checkpoints USE READ LOCK is the default. |
NAMED |
References the entry in database recovery activities |
chkptname |
Name of the database recovery event |