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

Subscribe to our news:
Partners
Testimonials
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.".
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.".

More

Add your opinion

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

DB2 Maestro online Help

Prev Return to chapter overview Next

Dependency tracker

Dependency tracker is a tool to browse all-level dependencies of a schema object (table, view, function, etc). To display dependencies of an object, drag and drop it from the Explorer tree (or Object Manager, Object Browser) to the tracker's working area.

 

This tool allows you to see the way any database object is involved in the net of scheme dependencies. The selected object is displayed in a highlighted rectangle in the center of the working area. The right side of this area represents objects depending on the selected one. The left side represents objects on which the selected object depends.

 

To highlight all occurrences of an object in the diagram, click the appropriate rectangle. Double click an object to change the tracker focus to this object. Right click a rectangle to display a popup menu with common operations related to the appropriate object.

 

 

The recursive dependencies are marked with a semicircle. This means marked object depends on itself directly or via other objects.

 

Example

Suppose we have two procedures A and B calling each other. The tracker displays these dependencies in the following way:

 

 

 



Prev Return to chapter overview Next