how to get TJ space-usage on session-level

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Enthusiast

how to get TJ space-usage on session-level

Hi There,

 

Is there a way to get the space-usage of the current transient journal on user-session-level?

 

I.e.; how to identify sessions that cause filling up the transient journal because a commit isn't given?

Tags (2)
2 REPLIES
Senior Apprentice

Re: how to get TJ space-usage on session-level

Hi,

 

Not really. The best you can do is to track the number of maint SQL requests (via DBQL) for each session after the last commit (and that will only give you the number of requests, not the number of entries in the TJ).

 

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Highlighted
Enthusiast

Re: how to get TJ space-usage on session-level

Thanks Dave