Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 16 Jun 2005 @ 17:43:11 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Question of Aborting an Abort operation
From:   Samuel Chu

I guess the question is how to abort a rollback/recovery session?

A recovery session show up in PMON as abort status.

Only V2R5.1 or higher has this ability. It is part of rcvmanager. Check the UTILITY REFERENCE Manual for the details. Basically, use list rollback tables; to see the table in question and capture the table id then use cancel rollback on table <table id found in list rollback tables>; to abort the recovery session.

Beware that once the rollback table had been aborted the table can only be drop or delete. If the data in the table need to be capture, it need to be capture before the job aborted.

Hope this helps,

Samuel Chu
Gap Inc.
DataBase Engineer

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016