DB Extract for DB2

What is DB Extract for DB2?

EMS DB Extract for DB2 is an impressive and easy-to-use tool for creating DB2 database backups in a form of SQL scripts. This database script utility allows you to save the metadata of all DB2 database objects, as well as the db2 table data as a snapshot of the database. DB2 database extraction scripts database objects in the correct order according to their dependencies. Flexible customization of the extraction process allows you to select objects and data tables for the DB2 database dump and adjust many other extraction options. DB Extract for DB2 includes a graphical wizard that will guide you through the DB2 extract step process by step, and a command-line utility to create DB2 backups in one touch.

Core features

• Unicode media.
• Friendly wizard interface.
• Selecting Database Objects for Extraction.
• Possibility to set constraints for extracted table data.
• Possibility to enter instructions for emptying tables before entering extracted data.
• Extracting data from the table to SQL script as INSERT statements.
• Possibility to extract database objects in the correct order according to their dependencies.
• Possibility to compress the result script and divide it into volumes.
• Possibility to select charset for the result file.
• Saving all extraction parameters defined in the current wizard session.
• Command-line utility for extracting metadata and data using the configuration file.

System Requirements

• Intel Pentium II compatible processor of 300 MHz (MHz) or faster; Recommended 600 MHz (MHz) processor
• Microsoft Windows NT4 com SP4 ou posterior, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista, Microsoft Windows 7
• 64 MB of RAM or more; 128 MB or more recommended
• 20 MB of available HD space for program installation
• Super VGA (800x600) or higher resolution video adapter and monitor; Super VGA (1024x768) or higher resolution video adapter and monitor is recommended
• Microsoft mouse or compatible pointing device
• DB2 Run-Time / Administrative Client 8.0 ou superior
• IBM DB2 Connect (no case of using servers gives platform z / Series, iSeries, pSeries)