what is a permanent journal and explain different types?

A Permanent Journal captures a picture of any row that changes. This would include UPDATES, INSERTS, and DELETES. Permanent Journals do not double the data or PERM for a table, but only doubles the rows that change.

i.e
The Permanent Journal stores only images of rows that have been changed due to an INSERT, UPDATE, or DELETE command.

There are four image options for the Permanent Journal:

· Before Journal

· After Journal

· Dual Before Journal

· Dual After Journal