Initial full refresh for a PUSH apply
Original Publication Date: 2002-Jan-01
Included in the Prior Art Database: 2003-Jun-18
The present invention relates to Replication process for DB2 (AIX). When using apply with PUSH technique, performance problems in the initial full refresh of the target database are frequently experienced. Depending on transmission time, the table sizes and number of tables in the subscription, this initial refresh could be very long and time consuming. This long refreshing time limits the availability of the data in the target. This problem becomes worse when the initial load in the source database is large and there is a need to do it more than one time. This is only the initial problem, other problems use to go with this, such as when the format for unload file didn’t matched with the target table, the order or name of the column was not the same in the source and in the target, or when any modification in the tables or in the definition of subscription implies a modification in the statements. An additional problem was the amount of log used by the application, making the massive population of the tables in the source. All those problems suggested the need for a new method able to generate in a dynamic way all the statements necessary in the process, avoiding any manual modification and thus, making automatic all those tasks.