STORAGE_LOCATIONS
Provides information about storage locations, their 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. |
Privileges
Must be a superuser.
Example
=> SELECT * FROM STORAGE_LOCATIONS;
-[ RECORD 1 ]--+------------------------------------------
location_id | 45035996273704984
node_name | v_vmart_node0001
location_path | /home/dbadmin/VMart/v_vmart_node0001_data
location_usage | DATA,TEMP
sharing_type | NONE
is_retired | f
location_label |
rank | 0
throughput | 0
latency | 0
max_size | 20G -[ RECORD 2 ]--+------------------------------------------
location_id | 45035996273705108
node_name | v_vmart_node0002
location_path | /home/dbadmin/VMart/v_vmart_node0002_data
location_usage | DATA,TEMP
sharing_type | NONE
is_retired | f
location_label |
rank | 0
throughput | 0
latency | 0
max_size | 10G ...