Full version Lite version
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
up to 5
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