EMS logo

Products Navigation

SQL Manager for DB2

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for DB2

Product FAQs

Table of contents

Q:
What is EMS SQL Manager for DB2?
A:
EMS SQL Manager for DB2 is a powerful tool for DB2 database server administration and development. SQL Manager for DB2 works with various DB2 server versions up to 8.2, and supports most of the latest DB2 features. It offers plenty of powerful tools for experienced users to satisfy all their needs. SQL Manager for DB2 has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.
Q:
What is the difference between Full and Freeware editions of EMS SQL Manager for DB2?
A:
These editions of SQL Manager for DB2 differ in their functionality. You can view the list of all functional differences between full and freeware versions at our Feature Matrix Page.
Q:
What do I need to start working with EMS SQL Manager for DB2?
A:
First of all, you must have a possibility to connect to some local or remote DB2 server to work with SQL Manager. You can download DB2 database server from http://www-306.ibm.com/software/data/db2/. Besides, you need your workstation to satisfy the system requirements of SQL Manager for DB2.
Q:
What is the difference between the Export/Import functions in SQL Manager and the Data Export/Import utilities?
A:
The Data Export/Import for DB2 utilities include some additional features which are not available in SQL Manager, such as:

  • export/import data from/to several tables at once;
  • export/import data from/to tables selected from different databases on one host;
  • a command line utility to export/import data using the configuration file with all the export/import options.
Q:
What is the difference between the Query Builder module in SQL Manager and the SQL Query for DB2 utility?
A:
First of all, SQL Query for DB2 works faster as it is a much lighter product. Besides, it provides additional features for query building, e.g.:

  • keeping query history which allows you to rollback to any edited query;
  • various interface improvements for more productive and easier work.
Q:
What is the difference between the Extract Database function in SQL Manager for DB2 and the DB Extract for DB2 standalone utility?
A:
The DB Extract for DB2 utility includes some additional features which are not available in SQL Manager, such as:

  • extracting metadata and/or data from several databases on one node;
  • a console application for performing extract in one-touch;
  • faster extraction speed.
Q:
I can't modify DDL. Why?
A:
The DDL tab of the SQL Manager editors is read-only. It displays object structure as SQL text and reflects the operations you perform over the object under other editor tabs. To modify an object, you can copy the text to the clipboard and edit it using SQL Script Editor.
Q:
How can I customize data formats in a grid?
A:
You can customize all display formats: integer, float, date, time and date/time using the Color & Formats page of the Environment Options dialog.
Q:
I need to perform some changes in database objects of my test database and then make the same changes on master database. Are there any tools for this purpose in SQL Manager for DB2?
A:
The Database Registration Info dialog provides the Logs tab where you can enable logging metadata changes performed over the database and/or SQL queries executed in SQL Editor.
Q:
I tried to export data from a table, but I found that I could export only the first 1000 records. Can I export all the records from a table if it contains more than 1000 records?
A:
The Export Data function exports only those records which are currently selected in the grid view. The selection is limited to 1000 by default, so you should increase this value to select all the records to be able to export them all. Also you can set the default limit value using the Grid page of the Environment Options dialog.
Q:
What is the difference between the "Extract Database" and "Export as SQL Script" functions?
A:
Export as SQL Script is intended for exporting table data that will be inserted into a database system other than DB2 server. Use Extract Database Wizard to copy metadata and/or data to a database on DB2 server afterwards.
Q:
How can I change the default directory where exported data are saved?
A:
Follow the steps below to change the default directory.

  1. Right-click the database alias in DB Explorer and select the 'Database Registration Info...' context menu item (you can also find this item in the 'Database' main menu) to open the Database Registration Info dialog.
  2. Proceed to the Directories section within the dialog.
  3. Set the 'Default directory for Export Data'.
Q:
I'm getting an error message indicating that there is no 'db2app.dll'. What is wrong here?
A:
To work with DB2, you need to have DB2 Administration Client installed on your system. SQL Manager uses the following libraries: 'db2app.dll', 'db2cli.dll', 'db2abind.dll', 'db2util.dll', 'db2aprep.dll'. Please make sure that the DB2 Client software of correct version is properly installed on your workstation.
Q:
Is it possible somehow to restore my database queries/settings/registrations from the old or faulty HDD, where SQL Manager was installed?
A:
SQL Manager stores all your settings in the Windows registry. It means that the only way to transfer your database data is to get access to the Windows registry. You can do it by loading OS from your old HDD (if possible) or by opening the registry file with a special editor program. If you managed it, you can unload the 'HKEY_CURRENT_USER\Software\EMS\DB2 Manager' branch to the *.REG file, transfer this file to a new system and add information to the registry by double-clicking the file.