• Print this Page

08/28/2007

SQL Manager for DB2 released!

EMS Company is pleased to announce EMS SQL Manager for DB2 - high performance tool for DB2 Database Server administration and development. SQL Manager 2007 for DB2 works with any DB2 versions from 8.1 to 9.0 and supports all DB2 objects and data types. It offers plenty of powerful 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.

SQL Manager for DB2 is also available in freeware (lite) version that has some restrictions in the functionality. Nevertheless, it allows perform the full scope of essential operations.

Learn full information at the product webpage: http://sqlmanager.net/products/db2/manager

You can download SQL Manager for DB2 at: http://sqlmanager.net/products/db2/manager/download

The trial period lasts 30 days.

EMS SQL Manager for DB2 Features:

• 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

• 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

• 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

• 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

• Grant manager displaying all database object grants in the form of a grid
• Easy management of database users, groups and user mappings

• 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

• 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

• 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

• Support of 8.1 and 8.2 DB2 server versions
• Support of most DB2 server platforms (LUW, z/OS, etc.)

• 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

• 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

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

Learn full information at the product webpage: http://sqlmanager.net/products/db2/manager

You can download SQL Manager for DB2 at: http://sqlmanager.net/products/db2/manager/download

The trial period lasts 30 days.

We would like to bring it to your attention that EMS SQL Manager for DB2 is distributed within EMS Maintenance Program – the basic product price includes 1 Year Maintenance for free! There are also variants with 2 and 3 Year Maintenance available for sale that allow to decrease the cost of annual maintenance. You can learn more about EMS Maintenance Program at: http://www.sqlmanager.net/support/faq/maintenance

We hope you’ll enjoy working with our products!