fbpx

The Teradata Permanent Journal allows us to keep a snapshot of permanent tables before and after applying changes. Before any change took place, copies of the original rows are stored in the permanent journal table. Permanent journaling is similar to the transient journal table, which stores before snapshots of tables whenever a transaction is initiated.

Journaling can be applied either on the table level or database level. Even with database-level journaling turned on, it is possible to separately turn off journaling for each table by overriding the default value in the table DDL statement.

For each database, precisely one permanent journal can be used.

Permanent journaling allows you to move back in time, giving you an “UNDO” functionality.

Permanent journals are continuously monitoring tables changes, tracking all UPDATE, INSERT and DELETE statements; They are protecting us from data losses by logging changes until the journal tables are manually dropped (pausing the usage of journaling is possible as well). Permanent journaling can be used to avoid or postpone full backups.

Teradata allows us to keep one or two journal rows per changed table record, similar to the FALLBACK protection feature.

While permanent journaling adds some protection level to your data, you have to consider that journal tables need the same amount of space per row, like the underlying permanent table.

It would be best if you decided on a case-by-case basis that should store permanent journal tables.

Here is an example of a table which is using a fallback protected after journal:

CREATE SET TABLE <DATABASE>.<TABLE>
,FALLBACK ,
NO BEFORE JOURNAL,
AFTER JOURNAL,
WITH JOURNAL TABLE = <OTHER_DATABASE>.<MYJOURNAL> ,
CHECKSUM = DEFAULT
(
PK INTEGER NOT NULL
) PRIMARY INDEX ( PK );

You can list all available journal tables in the system with the statement below:

SELECT * FROM DBC.JOURNALS;

Buy now at Amazon
  • เงี่ยน

    […]we like to honor several other world wide web internet sites on the net, even when they aren’t linked to us, by linking to them. Beneath are some webpages really worth checking out[…]

  • หนังav

    […]Wonderful story, reckoned we could combine several unrelated data, nevertheless truly worth taking a search, whoa did 1 discover about Mid East has got a lot more problerms as well […]

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    You might also like

    >