Selecting objects for analysis

You use the Objects window of the Log Analysis Advisor to specify the objects for which you want to find quiet times in the database logs.

About this task

The first time you expand each high level element in the list of available objects (for example, Storage Groups, Databases, Table Spaces), the number of matching objects is determined. If this number exceeds the threshold specified in user preferences, a filter window is displayed.

Procedure

  1. The Available objects list displays the objects that reside on the selected Db2 database. The objects are organized by object type. You drill down to the desired object and select it.
    The objects appear in different colors to identify their locations:
    Black
    In both the repository and the Db2® catalog
    Blue
    In the Db2 catalog only
    Red
    In the repository only
  2. In the Available Objects pane, you can also right-click a table space, a database, or a table partition node to display a menu with commands that you can use to change the display status. This gives you a convenient way to reset or check object statuses from within Db2 Recovery Expert. The available commands are Display, Start, and Stop. Selecting any of the options displays another window that allows you to perform the selected operation on the selected object.
  3. When you select an object, its properties display in the Properties pane. The Repository Status field in the Properties pane also identifies an object's location. Each of the properties that are listed vary by object type.
  4. Click the Include button to add the object to the list of objects to analyze. The object appears in the Selected objects list. You can continue to add objects to the Selected objects list until you have selected all of the objects that you want to be included in the log analysis.
    To remove an object from the Selected objects list, click the Remove button. To remove all the objects from the list, click the Remove All button.
  5. You can use the Exclude button to exclude an object from a larger set of objects that are to be analyzed. For example, if you choose to include all objects that are found in a database with the exception of one dependent object, then you would select the database using the Include button and then select one of the dependent database objects and using the Exclude button move it to the Selected objects list.
  6. You can use the Filter button to vary the display of objects as they appear in the Available objects list. The Available objects list displays the objects organized by object type. This organizational scheme is consistent throughout the tree. To vary the objects displayed beneath each object type on any level, select the object type and press the Filter button. You can also open the object type filter window by right clicking on the object type and selecting Create Filter from the menu. A filter window opens where you can specify the filter criteria.
    In addition you modify and remove filters by right clicking on an object type and selecting from the menu either Modify filter or Remove filter . The available object types are as follows:
    • Storage Groups
    • Databases
    • Table Spaces
    • Tables
    • Indexes
    • Views
    • Synonyms
    • Aliases
    • Data types
    • Triggers
    • Functions
    • Stored Procedures
    • Sequences
    • Roles
    • Plans
    • Packages
    • Global Variables
    • Automation Tool Object Profiles
  7. You can define a pattern that will match multiple objects that will be selected for recovery at the time the recovery job is run. To define a pattern, select the node labeled Pattern under the type of object you wish to select and click the Include button. A popup window opens, specific to the type of object that you selected. Specify the pattern and click OK. The object type pattern will appear in the Selected objects list.
    When you expand a pattern in the Selected objects list, you will see all matching objects that are found in the repository or currently exist in the Db2 subsystem.
  8. Click Next. The JCL window opens.