Tchater maintenant avec le support
Tchattez avec un ingénieur du 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

Desktop features specific to Spotlight on IBM DB2 LUW

Welcome to Spotlight on IBM DB2 LUW (Linux, Unix, and Windows). The help topics in this book cover features available in the interface when Spotlight is connected to a version 9 database.

Spotlight is a powerful database monitoring and diagnostic tool. Its unique user interface provides you with an intuitive, visual representation of the activity on the DB2 databases and database partitions that you choose to monitor. Graphical flows and line and fill graphs illustrate the activity on and between database components. Icons display the value of key statistics. Using the Spotlight browser, you can switch your monitoring focus between the various databases and partitions. Additionally, you can view activity at the DB2 instance level for any of these systems.  

The power of Spotlight lies in its ability to provide visual and audible warnings if the performance metrics exceed acceptable thresholds. The components and dataflows on the home page change color to show you the source of the problem.

A range of reports and graphs provide you with detailed information about a DB2 database, database partition, or the instance to which the database belongs. This information can be viewed on the screen or be printed.

You can set Spotlight options to warn you when a threshold is reached. You can define a number of thresholds so that warning messages are displayed well before the traffic levels into or out of databases become critical.

Spotlight uses a number of different techniques to warn you when your DB2 instance or a database is exceeding a threshold. For example, to issue a warning, you can configure Spotlight to change a color on the home page or drilldown, provide an audible signal, or perform an action, such as send an email message.

 

Related topics

Understanding the home page

A main feature of Spotlight is its user interface. This interface uses two major window types—home pages and drilldowns—to help you monitor performance on your IBM DB2 for LUW (Linux, Unix, and Windows) databases and database partitions. The home pages enable you to determine the status of your system at a glance, while the drilldowns provide performance details on specific areas of your system, enabling you to pinpoint and resolve problems.

Home page views

The home page is based on the Spotlight connection you are currently monitoring—either a database or a single database partition. This home page view provides a visual representation of the performance—in the form of icons, labels, and data flows—of this system. Throughout your Spotlight session, you can switch between the home pages for the different connections by selecting that connection in the Spotlight browser. Additionally, you can click DB2 Instance icon in the toolbar to monitor a home page at the instance level for the currently selected connection. This home page monitors activity across all databases in the DB2 instance to which the selected database or database partition belongs.

Home page components

The icons on the home page represent components—such as processing agents, areas of memory, data storage areas—in the DB2 database or database partition that you are monitoring.

On the database and partition home pages, related components are also grouped together in panels. These panels are connected to each other by dataflows, which illustrate the rate at which data traffic is moving through the system. The groupings reflect how your database or partition works.

Likewise, on the instance home page, related information is grouped into several panels that show overview and summary data concerning all databases and partitions within the instance.

Spotlight updates the component statistics and flows on all the home pages in real time and uses color and sound to indicate performance bottlenecks.

Related topics

Database or database node home page

The database or partition home page appears on the Spotlight desktop when you choose to monitor a specific DB2 for LUW (Linux, Unix, and Windows) database or a partition for that database. This home page provides a visual overview of activity on your database or on the partition. Related statistics and graphs are grouped together on panels, which, in turn, are connected by a series of graphical dataflows. Spotlight updates these statistics, graphs, and flows in real time so that you see how your system is performing. Visual or audible alarms on the home page help you to spot bottlenecks quickly.

The main elements of the database home page include the following components:

  • The toolbar—The set of icons across the top of the home page that provide quick methods for navigating between the home pages, drilldowns, and help.

  • Spotlight browser—The panel that lists the databases and their partitions that you are monitoring. The name of the specific database or partition that you are currently monitoring on the home page is highlighted. This name changes color to match the color of the component or dataflow that represents the worst severity currently existing in that database or partition. (This identifier can also match the color of a severity occurring at the instance level on the instance home page.)

  • Statistics panels—The vertical groupings of related components that represent areas of the database being monitored. For example, the Agents panel groups the Registered, Non-Pooled, Pending Locks, and Pending Token components, each of which monitors the status or a specific activity of database agents in the database or partition.

  • Dataflows—The flow graphs that illustrates the rate at which data, such requests for data and the I/O generated in response to these requests, is moving through the database. Dataflows change their speed and color, alerting you to performance issues.

  • Connection identifier—The name of the connection that you are currently monitoring. (This name was defined when the connection was set up in the Spotlight Connection Manager.) Located in the top right corner of the home page, this identifier changes color to match the color of the component or dataflow that represents the worst severity detected in the DB2 database or partition you are monitoring. (This identifier can also match the color of a severity detected at the instance level for this database or partition. You can view this severity on the instance home page.)

Home page elements

Click on any of the following for details about a specific home page element:

The toolbar

Spotlight browser

Client Apps panel

Agents panel

Buffer Pool panel

I/O Agents panel

Storage panel

Active Log panel

Dataflows

Database Information panel

Connection Identifier

How do I...?

Navigate between database, partition, and instance home pages and drilldowns

View help for components on the home page

Open the Alarm Log

Perform an immediate refresh on statistics

 

Related topics

Instance home page

The instance home page shows performance information for the DB2 for LUW (Linux, Unix, and Windows) instance that contains the database or database partition currently selected in the Spotlight browser. This home page provides a visual overview of activity across all active databases in the instance. Related statistics, graphs, and flows are grouped together on panels that Spotlight updates in real time so that you see how your system is performing. The use of visual or audible alarms on the home page helps you to spot bottlenecks quickly.

The main elements of the instance home page include the following:

  • The toolbar—The set of icons across the top of the home page that provide quick methods for navigating between the home pages, drilldowns, and help.

  • Spotlight browser—The panel that lists the databases and database partitions to which Spotlight is currently connected. The database or partition from which you launched the instance home page is highlighted. This name changes color to match the color of the component or dataflow that represents the worst severity currently existing in that database or partition (or existing at the instance-level).

  • Statistics panels—The groupings of related components in the instance being monitored, such as instance-wide I/O and SQL activity. For example, the Global SQL Request/Response panel groups the Static SQL, Dynamic SQL, and Transactions components, each of which monitors a type of SQL activity across the instance.

  • Dataflows—A flow that illustrates the rate at which data is moving through all active databases in the instance. Dataflows change their speed and color, alerting you to performance issues.

  • Connection identifier—The name of the database or partition connection currently selected in the Spotlight browser. (This database or partition resides in the DB2 instance whose home page you are now viewing.) Located in the top right corner of the home page, this identifier changes color to match the color of the component or dataflow that represents the worst severity detected in the DB2 instance (or at the database or database-partition level).

Home page elements

Click on any of the following for details about a specific home page element:

The toolbar

Spotlight browser

Instance Identification panel

Global Sort/Join panel

Switches panel

HADR panel

Global SQL Request/Response panel

Global Database I/O panel

Global Application/Agent panel

Connection Identifier

How do I...?

Navigate between database, partition, and instance home pages and drilldowns

View help for components on the home page

Open the Alarm Log

Perform an immediate refresh on statistics

 

Related topics

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation