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
• Yesterday 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:

View	Description
Summary	Displays a summary of the executions of products used on multiple Db2 subsystems
Product execution details	Displays the execution details of 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

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 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 .