Creating a Utility Status view
- Open or create a workspace.
- In the DB2 Navigator perspective, click the Add View
menu arrow, and then click Add Utility Status View. In the Add Utility Status View dialog, 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
and specifying which connections to include.
Utility Type
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
- Db2 Utilities—Displays the contents of the SYSIBM.SYSUTILITIES catalog table, which contains details for utilities in the SYSCOPY catalog table
- Object Events—Displays the contents of the SYSIBM.SYSOBJEVENTS catalog table, which contains object-level information and details about objects processed by a utility execution
Filter
Enter a filter pattern for the Utility ID.
Click OK.The results pane lists the matching utilities and displays the following information for each one:
Column
BMC Utility Status
Db2 Utility Status
Db2 Utilities
Object Events
User ID
X
X
X
Utility ID
X
X
X
Status
X
X
Utility name
X
X
X
X
Phase
X
X
Db2 subsystem ID
X
Database
X
X
Space name
X
X
Job name
X
X
Start timestamp
X
X
End timestamp
X
Elapsed time
X
X
Event ID
X
X
Partition
X
Object type
X
Instance
X
Event timestamp
X
Count
X
DB ID
X
PS ID
X
(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
- When finished, save the workspace.