One of our TestBase customers, a very large Federal Agency, recently broke what we think must be a world record for fastest RI DB2 test data extraction and subsetting live DB2 production data. Listen to the 6-minute podcast below to learn how this company was able to:

• Extract a 100,000 row subset of Referentially Intact (RI) DB2 data (to be used for testing) from a 300M+ row database of live customer production data in UNDER 2 Minutes
• Took advantage of several clever DB2 features to help facilitate this extremely fast transfer, including
  • Multi-Row Fetch
  • Multi-Row Inserts
  • Global Temporary Tables
  • Key Value Assignments

[audio:https://www.softbase.com/blog/wp-content/uploads/2013/08/TestBase-Populator-Success.mp3|titles=TestBase Populator Success]

(If you the audio player gives an error, reload the page by clicking here: https://www.softbase.com/blog/?p=615)

Not mentioned in the audio above, the same customer was also able to create a similar extract of 25M rows of RI DB2 test data from the same live production database in under 40 minutes – quite an impressive feat.

Click here to learn more about TestBase or feel free to contact us here.