LOAD LIST Command | unityadmin | Teradata Unity - 17.00 - LOAD 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

Purpose

Displays information on all client loads that are currently loading data through Unity.

Syntax

LOAD LIST [LSN] ;

Parameters

LSN [optional]
Optional LSN command to get more details about a specific client job that is currently in progress.

Examples

Lists all current loads.

unityadmin> Load List;
Client Loads In Progress: 2
----------------------------------------------------
LSN:    1000

Table: testDB.testtable3

Transaction ID                : 61
Latest client checkpoint      : 21
Systems participating in load :
  managed1: processing checkpoints/data (last checkpoint taken: 21)
  managed2: processing checkpoints/data (last checkpoint taken: 20)
----------------------------------------------------
LSN:    1004

Table: testDB.testtable2

Transaction ID                : 85
Latest client checkpoint      : 3
Systems participating in load :
  managed1: processing checkpoints/data (last checkpoint taken: 3)
  managed2: processing checkpoints/data (last checkpoint taken: 3)

Lists specific LSN

unityadmin> LOAD LIST 1004;
----------------------------------------------------
LSN:    1004

Table: testDB.testtable2
    Error tables: testDB.testtable2_error_a testDB.testtable2_error_b

Transaction ID                : 85
Load Type                     : fastload
Latest client checkpoint      : 11
Endpoints participating in load:
  region1_ept
  region2_ept

Load Size                     : 990000 bytes
Load rows applied             : 110000 rows applied

System managed1:
  2 data connections
  State: processing checkpoints/data (last checkpoint taken: 11)
  Approximate data loaded: 990000 bytes
  Approximate rows applied: 110000
System managed2:
  2 data connections
  State: processing checkpoints/data (last checkpoint taken: 10)
  Approximate data loaded: 900000 bytes
  Approximate rows applied: 100000