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
Which is better way to move table or data between databases.
db2move or load cursor ?