how to "purge" transient journal

Database
Fan

how to "purge" transient journal

Hi all

Since some days the TransientJournal Table is growing and growing and takes a lot of space from DBC.
The TransientJournal its only growing on one AMP. The CurrentPerm for the AMPs ar between 1GB and 7GB, the growing one is now over 40GB. The MaxPerm for every AMP is 16GB.

Thanks for any Help.
Daniel
3 REPLIES
Teradata Employee

Re: how to "purge" transient journal

Transient journal space should be reclaimed automatically as transactions commit or roll back their changes. You must have some very long / very skewed unit of work still processing or rolling back.
Enthusiast

Re: how to "purge" transient journal

You didn't say which Teradata version you are running. With V2R6.2 and later, the TJ is also used by the file system as a write-ahead log, which greatly increases the amount of disk space used. The TJ purge algorithm was also changed in that release to more efficiently purge WAL records, but one consequence is that a transaction that is open for a long time greatly reduces the purge efficiency even if the transaction itself does not generate a lot of journal activity.
Fan

Re: how to "purge" transient journal

Thanks for your help,

The Teradata Version is V2R6.2.
I involved NCR and they have to restart the Database. It was a known Problem with the purging Process of the Transient Journal.
Now everything is ok.