Table space storage health indicators
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.
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.
- 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.
(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.- 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.
- Identifier
- ts.ts_util_auto_resize
- Health monitor level
- Table Space
- Category
- Table Space Storage
- Type
- Upper-bounded threshold-based
- Unit
- Percentage
((ts.used * ts.page_size) / ts.max_size) * 100
where- ts.used is the value of tablespace_used_pages - Used pages in table space monitor element
- ts.page_size is the value of tablespace_page_size - Table space page size monitor element
- ts.max_size is the value of tablespace_max_size - Maximum table space size monitor element
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.
- 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.
(ts.used / ts.usable) * 100
where- ts.used is the value of tablespace_used_pages - Used pages in table space monitor element
- ts.usable is the value of tablespace_usable_pages - Usable pages in table space monitor element
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.
- 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.
(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.
- 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.
- Identifier
- tsc.tscont_op_status
- Health monitor level
- Table Space Container
- Category
- Table Space Storage
- Type
- State-based
- Unit
- Not applicable