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

Teradata® Business Continuity Manager User Guide - 2.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Business Continuity Manager
Release Number
2.00
Published
August 2024
ft:locale
en-US
ft:lastEdition
2025-01-31
dita:mapPath
sko1694443904278.ditamap
dita:ditavalPath
ft:empty
dita:id
otc1639627713801
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.

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)

Lists specific LSN.

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