The Operating System drilldown provides information about the performance, processes, and storage on the server.
When you click the OS drilldown icon on the toolbar, the Operating System home page for the system where your database is running opens. For help with the OS drilldowns for Windows, Linux, or Unix, press F1 on the appropriate OS home page.
For specific information about monitoring a Unix or Linux Operating System, refer to help for Spotlight on Unix, and for monitoring a Windows Operating System, refer to help for Spotlight on Windows, or Spotlight on Windows Clusters. To open this help, select Help|Contents.
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.
Note: This drilldown is available for DB2 9.5 and later databases only.
The Workload Management Analysis drilldown reports the information gathered by the WLM_GET table functions about the Workload Management (WLM) environment for the currently selected database.
To open the Workload Management Analysis drilldown
On the home page for the selected DB2 database or on the home page for the DB2 instance, click in the toolbar.
From the following tabs on the drilldown, view both summary information and drill-down details about how workloads are being managed and how they are performing in the database:
The Service Classes tab on Workload Management Analysis drilldown shows real-time summary and drill-down information about each service class defined on the current database.
A DB2 service class is a database object, assigned to one or more workloads, which defines the execution environment in which the activities in a workload run. That is, the service class is the primary point from which resources for database requests are assigned, work flow is managed, and activities are monitored in a workload.
A workload is assigned to one service class in the workload definition. However, a service class can be assigned to multiple workloads.
The tab lists the service classes currently defined on the database. These include both user-defined and system default service classes. Each top-level node in the list is the service superclass , which serves as the top tier for managing work environments. Expand a service superclass node to view its subclasses. The different service subclasses provide granularity in mapping resources and applying controls. A subclass is the actual environment where workload activities run.
The following summary statistics are shown for each subclass at database-partition level:
To access in-depth information about what is happening across all workloads in your database at the service class level, click a service class entry and view any of the following sub-drilldowns. (Click a superclass to view information across all its subclasses; click a subclass to view information specific to the subclass.)
Shows details about occurrences (that is, database connections assigned to a workloads) currently running across all workloads assigned to the service class. For each occurrence, view the attributes used to assign the connection to its workload, the current status of the occurrence, and the volume and success and failure rates of its activities.
Provides details about the agents handling activities associated with occurrences across all workloads in the service class.
Lists statistics for queued activities in all workloads in the service class. These statistics include queue times and sizes.
Graphically depicts activity totals for all workloads in the service class.