[Skip to Content]
Fresche Quadrant Software BCD Software SoftBase NetLert

Archive for the ‘Podcasts’ Category

[Podcast] Fastest DB2 Test Data Subsetting: From 300M rows production to 100,000 rows RI test data in <2 minutes

All Baseline Posts, Application Testing, Podcasts

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 clip: Adobe Flash Player (version 9 or above) is required to play this audio clip. Download the latest version here. You also need to have JavaScript enabled in your browser.

(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.