Choose your database:

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.".

Add your opinion

Customers

Become a customer

SQL Maestro Group / Products / DB2 / DB2 Maestro / Documentation

Download

Buy

DB2 Maestro online Help

Return to chapter overview

To manage an existing database with DB2 Maestro, you have to create the according database profile first. A profile stores database connection settings, and some additional options to customize the way the software works with the database. After the creation database profiles appear as nodes in the Explorer tree on the left (profile properties can be later changed with Database Profile Editor).

When the profile is created you can connect to the database. To do so, select the database in the Explorer tree, or either select the Database | Connect to Database main menu item or use the Connect to Database item of the popup menu. You can also double click the database node in the explorer tree. If connection succeeds, the database node expands displaying the tree of database objects (tables, views, procedures, etc). The database becomes ready for your activities.

How can I disconnect from a database?

In order to disconnect from a database you should first select the database in the explorer tree, then either

•	select the Database \| Disconnect from Database main menu item

•	use the Disconnect from Database item of the popup menu.

See also: Connection parameters

Return to chapter overview

SQL Maestro Group wish you a Merry Christmas!

We're happy to grant you a 20% discount for all our products and bundles till December 31!

Company news

May 18, 2023

DB2 Maestro 23.5 released

New version comes with colored tabs, new encryption algorithms in data grids, updated BLOB Editor, database profile usage statistics and a lot of other useful things.

Nov 9, 2013

DB2 Maestro 13.11 released

A new reporting tool, advanced SQL Dump wizard, updated SQL Editor, enhanced data grids, redesigned Start Page, improved Database Explorer, and a lot of other useful things.

May 16, 2011

DB2 Maestro 11.5 released

Completely redesigned Data Export and Data Import wizards, improved database profile management, updated OLAP viewer and a lot of other improvements.

More news

Resources

How to add inline buttons to a webpage created with PHP Generator?

The article shows how to implement an AJAX-based one-click editor for a logical column.

Investigating NBA demo. Part 1: Customizing common templates

This article begins a series of step-by-step tutorials on how we made the NBA demo. It explains how to add new items to the menu, implement run-time theme selection, and tweak the login form.

How to add a chart to a webpage created with PHP Generator?

The article illustrates how to use various chart libraries with PHP Generator.

More resources

Feature of the day

Managing user permissions

DB2 Maestro allows you to grant user/group in two manners: using the Object (to grant the permission on) Editor or within the User (grantor) Editor.

Query Builder

This feature of DB2 Maestro allows you to build and edit the SELECT queries as visual diagrams.

DB2 Maestro online Help

Connect to a database

Christmas Sale