Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Jeff Rule: "I have to tell you I am really impressed. I have never had a software company turn around a bug fix like this so fast. I have been doing database work for over 20 years and that has never happened.".
Ilakshi Rathod : "This tool is just wonderful. I have never seen any tool for DB2. This tool provides very good features which helps in ease us work as well as quick resolution of any errors.".

More

Add your opinion

SQL Maestro Group / Products / DB2 / DB2 Maestro

DB2 Maestro

DB2 Maestro

DB2 Maestro is the premier DB2 admin tool for database management, control and development. Key features include:

  • Support for all DB2 versions from 8.x to 9.x
  • Easy database object management
  • Database Designer
  • Comfortable access to DB2 security features
  • Data management: editing, grouping, sorting and filtering abilities
  • Handy SQL Editor with code folding and multi-threading
  • Visual Query Builder with support for subqueries and UNIONS
  • Data export/import to/from the most popular formats
  • Powerful BLOB Viewer/Editor

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.