Health indicators for DMS table spaces

You can determine the health indicators that are relevant for a DMS table space based on the characteristics of the table space.

Important: The health monitor, health indicators, and related components have been deprecated and might be removed in a future release. Health monitor is not supported in Db2® pureScale® environments. For more information, see Health monitor has been deprecated.
This table describes which table space health indicators are relevant for a DMS table space based on the characteristics of the table space:
Table 1. Relevant table space health indicators for a DMS table space
Table space characteristics Maximum table space size defined Maximum table space size undefined
Automatic resize enabled = Yes ts.ts_util_auto_resize - Tracks percentage of table space used relative to the maximum defined by you. An alert indicates that the table space will soon be full and requires intervention by you. As long as the maximum size has been set to a reasonable value (that is, the amount of space specified by the maximum size does exist), this is the most important health indicator for this configuration.

ts.ts_util - Tracks usage of currently allocated table space storage. An alert may not require intervention by you to resolve any problems since the table space will attempt to increase in size when it is full.

ts.ts_auto_resize_status - Tracks health of resize attempts. An alert indicates that the table space failed to resize (that is, the table space is full).

ts.ts_util_auto_resize - Not applicable. No upper bound specified for the table space size.

ts.ts_util - Tracks usage of currently allocated table space storage. An alert may not require intervention by you to resolve any problems since the table space will attempt to increase in size.

ts.ts_auto_resize_status - Tracks health of resize attempts. An alert indicates that the table space failed to resize (that is, the table space is full).

Note: If a DMS table space is defined using automatic storage and there is no maximum size specified, you should also pay attention to the db.auto_storage_util health indicator. This health indicator tracks utilization of the space associated with the database storage paths. When this space fills up, the table space is unable to grow. This may result in a table space full condition.
Automatic resize enabled = No Not a valid configuration. Maximum table space size is only valid for table spaces that have automatic resize enabled. ts.ts_util_auto_resize - Not applicable. Table space will not attempt to resize.

ts.ts_util - Tracks usage of currently allocated table space storage. An alert indicates a table space full condition and requires immediate intervention by you. The table space will not attempt to resize itself.

ts.ts_auto_resize_status - Not applicable. Table space will not attempt to resize.

db.auto_storage_util - Database automatic storage utilization health indicator

Indicates the consumption of storage for the defined database storage paths.

Important: The health monitor, health indicators, and related components have been deprecated and might be removed in a future release. Health monitor is not supported in Db2 pureScale environments. For more information, see Health monitor has been deprecated.
Identifier
db.auto_storage_util
Health monitor level
Database
Category
Database
Type
Upper-bounded threshold-based
Unit
Percentage

When automatic storage table spaces are created, containers are allocated automatically for these table spaces on the database storage paths. If there is no more space on any of the file systems on which the database storage paths are defined, automatic storage table spaces will be unable to increase in size and may become full.

The indicator is calculated using the formula:
(db.auto_storage_used / db.auto_storage_total) * 100
where
  • db.auto_storage_used is the sum of used space across all physical file systems identified in the list of database storage paths
  • db.auto_storage_total is the sum of total space across all physical file systems identified in the list of database storage paths

Database automatic storage path utilization is measured as a percentage of the space consumed on the database storage path file systems, where a high percentage indicates less than optimal function for this indicator.

The Time to fullness in the Additional Information line returned for this health indicator is a prediction of how much time is remaining until the maximum size for the table space has been reached.

Usage note
If you use storage groups, this health indicator indicates the consumption of storage for the defined database storage paths in the default storage group only.

ts.ts_auto_resize_status - Table space automatic resize status health indicator

This health indicator identifies whether table space resize operations are succeeding for DMS table spaces which have automatic resize enabled.

When a DMS table space with automatic resize enabled fails to increase in size, it is effectively full. This condition may be due to lack of free space on the file systems on which the table space containers are defined, or a result of the table space automatic resize settings. For example, the defined maximum size may have been reached, or the increase amount may be set too high to be accommodated by the remaining free space.
Important: The health monitor, health indicators, and related components have been deprecated and might be removed in a future release. Health monitor is not supported in Db2 pureScale environments. For more information, see Health monitor has been deprecated.
Identifier
ts.ts_auto_resize_status
Health monitor level
Table Space
Category
Table Space Storage
Type
State-based
Unit
Not applicable

ts.ts_util_auto_resize - Automatic resize table space utilization health indicator

This health indicator tracks the consumption of storage for each automatic resize DMS table space on which a maximum size has been defined. The DMS table space is considered full when the maximum size has been reached.

Important: The health monitor, health indicators, and related components have been deprecated and might be removed in a future release. Health monitor is not supported in Db2 pureScale environments. For more information, see Health monitor has been deprecated.
Identifier
ts.ts_util_auto_resize
Health monitor level
Table Space
Category
Table Space Storage
Type
Upper-bounded threshold-based
Unit
Percentage
The indicator is calculated using the formula:
((ts.used * ts.page_size) / ts.max_size) * 100
where

Automatic resize DMS table space utilization is measured as a percentage of the maximum table space storage consumed. A high percentage indicates the table space is approaching fullness. The short term and long term growth rates, included in the additional information for this indicator, can be used to determine if the current rate of growth is a short term aberration, or consistent with long term growth.

The Time to fullness in the Additional Information line returned for this health indicator is a prediction of how much time is remaining until the maximum size for the table space has been reached.

ts.ts_util - Table Space Utilization health indicator

This health indicator tracks the consumption of storage for each DMS table space.

Important: The health monitor, health indicators, and related components have been deprecated and might be removed in a future release. Health monitor is not supported in Db2 pureScale environments. For more information, see Health monitor has been deprecated.
Identifier
ts.ts_util
Health monitor level
Table Space
Category
Table Space Storage
Type
Upper-bounded threshold-based
Unit
Percentage

The DMS table space is considered full when all containers are full.

If automatic resize is enabled on the table space, this health indicator will not be evaluated. Instead, the database automatic storage utilization db.auto_storage_util and table space automatic resize status (ts.ts_auto_resize_status) health indicators are relevant for table space storage monitoring. The automatic resize table space utilization (ts.ts_util_auto_resize) health indicator will also be available if a maximum size was defined on this table space. The table space utilization percentage can still be retrieved from column TBSP_UTILIZATION_PERCENT of the TBSP_UTILIZATION administrative view if it is required.

The indicator is calculated using the formula:
(ts.used / ts.usable) * 100
where

Table space utilization is measured as the percentage of space consumed, where a high percentage indicates less than optimal function for this indicator.

The short term and long term growth rates, included in the additional information for this indicator, can be used to determine if current rate of growth is a short term aberration or consistent with longer term growth.

The Time to fullness in the Additional Information line returned for this health indicator is a prediction of how much time is remaining until the maximum size for the table space has been reached.

tsc.tscont_util - Table Space Container Utilization health indicator

This health indicator tracks the consumption of storage for each SMS table space that is not using automatic storage.

Important: The health monitor, health indicators, and related components have been deprecated and might be removed in a future release. Health monitor is not supported in Db2 pureScale environments. For more information, see Health monitor has been deprecated.
Identifier
tsc.tscont_util
Health monitor level
Table Space Container
Category
Table Space Storage
Type
Upper-bounded threshold-based
Unit
Percentage

An SMS table space is considered full if there is no more space on any of the file systems for which containers are defined.

If free space is not available on the file system to expand an SMS container, the associated table space becomes full.

An alert may be issued for each container defined on the file system that is running out of free space.

The indicator is calculated using the formula:
(fs.used / fs.total)*100
where fs is the file system in which the container resides.

SMS table space utilization is measured as the percentage of space consumed, where a high percentage indicates less than optimal function for this indicator.

The short term and long term growth rates, included in the additional information for this indicator, can be used to determine if current rate of growth is a short term aberration or consistent with longer term growth.

The Time to fullness in the Additional Information line returned for this health indicator is a prediction of how much time is remaining until the maximum size for the table space has been reached.

ts.ts_op_status - Table Space Operational State health indicator

The state of a table space can restrict activity or tasks that can be performed. A change from normal to another state may generate an Attention alert.

Important: The health monitor, health indicators, and related components have been deprecated and might be removed in a future release. Health monitor is not supported in Db2 pureScale environments. For more information, see Health monitor has been deprecated.
Identifier
ts.ts_op_status
Health monitor level
Table Space
Category
Table Space Storage
Type
State-based
Unit
Not applicable

tsc.tscont_op_status - Table Space Container Operational State health indicator

This health indicator tracks the accessibility of the table space container. The accessibility of the container can restrict activity or tasks that can be performed. If the container is not accessible, an Attention alert may be generated.

Important: The health monitor, health indicators, and related components have been deprecated and might be removed in a future release. Health monitor is not supported in Db2 pureScale environments. For more information, see Health monitor has been deprecated.
Identifier
tsc.tscont_op_status
Health monitor level
Table Space Container
Category
Table Space Storage
Type
State-based
Unit
Not applicable