Check if rollback is running (If session is in aborting state) in Teraddata

Aborted session will remain in aborting state until rollback is completed.Run this command in rcvmanager utility:

    > LIST ROLLBACK TABLES; 

 

Example:

# cnsterm 6

Attempting to connect to CNS...Completed.

Hello

> start rcvmanager

start rcvmanager

Started 'rcvmanager' in window 1

 at Thu Jan 16 08:57:30 2020

Input Supervisor Command:

> ^C

# cnsterm 1

Attempting to connect to CNS...Completed.

Hello

  (A Large Cylinder is 6 times the size of a small cylinder)

 Ferret  ==>

 quit

 Waiting for Ferret Slave Tasks to exit

Ferret Exited

 _______

    |                                |              |

    |    ___     __     ____         |    ____    __|__    ____

    |   /      |/  \    ____|    ____|    ____|     |      ____|

    |   ---    |       /    |   /    |   /    |     |     /    |

    |   \___   |       \____|   \____|   \____|     |__   \____|

     Release 16.20.32.11 Version 16.20.32.11

    RCVMANAGER Utility (Jan 96)

 Enter command, "QUIT;" or "HELP;" :>  list rollback tables;

 list rollback tables;

TABLES BEING ROLLED BACK AT 09:00:02 20/01/16

ONLINE USER ROLLBACK TABLE LIST

Host  Session   User ID     Performance Group               AMP W/Count

----  --------  ---------   ------------------------------  -----------

TJ Rows Left   TJ Rows Done   Time Est.

-------------  -------------  ---------

Table ID   Name

---------  ------------------------------------------------------------------

SYSTEM RECOVERY ROLLBACK TABLE LIST

Host  Session   TJ Row Count

----  --------  -------------

Table ID   Name

---------  ------------------------------------------------------------------

Comments