CHECKPOINT - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

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