Online Documentation for DB Extract for DB2
EMS DB Extract FAQ
Please read this page attentively if you have questions about EMS DB Extract for DB2.
- What is DB2 Extract utility?
- What do I need to start working with DB2 Extract?
- What is the easiest way to configure template files for the console application of the extract utility?
- Are there any limitations implied in the trial version as compared with the full one?
- When I try to connect to the database, I get the following error: "Cant load db2cli.dll". What is wrong here?
Question/answer list
Q: What is DB2 Extract utility?
A: EMS DB Extract for DB2 is a powerful and easy-to-use utility for creating database backups in the form of SQL scripts. It allows you to save metadata of all database objects as well as table data. DB Extract for DB2 includes a GUI wizard guiding you through the extract process step by step, and a command-line service for creating backups in one-touch.
Q: What do I need to start working with EMS DB2 Extract?
A: First of all, you must have a possibility to connect to some local or remote DB2 server to work with DB2 DB Extract. You can download DB2 database server from https://www.ibm.com/products/db2 (download is free). Besides, you need your computer to satisfy the system requirements of DB Extract for DB2. The utility runs on Windows NT4/2000/XP, CPU Pentium 166, 32 Mb RAM or higher is recommended.
Q: What is the easiest way to configure the template files for the DB2 Extract console application?
A: You can configure the template files visually using the DB Extract wizard. Set the required extract options in all steps of the wizard and use the Tools | Save template menu item. All the options will be saved to a *.ext template file which can be used afterwards in the console application.
Q: Are there any limitations implied in the trial version as compared with the full one?
A: Actually the trial version of the utility does not differ from the full version as far as the functionality is concerned. That is, you can test all the features implemented in DB Extract for DB2 within the 30-day trial period.
Q: When I try to connect to the database, I get the following error: "Cant load db2cli.dll". What is wrong here?
A: For working with a remote DB2 server you need to have DB2 Client installed on your workstation. Obviously file db2cli.dll is missing or corrupted. Please make sure that the DB2 Client software is properly installed on your PC.
If you still have any questions, contact us at our Support Center.