#Tera travel journal permanent update#

You can override this in table level by specifying “NO AFTER JOURNAL”. First you need to create one journal table either on same database or any other database or user space as below:-ĭEFAULT JOURNAL TABLE='Mydb'.'Myjournal' You can choose snapshot of the table as single copy/dual copy/no copy or local copy which will be created on same AMP.

You can choose snapshot of the table as single copy/dual copy or no copy.Īfter journal/after image:- Snapshot will be captured after applying any changes on table, used for rollin or redo the changes. During creation of permanent journal of table you can specify to capture table snapshot as below-īefore journal / before image:- Snapshot will be captured before applying any changes on table, used for rollback or undo the changes. So it’s the responsibility of DBA to maintain permanent journal by deleting, archiving and so on.

#Tera travel journal permanent update#

Once you define permanent journal for table/tables and start doing operation like insert, delete and update on the table, permanent journal will start to grow and will take addition space. The single journal table will be maintained in one database or user space. You can define permanent journal in database level or table level. Incorrect batch or application processing.loss of data because of 2 or more AMPs fail in the same cluster.loss of data due to disk failure in a table that is not fall back or RAID protected.