LOAD RECOVERY LIST Command | bcmadmin | Teradata Business Continuity Manager - LOAD RECOVERY LIST - Teradata Business Continuity Manager

Teradata® Business Continuity Manager User Guide

Product
Teradata Business Continuity Manager
Release Number
1.0
Published
January 2022
Language
English (United States)
Last Update
2022-01-27
dita:mapPath
otc1639627713801.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2550
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Returns a list of recovery loads in progress or ready to start.

Syntax

LOAD RECOVERY LIST LSN ;

Parameters

LSN
Load session number. Enter an optional session number to see the details for the specified session.

Examples

This shows all recovery loads in progress.
bcmadmin> load recovery list;
Recovery Loads In Progress: 1
----------------------------------------------------
LSN:    1003

Table: testDB.mloadA

Table: testDB.mloadB

Transaction ID                : 286
Latest checkpoint applied     : 0
System being recovered        :
 managed2: processing checkpoints/data (last checkpoint taken: 0) 
This shows load session number 1003 in progress.
bcmadmin> load recovery list 1003;
Recovery Loads In Progress: 1
----------------------------------------------------
LSN:    1003

Table: testDB.mloadA
    Error tables: testDB.mloadA_et1 testDB.mloadA_et2
    Work table: testDB.mloadA_wt
Table: testDB.mloadB
    Error tables: testDB.mloadB_et1 testDB.mloadB_et2
    Work table: testDB.mloadB_wt
Transaction ID                : 286
Load Type                     : mload
Latest checkpoint applied     : 0
System managed2:
  2 data connections
  State: processing checkpoints/data (last checkpoint taken: 0)
  Approximate data loaded: 110 bytes
  Approximate rows applied: 10