Examining product usage data

(BMC.DB2.SPE2510)

With BMC Runtime Insights, you can gain actionable visibility into how the following BMC products are used across your Db2 subsystems, helping you manage performance, resources, and compliance more effectively:

• BMC AMI Check for Db2
• BMC AMI Copy for Db2
• BMC AMI Load for Db2
• BMC AMI Recover for Db2
• BMC AMI Reorg for Db2
• BMC AMI Stats for Db2
• BMC AMI Unload for Db2
• CHECK PLUS for DB2
• LOADPLUS for DB2
• REORG PLUS for DB2
• UNLOAD PLUS for DB2

You can use BMC Runtime Insights to perform the following tasks:

• Identify which subsystems are experiencing the highest utility activity to guide performance tuning and workload distribution
• Visualize detailed usage patterns for specific subsystems to uncover inefficiencies or trends
• Track the most frequently used product keywords to understand operational behavior and optimize product execution
• Trace product-keyword pairs back to the jobs that used them, enabling faster troubleshooting and smarter job scheduling
• Support audit and compliance efforts with transparent, job-level insights into data operations

Using the BMC Runtime Insights view, you can view a summary of the BMC products that ran in a Db2 subsystem for one of the following predefined time frames:

• Yesterday
• 7 days
• 30 days
• 90 days

Each time frame ends at 23:59:59 of the day before the current date. So Yesterday is defined as the 24-hour period starting at 00:00:00 and ending at 23:59:59 of the day before the current date. 

Similarly, if today is August 25, 2025, then Yesterday starts at 2025-08-24 00:00:00 and ends at 2025-08-24 23:59:59.

From the BMC Runtime Insights Summary view, you can drill down to more specific details about the product usage for a Db2 connection.

The following table lists the available BMC Runtime Insights views:

• (BMC.DB2.SPE2604) For view descriptions for SPE2604 and later, see the following table.
• For view descriptions for SPE2601 and earlier, click here.

View	Description
Summary	Displays a summary of the executions of BMC products used on multiple Db2 subsystems
Product execution details	Displays the execution details of BMC products used on a single Db2 subsystem in the following graphs: Execution count by product—A pie chart showing how many times a product was executed DSNUTILB count by product—A pie chart showing how many times DSNUTILB was called by a product AMI vs PLUS utilities—A bar chart showing a comparison of the execution count of all BMC AMI Utilities and all BMC PLUS Utilities
Product (BMC.DB2.SPE2604)	Displays the following tabs in a slide-out panel: Keywords—Displays the frequency of keyword usage for a select product Keyword usage data is not available for the following products: BMC AMI Check BMC AMI Stats CHECK PLUS DSNUTILB—Displays the frequency of the reason code for calling DSNUTILB by a selected product Result set—Displays all the executions of the product for the selected time frame Result set for keyword—Displays the details of the executions when a product-keyword pair was used Result set for DSNUTILB—Displays the details of the executions when DSNUTILB was called because of a product-reason code pair

Click here for view descriptions for SPE2601 and earlier...

View	Description
Summary	Displays a summary of the executions of BMC products used on multiple Db2 subsystems
Product execution details	Displays the execution details of BMC products used on a single Db2 subsystem in the following graphs: Execution count by product—A pie chart showing how many times a product was executed DSNUTILB count by product—A pie chart showing how many times DSNUTILB was called by a product AMI vs PLUS utilities—A bar chart showing a comparison of the execution count of all BMC AMI Utilities and all BMC PLUS Utilities
Keyword usage details	Displays the frequency of keyword usage for a selected product. You can access this view by clicking a slice of the Execution count by product pie chart. Keyword usage data is not available for the following products: BMC AMI Check BMC AMI Stats CHECK PLUS
DSNUTILB details	Displays the frequency of the reason code for calling DSNUTILB by a selected product. You can access this view by clicking a slice of the DSNUTILB count by product pie chart.
Job details	If called from the Keyword usage details view, the Job details view displays the details of the jobs when a product-keyword pair was used. If called from the DSNUTILB details view, the Job details view displays the details of the jobs when DSNTUILB was called because of a product-reason code pair.

To examine product usage data

• (BMC.DB2.SPE2604) For SPE2604 and later, use the following procedure.
• For SPE2601 and earlier, click here

1. Open or create a workspace.
2. In the upper left corner of the console, click Apps.
3. Click BMC Runtime Insights .
   The Options dialog box of the BMC Runtime Insights application is displayed.
4. In the Options dialog box, perform the following steps:
   1. Select the Time frame in which you want to view product usage data.
   2. (Optional) Select Show only favorites to limit the display of Db2 connections to those you have marked as favorites.
   3. Select one or more DB2 connections.
   4. Click OK.
      The BMC Runtime Insights Summary view is displayed.

5. To adjust the Db2 connections displayed, click Options.

6. To adjust the time frame, select a Time frame from the list.

7. To view the details for a Db2 connection, perform one of the following actions:

   • Click the Db2 connection's bar on the bar chart.
   • Double-click the Db2 connection's row on the grid.
   • Select the Db2 connection's row on the grid and click Details.
8. On the Product execution details view, you can perform the following actions:

   Purpose	Action
   Remove a product from a pie chart	In the pie chart legend, clear the product checkbox.
   Add a product to a pie chart	In the pie chart legend, select the product checkbox.
   Filter the product usage data	Click Filter  to restrict the results displayed based on one or more of the following fields: Job name Auth ID Database Table space Object creator Object name If you add a filter, BMC AMI Command Center changes the color of the filter icon .  For more information, see Filtering product usage data.
   View filter criteria	Hover the cursor over the filter icon . BMC AMI Command Center displays a tooltip that lists the filter criteria.
   View the raw data for the charts	Click Show in tabular form . The By product details panel is displayed.
   Export chart data to a spreadsheet (BMC.DB2.SPE2601)	Click Generate report . If prompted, select a location for the exported data. The default file name is RuntimeInsightsssid.xlsx. Save the file.
   Export raw data for the charts	On the By product details panel, perform the following actions: Select one of the following tables: Execution count by product DSNUTILB count by product AMI vs PLUS utilities Select one or more rows from the table. To select all the rows, on the context menu, select Select all. On the context menu, select Export data. If prompted, select a location for the exported data. The default file name is export_data.csv. Save the file.
   View the keywords used for a product	On Execution count by product, click a slice of the pie chart. The Keywords tab of the Product details panel is displayed.
   View the reasons DSNUTILB was called by a product	On DSNUTILB count by product, click a slice of the pie chart. The DSNUTILB tab of the Product details panel is displayed.
   Return to the Summary view	Click Back .

9. (BMC.DB2.SPE2604) On the Product panel, you can perform the following actions:

   Purpose	Action
   View the keywords used by a product.	Select the Keywords tab.
   View the reasons DSNUTILB was called.	Select the DSNUTILB tab.
   View the executions for the product in the selected time frame	Select the Results tab.
   View the executions where a keyword was used for a product	On the Keywords tab, perform one of the following actions: Double-click a row on the grid Select a row on the grid and click Details The Result set for keyword tab is displayed.
   View the executions using DSNUTILB for a reason code	On the DSNUTILB tab, perform one of the following actions: Double-click a row on the grid Select a row on the grid and click Details The Result set for DSNUTILB tab is displayed.
   View the properties of an execution of the product	Perform the following steps: Select one of the following tabs: Result set Result set for keyword Result set for DSNUTILB Select a row on the grid Click Properties The Properties dialog box is displayed, which contains the following tabs: Attributes—Displays all of the details for the selected execution of the product Keywords—Displays all of the keywords used by the execution of the product DSNUTILB—Displays all of the reason codes for calling DSNUTILB
   View an additional 5,000 rows of data in a result set tab	On the following tabs, click Load more: Result set Result set for keyword Result set for DSNUTILB
   Compare the keywords used for executions of the product	On the Result set tab, perform the following actions: Select up to 10 rows on the grid. Click Compare. The Compare dialog box is displayed.
   Export the grid data	Perform the following actions: Select one or more rows from the grid. To select all the rows, on the context menu, select Select all. On the context menu, select Export data If prompted, select a location for the exported data. The default file name is export_data.csv. Save the file.
   Return to the Product execution details view	Click X.

Click here for the procedure for SPE2601 and earlier

1. Open or create a workspace.

2. In the Product Tools perspective, select Add view  > Add BMC Runtime Insights View.

   Success

   Tip

   The default value of the Add View menu is always the last option that you created.

3. Enter a name for the view.
4. Select a Time frame for the product usage to display.
5. To limit the list of Db2 connections to your favorites, select Show only favorites.
6. Select one or more DB2 connections.
7. Click OK.
   The Summary view is displayed in the results pane.
8. To adjust the Db2 connections displayed, click View settings.
9. To adjust the time frame, select a Time frame from the list.

10. To view the details for a Db2 connection, perform one of the following actions:

    • Click the Db2 connection's bar on the bar chart.
    • Double-click the Db2 connection's row on the grid.
    • Select the Db2 connection's row on the grid and click Details.
11. On the Product execution details view, you can perform the following actions:

    Purpose	Action
    Remove a product from a pie chart	In the pie chart legend, clear the product checkbox.
    Add a product to a pie chart	In the pie chart legend, select the product checkbox.
    View the raw data for the charts	Click Show in tabular form . The By product details panel is displayed.
    Export chart data to a spreadsheet (BMC.DB2.SPE2601)	Click Generate report . If prompted, select a location for the exported data. The default file name is RuntimeInsightsssid.xlsx. Save the file.
    Export raw data for the charts	On the By product details panel, perform the following actions: Select one of the following tables: Execution count by product DSNUTILB count by product AMI vs PLUS utilities Select one or more rows from the table. To select all the rows, on the context menu, select Select all. On the context menu, select Export data. If prompted, select a location for the exported data. The default file name is export_data.csv. Save the file.
    View the keywords used for a product	On Execution count by product, click a slice of the pie chart. The product details view is displayed.
    View the reasons DSNUTILB was called by a product	On DSNUTILB count by product, click a slice of the pie chart. The DSNUTILB details view is displayed.
    Return to the Summary view	Click Back .

12. On the Keyword usage details view and DSNUTILB details view, you can perform the following actions:

    Purpose	Action
    View the jobs where a product-keyword or product-reason pair was used	Perform one of the following actions: Double-click a row on the grid Select a row on the grid and click Details The Job details view is displayed.
    Export the grid data	Perform the following actions: Select one or more rows from the grid. To select all the rows, on the context menu, select Select all. On the context menu, select Export data If prompted, select a location for the exported data. The default file name is export_data.csv. Save the file.
    Return to the Product execution details view	Click Back .

13. On the Job details view, you can perform the following actions:

    Purpose	Action
    View the details for a job	Perform one of the following actions: Double-click a row on the grid. Select a row on the grid and click Details.
    View an additional 5,000 rows of data	Click Load more.
    Export the grid data	Perform the following actions: Select one or more rows from the grid. To select all the rows, on the context menu, select Select all.  On the context menu, select Export data. If prompted, select a location for the exported data. The default file name is export_data.csv. Save the file.
    Return to the previous view	Click Back .