How to reinitialize the DR Vertica database

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

How to reinitialize the DR Vertica database to reinstall DA and DC?

Environment

Release : 22.2

Resolution

If you want to reinitialize the DR database you need to do the following:

1) Stop the DA & DC

systemctl stop dadaemon
systemctl stop activemq

systemctl stop dcmd
systemctl stop icmpd (22.2.2 and higher)
systemctl stop activemq

2) Remove the DA as a Data Source from PC
https://knowledge.broadcom.com/external/article?articleId=142962

3) Uninstall the DA & DCs
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/22-2/installing/uninstall-ca-performance-management/uninstall-the-data-collectors.html

cd DC_installation_directory/Uninstall
./Uninstall

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/22-2/installing/uninstall-ca-performance-management/uninstall-the-data-aggregator-component.html

cd <caimda> <installation_directory>/Uninstall
./Uninstall

4) Use the vertica admintool to drop the DA's database
su - dradmin
cd /opt/vertica/bin
./admintools

4. Stop Database
6. Configuration Menu
7. Drop Database

5) Use the vertical admintool to create the DA's database (just as you would if you were installing the DR for the first time)

6. Configuration Menu
1. Create Database --> Select Enterprise Mode

drdata (is the database name)

6) Install the DA
The DA installation creates the tables in Vertica db.

7) Add it as a data source to PC

8) Install and configure the DCs