EMS Data Import for DB2 is a powerful tool to import data to DB2 tables from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, RTF, ODF and HTML files. It provides adjustable import parameters, including source data formats for all the fields and destination DB2 data formats for the selected fields, commit options, number of records to skip, etc. Data Import for DB2 includes a wizard, which allows you to set all the DB2 import options for different files visually, and a command-line utility to execute import to DB2 database in one-touch.

EMS Data Generator for DB2 is an impressive tool for generating test data to DB2 database tables with the possibility to save and edit scripts. The utility can help you to simulate the database production environment and allows you to populate several DB2 database tables with test data simultaneously, define tables and fields for generating data, set value ranges, generate DB2 char fields by mask, define lists of values manually or select them from SQL queries, set generation parameters for each field type and has many other features to generate DB2 test data in a simple and direct way. Data Generator for DB2 also provides a console application, which allows you to generate DB2 test data in one-touch by using generation templates.