Monitoring rollback / abort progress

Tools
Enthusiast

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.
2 REPLIES
Teradata Employee

Re: Monitoring rollback / abort progress

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).
Enthusiast

Re: Monitoring rollback / abort progress

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.