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