Viewing DB2 Object Data in the Investigator › View Catalog Objects

View Catalog Objects

Use this procedure to display DB2 catalog object data in the Investigator. An object tree is used with nodes that represent the DB2 catalog objects such as database, table space, tables, and so on. This data lets you determine status, identify an issue, and confirm changes in the DB2 database.

As you drill down into catalog tabular data, the Investigator table header includes information to indicate how you arrived at a piece of data. If you filter data, those values appear as header information in your results. Sets of actions are provided to view, navigate, and perform administrative actions like migrate and visualize.

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. This category displays DB2 version specific catalog information to take an inventory of your catalog and to analyze object relationships quickly.
4. Select the folder matching the version of the DB2 being accessed.
5. Drill down to and select an object type.
6. Click the Filter icon, which resides above the table on the left.
7. Filter data using the available drop-down lists.

   The Investigator displays tabular data that meets your filter criteria.

8. (Optional) Select rows of data and specify the action to perform.

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

   Note: If multiple rows are selected, the Detail pane shows information for only the first row selected.