17.10 - LIST CANCEL ROLLBACK TABLES - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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

Syntax

LIST CANCEL ROLLBACK TABLES ;

Usage Notes

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

The list excludes Permanent Journal (PJ) tables and all DBC tables except DBQL and ResUsage tables.

The LIST ROLLBACK TABLES command report does not include invalid tables, that is, tables on which rollback is being canceled. 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 canceled exist, then only the column headings are displayed.

Example: Displaying a list of tables with canceled rollback processing

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"