DATABASE_VOLUMES table
The DATABASE_VOLUMES table represents which volumes are used by which databases. The primary key is the combination of DB_UID, NODE_NAME, and VOLUME_NAME columns.
Column number |
Column Name |
Data Type |
Description |
1* |
DB_UID |
LARGEINT |
The catalog UID of the database. Links to ALL_DATABASES. |
2* |
NODE_NAME |
CHAR(8) |
The Expand node name of the system where the volume resides, links to DBS_VOLUMES. |
3* |
VOLUME_NAME |
CHAR(8) |
The name of the volume, links to DBS_VOLUMES. |
4 |
RESERVED_CAPACITY |
LARGEINT |
The amount of disk space on the volume that is reserved for the associated database. |
5 | REQUESTED_CAPACITY | LARGEINT | The amount of disk space allotted on the volume that is reserved for the associated database. However, SQL/MX does not impose any restrictions when the data volume is used more than the allotted capacity. |
6 |
IS_EXCLUSIVE |
CHAR(2) |
Y/N indication if the volume is reserved for exclusive use by the database. |
* Indicates primary key |