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

Current Users Nearing Limit Alarm

When the current user count nears the number of user licenses available on the machine, it may be time to upgrade the license count on that particular system.


Diagnose Single Application Alarm

This alarm is raised when a process is terminated that was selected for diagnosis in the Windows Applications Metrics options in the Spotlight on Windows Options window.


Related Links

Disk Alarm

This shows that the logical disk is filling up or is full.

To rectify this:

  • Inform users of the disk volume to clean up space by deleting or moving files no longer required.
  • Go through and delete files that are no longer required from the volume.
  • Move files to a volume with spare space.
  • Purchase more disk capacity for the system, and move data onto it.

It is recommended that a backup of the system is taken before any files are moved or deleted.


Disk Reads Alarm

The Disk Reads alarm is activated when the level of traffic being transmitted from this disk exceeds a threshold. Sustained high disk activity can cause an overall degradation of system responsiveness.

When this alarm is current you should look at:

  • The Page File Transfers chart on the Paging Activity page of the Memory drilldown. High paging in suggests that the high number of disk reads could be due to system paging. Adding more memory may alleviate the problem.
  • The NBT page of the Network drilldown and see if any systems are transferring a large amount of data.
  • The Disk Queue chart on the Physical Disks Activity page of the Disks drilldown. If the disk queue length is high on a single physical disk you can look at:
    • Spreading frequently accessed data over multiple physical disks.
    • Spreading page files over multiple physical disks.
    • Implementing a faster disk subsystem.
    • Implementing RAID striping technology.

If the high number of reads is causing an overall degradation of the system, consider upgrading the disk subsystem (controller and/or disks).


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating