Recovery Manager Commands - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Recovery Manager presents a command-line environment that allows the entry of Recovery Manager commands. Commands must be terminated with a semicolon.

The following table summarizes the commands.

Command Description
CANCEL ROLLBACK ON TABLE Cancels rollback processing on tables currently undergoing rollback as part of a Teradata Database system recovery or an online, user-transaction abort.
DEFAULT PRIORITY Sets the priorities to the default values.
HELP Displays the syntax for the commands supported by rcvmanager.
LIST CANCEL ROLLBACK TABLES 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 canceled.
LIST LOCKS Displays all locks currently held by transaction recovery.
LIST ROLLBACK TABLES Displays a report with the names and details of the tables undergoing rollback in the Teradata Database system.
LIST STATUS Displays transaction recovery information and AMP recovery information for unavailable AMPs or detailed information about the recovery process of a specific AMP.
QUIT Exits rcvmanager.
REBUILD/RECOVERY PRIORITY Sets or displays a priority level for use by the Table Rebuild utility and a Teradata Database system recovery operation.
ROLLBACK SESSION...WORKLOAD Sets or displays the workload used by rollbacks for a specified host and session.

The following sections describe each of the Recovery Manger commands in more detail.