New state-of-the-art graphical user interface
- Office 11 and Windows XP visual schemes support
- 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