Sunday, March 18, 2012

Loading Large Enscribe files, using GoldenGate - Timing estimates

I failed to mention the load times in the previous post, it took some time to collect the data so bear with me. 
The files being loaded ranged up to 10 Gb in size. By using GoldenGate Direct Data Pumps to load the files and their alternate key files, the largest file took approximately 10 hours, but keep in mind this was being performed during normal processing without impacting the current configuration. 

Smaller files ranged in the 100's of megabytes and took approximately 2-4 hours depending on size. All files were being changed from 2 alternate keys to 8 alternate keys. 

Time was not a critical factor since we knew well ahead that this change was needed and didn't fall into the urgent category. 

All of the loads were started after the peak processing time and allowed to run thru the night/early evening. This was a perfect time, although observation showed that GoldenGate tends to "play well" with other processing in our environment. 

Part two coming up describing file load completion and file validation....

No comments:

Post a Comment