Online Documentation for SQL Manager for DB2

Database Tools


SQL Manager for DB2 provides a number of powerful tools that allow you to perform various operations over your databases.

 

SQL Monitor

Displays all the SQL statements executed while working in SQL Manager for DB2.

 

SQL Script Editor

Executes SQL scripts in the database.

 

Search in Metadata

Provides quick search for a string within the scope of database metadata.

 

Extract Database Wizard

Extracts the table metadata and/or data to an SQL script which can be executed later on another machine to restore the database structure and/or data.

 

Activity Monitor

Displays all current connections to a database.

 

Print Metadata

Creates powerful metadata reports in the WYSIWYG mode ready for printing.

 

HTML Report

Creates powerful metadata reports in the HTML format.

 

Reports management

Tools for efficient management of reports: creating, editing, viewing, printing.

 

Dependency Tree

Allows you to view all the object dependencies in one diagram.

 

CLP Console

Allows you to execute the DB2 CLP commands.

 

Compare Databases

Creates an SQL script that provides database structure synchronization.

 

Grant Manager

Allows you to manage grants on your DB2 database objects.

 

Visual Database Designer

Allows you to lay out your database schema visually.

 

Project Interaction

Creates projects which allow you to work with virtual databases that do not require connection to the server.

 

External Tools

Allows to add external Windows applications.

 

Using templates

Facilitates using SQL Manager wizards.