LOAD INFO RECOVERY - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.50
Published
January 2020
Language
English (United States)
Last Update
2020-02-04
dita:mapPath
frp1571162435023.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Displays information on all loads that are currently being recovered as well as loads that are in the recovery queue (and ready to be recovered once preceding requests have completed).
  • 1 - Session id, tid and load type [MLOAD session 1000 tid 1234]
  • 2 - System being recovered
  • 3 - Checkpoints applied
  • 4 - Total checkpoints
  • 5 - Mload: Will exec be run

Syntax

LOAD RECOVERY LIST [LSN]

Parameters

LSN [optional]
Optional LSN command to get more details about a specific load job in recovery.

Examples

Lists all recovering loads.

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)

Lists specific LSN.

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