Configure the Displayed Data

You can use the following options to configure the displayed data. These options help you quickly target problematic applications:
dm20
You can use the following options to configure the displayed data. These options help you quickly target problematic applications and Db2 objects:
2
2
Configure and Sort Db2 Metrics Using Filters
You can apply one or more filters to refine the information that is displayed in a table. As you apply filters, fewer rows are displayed from the cached data. To disable data caching, select Disable row caching under the Settings cogwheel.
Follow these steps:
  1. Select the
    FILTER
    icon to open the filter dialog.
  2. Enter the filter values in the following fields:
    You can also apply these filters at the column level by selecting the filter icon in the column.
    • COLUMN
      Select a column to filter on from the drop-down list. The list includes all available column names, in alphabetical order.
    • CONDITION
      Specify a filter condition to apply to the selected column.
    • VALUE
      Enter a filter value that is related to the filter condition you specified.
  3. Select
    ADD FILTER
    .
    A box displays in the filter dialog that summarizes your filter selections.
  4. (Optional) Repeat steps 2 and 3 to add more filters and reduce the number of rows that are displayed in the table. As you add filters, fewer rows are displayed.
  5. Select APPLY when you are done adding filters.
    The table is filtered based on the criteria you specified. A list of active filters displays above the table. Click the X in an active filter box to remove the filter and update the table display.
Examples:
  • To display data where CPUPCT exceeds 80, specify
    CPUPCT
    for COLUMN,
    >
    for CONDITION, and
    80
    for VALUE.
  • To display data where the COMMIT frequency is zero, specify
    COMMIT
    for COLUMN,
    =
    for CONDITION, and
    0
    for VALUE.
  • To display data where the ABORT rate is greater than zero, specify
    ABORT
    for COLUMN,
    >
    for CONDITION, and
    0
    for VALUE.
  • To display databases that start with DSN, specify DSN for Column, contains for CONDITION, and DSN for VALUE.
Display Totals or Averages for Performance Metrics
You can display totals or average values in the table data for performance metrics. Comparing total and average metric data can be useful when analyzing performance issues.
The Totals/Average icon appears above the table data. Select Totals or Average as follows to switch the selection:
  • Totals
    (Default) Displays the total value for metrics.
  • Average
    Displays average values. Average values are calculated by dividing the metric value by the value in the SQL column (the count of SQL statements).
When a new table displays, it shows the total values by default. After you select average values, the display reverts to total values under the following conditions:
  • You click an element of the navigation path.
  • You click another category.
  • You navigate to another table display. For example, from Plans to Packages.
Note:
Average values are displayed for numeric columns when an average based on the number of SQL calls can be calculated. The following numeric columns cannot be displayed as average values: ABORT, CCSID, COMMIT, CPUPCT, PLANCNT, SECT, SQL, STMT, STYPE, TIMEPCT, and USE_COUNT.
Configure a Table
You can change the appearance of the table and save your configuration for future sessions. Changes to table configuration only apply to a specific table type. For example, you can set different table configurations for SQL Statements and Packages.
You can show 10000, 100, 1000, or ALL rows for performance data. You can show 100, 500, 2500, or ALL for administration data. The number of rows that are displayed is controlled by the filter results.
You can perform the following actions on the table:
  • Adjust column width
  • Drag and pin more columns to the left side of the table.
  • Change the row sort order.
    The column that is used for the default sort contains a directional icon in the column header. Use Shift + click to sort on multiple columns.
  • Drag to change the column order.
  • Filter column data
You can save or reset table configurations for each category as needed.
You must enable local storage in your browser to save configuration changes. In Firefox and Chrome, your changes are lost if cookies are disabled or deleted. If you start a new session using a different browser, the saved configuration for that browser is used.
Follow these steps:
  1. Move the columns to your preferred configuration.
  2. Select the Settings (cogwheel) icon and select
    Save table configurations
    .
    Changes are saved. The table holds the configuration when you return to this category.
    To reset, click the cogwheel drop-down and select Reset table configurations to default. By default, column width is standardized, the key name column is pinned to the left side of the table, and default sort order is used.
Export to CSV
After you list Db2 object information or application performance data, you can export the displayed table results in CSV format. Doing so is useful for reviewing the table results offline or for providing the results to others. You can also import the data into other applications such as Microsoft Excel.
Follow these steps:
  1. Select the
    Export
    icon.
    The Export to CSV dialog appears.
  2. Select
    one
    of the following options:
    • Export only selected rows
    • Export only displayed table rows
    • Export all rows
    Select
    Export
    .
    The results are downloaded in CSV format.
You can view, analyze, and share the exported data offline as needed.
View SQLCODE Counts in Chart Format
You can view SQLCODE counts in a chart format by SQLCODE, package, and OPID. The chart view provides a graphical representation of the SQL return codes in the form of a bar chart. You can review the data and increase the display size and display details so that it can be investigated further. You can toggle charts off if not needed.
The ability to see activity graphically, at a glance, can help you identify and understand your systems' health. Charts also help you to identify data anomalies.
Follow these steps:
  1. Select the Db2 subsystem and environment, select
    SQLCODES
    as the Performance category, specify the collection interval, and select
    View Range
    .
    The charts are displayed by default with the other SQLCODE table data. The charts show the SQLCODE counts by SQLCODE (top 20), package (top 10), and OPID (top 10).
    The table data shows the SQLCODE metrics.
  2. Complete the following tasks as needed:
    • Toggle the charts on and off as needed using the chart icon next to the Actions drop-down.
    • Hover over a chart to view additional details.
    • Select a chart and select the maximize button to extend it across the width of the display. When a chart is maximized, the other two charts are hidden.
Refresh Data in a Table
You can refresh data in a table to display the most current metrics while viewing current interval data or historical data in a time range that includes the current time.
Click the refresh button above the table to perform a refresh. All table configuration settings, including defined and applied filters, remain in place after a refresh.
Example: Refresh metrics while reviewing same-day historical metrics
Imagine that it is 15:55 and you want to look at the metrics for this afternoon. You select a time range from 12:00 - 16:00. The metrics are displayed from the intervals that completed between 12:00 - 15:00. You review the metrics, and at 16:01, you click Refresh. The table updates the metrics from the interval that completed at 16:00.
If you refresh the page with a Web browser, all configuration settings and filters are lost.