DB2 Version 9.7 for Linux, UNIX, and Windows

tablespace_auto_resize_enabled - Table space automatic resizing enabled monitor element

This element describes whether automatic resizing is enabled for the table space. A value of 1 means "Yes"; a value of 0 means "No".

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Command and Level
MON_GET_TABLESPACE table function - Get table space metrics	DATA OBJECT METRICS BASE

Table 2. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Table Space	tablespace	Basic

Usage

This element is only applicable to DMS table spaces and non-temporary automatic storage table spaces. If this element is set to 1, then automatic resizing is enabled. See the following monitor elements for information about the rate of increase and the maximum size for the table space.

tablespace_max_size
tablespace_increase_size
tablespace_increase_size_percent