Online Documentation for SQL Query for DB2

Database management tools


SQL Query for DB2 provides a number of tools you may need to manage your DB2 databases. Find the list of common database management operations for working in SQL Query below.

 

 

Cataloging Nodes

  • select the Database | Catalog Node... main menu item or use the corresponding btnRegisterHost toolbar button;
  • set all the necessary options using Catalog Node Wizard which guides you through the whole process of Node cataloging.

 

Cataloging Databases

  • select the Database | Catalog Database... main menu item or use the corresponding btnRegisterDB toolbar button;
  • set all the necessary options using Catalog Database Wizard which guides you through the whole process of Database cataloging.

 

Uncataloging Databases

In order to uncatalog a single database in SQL Query for DB2:

  • select the database to uncatalog in the DB Explorer tree;
  • select the Database | Uncatalog Database main menu item or use the corresponding btnUnregisterDB toolbar button;
  • confirm uncataloging in the corresponding dialog window.

 

In order to uncatalog a node and all databases at the node:

  • select the node to uncatalog in the DB Explorer tree;
  • select the Database | Uncatalog Node main menu item or use the corresponding btnUnregisterHost toolbar button;
  • confirm uncataloging in the corresponding dialog window.

 

Connecting to Databases

In order to connect to a database in SQL Query for DB2:

  • select the database to connect to in the DB Explorer tree;
  • double-click its alias

or

  • select the Database | Connect to Database main menu item or use the corresponding btnConnectToDB toolbar button

or

  • right-click its alias and select the Connect to Database context menu item.

 

Disconnecting from Databases

In order to disconnect from a database in SQL Query for DB2:

  • select the alias of the database to disconnect from or any of its objects in the DB Explorer tree;
  • select the Database | Disconnect from Database main menu item or use the corresponding btnDisconnectFromDB toolbar button

or

  • right-click its alias or any of its objects and select the Disconnect from Database context menu item.