Viewing Database Information
After the database is created, you can use the infodb command to confirm that the database is using the HDFS locations, such as II_HDFSDATA as its VWROOT location.
infodb dbtest
==================Wed May 13 20:33:43 2015 Database Information=================
.
.
.
================================================================================
----Vectorwise directory--------------------------------------------------------
Location Flags Physical_path
------------------------------------------------------------------
ii_database ROOT,DATA /opt/Actian/VectorVH/ingres/data/vectorwise/dbtest
ii_journal JOURNAL /opt/Actian/VectorVH/ingres/jnl/vectorwise/dbtest
ii_checkpoint CHECKPOINT /opt/Actian/VectorVH/ingres/ckp/vectorwise/dbtest
ii_hdfsbackup CHECKPOINT,HDFS hdfs://namenode:8020/Actian/VectorVH/ingres/ckp/vectorwise/dbtest
ii_work WORK /opt/Actian/VectorVH/ingres/work/vectorwise/dbtest
ii_hdfsdata DATA,VWROOT,HDFS hdfs://namenode:8020/Actian/VectorVH/ingres/data/vectorwise/dbtest
ii_hdfswork WORK,HDFS hdfs://namenode:8020/Actian/VectorVH/ingres/work/vectorwise/dbtest
================================================================================