The Tip in the Prepare to install the DA documentation shows the incorrect result of the command
search cancel

The Tip in the Prepare to install the DA documentation shows the incorrect result of the command

book

Article ID: 373213

calendar_today

Updated On:

Products

DX NetOps CA Performance Management - Usage and Administration

Issue/Introduction

The below command shows the result as the version of the database. What the below command does is show the current active database. 

You can verify that the data repository is running by completing the following steps:

Open a console and log in to the data repository host as the root or sudo user.

Issue the following command:

su - dr_admin_user -c "/opt/vertica/bin/admintools -t show_active_db"

dr_admin_user
 
Specifies the Linux user that serves as the Vertica database administrator system account (the database administrator user).
 
The following response is expected:
 
version ------------------------------------ Vertica Analytic Database vx.x.x-x

Cause

The documentation is incorrect. 

Resolution

The following command will show the version of the vertica database:

/opt/vertica/bin/vsql -c 'select version()'

To show the current active database, the following command can be run:

su - dr_admin_user -c "/opt/vertica/bin/admintools -t show_active_db"