Home > Storage > PowerScale (Isilon) > Industry Solutions and Verticals > Analytics > Scale Quickly and Efficiently with Dell PowerScale OneFS and Vertica Analytical Database > Create the Vertica Eon Mode database
Run the following commands to create the Vertica test database.
Create the database:
admintools -t create_db -x auth_params.conf -s <add database server IPs example: x.x.x.x,x.x.x.x,x.x.x.x,x.x.x.x,x.x.x.x > -d VMart -p databasepwd --depot-path=/data/db/mydepot --shard-count=12 --communal-storage-location=s3://objstorc -D /home/dbadmin -c /home/dbadmin -l /home/dbadmin/DELL.dat --depot-size 500GB
Run vsql to change the dbadmin's password to an empty string:
vsql -U dbadmin -w databasepwd
> alter user dbadmin identified by '';
Alter the database default setting for AWSStreamingConnectionPercentage:
> ALTER DATABASE DEFAULT SET PARAMETER AWSStreamingConnectionPercentage = 0;
Activate native load balancing:
> SELECT SET_LOAD_BALANCE_POLICY('ROUNDROBIN');
Create a small table, insert a row, and query the table to ensure basic functionality:
> create table test(c1 int);
> insert into test values('1');
> commit;
> select * from test;
> drop table test cascade;
# exit vsql
\q