Tuesday, October 11, 2011

What are permanent journals in teradata?

- Journals are used to capture information about table in Teradata.  In case of Permanent journals they capture details of Journal enabled tables in teradata   with all the pre transaction and post transaction details . 
- Journal tables are assigned PERM space and they reside in same database as of parent or they can reside on different database.
- They are mainly used for protection of data and sometimes  also for disaster recovery ( fallback is better in this case )
- Permanent journal tables can be enabled or disabled by running alter database <databasename> 'no journal' /' journal = <databasename.jrnltbl>'
- Arcmain  utility provides the feature of backing  up Journal tables
- We can find details about all journal tables present in  teradata  database using DBC.JOURNALS table.

1 comment:

  1. hi ,the content is very useful,it would be good if you cn start a similar platform for Teradata SQL