Determine Vertica data and catalog directories and disk usage from command line

Products

• CA Infrastructure Management
• CA Performance Management
• Network Observability

Issue/Introduction

How can the location of the Vertica catalog and data directories along with disk usage be determined from the command line?

Environment

DX NetOps CAPM all currently supported releases

Resolution

To determine where the vertica catalog and data directories reside, along with disk usage - do the following:

1. Log on to a vertica node
2. su - dradmin (or equivalent user)
3. cd /opt/vertica/bin
4. Run the following command:
   
   SELECT node_name, storage_path, storage_status,storage_usage, DISK_SPACE_FREE_MB, disk_space_free_percent from disk_storage;

You should get output that looks similar to this:


-bash-4.2$ ./vsql -Udradmin -wdbpass -c 'SELECT node_name, storage_path, storage_status,storage_usage, DISK_SPACE_FREE_MB, disk_space_free_percent from disk_storage';
     node_name     |                        storage_path                        | storage_status | storage_usage | DISK_SPACE_FREE_MB | disk_space_free_percent
-------------------+------------------------------------------------------------+----------------+---------------+--------+-----
 v_drdata_node0001 | /loddisk2/catalog/drdata/v_drdata_node0001_catalog/Catalog | Active         | CATALOG       | 130847 | 92%
 v_drdata_node0001 | /loddisk2/data/drdata/v_drdata_node0001_data               | Active         | DATA,TEMP     | 130847 | 92%