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

FCM Analysis drilldown

The Fast Communication Manager (FCM) Analysis drilldown provides a breakdown of message buffer traffic for the instance you are monitoring. FCM provides communication support between partitions for agent requests, and message buffers in DB2 environments.

Note: Setting DB2_FORCE_FCM_BP to YES in an MLN environment lets DB2 create FCM buffers in a separate memory segment. Once this is done, communications between FCM agents belonging to different logical partitions (on the same physical partition) occurs through shared memory.

This drilldown consists of two tabs:

  • Internode Summary tab—Breaks down the traffic between source partition and target partition and displays summary totals for data traffic.

  • Resources tab—Provides low water mark information for different types of traffic and displays utilization statistics.

Internode Summary tab contents

The Internode Summary tab provides the following columns. Since you can choose to hide, display, or rearrange any column in the grid, some columns below might not display, or be in this order, in your current list view.

Source Node

Buffers Total

Target Node

Percent of Traffic

Buffers Sent

Connection Status

Buffers Received

Freeze First Column

Resource tab contents

The Resource tab provides the following columns. Since you can choose to hide, display, or rearrange any column in the grid, some columns below might not display, or be in this order, in your current list view.


Conn Entries


Conn Entry LWM

Buffer LWM

RQ Blocks

Msg Anchors

RQ Block LWM

Msg Anchor LWM

Freeze First Column

Intra-partition parallelism

Intra-partition parallelism is the name for the breaking up of a query into several parts such as index creation, database loading, or SQL queries, operations usually considered as parts of a single task. When intra-partition parallelism is turned on, FCM helps these tasks run in parallel within a single database partition.

Note: In some environments, the intra_parallel parameter must be active before it can be used.


Tablespace Analysis drilldown

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

Tablespace Analysis drilldown

The Tablespace Analysis drilldown displays key performance statistics for the tablespaces in monitored databases and partitions. At its top level, the drilldown provides an overview of performance during the current monitoring session. This is shown in the Tablespaces tab.

From the Tablespaces tab, you can drill down to detailed information on I/O activity, I/O times, ranges, quiescers, and more for a certain tablespace. This is shown in sub drilldown tabs, which are displayed in the lower half of the window when a tablespace is selected. The additional statistics can be used to diagnose any problems detected in the Tablespaces tab.

Using the Tablespace Analysis drilldown

The steps below outline the basic workflow involved in using the Tablespace Analysis drilldown.

To use the Tablespace Analysis drilldown

  1. View top level tabs to detect performance problems in tablespaces. Work from the Tablespaces tab to check statistics. Work from Criteria tab to filter the list in the Tablespaces tab based on criteria such as level of I/O activity or amount of unusable space.

  2. View rows in the Tablespaces tab to focus on a certain tablespace. When a database is being monitored, rows show information for a tablespace across all partitions and on individual partitions. Check columns in the Tablespaces tab to see statistics for a tablespace.

  3. View sub drilldown tabs to see additional statistics for a certain tablespace. Click the tablespace row to display the tabs. The information they contain can help you diagnose problems detected in the Tablespaces tab.

  4. Open a Toad for DB2 session to alter a tablespace or view its properties, storage exceptions, or historical and hypothetical growth requirements. (You must have either product licensed and installed on the same computer where the Spotlight for DB2 client resides.)

Opening a Toad for DB2 session

If you have Toad for DB2 installed, you can alter a tablespace, view it properties, or determine which tables and indexes in the tablespace need to be reorganized.

Right-click the tablespace entry in the list of tablespaces, and proceed as follows:

To alter a tablespace

  • Select Toad 4 Alter to open the Alter window, enabling you to change the tablespace properties.

To view tablespace properties

  • Select Toad 4 Properties to open the Toad database explorer on the tablespace.

To determine which tables and indexes in the tablespace need to be reorganized

  • Select Toad 4 Storage 4 Identify Exceptions to open the Space Exceptions window, enabling you to identify those tables and indexes in the tablespace that need to be reorganized or for which statistics need to be collected.

On the resulting window for any of these functions, press F1 for instructions to proceed with the function.


Related Topics

Criteria Tab

As you view drilldowns, you can filter them based on criteria specified in the Criteria tab. This is available for the following drilldowns: Database Analysis, Tablespace Analysis, Buffer Pool Analysis, Client Application Analysis, and Diagnostic Log.

Filtering lets you narrow the scope of the list shown in a drilldown. You can use it to focus on objects with a certain level of activity, certain attributes, or a certain current state. For example, you might filter a drilldown to see databases with the greatest I/O, tablespaces with the most direct writes, buffer pools with the lowest hit ratio, or applications that are currently connected.  

Criteria for a drilldown can include multiple filters. The more filters you create, the narrower the scope of the drilldown list. Only items that meet filter criteria are shown. All others are filtered out. If no objects meet filter criteria, "No Data" is shown in the drilldown.

Filtering applies to the current database and current session. It is not saved when the session ends.

Note: When filtering is in use, an asterisk is shown beside the name of a drilldown's list tab. For example, when filtering is in use for the Tablespace Analysis drilldown, Tablespaces* is shown at the top of the Tablespaces tab.

Using the Criteria tab

Follow the procedure below to specify filter criteria. Before you create or modify filters, review the columns shown in the drilldown. The columns you can select for a filter are the ones currently displayed. If you want to filter on columns that are not currently displayed, select those columns in the Column Organizer. To open this window, right click any column header and select Organize Columns... from the right-click menu.

Note: The first filter you create determines which values are shown in the Value list box for the next filter. For example, if your first filter specifies "Content = Large" and you select the Extent Size column for the next filter, the Value list box shows extent sizes for tablespaces with the Large content type. If you want to use an extent size that is not listed, enter it in the Value list box.

To specify filter criteria

  1. Click the Criteria tab for a drilldown.

  1. If you plan to use multiple filters in criteria, select an option from the Result Set will include list box as follows:


Select this option if the result set should include items that meet criteria for one or more filters. Items are included even if they do not meet criteria for all filters.


Select this option if the result set should include items that meet criteria for all filters. Items are included only if they meet criteria for all filters.  

  1. Specify criteria for a filter as follows:



From this list box, select a column for the filter. Objects are checked against values in this column. The list includes all columns currently displayed in the drilldown.



From this list box, select a comparison operator for column values. The choices are = (equal to), <> (less than and greater than), > (greater than), and < (less than). Use the = (equal to)operator for a column that shows an attribute such as status, name, or ID.  

c .


From this list box, select the column value for the filter. In most cases, the values shown are for entire objects. Values for partitions are not listed. If a value for an entire object is not shown, you can enter it manually. Objects are checked to see if their values are equal to, less than and/or greater than this value (depending on the operator selected). 

  1. Click Add to add the filter to the Active Filters list.

  1. Repeat steps 3 and 4 for each filter you want to create.

  1. To remove a filter from the Active Filters list, select it in the list, then click Remove. To remove all filters from the list, click Remove All.

Tip: To change the value for an active filter, remove the filter from the Active Filters list. Then create a new filter with the same column but a different value.

  1. When you finish specifying filter criteria, click the information tab for a drilldown. The tab lists objects that meet filter criteria.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating