Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

Creating a Utility Status view

Use the following procedure to create a new Utility Status view.

Related topics

Displaying-utilities


New console
  1. Open or create a workspace.
  2. In the DB2 Navigator perspective, click the Add View NW_plus_circle_o.png menu arrow, and then click Add Utility Status View.

  3. In the Add Utility Status View dialog box, complete the following fields or accept the displayed default values:


    Field

    Action

    DB2 Connection

    Use either of the following methods:

    • Type the full or partial name of a Db2 connection to select the first subsystem that matches this value in the list of favorite connections.

    • Use the menu arrow to select from your list of favorite connections.

      Tip

      You can add Db2 connections to your list of favorite connections by clicking NW_plug_connect_square_green.png and specifying which connections to include.

    Utility Type

    (BMC.DB2.SPE2210)

    Select one of the following utility types:

    • BMC Utility Status—displays a list of BMC PLUS utilities running on a specified Db2 subsystem
    • Db2 Utility Status—displays a list of IBM Db2 utilities running on a specified Db2 subsystem

    Filter

    Enter a filter pattern for the Utility ID.

  4. Click OK.The navigation pane lists the matching utilities and displays the following information for each one:
    • User ID 
    • Utility ID
    • Status
    • Utility name
    • Phase
    • Db2 Subsystem ID (BMC Utility Status View only)
    • Database (BMC Utility Status view only)
    • Space name (BMC Utility Status view only)
    • Job Name (Db2 Utility Status view only)
    • Timestamp (Db2 Utility Status view only)

  5. (Optional) On the BMC Utility Status view, select a utility, and then select Navigate To > BMC Utility Status Details.

    The BMC Utility Status Details view shows the objects that the utility accesses and includes the following information about each object:

    • Fully qualified object name
    • Partition
    • Blocks
    • BMCID
    • DDNAME
    • EXTRABA
    • KIND
    • ORIG_STATUS
    • SHRLEVEL
    • XCOUNT
  6. When finished, save the workspace.
Classic console
  1. Open or create a workspace.

  2. In the DB2 Navigator perspective, click the Add View Add-16.png menu arrow, and then click AddUtilStatView-24.png Add Utility Status View.

    Tip

    You can also right-click in the DB2 navigation pane to select this action.

    The default value of the Add View menu is always the last option that you created. For example, if the last view you created was a new DB2 Statement Cache view, then clicking Add-16.pngcreates a new DB2 Statement Cache view.

  3. In the Add Utility Status View dialog box, complete the following fields or accept the displayed default values:

    Field

    Action

    DB2 Connection

    Use either of the following methods:

    • Type the full or partial name of a Db2 connection to select the first subsystem that matches this value in the list of favorite connections.

    • Use the menu arrow to select from your list of favorite connections.

      Tip: You can add Db2 connections to your list of favorite connections by clicking ViewFavoritesList-24.pngand specifying which connections to include.

    Filter

    Enter a filter pattern for the Utility ID.

  4. Click OK.The navigation pane lists the matching utilities, and displays the following information for each one:
    • Utility ID
    • User ID
    • Utility name
    • Status
    • Phase
    • Restart
    • Database
    • Space name
    • Space status
    • Start timestamp
    • Command
    • NOTEID

  5. (Optional) Select a utility and click Utility Status Details UtilStatDetails-24.png.

    Note

    You can also right-click on a utility to select this action.

    The Utility Status Details screen shows the objects that the utility accesses and includes the following information about each object:

    • Fully qualified object name
    • Partition
    • Blocks
    • BMCID
    • DDNAME
    • EXTRABA
    • KIND
    • ORIG_STATUS
    • SHRLEVEL
    • XCOUNT
  6. When finished, save the workspace.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*