Syntax - Teradata Tools and Utilities

where:

(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

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