This tool is for administration and development in DB2 database.
EMS SQL Manager for DB2 is a high performance tool for DB2 database. This is used to administer and help development in DB2 database. This SQL Manager works with versions 8.1 and 9.7 and supports all DB2 objects and data types. This tool has many DB2 tools including Visual Database Designer to create DB2 database in few clicks, Visual Query Builder to write complex DB2 SQL queries, powerful BLOB editor, DB2 data export and import capabilities and other useful features for efficient DB2 Server administration. The GUI offered by the tool is simple so that comparatively inexperienced users too would be able to get started quite easily with this tool. A wizard makes it even simpler. Database navigation is easy and can be navigated very quickly. Data manipulation facilities available are quite sophisticated. Unicode is supported.
Query building is made easy with visual tools. A report designer makes it simple to generate the kind of reports that you need. Extensive data import and export capabilities are available. The data base designer is quite sophisticated and supports DB2 LUW servers from 8.1 to 9.7. a wizard is available to help compare databases. Effective security management features are available. DB2 objects are easily managed. The operations include create/edit and drop operations. Extensive manipulation of the objects is possible. Security management is also extensive. Wizards that help running DB2 services are easy to use. This is a very good tool. If you have a need, do try it out in actual use.