db2move vs load cursor

Gopalan Venkatramani

db2move vs load cursor

Archive plan for a Table1

Server A (sample1) ------------ Server B (sample2)

 

1 ) Rename the table1 to table1_old

2 ) create table table1

3 ) move the table1_old from sample1 to sample2 ( first time )

4 ) after that every month - follow step 1, 2 and do load cursor to transfer data between sample1 and sample2

Why load cursor because of "insert into "

 

This is what I'm planning for archiving of table

Question :

Which is better way to move table or data between databases.

db2move or load cursor ?

 

 

 

 

Glenn

DB2 LUW