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

Connection Properties - General Page

View general information about the spotlight connection.

To open the Connection Properties dialog, General page

  1. Locate the connection in the Spotlight Connection Manager or the Spotlight Browser.
  2. Right click the connection and select Properties | General.

About the General page

Note: You cannot edit the fields in this page directly while the connection is open.

Field Description
Connection name The display name for the connection.
Type

The type of connection. (DB2, Windows etc.)

Location

The location of the connection profile. Connection profiles store information that Spotlight uses to connect to the system.

Calibrated Has the connection been calibrated? When? Calibrate Spotlight Connections
Template

The name of the template applied to the connection. Connection Templates

Note: Click Change template to change the template.

Created

The date the connection was created.

Modified

The date the connection was last modified.

Accessed

The date the connection was last accessed.

Notes:

  • User defined connection profiles are stored by default in C:\Documents and Settings\user\Application Data\Quest Software\Shared\Profiles
  • User defined templates are stored by default in C:\Documents and Settings\user\Application Data\Quest Software\Shared\Templates
  • Locations for connection profiles and templates may differ from the default in your case. Migrate (Move And Share) Connections

 

Related Topics

Connection Properties - Details Page

Connection Properties - Overhead Page

Connection Properties - Details Page

View / Enter / Modify the settings for the Spotlight connection.

To open the Connection Properties dialog, Details page

  1. Locate the connection in the Spotlight Connection Manager or Spotlight Browser.
  2. Right click the connection and select Properties | Details.

About the Details page

The fields in the Details page are dependent on the type of Spotlight connection.

  • For help on a specific field, click in the field and press F1.
  • For help on all fields, click Help | Contents | Connection type | Connect to A … System.

Note: You cannot edit the fields directly while the connection is open.

 

Related Topics

Connection Properties - General Page

Connection Properties - Overhead Page

Connection Properties - Overhead Page

The queries that Spotlight uses to collect data from a Spotlight connection can place an additional load on the monitored system.

  • Simple queries that retrieve small amounts of data have little impact on the performance of the monitored system.
  • Most Spotlight queries consume a measurable but not significant amount of system resources.
  • Queries that are complex or collect large amounts of data may put a significant load on the system.

The controls on the Overhead Management page allow you to adjust collection rates for different categories of Spotlight data, and so limit the load that Spotlight places on the monitored system.

Notes: Use this page to change the overall settings for the connection. To change the settings for a Spotlight component use the Component Properties editor. Component Properties - Overhead Page

To open the Connection Properties dialog, Overhead page

  1. Locate the connection in the Spotlight Connection Manager or the Spotlight Browser.
  2. Right click the connection and select Properties | Overhead.

Alternatively

  1. Select the connection in the Spotlight Browser Live connections.
  2. Select Tools | Performance Settings

    or click .

About the Spotlight overheads dialog

Control

Description

Overhead Impact slider

Drag the slider to one of the standard overhead settings:

  • Higher impact - Spotlight collects more data but may put a higher load on the system.
  • Medium impact - Spotlight collects less data or collects it less often.
  • Lower impact - Spotlight puts a minimal load on the system while still collecting essential data.

Accompanying text further defines the data collected under each overhead setting. The definitions are dependent on the connection type. The criteria may include:

  • The kind of data being collected
  • The load that collecting the data will put on the system
  • Where the data in the category is to be displayed
  • The importance of the data
  • How often the data is needed

Note: The slider is not displayed if a component in the connection already has a custom setting. Click Restore default to remove all custom settings.

Custom...

Click to select a collection rate for each available category of Spotlight data. Custom Connection Performance

Restore default

Click to remove all user-specified collection rates. Revert to Spotlight default settings. Set the rate at which data is collected

Make this the default setting for all new connections

When selected, all new Spotlight connections collect data at the rates defined in this dialog.

 

Related Topics

Custom Connection Performance

Use the Custom Connection Performance page to choose specific collection rates for every available category of Spotlight data.

To open the Custom Connection Performance dialog

  1. Open the Connection Properties - Overhead Page.
  2. Click Custom.

About the Custom Connection Performance dialog

The Category / Impact table lists each category of Spotlight data and defines the effect of collecting that data on the monitored system.

  1. Select a category. This enables the Refresh setting list.
  2. Select from the Refresh setting list how often Spotlight will collect data in the specified category.

Refresh setting

Description

Refresh at the default rate

Spotlight data is refreshed as per the definition in Spotlight Options. Set the rate at which data is collected

Note: In most cases (but not all) this will be at the foreground rate when the component is visible and the background rate when the component is not visible.

Always refresh at the foreground rate

Always refresh at the foreground rate, whether the data is displayed or not.

Refresh only while data is displayed on the screen

Refresh data at the foreground rate when it is visible in the Spotlight window.

Do not refresh data in this category

The data is never collected. Spotlight displays one of the following icons on components that display this category of data:

Data for this control is not available. (There are no alarms associated with this control.)

Data for this control is not available. (Alarms associated with the control are disabled.)

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating