All Forums Database
Dani 3 posts Joined 04/06
13 Jul 2007
how to "purge" transient journal

Hi allSince 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

Fred 1096 posts Joined 08/04
13 Jul 2007

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.

Jim Chapman 449 posts Joined 09/04
13 Jul 2007

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.

Dani 3 posts Joined 04/06
16 Jul 2007

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.

You must sign in to leave a comment.