Exploring the Db2 catalog

Edit online

Use the IBM® Z Database Assistant object explorer to display information about the database objects in a Db2® subsystem.

Before you begin

Tip: You can also use natural-language queries in the Assistant chat to complete tasks described in this topic. For more information, see Obtaining Db2 subsystem information by using the Assistant chat.

Procedure

  1. From the side navigation panel, select the Db2 for z/OS® subsystem that you want to work with and open the Object explorer view.
  2. Select the object type that you want to explore:
    • Storage groups
    • Databases
    • Table spaces
    • Tables Indexes Sequences
    • User-defined types
    • Schemas
    • Views
    • Triggers
    • Stored procedures
    • User-defined functions
    • Packages
    • Plans
    • REST services
    • Global variables
  3. Optional: To display the referential integrity associated with an object, including parent-child relationships, click the View relationships icon in the RI column ().
  4. Click an object in the Name column to display details about that object.
    The object details are displayed in the following tabs:
    • The Properties tab displays the properties and their values for the selected object.
    • The Objects tab displays objects that are associated with the selected object. To display objects that the system created automatically, select View implicit objects. You can continue to navigate objects by clicking values in the Name column.

    You can refresh the data by clicking the Refresh icon ().

Filtering by multiple columns

Edit online

You can apply a complex set of filtering criteria to display the objects that you want to work with.

Procedure

  1. Click the Filter icon () in the toolbar at the top of the page to display the Filter dialog.
  2. Select a column that you want to filter on, an operator, and a value (for example, Name Starts with DB1), and click Add new filter rule to add it to the list. Repeat this process to add additional filter criteria.
    The operators and values vary depending on the characteristics of each column.
    Note: The following types of objects contain columns that can have blank values:
    • Databases: Storage group, Buffer pool
    • Packages: Version
    • Plans: Group member
    • Stored procedures: Version
    • Triggers: Version
    • User-defined functions: Language, Version
    When you specify a blank value for one of these columns in conjunction with the EqualTo or NotEqualTo operator, you can still apply the filter criteria. For example, specifying the Storage group column for a database object, and selecting the Equal to operator but leaving the Value field blank is a valid filter set of criteria.
  3. Select Match all to display only results that meet all of the criteria that you specified, or select Match any to display results that meet one or more of the criteria that you specified.
  4. Click Apply to apply the filter criteria. The filtered set of data is displayed. The filter icon is displayed next to the column names that are included in your filter criteria.
  5. Click Clear filters to re-display the unfiltered column data.