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

Display Problems on The Home Page Disks Panel And Disk Drilldown

The Disks panel on the Spotlight on Windows home page and the Disks drilldown are not displaying data. Ensure disk performance counters are enabled on the Windows machine being monitored.

Solution: Enable collection of disk data:

On the Windows system being monitored

  1. Start a command line window
  2. At the command prompt, type the following

    diskperf -y

  3. Restart the system.


Related Topics

Disk Summary Page

Display Problems on The Home Page Network Panel, Flows And Network Drilldown

Spotlight on Windows cannot display data in the Network panel, flows, and drilldowns. The likely cause is that the appropriate performance counters have not been enabled on the Windows machine being diagnosed.

Solution: Enable the collection of network data:

  • Check that the PerfNet counters are active on the system. To do so, use the Exctrlst utility, which you can download from the Microsoft Web site.
  • Check that at least one network device is using NBT (NetBIOS over TCP/IP). To do so, check the properties of all network connections (in particular, Advanced TCP/IP Settings | WINS) to ensure that the NetBIOS setting is not disabled.
  • Check that Service Pack 4 is installed on Windows 2000 systems.


Related Topics

The Processes Page And Process Affinity

In Windows systems where there are multiple processors, an activity (thread) in a process can migrate from processor to processor – and every migration reloads the processor cache.

Process affinity, which you can set on the target Windows machine via the Windows Task Manager, allows you to establish an association that permits specified processes to run ONLY on nominated processors. This limits the number of cache reloads, which may be desirable on systems operating under heavy load.

You CANNOT set process affinity via Spotlight on Windows.

What you CAN do is:

Use the Processes drilldown to indicate the CPUs where the specified process is permitted to run. This enables Spotlight to report the CPU usage for that process with accuracy.

Example: Running a process on an eight-CPU system

Spotlight uses the Windows Performance Monitor (PerfMon) to retrieve important data from target Windows systems, including the total percentage of CPU usage by specified processes.

On a single-CPU system, PerfMon can report a maximum CPU usage of 100%.

On a multiple-CPU system, that maximum value is multiplied by the number of CPUs. For an eight-CPU system, PerfMon can report a maximum CPU usage of 800%. Spotlight on Windows compensates by dividing the reported PerfMon value by the number of CPUs on the system.

However, when the affinity for a process is set so that it can run only on two nominated CPUs of the eight available, the default Spotlight calculation fails. For example, if PerfMon reports a CPU usage of 120% for the process (corresponding to a 60% usage on each permitted CPU), Spotlight initially calculates a value of 15%. Use Spotlight's Configure Affinity function to adjust the Spotlight calculation. Processes Page

How to set process affinity

Process affinity can be set via the Windows Task Manager on Windows machines that have multiple CPUs.

  1. Log in to the monitored Windows machine.
  2. Press CTRL+ALT+DEL.
  3. Click Task Manager | Processes.
  4. Right-click the name of the process whose affinity you want to set and select Set Affinity.

    Note: This option is unavailable when the system has one CPU.

  5. Select which of the available CPUs you want to use for the process.

Note: You can also set process affinity for Microsoft SQL Server through the SQL Server Enterprise Manager.


Related Topics

Installing The SNMP Protocol

Spotlight is unable to display Open Ports information if the SNMP protocol has not been installed on:

  • The Windows machine under diagnosis, AND
  • The machine running the Spotlight client.

To install the SNMP protocol (Windows XP)

  1. Open the Control Panel | Add or Remove Programs | Add/Remove Windows components.
  2. Select Management and Monitoring Tools from the list of components.
  3. Click Details.
  4. Select Simple Network Management Protocol.
  5. Follow the installation instructions.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating