Purpose
Returns a list of recovery loads in progress or ready to start.
Syntax
LOAD RECOVERY LIST LSN ;Parameters
- LSN
- Load session number. Enter an optional session number to see the details for the specified session.
Examples
This shows all recovery loads in progress.
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)This shows load session number 1003 in progress.
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