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

Percent of Sort Heap Threshold alarm

The Percent of Sort Heap Threshold alarm becomes active when the amount of sort heap space allocated approaches or exceeds the SHEAPTHRES database manager configuration parameter value. The SHEAPTHRES parameter value is the sort heap threshold for the entire instance.

The underlying metrics for this alarm can be adjusted to suit your environment by using the Metric Editor.

What you can do

  • Determine whether the current SHEAPTHRES parameter value is appropriate for your system. Insufficient sort heap allocation causes the database manager to select less efficient sorting techniques that can severely impact system performance.
  • Access the Client Applications and Databases drilldowns.

    • The Sorting tab in both drilldowns can help you profile the sorting requirements and sort exception rates at the instance, database, and application levels.
    • The Details tab can help you identify databases and applications that are consuming significant amounts of CPU time to perform sorts.

Related topics

 

SMS Container Percentage alarm

The SMS Container Percentage alarm becomes active when the percentage of utilized System Managed Space (SMS) approaches the total amount of SMS storage in the DB2 instance.

The default thresholds are predefined as follows:

  • Threshold 1—The zero to 69 percent range. The percentage of SMS space utilized is low. No alarms are raised.

  • Threshold 2—The 70 to 79 percent range. This raises a Low severity alarm stating, The percentage of SMS space utilized is moderate.

  • Threshold 3—The 80 to 89 percent range. This raises a Medium severity alarm stating, The percentage of SMS space utilized is high.

  • Threshold 4—The 90 to 100 percent range. This raises a High severity alarm stating, The percentage of SMS space utilized is very high.

The underlying metrics for this alarm can be adjusted to suit your environment by using the Metric Editor.

What you can do

Click the SMS database files component to open the Tablespaces drilldown. This drilldown provides details about the tablespaces in which the database you are currently monitoring resides. You can select a specific tablespace to view its storage and activity statistics.

 

Related topics

SMS Utilization alarm

The SMS Utilization alarm becomes active when the percentage of utilized System Managed Space (SMS) approaches the total amount of SMS storage in the DB2 instance.

The default thresholds are predefined as follows:

  • Threshold 1—The zero to 69 percent range. The percentage of SMS space utilized is low. No alarms are raised.

  • Threshold 2—The 70 to 79 percent range. This raises a Low severity alarm stating, The percentage of SMS space utilized is moderate.

  • Threshold 3—The 80 to 89 percent range. This raises a Medium severity alarm stating, The percentage of SMS space utilized is high.

  • Threshold 4—The 90 to 100 percent range. This raises a High severity alarm stating, The percentage of SMS space utilized is very high.

The underlying metricsfor this alarm can be adjusted to suit your environment by using the Metric Editor.

What you can do

Click the SMS database files component to open the Tablespaces drilldown. This drilldown provides details about the tablespaces in which the database you are currently monitoring resides. You can select a specific tablespace to view its storage and activity statistics.

 

Related topics

Sort Overflows alarm

The Sort Overflows alarm becomes active when the percentage of sort at the database or partition exceeds the overflow threshold limits. Sort heap is controlled by the SHEAPTHRES database manager configuration parameter, which sets the sort heap threshold for the entire instance and by the SORTHEAP database configuration parameter, which sets the sort heap size. Sort overflows are sorts that run out of sort heap and require disk space for temporary storage.

The thresholds are predefined as follows:

  • Threshold 1—The zero to 69 percent range. The percent of sort overflows is very low. No alarms are raised.

  • Threshold 2—The 70 to 79 percent range. This raises a Low severity alarm stating, The percent of sort overflows is moderate.

  • Threshold 3—The 80 to 89 percent range. This raises a Medium severity alarm stating, The percent of sort overflows is high.

  • Threshold 4—The 90 to 100 percent range. This raises a High severity alarm stating, The percent of sort overflows is very high.

The underlying metricsfor this alarm can be adjusted to suit your environment by using the Metric Editor.

What you can do

  • If the percentage of overflowed sorts is high, increase the sort heap.

  • If there were any post-threshold sorts, increase the SHEAPTHRES configuration parameters. To determine if there were any post threshold sorts, click the Overflows component to open the Databases drilldown. This drilldown provides details about all the active databases in the DB2 instance. You can select any database to view details about that database, including sort activity and sort heap usage statistics.

 

Related topics

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione