EMS SQL Manager for DB2

Simplify and automate your database development process, design and maintain existing databases, build compound SQL queries EMS SQL Manager 2007 for DB2 is a high performance tool for DB2 Database Server administration and development. SQL Manager 2007 for DB2 works with DB2 versions 8.1 and 8.2 and supports all DB2 objects and data types.

EMS SQL Manager for DB2 offers many powerful and useful tools for experienced users such as Visual Database Designer, Visual Query Builder, and powerful BLOB editor to satisfy all their needs. SQL Manager 2007 for DB2 has a state-of-the-art graphical user interface with a well-described wizard system, so clear in use that even a newbie will not be confused with it.

Here are some key features of "EMS SQL Manager for DB2":
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 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

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

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

Back up and restore database

Rollforward database

Stop, start and restart database

Quiesce and unquiesce database

Reorganize database tables and indexes

Run database statistics

Background mode execution makes it possible to continue working with SQL Manager while any of DB2 services is being performed

Most of DB2 server versions support

Support of 8.1 and 8.2 DB2 server versions

Support of most DB2 server platforms (LUW, z/OS, etc.)

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

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

...and other useful features

Keyboard templates

External Tools editor

To-do list


Requirements:

300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended

64 MB of RAM or more; 128 MB or more recommended

50MB of available HD space for program installation

Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended

Microsoft Mouse or compatible pointing device

Possibility to connect to any local or remote DB2 server


Limitations:

30-day trial