Question: How can I check Load status in DB2 LUW?

Answer: Checking the DB2 Luw Load Status is achieved by using the load query command. The best way to explain is by demonstrating with a simple example.

The DB2 LUW command is used to load data into a DB2 LUW Table. The data can be stored in many different forms – including named pipe and tape

Starting the load process

connect to mydb; 
create table table2 like table1; 
load from somedata.del of del insert into table2; 

While the load process is in flight , create another connection and view the progress

connect to mydb; 
load query table table2; 
connect reset;

 Read More on topics related to How to check DB2 LUW load status 

db2move to copy data between databases