Online Documentation for SQL Manager for DB2

Database Management

SQL Manager 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 Manager below.

 

 

Registering Nodes

In order to register a node in SQL Manager for DB2:

• select the Database | Register Node... main menu item, or use the corresponding Register Node toolbar button;
• right-click any node alias and select the Register Node... context menu item in the DB Explorer tree;
• set all the necessary options using Register Node wizard which guides you through the entire process of node registration.

 

Unregistering Nodes

In order to unregister a node in SQL Manager for DB2:

• select the node to unregister in the DB Explorer tree;
• select the Database | Unregister Node main menu item, or use the corresponding Unregister Node toolbar button;
• right-click the node alias and select the Unregister Node context menu item in the DB Explorer tree;
• confirm unregistering in the corresponding dialog window.

 

Viewing and Editing Node Properties

In order to view/edit node properties in SQL Manager for DB2:

• select the node in the DB Explorer tree;
• use the corresponding Properties toolbar button;
• right-click the node alias and select the Node Properties context menu item in the DB Explorer tree.

 

Creating Databases

In order to create a database in SQL Manager for DB2:

• select the Database | Create Database main menu item, or use the corresponding Create Database toolbar button;
• set all the necessary options using Create Database wizard which guides you through the entire process of creating a new database.

 

Dropping Databases

In order to drop a database in SQL Manager for DB2:

• select the database to drop in the DB Explorer tree;
• select the Database | Drop Database main menu item;
• confirm dropping in the corresponding dialog window.

 

Registering Databases

In order to register a single database in SQL Manager for DB2:

• select the Database | Register Database... main menu item, or use the corresponding Register Database toolbar button;
• right-click any database alias and select the Register Database... context menu item in the DB Explorer tree;
• set all the necessary options using Register Database wizard which guides you through the entire process of database registration.

 

Unregistering Databases

In order to unregister a database in SQL Manager for DB2:

• select the database to unregister in the DB Explorer tree;
• select the Database | Unregister Database main menu item, or use the corresponding Unregister Database toolbar button;
• right-click the database alias and select the Unregister Database context menu item in the DB Explorer tree;
• confirm unregistering in the corresponding dialog window.

 

Connecting to Databases

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

• select the database to connect to in the DB Explorer tree;
• select the Database | Connect to Database main menu item, or use the corresponding Connect to Database toolbar button;
• right-click the database alias and select the Connect to Database context menu item in the DB Explorer tree.

 

Disconnecting from Databases

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

• select the database to disconnect from in the DB Explorer tree;
• select the Database | Disconnect from Database main menu item, or use the corresponding Disconnect from Database toolbar button;
• right-click the database alias and select the Disconnect from Database context menu item in the DB Explorer tree.

 

Viewing and Editing Database Registration Info

In order to view/edit database registration info in SQL Manager for DB2:

• select the database or any of its objects in the DB Explorer tree;
• select the Database | Database Registration Info... main menu item;
• right-click the database alias or any of its objects and select the Database Registration Info... context menu item in the DB Explorer tree.

 

Viewing and Editing Database Properties

In order to view/edit database properties in SQL Manager for DB2:

• select the database in the DB Explorer tree;
• select the Database | Database Properties main menu item, or use the corresponding Properties toolbar button;
• right-click the database alias and select the Database Properties... context menu item in the DB Explorer tree.

 

Viewing and Editing Node Registration Info

In order to view/edit node registration info in SQL Manager for DB2:

• select the node in the DB Explorer tree;
• right-click the node alias and select the Node Registration Info... context menu item in the DB Explorer tree.

 

 

---