Chatta subito con l'assistenza
Chat con il supporto

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

Log Status tab

The Log Status tab on the Database Analysis drilldown provides current log utilization statistics for the selected database or partition. Use this information to help you pinpoint log utilization problems.

The following statistics describe the current status of the log files on the database. If you detect log utilization problems, such as a log-full condition, you might need to adjust configuration parameter settings for the log files. For information on current parameter settings, go to the Configuration tab for the Databases drilldown.

Log Secondaries Allocated

Log Usage (%)

Log Max Secondaries Used ( Kb )

Log Total Transactions

Log Max Total Used ( Kb )

Log Avg Log Space/Transaction ( Kb )

Log Total Used ( Kb )

Node with Least Available Log Space

Log Total Available ( Kb )

 

Graphs

These graphs provides an overview of log activity and space utilization over consecutive monitoring intervals:

  • Total Transaction Rate -- Keeps track of the number of commits and rollbacks taking place in the log files per second.

  • Avg Log Space per Transaction -- Keeps track of the average amount of log file space being used per transaction.

 

Related topics

Statistics tab

The Statistics tab on the Database Analysis drilldown lists performance statistics for events that have occurred in the selected database. 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

Tables tab

The Tables tab in the Database Analysis drilldown shows a list of tables in the database that are currently experiencing I/O activity. The list provides the following information about each table in a grid format. Since you can choose to hide, display, or rearrange any column in the grid, some columns below might not appear in your current list view, or be in the order shown here.

Table Schema

Rows Written

Table Name

Overflow Accesses 

Table Type

Page Reorgs 

Row Accesses

Freeze First Column 

Rows Read

 

 

Related topics

Memory Pools tab

The Memory Pools tab on the Database Analysis drilldown helps you keep track of system memory usage as it relates to the database you are monitoring. It is important to remember that, with the notable exception of buffer pools, most memory is allocated dynamically on an as needed basis by the Database Manager.

The memory pools list provides the following information about each memory pool in a grid format. Since you can choose to hide or display any column in the grid, some columns below might not display in your current list view.

Pool

HWM Util Pct

Curr Size ( kb )

Max Size ( kb )

Curr Util Pct

Node

Size HWM ( kb )

Freeze First Column

 

Related topics

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione