Purpose
Displays information on all client loads that are currently loading data through Business Continuity Manager.
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.
bcmadmin> 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
bcmadmin> 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