Recovery Manager Commands - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.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 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 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 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 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.