LOAD LIST - Teradata Unity

Purpose

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

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