DB2 Maestro
DB2 Maestro is the premier DB2 admin tool for database management, control and development. Key features include:
The application also provides you with a powerful set of tools to manage DB2 users and groups, edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more. With all these features our software will be an everyday assistant in your work with DB2 database server.
|
Top 10 reasons to use DB2 Maestro
Latest DB2 server version support DB2 Maestro supports all the latest versions of DB2 |
Use DB2 Maestro to work with any DB2 version from 8.x to 9.x! The software supports such the server features as views, triggers, functions, procedures, aliases, sequences, user-defined types, tablespaces, and much more.
Powerful security management DB2 security system is easy and clear in DB2 Maestro |
Tune up your DB2 server security policy with several mouse clicks. DB2 Maestro provides you with a number of powerful editors, that make management of DB2 users, groups and their privileges as easy as it can be, even if you are not a skilled DB2 administrator.
Easy database objects management DB2 Maestro is incredibly easy in database objects management |
Windows clipboard, drag-and-drop operations, local pop-up menus - all of them can be used with database objects now! For example, to copy an object, simply drag and drop the object from one database to another, or use the Ctrl+C and Ctrl+V shortcuts instead of performing a long succession of manual operations.
Clear in use Even a newbie can use DB2 Maestro |
DB2 Maestro is as easy in use as Windows explorer! DB2 Maestro provides you with an understandable "explorer-like" navigation style, well-described wizard system, quick launch panel and a lot of other tools and features which do not require deep knowledge of DB2.
Advanced SQL Editor DB2 Maestro allows you to create and execute queries in the most convenient way |
Handy SQL Editor provides you with an ability to execute several queries simultaneously. Each query is executed in a separate thread, so all DB2 Maestro opportunities remain available and there is no need to wait for your complex query to be completed. Such features as syntax highlighting and code completion make your work with the Editor extremely comfortable.
Powerful data export and import DB2 Maestro provides you with advanced data export and import abilities |
DB2 Maestro supports more than twelve formats for data export and six formats for data import. These are MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, CSV, DBF and more. Moreover, DB2 Maestro does not require any additional software installed for all the supported formats.
Full support for BLOB fields DB2 Maestro has an ability to view BLOB data in various ways |
Using DB2 Maestro you can view or edit BLOB data in the following ways: hexadecimal dump, plain text, graphical image or HTML page. A graphical representation of BLOB data supports five image formats: BMP, Windows metafile, JPEG, GIF and PNG.
Viewing data as diagrams DB2 Maestro allows you to build diagrams based on DB2 data |
This exclusive feature represents numeric data from a table or a query result as a diagram with a possibility of customizing its appearance in various ways. You can also easy export the diagram to the following formats: BMP, Windows metafile, PDF, JPEG, PNG and more.
The fastest way for building queries DB2 Maestro allows you to create the SELECT statements visually |
The Visual Query Builder is a powerful tool of DB2 Maestro intended for designing queries as visual diagrams. This tool does not require any knowledge of the SELECT statement syntax, it will form a query automatically, you just need to mark what information do you want to retrieve.
Full customization according to your preferences and needs DB2 Maestro admits to flexible customization |
In DB2 Maestro you can customize the behavior of all its tools, select a user interface scheme and set a lot of other various preferences.