LOAD RECOVERY LIST Command | unityadmin | Teradata Unity - LOAD RECOVERY LIST - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval
dita:id
B035-2520
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.
unityadmin> 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.
unityadmin> 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