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 Features

New state-of-the-art graphical user interface

  • The possibility to choose different visual schemes
  • Well-described Wizard System
  • User-friendly Database Explorer for easy management of all DB2 objects
  • Windows Toolbar to switch between windows easily, like in Windows Task Bar
  • Navigation bars and hot keys in most of the windows
  • Ability to save all program settings
  • Customizable toolbars for all program windows
  • Fully customizable program interface
  • Powerful visual options module
  • Localizable program interface

Easy management of all DB2 objects (including create / edit / drop operations)

  • Managing database schemas
  • Managing tables and all their subobjects: fields, primary, unique and foreign keys, indexes, triggers, and check constraints
  • Managing views and all their subobjects: fields and triggers
  • Managing materialized query tables
  • Managing procedures, functions, sequences and packages
  • Managing user-defined types and structure types
  • Managing nicknames and aliases
  • Managing users, groups and user mappings
  • Managing tablespaces, buffer pools and partition groups
  • Managing packages
  • Managing global variables
  • Managing event monitors
  • Managing servers and wrappers
  • Duplicating database objects
  • Viewing dependencies between database objects

Rapid database management and navigation

  • Multiple database connections
  • Registering selected databases to work with
  • Projects to work with the selected database objects only
  • Multiple user-defined tabs for any tree object to access it in one-click
  • Working with multiple selected objects at a time
  • Grouping / Ungrouping registered databases by node name

Advanced data manipulation tools

  • Unicode support
  • Powerful BLOB viewer/editor with several types of viewing BLOB data: simple text, RTF text, sequence of hexadecimal values, image, HTML page, XML document
  • Exporting data to SQL script as INSERT statement
  • Plenty of useful tools such as data grouping, fast search and filtering
  • Multi-level master-detail view to work with several linked tables at the same time
  • Table and card views to see data the way you like
  • Ability to copy and paste selected records
  • Ability to continue working with SQL Manager while data are being fetched from the DB2 server
  • A fetching process taking too long to execute can be aborted

Effective security management

  • Grant manager displaying all database object grants in the form of a grid
  • Easy management of database users, groups and user mappings
  • Support of LBAC (Label Based Access Control)
  • Possibility to work with private contexts, security policies, audit policies and roles

Excellent visual and text tools for query building

  • Multiple SQL Editors of the Visual Studio 2005 kind with Code Folding, UNICODE support, code completion, syntax highlight and other useful features
  • Visual query builder allows you to build complicated queries without any knowledge of SQL syntax
  • Large script execution (SQL script editor) with UNICODE support
  • Ability to view query plan as diagram
  • SQL Formatter (available from SQL Editor context menu)
  • Favorite Queries (save and use your frequently used queries easily)
  • Ability to continue working with SQL Manager while a query is being executed in SQL Editor or Query Builder
  • A query taking too long to execute in SQL Editor or Query Builder can be aborted

Impressive data export and import capabilities

  • Exporting data to most popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF, etc.
  • Importing data from MS Excel, MS Access, DBF, XML, ODF, TXT and CSV
  • Background mode execution makes it possible to continue working with SQL Manager while an import or export process is being performed

Report designer with a clear in use report construction wizard

  • Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree
  • Create Report Wizard allows you to create simple reports in a few clicks

Easy-to-use wizards for running DB2 services

  • Backing up and restoring database
  • Rollforward of database
  • Stopping, starting database manager
  • Restarting database
  • Quiescing and unquiescing database
  • Reorganizing database tables and indexes
  • Running database statistics
  • Support of DB2 server tools: IMPORT, EXPORT, MOVE, LOAD
  • Background mode execution makes it possible to continue working with SQL Manager while any of DB2 services is being performed
  • Ping database

Most of DB2 server versions support

  • Support of DB2 LUW servers from 8.1 to 9.7

Powerful Visual Database Designer

  • Two diagram notations (IDEF1x and IE)
  • Useful diagram navigation tool
  • Reverse engineering
  • Several pages in one diagram to divide the diagram into different subject areas
  • Ability to create/edit/drop database objects, visually set links between them
  • Virtual objects such as comments and virtual relationship
  • Saving as image or printing database diagram
  • A lot of visual personalization options

Working with projects. Ability to create databases even without connecting to the server

  • Creating projects - virtual set of locally stored database objects
  • Editing, adding and deleting project objects
  • Working with projects in Visual Database Designer (VDBD)
  • Creating scripts generated by comparing the project structure with the actual database
  • Fast publication of the project either to an existing or newly created database
  • Ability to duplicate project objects and to add actual databases objects to the project
  • Uploading and printing project metadata
  • Generating HTML reports of the project

Other useful tools to make your work with DB2 server as easy as it can be

  • Extracting metadata into text files or SQL Script Editor
  • Powerful print metadata module to create customizable metadata reports
  • Report designer for building powerful reports visually
  • SQL Monitor
  • HTML Report wizard to create a detailed HTML report of your database quickly
  • Dependency tree tool allows to view dependencies between database objects
  • Active database connections Monitor
  • Support of Team Development
  • Create Tag Wizard to remember the current database state
  • Check Repository Wizard reveals differences between a database and its description in the repository
  • Get Change Script Wizard allows you to get a script removing differences between two database states
  • History of changes made to a database or an object
  • CLP console
  • Database Comparer Wizard

...and other useful features

  • Keyboard templates
  • External Tools editor
  • To-do list