Viewing Db2 utility status

Edit online

You can use the Utility status tab to filter and view the status of the utilities submitted for a specific subsystem over a selected time frame.

Before you begin

  • Ensure Db2 Automation Expert version 1.1.0 is configured for the Utility status tab to be enabled.
  • The Utility status feature is not available with Db2 Administration Tool for z/OS.

Procedure

  1. On the navigation menu, click Explore > Objects.
    The Explore objects page opens.
  2. Specify the search criteria. To know the required fields, refer to Exploring Db2 objects.
  3. Click the subsystem name that is displayed in the result table. The Overview tab is displayed.
  4. Click the Utility status tab.
  5. Select the required field values and check boxes for the following:
    Utility
    Select the utility type from the drop-down for which you want to view the status. You can select more than one value from the drop-down. The valid values are
    • REORG - Reorganizes the tablespace to improve performance.
    • RUNSTAT - Collects and updates statistics for the optimizer.
    • COPY - Creates a backup of the tablespace.
    Status
    Select the status of the utility from the drop-down. You can select more than one value from the drop-down. The valid values are:
    • COMPLETED - Utility execution is completed successfully.
    • ERROR - Utility execution is completed with an error.
    • OPEN - Utility is open for execution.
    Return code
    Select one or more return codes of the utility from the drop-down. You can select more than one value from the drop-down. The valid values are 0, 4, and 8.
    User ID
    Enter the user ID who submitted the utility.
    Evaluation ID
    Enter the evaluation ID of the utility.
    Time range
    Select the time period to fetch the list of utilities that were submitted. This is a mandatory field.
    If you select Custom range from the drop-down, the FROM and TO fields are displayed. The date should be in YYYY-MM-DD HH:mm:ss format.
    Note: The default time value is 24 hours.
  6. Click Apply.

Results

Displays the list of utilities that were submitted in the selected time range.
If you want to customize this view, perform the following to sort the data according to your requirements:
  • Click on the right corner of the table results to search and select the check box of the fields that should be included as columns in the table.
  • Click Apply. The table result is displayed with the updated fields.