EMS Data Generator for DB2

What is EMS Data Generator for DB2?

EMS Data Generator for DB2 is an impressive tool for generating test data in DB2 database tables with the ability to save and edit scripts. The utility can help you simulate the database production environment and lets you populate multiple DB2 database tables with test data simultaneously, define tables and fields to generate data, set value ranges, generate DB2 character fields per mask, set value lists manually, or select them in SQL queries,  define generation parameters for each field type and has many other features to generate DB2 test data simply and directly. Data Generator for DB2 also provides a console application, which allows you to generate DB2 test data with one touch, using generation models.

Core features

• Unicode support.
• Friendly wizard interface.
• Ability to save and edit data generated in sql script without running queries on the server.
• Generating data on multiple tables of different databases on a host.
• Support of basic DB2 data types, including user-defined data types based on simple types.
• Different generation types for each field, including list, random and incremental generation, generation in two and more fields simultaneously.
• Ability to use SQL query results as a list of values for data generation.
• Ability to view the generated data.
• Automatic referential integrity control for linked tables.
• Wide variety of generation parameters for each field type.
• Ability to set NULL values for a given percentage of cases.
• Ability to save all generation parameters defined in the current wizard session in a configuration file.
• Command-line utility for generating data using the template file.

System requirements

Microsoft Windows XP, Microsoft Windows Server 2003, Microsoft Windows Server 2008, Microsoft Windows Server 2008 R2, Microsoft Windows Server 2012, Microsoft Windows Server 2012 R2, Microsoft Windows Server 2016, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8 / 8.1, Microsoft Windows 10

20 MB of available HD space for program installation

DB2 Run-Time / Administrative Client 8.0 ou superior

IBM® DB2 Connect (not case of using z platform servers / Series, iSeries, pSeries)