The DB2® Tablespace Auto-resize attributes
provide information about the monitoring of the automatic resizing
of tablespaces.
Node Name The node name of
the database.
Timestamp The local time at
the agent when the data was collected.
Host Name The host name of the
machine where the DB2 database
is hosted.
Instance Name The name of the
monitored DB2 instance (Unicode). The
valid format is a text string with a maximum of 60 bytes.
DB Name The name of the monitored
database.
DB Partition The DB2 database partition node number, which can
range from 0 to 999. The Aggregated and Current® Partition values can be used within
a query or situation filter. If a db partition filter is not specified,
data is returned for the current database partition. If a db partition
filter is set to Aggregated, only aggregated partition data is returned.
Historical data collection includes both aggregated and individual
partition attribute data. In addition to numeric partition numbers
in the 0 to 999 range, the following values are also valid:
| External value |
Internal value |
| Aggregated |
-1 |
| Current Partition |
-2 |
| All |
-3 |
TBSP Name Represents the tablespace
name of DB2. Value format
is a simple text string with a maximum of 96 characters.
TBSP ID Represents the identifier
for the tablespace. A valid value is an integer. The following
value is valid:
| External value |
Internal value |
| Value Exceeds Maximum |
9223372036854775807 |
Total Pages Represents the number
of total pages available associated with the database. A valid
value is an integer. The following value is valid:
| External value |
Internal value |
| Value Exceeds Maximum |
9223372036854775807 |
Usable Pages Represents the number
of usable pages associated with the database. A valid value is
an integer. The following value is valid:
| External value |
Internal value |
| Value Exceeds Maximum |
9223372036854775807 |
Used Pages Represents the total
number of used pages. A valid value is an integer. The following
value is valid:
| External value |
Internal value |
| Value Exceeds Maximum |
9223372036854775807 |
Free Pages Represents the number
of free pages associated with the database. A valid value is
an integer. The following value is also valid:
| External value |
Internal value |
| Value Exceeds Maximum |
9223372036854775807 |
Initial Size Represents the initial
tablespace size in bytes associated with the database. A valid
value is an integer. The following value is also valid:
| External value |
Internal value |
| Value Exceeds Maximum |
9223372036854775807 |
Current Size Represents
the current tablespace size in bytes associated with the database. A
valid value is an integer. The following value is also valid:
| External value |
Internal value |
| Value Exceeds Maximum |
9223372036854775807 |
Max Size Represents the maximum
tablespace size in bytes associated with the database. A valid
value is an integer. The following value is also valid:
| External value |
Internal value |
| Value Exceeds Maximum |
9223372036854775807 |
Increase Size Represents the size
in bytes of the increase of the tablespace associated with the database. A
valid value is an integer. The following value is also valid:
| External value |
Internal value |
| Value Exceeds Maximum |
9223372036854775807 |
Increase Size Pct Represents
the size as a percentage to which an auto-resize tablespace increases
before reaching its maximum size and more space is required. The
following value is also valid:
| External value |
Internal value |
| Value Exceeds Maximum |
2147483647 |
Last Resize Time Represents
the time at which the last tablespace resize was successfully executed.
Last Resize Failed Indicates
whether the last resize attempted succeeded.
Rebalance Mode Represents whether
a forward or reverse rebalance is taking place. A valid value
is an integer.
Prefetch Size Represents the
maximum number of pages the prefetcher gets from the disk at a time. A
valid value is an integer. The following value is also valid:
| External value |
Internal value |
| Value Exceeds Maximum |
9223372036854775807 |
TBSP Utilization (%) Represents
the percentage of storage consumption for each DMS tablespace. .
A valid value is an integer. The following value is also valid:
| External value |
Internal value |
| Value Exceeds Maximum |
2147483647 |
Used Allocated Pct Represents
the percentage of the allocated size that has been used. A valid
value is an integer. The following value is also valid:
| External value |
Internal value |
| Value Exceeds Maximum |
2147483647 |
Used Max Pct Represents the percentage
of the maximum size that has been used. A valid value is an integer.
The following value is also valid:
| External value |
Internal value |
| Value Exceeds Maximum |
2147483647 |
Used Disk Pct Represents the
percentage of used tablespace size for the disk size. A valid
value is an integer. The following value is also valid:
| External value |
Internal value |
| Value Exceeds Maximum |
2147483647 |
Auto Resize Enabled Indicates
whether automatic resizing is enabled for the tablespace
Using
Auto Storage Indicates whether the tablespace was created as an
automatic storage tablespace.