Sunday, November 4, 2012

Where does TD store transient journal?

Transient Journal (TJ) is an area of space in the DBC database which is used primarily for storing of roll-back/undo  information during inserts/deletes/updates on a tables. 

TJ require perm space and is stored in "dbc.transientjournal". This special type of table can grow beyond dbc's  perm space limit until the whole system runs out of perm space.

It is good practice to backup Transient Journal regularly and delete to enhance query and load performance.

No comments:

Post a Comment