Advertisement

EMS SQL Manager for DB2 Lite 1.4.0.1

Publisher's Description

EMS SQL Manager for DB2 Freeware (EMS SQL Manager Lite for DB2) is an excellent freeware graphical tool for DB2 Server administration. It has minimal required set of instruments for those users who are new to DB2 server and need only its basic functionality.

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
• Plenty of useful tools such as data grouping, fast search and filtering
• 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
• Large script execution (SQL script editor) with UNICODE support
• 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

Easy-to-use wizards for running DB2 services

• Backing up and restoring database
• Rollforward of database
• Stopping, starting database manager
• Quiescing and unquiescing database
• Reorganizing database tables and indexes
• Running 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 DB2 server versions from 8.1 to 9.5
• Support of most DB2 server platforms (LUW, z/OS, etc.)

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
• SQL Monitor
• Dependency tree tool allows to view dependencies between database objects

other useful features

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

Category : Database Management
Size : 47.53 Mb
Added : Tuesday, January 26th, 2010
License : Freeware
Downloads: 94 times
Developer : Website
System Requirements : Win 2000/XP/2003/ 2008/Vista

EMS SQL Manager for DB2 Lite 1.4.0.1 Copyright Information
Using EMS SQL Manager for DB2 Lite 1.4.0.1 crack, password, serial numbers, registration codes, key generators is illegal it's not collection on softfive.com. We at softfive.com also does not provide download link from file hosting sites such as Rapidshare, Easyshare, Megaupload, Sendspace, Depositfiles, Uploading, Sharingmatrix, Letitbit, Hotfile, Yousendit, Kewlshare, Ziddu, Mediafire, file2box and so on.

EMS SQL Manager for DB2 Lite 1.4.0.1

Advertisement