Chat now with support
Chat with Support

Spotlight on DB2 6.9.3 - User Guide

Spotlight on IBM DB2 LUW (Linux, Unix, and Windows)
New in This Release Getting started with Spotlight on IBM DB2 LUW Desktop features specific to Spotlight on IBM DB2 LUW Spotlight on IBM DB2 LUW drilldowns
About Spotlight on IBM DB2 LUW drilldowns Buffer Pool Analysis drilldown Client Application Analysis drilldown Database Analysis drilldown Database Manager Summary drilldown Diagnostic Log drilldown FCM Analysis drilldown Tablespace Analysis drilldown Top SQL drilldown Operating System drilldown Workload Management Analysis drilldown
Spotlight on IBM DB2 LUW alarms Spotlight on IBM DB2 LUW Options Tuning SQL statements in Spotlight on IBM DB2 LUW
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

Chart Properties - Chart Page

You can edit the visual properties of the charts displayed in Spotlight.

To set chart properties

  1. Right-click the chart and select Properties | Chart.
  2. Configure as appropriate:

    Option Description
    Name Select the chart to configure. Applicable when the chart name is selectable.

    Chart style

    Select a style for the chart.

    Notes:

    • You can use a Summary chart to view the statistics on how the charted data varies over time, including details on average, maximum, and minimum values. The percentile range (10% to 90%) shows the spread that contains 80% of all values in the chart.
    • You can use a Histogram to sort data into ranges of values. The horizontal axis shows the distribution of data across those ranges. The vertical axis shows the number of items in each range. (A current data histogram displays the most recent data collected; a trend histogram displays an average of the data collected over the available history of the chart.)
    • Any charts under the Other views heading (as in the Sample item here) are specific to individual Spotlight applications.
    • Some charts that show task or status data may be drawn as Gantt charts. These are custom-coded charts and cannot be displayed in other styles.

    Arrange by

    Applicable when the Chart style is set to Bar or Pie.

    • Select to arrange the data in Name or Value order.

    Include legend in chart

    Select to show the legend associated with the chart. Not all charts have a legend.

    Series are stacked

    Applicable when the Chart style is set to Area.

    • Select to plot the cumulative values of the different series.
    • Clear to superimpose the different series on the same set of axes.

    Manual scaling
    Minimum value
    Maximum value

    Select Manual Scaling to set the scaling factor for the chart in the Minimum value and Maximum value fields.

    Clear Manual Scaling to accept Spotlight's default scaling of the chart.

 

Related Topics

Chart Properties - Filtering Page

A Spotlight chart may contain multiple graphs representing separate data series from multiple data sources. You can filter the chart so that it shows only the data series that you want to see.

Spotlight supplies a set of filters that you can use, but if none of the standard filters are suitable for your chart, you can design a custom filter.

To set a custom filter on a chart

  1. Right-click the chart and select Properties | Filtering.
  2. Configure as appropriate:

    Option Description

    Name

    Select the chart to configure. Applicable when the chart name is selectable.

    Show all items

    Select to display all current data series.

    For example, if a system has the multiple disks C:, D:, E:, and F:, the relevant disk usage chart displays the disk usage statistic for all four disks.

    Show only the top items

    Select to display the most significant data series.

    Select the number of data series to show from the associated drop down list.

    Show the following items

    Select to choose the data series to show.

    Select the data series to show from the associated list. Note also the associated Select all and Clear all buttons.

 

Related Topics

Grids

Spotlight Basics describes how Spotlight applications work. It contains these sections:

Section

Description

Spotlight Connections

Create / Modify / Delete connections to systems, and monitor those systems.

Monitor Spotlight Connections Monitor connections, detect alarms, investigate the cause of alarms.
Alarms

Alarms are the warnings that Spotlight raises when a metric falls outside its "normal" range of values.

Charts, Grids and Home Page Components Spotlight displays provide detailed statistics of the monitored system, relevant to diagnosing the cause of alarms. Make the best use of them.
View | Options Customize Spotlight.
Troubleshooting Solve problems using Spotlight.

 

About Spotlight Grids

A table or grid shows values in tabular form. The grid component is used in Spotlight alarms and drilldowns.

Actions common to Spotlight grids

Notes: 

  • Not all items are available with all grids.
  • If not all the grid can be seen all at the one time then scroll bars allow you to choose the visible portion.
Click Description
Find Text
Alarms: Alarm Filters.
Tree View
Select Multiple Rows
Select Multiple Rows
Save To File
Copy To Clipboard
Show, Hide & Order Columns
  Sort the Grid
Right click the table body and select What's This? View help specific to the gird.
Right click the table body and select Print Print
Right click the table body and select Restore Default Settings Restore Default Settings
Right click the table body and select View as Chart. View the data in a Spotlight chart. About Spotlight Charts
Right click the table body and select Properties. Freeze the first column or word-wrap text. Grid Properties - Options Page
If the diagnostic server is unable to collect the data required, Spotlight displays a small icon on the affected component. Click the icon to see more information about the problem.
  Pause / Resume / Refresh

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating