Storage Information metrics provide information about the storage objects, such as the tablespace and data files. Storage Information metrics consist of the following categories:
The metrics in this category provide information about the file properties for the database data storage files.
Default Collection Interval — Every 2 hours
Table 2-31 Data Files Storage Metrics
Metric | Description |
---|---|
Data File Identifier (key column) |
Unique identifier for the data file. |
Table Name |
Name of the particular table in the database where the file resides. |
Table Schema |
Schema of the table in which the file resides. |
Table Type |
Type of table to which the file belongs. |
Page Reorganizations |
Number of page reorganizations. |
Overflow Accesses |
Number of overflow accesses. |
The metrics in this category provide information about the log storage properties for the database.
Default Collection Interval — Every 30 minutes
Table 2-32 Log Storage Metrics
Metric | Description and User Action |
---|---|
Database Name (key column) |
Real name of the database for which information is collected or to which the application is connected. This is the name the database was given when created. |
Allocated Secondary Log Size |
Allocated size of the secondary log. |
Log Space Utilization (%) |
Space utilization of log files. |
Total Log Available (in 4Kb Pages) |
Total number of pages available for logging. |
Total Log Used (in 4Kb Pages) |
Total number of pages used for logging. |
The metrics in this category provide information about the individual tablespace properties for all database tablespaces.
Default Collection Interval — Every 15 minutes
Table 2-33 Tablespace Storage Metrics
Metric | Description |
---|---|
Tablespace Identifier (key column) |
Identifier for the tablespace. |
Tablespace Name (key column) |
Name of the tablespace. |
Bufferpool Identifier |
Bufferpool identifier for the tablespace. |
Extent Size |
Extent size for the tablespace. |
Number of Containers |
Number of containers. |
Number of Ranges |
Number of ranges. |
Page Size |
Page size for the tablespace. |
Prefetch Size |
Prefetch size for the tablespace. |
Tablespace Free Pages |
Number of pages in a tablespace that will become free if all pending transactions are committed or rolled back, and new space is requested for an object. |
Tablespace State |
State of the tablespace. |
Tablespace Total Pages |
Total number of pages in a tablespace. |
Tablespace Type |
Type of tablespace. |
Tablespace Usable Pages |
Total number of pages in a tablespace minus overhead pages. |
Tablespace Used Pages |
Total number of pages currently used (not free) in a tablespace. |
Tablespace Utilization (%) |
Tablespace utilization in percentage. |