Friday, March 16, 2012

File builds in preparation for conversion

The files that were to have alternate keys added were all archived data, required by various applications and regulations to be online and available.
Many of these files were either Enscribe type 2 or were about to become candidates for a type 2 file because of the size, some contain data dating back to the late 70's early 80's and are several gigabytes of storage.
We created a template for the files, using FUP, and set the required alternate keys adding 6 new keys instead of the previous 2.
When file was created on the Primary site, we already had GETFILEOPS enabled for the current GoldenGate replication environment so the new files, primary with new alternate keys and the larger alternate file were created automatically on the Recovery or DR site.
A quick check of all files on both systems confirmed that we had new files ready for loading the data.
Next up I will describe how we loaded these files, discuss how long it took to move data and the benefits of using GoldenGate to perform the load.
- Posted using BlogPress from my iPad

No comments:

Post a Comment