where does TD store transient journal?

Database

where does TD store transient journal?

in spool or perm space, or in memory?
6 REPLIES
Senior Apprentice

Re: where does TD store transient journal?

In perm space -> dbc.transientjournal
But that special table can grow over dbc's perm limit until the whole system runs out of perm space.

Dieter
Enthusiast

Re: where does TD store transient journal?

Can not we access them using sql assistant, how can we look them?

Enthusiast

Re: where does TD store transient journal?

The Filer utility has commands for inspecting the Transient Journal.  It is not acually a table.  It is a special file system object.

Enthusiast

Re: where does TD store transient journal?

the dbc.transientjournal is very large while importing the data via bteq,

then i tried to delete it by SQL: modify database dbc as drop default journal table;

but it was failed.

so any suggestion? thanks so much.

Senior Apprentice

Re: where does TD store transient journal?

MODIFY DATABASE DROP DEFAULT JOURNAL is not related to the Transient Journal, this is for Permanent Journals only.

Your BTEQ job probably logged on using an ANSI session, so all INSERTs are part of a single transaction.

Change to Teradata mode or for a large number of rows better use a load utility.

Teradata Employee

Re: where does TD store transient journal?

You do not need to delete it. Teradata will clean it out for you automatically once you complete your transaction.