Viewing DB2 Object Data in the Investigator › View Object Relationships

View Object Relationships

As a DB2 database administrator, you can view object relationships for database objects (databases, tables, and so on) and application objects (plans, packages) to reveal the hierarchy of DB2 data structures. This information provides an overall view of the system. This information is necessary when assessing the effects of object deletion, alteration on dependent objects, or when planning new migrations. You can view all, child, and parent relationships.

You can customize the dependent object view by levels and include or can exclude creator IDs.

Follow these steps:

1. Add the Investigation Launcher module to a dashboard, and click Start New Investigation.
2. Select DBA from the discipline drop-down list.
3. Open a DB2 for z/OS Catalog folder and navigate to the DBA object in the tree.

   The Data pane displays the data for the selected DBA object.

4. Click the Filter icon, which resides above the table on the left.
5. Filter data using the available drop-down lists.

   The Investigator displays tabular data that meets your filter criteria.

6. Select rows of data and specify the action to perform.

   The applicable data appears, with header information that provides the context for the data.