Viewing DB2 Object Data in the Investigator › How to Migrate DB2 Objects › View DB2 Object Relationships in the Topology Viewer

View DB2 Object Relationships in the Topology Viewer

The Topology Viewer provides a pictorial view of your DB2 catalog objects in your system and their relationships. Labeled shapes identify each object, and lines connect objects to show parent-child relationships. Each shape symbolizes a different object type. Each object appears with text to indicate the object type and object name. For example, a table space appears as a square with the words Table Space: SYSDDF. This functionality lets you quickly see the object type and identify the object name.

This view can simplify your ability to identify relationships as you manage your data because the pictorial view can be easier to read than a tabular view. You can also drill down to isolate data within your system. The Topology Viewer provides a better understanding of the DB2 object relationships before you migrate changes and can help when you are performing the following tasks:

• Troubleshooting
• Taking inventory of your system
• Identifying migration sources

  You can launch the Topology Viewer for any row of object data in the catalog of the Investigator. You cannot display application performance or subsystem performance activity in the Topology Viewer.

Note: This task is not required to migrate DB2 objects. However, we recommend that you view the object relationships before proceeding with a migration. Viewing the object relationships provides a clear understanding of the relationships between the objects to help determine the possible impact of the migration before it occurs.

Example: Visualize Objects in the ADMNUSER Table

A DBA often must find the family of objects that relate to a table (that is, the database name, table space name, indexes, and views). With CA Chorus for DB2 Database Management, you can log in to a central web browser and access all systems across multiple LPARs. Not only one LPAR as is the case with the 3270. In the following example, the DBA is trying to identify the objects that are associated with the ADMNUSER table in the DA0G subsystem. This information is especially useful for troubleshooting and planning exercises.

Follow these steps:

1. Add the Investigation Launcher module to a dashboard, and click Start New Investigation.
2. Select DBA for DB2 from the discipline drop-down list.
3. Open a DB2 for z/OS Catalog folder and DB2 version.
4. Select the Table folder.
5. Enter your filter criteria, and click Filter.
6. Select the applicable table row, and click Add to Topology Viewer in the right pane.

   The Topology Viewer opens, loads, and displays the objects that are related to the ADMNUSER table. In this case, the table has two index children. Additionally, the table is part of a table space, which is part of a database and storage group.