How can we check the version of DA, DC, and Vertica version on DR?
search cancel

How can we check the version of DA, DC, and Vertica version on DR?

book

Article ID: 230625

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

Please let us know how can we check the version on DA, DC, and Vertica version on DR? 

Environment

Release : 3.7 / 20.x / 21.x

Component : IM Reporting / Admin / Configuration

Resolution

On the PC machine:

cat /opt/CA/PerformanceCenter/InstallLogs/.history

On the DA machine:

cat /opt/IMDataAggregator/Logs/.history

On the DC machine:

cat /opt/IMDataCollector/Logs/.history


On the DR - Vertica machine:

cd /opt/vertica/bin

./vsql -U dauser -W   (prompt for password)

./vsql -U dradmin -W   (prompt for password)

./vsql -U dauser -w dapass (this is an example, your password may be different)

./vsql -U dradmin -w dbpass (this is an example, your password may be different)

Then run this query:

dauser=> SELECT version();

Example of the output of the query:
              version
------------------------------------
 Vertica Analytic Database v9.1.1-5
(1 row)

 

Or you check in the Vertica admintools utility.

Here are the steps:

Logged as root switch to the dradmin account:

$ su - dradmin

Navigate to the /opt/vertica/bin/ directory (OOB directory - you may have installed in a different directory):

$ cd /opt/vertica/bin/

Launch the admintools utility:

$ ./admintools

https://api-broadcom-ca.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=GMws+5jCr1ho42jxpJyEdg==

You will see the Vertica version at the top of the admintools window above.

Additional Information

Vertica versions by CAPM versions
https://knowledge.broadcom.com/external/article?articleId=185454