15.00 - LIST CANCEL ROLLBACK TABLES - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

LIST CANCEL ROLLBACK TABLES

Purpose  

The LIST CANCEL ROLLBACK TABLES command displays a report containing the table-id, database name, and table name of the tables whose rollback processing during an online, user-requested abort or during Teradata Database system recovery is cancelled.

Syntax  

 

Syntax element...

Specifies...

CANCEL ROLLBACK TABLES

to display the list of tables upon which rollback is cancelled.

Usage Notes  

This report lists all the tables for which rollback is being cancelled, as the process of cancellation of rollback is not instantaneous. The report is in alphabetical order, by the database name and table name.

Note: The LIST ROLLBACK TABLES command report does not include invalid tables, that is, tables on which rollback is being cancelled. Therefore, if all the tables in a session have been specified for rollback cancellation, they appear only in the output of the LIST CANCEL ROLLBACK TABLES command.

If no tables on which rollback is cancelled exist, then only the column headings are displayed.

Example  

The following is sample output of the LIST CANCEL ROLLBACK TABLES command.

PENDING CANCEL ROLLBACK TABLES AT 03:02:25 01/11/15
 
Table ID     Name
----------- ----------------------------------------------
0000:6707   "Department"."Dept_Details"
0000:6712   "Department"."Temp_Table"