Could I stop an abort session?

UDA
Enthusiast

Could I stop an abort session?

I have an abort session of a delete job.

Are there some way to stop the abort session?

6 REPLIES
Enthusiast

Re: Could I stop an abort session?

Alfredo,

If you mean that you have an aborting session and you'd like to kill the abort process, then yes, you can by using the CANCEL ROLLBACK option in Recovery Manager.

Bear in mind though, you'll need the DBC password and you'll probably corrupt the table.
Enthusiast

Re: Could I stop an abort session?

Yes I want to do that.
I have a backup.

Could you tell me how to do it?

My version of teradata is
VERSION 05.00.02.31
RELEASE V2R.05.00.02.28

Thank you
Enthusiast

Re: Could I stop an abort session?

Alfredo,

Do you have a friendly DBA around with access to the database window ?
That's where you'll need to start the recovery manager.

In the Supervisor screen of the database window, type (you'll need to use later on to get out).

Once started, you can then type CANCEL ROLLBACK ON TABLE ;

At which point you'll be prompted for the DBC password.

If you decide to proceed, the abort process will be zapped (along with the table header contents).

You should then treat the table as corrupted. ie drop it and recreate it if necessary.
Enthusiast

Re: Could I stop an abort session?

oops..

Alfredo,

Do you have a friendly DBA around with access to the database window ?
That's where you'll need to start the recovery manager.

In the Supervisor screen of the database window, type 'start rcvmanager' (you'll need to use 'quit' later on to get out).

Once started, you can then type CANCEL ROLLBACK ON TABLE 'table-id' ;

At which point you'll be prompted for the DBC password.

If you decide to proceed, the abort process will be zapped (along with the table header contents).

You should then treat the table as corrupted. ie drop it and recreate it if necessary.
Teradata Employee

Re: Could I stop an abort session?

CANCEL ROLLBACK ON TABLE is not available prior to V2R5.1.
Enthusiast

Re: Could I stop an abort session?

It's correct, we try to use the sentence but we can do it.

Are there some diferent way to do that?