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 News

SQL Manager for DB2 version 1.2 released

We are pleased to announce the new minor version of SQL Manager for DB2 - a high performance tool for DB2 server administration and development. You can download the newest version of the software from the download page.

What's new in SQL Manager for DB2 1.2?

  1. Wrappers. The possibility to add/edit/delete wrapper options is implemented.
  2. The Print metadata procedure is fixed for the following objects: aliases, buffer pools, partition groups, event monitors, MQ tables, nicknames, sequences, distinct types, structured types, wrappers, groups, schemas, servers, user mappings.
  3. Databases located at the nodes using a port different from 50000 used to be displayed improperly in the DB Explorer. Fixed now.
  4. Added a number of new data manipulation services:
    • Data export into files,
    • Data import into database tables, 
    • Data load from files into database tables,
    • Data move between different databases.
  5. The default number of records to be loaded into data frame after registering a new database is changed from 1 to 1000.
  6. Added a new database option – Login Timeout, which allows you to restrict the time of user logging in to the server.
  7. Added the Application Monitor which displays the current connections to a database.
  8. New table space options are now available when creating a database (for DB2 version 9.5):
    • Automatic resize,
    • Maximum size,
    • Increase size, 
    • File system caching.
  9. Database tables partitioning is supported now (this option is located at different tabs in 8.x and 9.x DB2 versions).
  10. Databases deleted in other programs were displayed incorrectly when starting SQL Manager for DB2. Fixed now.
  11. A number of new options for table indices are implemented (for DB2 versions 8.x and 9.x).
  12. Automatic capitalization of object names is now available: the Capitalize names option is added.
  13. Added the possibility to change field parameters for created databases. You can now change the field type (only for compatible types) and size (only increment) and set or reset the Not Null option. 
  14. Units of measurement can be defined for any BLOB type when setting its field size.
  15. Fields of the GRAPHIC, VARGRAPHIC and LONG VARGRAPHIC types used to be displayed improperly in the data frame. Fixed.
  16. The new XML Editor tab is added into the BLOB editor.
  17. The support of new objects Security label component, Security policy and Security label are added in the Print data, HTML Report and dependency tree tools. The Label based access control (LBAC) is implemented on the basis of these objects.
  18. A lot of other small improvements and bugfixes.

We hope you’ll enjoy working with our products!