All Forums Tools
MNagat 7 posts Joined 03/06
20 Mar 2006
Monitoring rollback / abort progress

Hi experts,I was wondering if there really isn't a way for us to see the progress of a job when it is aborting due to any kind of failure. Specially if it's rolling back what it's done so far.On TD Manager, we can see session and job details. But not any rollback internal steps of the query and info like:- how many records were inserted;- how many were rolled back;- what was the error (specially when the user hasn't received the message yet).Thanks.

Fred 1096 posts Joined 08/04
20 Mar 2006

In V2R5.1 and later, the Recovery Manager (rcvmanager) utility LIST ROLLBACK TABLES command gives progress information related to long rollbacks.RcvManager can be accessed via the Teradata Manager Remote Console tool (if you have appropriate rights).

MNagat 7 posts Joined 03/06
21 Mar 2006

Thanks Fred.Although I'd like to have more detailed info on what happenned to the query, the recovery console does it for us now since we have an estimate of how long it will take to finish.

You must sign in to leave a comment.