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.
unityadmin> 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.
unityadmin> 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