Chat now with support
Chat with Support

Spotlight on SAP ASE 2.12 - Getting Started Guide

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating