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

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