Effective security management
Easy management of database users groups and user mappings
Easy management of database users groups and user mappings
Effective security management
- Easy management of database users groups and user mappings
- Grant Manager displaying all database object grants in the form of a grid
Powerful visual database designer
Easy management of all DB2 objects
- Managing event monitors
- Managing materialized query tables
- Managing nicknames and aliases
- Managing procedures, functions, sequences and packages
- Managing servers and wrappers
- Managing tables and all their subobjects
- Managing tablespaces, buffer pools and partition groups
- Managing user-defined types and structure types
- Managing users groups and user mappings
- Managing views and all their subobjects
- Viewing dependencies between database objects
Efficient reports management
- Create Report Wizard allows you to create simple reports in a few clicks
- Managing reports in the same way as if they were database objects
- Report Designer with clear in use report construction tools
Easy-to-use wizards for running DB2 services
Other useful tools to make your work with DB2 server as easy as it can be
- External Tools editor
- Extracting metadata and data to files or SQL Script Editor
- HTML Report wizard to create a detailed HTML report of your database quickly
- Powerful print metadata module to create customizable metadata reports
- SQL Monitor
- Database Activity monitor
- Database version control repository management
- Getting script revealing differences in database states
- History of database metadata changes
New state-of-the-art graphical user interface
- Fully customizable program interface
- Navigation bars with hot actions in most of the windows
- Office 11 and Windows XP visual schemes support
- Windows Toolbar to switch between forms easily
Rapid database management and navigation
- Multiple database connections
- Multiple user-defined tabs for any tree node to access it in one-click
- Projects to work with the selected database objects only
- Working with multiple selected objects at a time
Advanced data manipulation tools
- Exporting data to SQL script as INSERT statement
- Multi-level master-detail view to work with several linked tables at the same time
- Plenty of useful tools such as data grouping fast search and filtering
- Powerful BLOB viewer with several types of viewing BLOB data
- Table and card views to see data the way you like
Excellent visual and text tools for query building
- Ability to view query plans as diagram
- Multiple SQL editors with code completion and syntax highlight
- Using Favorite Queries
- Visual Query Builder allows you to build complicated queries
Impressive data export and import abilities
- Data export - adjusting data formats
- Data export - selecting fields to export
- Data export - selecting format to export data
- Data export - setting options to export data to MS Excel
- Data export - setting options to export data to HTML
- Data import - defining columns to import from CSV
- Data import - selecting format to import data





