STORAGE_LOCATIONS
Provides information about storage locations, including IDs, labels, and status.
Column Name | Data Type | Description |
---|---|---|
LOCATION_ID |
INTEGER |
Catalog-assigned integer value that uniquely identifies the storage location. |
NODE_NAME |
VARCHAR |
The node name on which the storage location exists. |
LOCATION_PATH |
VARCHAR |
The path where the storage location is mounted. |
LOCATION_USAGE |
VARCHAR |
The type of information stored in the location:
|
SHARING_TYPE | VARCHAR |
How this location is shared among database nodes, if it is:
|
IS_RETIRED |
BOOLEAN |
Whether the storage location has been retired. This column has a value of |
LOCATION_LABEL |
VARCHAR |
The label associated with a specific storage location, added with the ALTER_LOCATION_LABEL function. |
RANK |
INTEGER |
The Access Rank value either assigned or supplied to the storage location, as described in Prioritizing Column Access Speed. |
THROUGHPUT |
INTEGER |
The throughput performance of the storage location, measured in MB/sec. You can get location performance values using MEASURE_LOCATION_PERFORMANCE, and set them with the SET_LOCATION_PERFORMANCE function. |
LATENCY |
INTEGER |
The measured latency of the storage location as number of data seeks per second. You can get location performance values using MEASURE_LOCATION_PERFORMANCE, and set them with the SET_LOCATION_PERFORMANCE function. |
MAX_SIZE | INTEGER | Maximum size of the storage location in bytes. |
DISK_PERCENT | VARCHAR | Maximum percentage of available node disk space that this storage location can use, set only if depot size is defined as a percentage, otherwise blank. |
Privileges
Superuser