Skip to main content

Software > Information Management > IBM DB2 and IMS Tools >

DB2 Test Database Generator


Information Management software
Overview

Is the routine task of creating test data taking up too much of your time?

  • Do you need to broaden the number of developers and administrators that can create test data?
  • Are you concerned about the liability risk of exposing sensitive or confidential production data used in test environments?
  • Do you need a more automated way to compare and synchronize DB2 tables?
  • Is it time consuming to update existing test data because you have to delete and recreate it?

To help you deal with the routine task of creating test data IBM offers DB2 Test Database Generator for the z/OS as well as the Linux, Unix and Microsoft Windows environments. This tool helps both developers and database administrators quickly create test data from scratch or from existing production data. DB2 Test Database Generator is part of IBM's suite of regulatory compliance tools.

Buy DB2 Test Database Generator as part of the DB2 Toolkit, which offers six Tools at a significant cost savings
Visit the DB2 Multiplatform Tools website

Key Features
  • Maintains referential integrity while extracting data sets from source databases using the IBM DB2 Grouper Component.
  • Lets you easily create subsets of DB2 production data while masking out any sensitive or confidential data like identification numbers, salaries, addresses or financial information.
  • Lets you compare and synchronize DB2 tables by automatically creating a pre-copy of the original data and comparing this with post-test data. This helps you quickly and easily revert to your original date, or determine where changes have been made during testing.
  • Allows you to update your existing target data without deleting it entirely then re-creating it. This prevents you from having to delete the impacted data on the target tables before the load is processed.
  • Helps you quickly meet testing needs while protecting private data and avoiding unnecessary liability
  • DB2 Test Database Generator also supports:
    • Additional DB2 Load Format options
    • DB2 JDBC Type 4 Driver
    • DB2 Test Database Generator Server on Linux operating environments
  • Available for DB2 on z/OS, Linux, UNIX, and Microsoft Windows.

Program Numbers:
DB2 Test Database Generator for z/OS, V2.2 (5697-I02)
DB2 Test Database Generator for Multiplatforms, V2.2 (D55TQLL)
DB2 Toolkit for Multiplatforms (D57UKLL)

Application Management


Related Tools
DB2 Audit Management Expert
DB2 Bind Manager
DB2 Data Archive Expert
DB2 Path Checker
DB2 Table Editor
DB2 Web Query Tool
IBM Data Encryption for IMS and DB2 Databases

System Requirements

IBM DB2 Test Database Generator for z/OS, Version 2.2 requires:

  • DB2 Universal Database, Version 7 or later
  • z/OS operating system, Version 1.4 or later
  • SDK for OS/390 Java 2 Technology Edition V1.3, or later

DB2 Test Database Generator for Multiplatforms, Version 2.2 supports DB2 UDB Enterprise Server Edition, Version 8.1 with Fix Pack 7 or later.

For more information on the system requirements for DB2 Test Database Generator on z/OS , see the Program Directory on the Library page.


Offsite link Get Adobe® Reader®


Ready to buy?

View pricing & buy


We're here to help
Easy ways to get the answers you need.
Request a quote
E-mail IBM

or call us at
877-426-3774
Priority code:
104CBW60


Highlights

Analyst Report: Meeting Regulatory Compliance Challenges

Article: "Simplify regulatory compliance with DB2 Tools for z/OS"

Article: Regulatory Compliance and Your Data

Regulatory Compliance Tools Suite (PDF 96KB)


Technical details

Fact Sheet (PDF)

Product Life Cycle


Publications

Library

See analyst report on test data and archiving.

Get Started with Test Database Generator


Trials and Betas

For a trial version of this product, contact IBM.