Prior to archiving journal tables, use the CHECKPOINT statement to bookmark each journal table to prepare for archival. For more information, see “CHECKPOINT” on page 190.
In this example, journal tables for database PJ are archived to a file with a filename of ARCHIV1. The assumption is that database PJ has one or more journal tables.
LOGON TDPID/DBC,DBC;
CHECKPOINT (PJ) ALL, WITH SAVE;
ARCHIVE JOURNAL TABLES (PJ) ALL,
RELEASE LOCK,
FILE=ARCHIV1;
LOGOFF;
In this example, all of the journal tables in the Teradata Database are archived to a file named ARCHIV2. The assumption is that each journal table in the system has already been bookmarked with the CHECKPOINT command to prepare for archival.
LOGON TDPID/DBC,DBC;
ARCHIVE JOURNAL TABLES (DBC) ALL,
EXCLUDE (DBC),
NONEMPTY DATABASES,
RELEASE LOCK,
FILE=ARCHIV2;
LOGOFF;
You can include a single CHECKPOINT statement to bookmark all journal tables in the
system. If there are any databases without a PERMANENT journal, the Teradata Database
will automatically flag those databases. Arcmain will display a non-fatal 3566 error
(Database does not have a PERMANENT journal) for each database in response to the CHECKPOINT request.
LOGON TDPID/DBC,DBC;
CHECKPOINT (DBC) ALL, WITH SAVE;
ARCHIVE JOURNAL TABLES (DBC) ALL,
EXCLUDE (DBC),
NONEMPTY DATABASES,
RELEASE LOCK,
FILE=ARCHIV2;
LOGOFF;