Online Documentation for SQL Manager for DB2

EMS SQL Manager FAQ


Please read this page attentively if you have questions about EMS SQL Manager for DB2.

 

 

Table of contents

 

Product questions

 

Common questions

 

Export/Import questions

 

Troubleshooting

 

 

Question/answer list

 

Product questions

 

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/Lite editions of EMS SQL Manager for DB2?

A: These editions of SQL Manager for DB2 differ in price and features. To register SQL Manager for DB2 see the Purchase page, and to learn about the difference in features please go to 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 node;
  • 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.

 

Scroll to top

 

Common questions

 

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. For more details refer to Viewing object DDL structure.

 

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.

 

Scroll to top

 

Export/Import questions

 

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'.

 

Scroll to top

 

Troubleshooting

 

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.

 

Scroll to top

 

If you still have any questions, contact us at our Support Center.