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

I/O Times tab

The I/O Times tab on the Tablespace Analysis drilldown contains graphs that let you visually monitor average I/O times and buffer pool hit ratios for a tablespace. The four graphs track the following:  

  • Average amount of time spent on direct I/O.

  • Average amount of time spent on asynchronous I/O.

  • Average amount of time spent on physical I/O.

  • Buffer pool hit ratios.

All four graphs use counter data to show statistics as they change over time. This allows you to see when average I/O times are high and buffer pool hit ratios are low for a tablespace.      

Consistently high I/O times can be a symptom of I/O conflict. Consistently low hit ratios can be a sign that a buffer pool is not operating efficiently. Both problems degrade performance. To identify applications that are contributing to I/O conflict, work from the Client Application Analysis drilldown. To investigate buffer pool conditions, work from the Buffer Pool Analysis drilldown.

Graphs in the I/O Times tab

Click the links below to see descriptions of each graph in the I/O Times tab:

Average Direct I/O Times

Average Async I/O Times

Average Physical I/O Times

Read BP Hit Ratios

Functions for graphs

As you view graphs in the I/O Times tab, you can click icons in graph toolbars to:

Copy graph details to the clipboard

Change the graph view

Filter a graph

Maximize or restore a graph

Pan over a zoomed graph

Zoom a graph

 

 

Related topics

 

Quiescers tab

The Quiescers tab on the Tablespaces drilldown provides information about quiescer activity that is currently in progress. It shows the type of quiesce being performed. It also shows information that can help identify who is responsible for quiescing a tablespace. This information is shown in the Agent ID, Authorization ID, OBID, Tablespace ID columns.  

Columns in the Quiescers tab

All columns available for the Quiescers tab are listed below in alphabetic order. Initially, the tab contains Spotlight's default column selection. You can choose which columns to display and organize them in any order from left to right using the Organize Columns function. This can be selected from the right-click menu for column headers.

Column

Description

Agent ID

The ID of the agent holding a quiesce state.

Authorization ID

The authorization ID of the user holding a quiesce state. This is the ID that was used to connect to the database.

OBID

The object ID of the object that caused a tablespace to be quiesced.

State

The quiescer state. This indicates the type of quiesce being performed. For example, the type might be SHARE, INTENT TO UPDATE, or EXCLUSIVE.

Tablespace ID

The tablespace ID of the object that caused a table space to be quiesced.

 

Ranges tab

The Ranges tab on the Tablespaces drilldown shows how ranges are defined for range partitioning in DMS tablespaces. When an aggregate tablespace row is selected, the tab shows partitioning information for a tablespace across all database partitions. When the row for an individual tablespace is selected, the tab shows partitioning information for the partition on which the tablespace is defied.

Note: Information in the Ranges tab applies only to DMS tablespaces. It does not apply to SMS tablespaces.

Columns in the Ranges tab

All columns available for the Ranges tab are listed below in alphabetic order. Initially, the tab contains Spotlight's default column selection. You can choose which columns to display and organize them in any order from left to right using the Organize Columns function. This can be selected from the right-click menu for column headers.

Column

Description

Adjustment

Any offset into the container array in which a range starts.

Container ID

The ID that uniquely identifies a container within a range.

Containers

The number of containers in a range.

End Stripe

The number of the last stripe in a range.

Max Extent

The maximum extent number that is mapped by a range.

Max Page

The maximum page number that is mapped by a range.

Number

The number of a range in the tablespace map.

Offset

The offset from stripe 0 of the beginning of the stripe set to which a range belongs.

Start Stripe

The number of the first stripe in a range.

Stripe Set

The number of the stripe set to which a range belongs.

 

Statistics tab

The Statistics tab on the Tablespaces drilldown lists performance statistics for database events associated with the selected tablespace. Each row in the list identifies a specific event and provides countsfor the event based on these time measurements:

  • Interval—Displays the number of occurrences of the event for the most recent monitoring interval.

  • Rate—Displays the rate per second during the most recent monitoring interval.

  • Lifetime—Displays the number of occurrences during the life of the event (since the database was activated or performance statistics were reset).

 

Related topics

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation