Can the data repository stop or start be scripted

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

The DX Netops Performance Management  section on how to restart the data repositor details the process which includes using the administration tool (adminTools) which is menu driven:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/performance-management/22-2/administrating/restart-ca-performance-management-component-services/restart-the-data-repository.html

However, sometimes the interface or accessibility requires this be done using the command line. For example, to script this for use as part of system patching tasks.
 

Is there a way to restart the Vertica cluster via a script?

Environment

CAPM 3.x on linux

Resolution

There is one caveat that you need to be aware of using the command line with Vertica. Sometimes, if there is a problem starting the db, adminTools will offer some choices, like start from last good epoch. When you use the command line, those options are not seen and the db just fails.

With that in mind, here are some commands:

Replace dbpass with your password, if different, also replace dradmin if your Data Repository user is not dradmin and drdata with the name of your database if it is not dradmin as well:

Example of starting the DB from the root user account:

su - dradmin -c "/opt/vertica/bin/adminTools -t start_db -d drdata -p dbpass -i";

To stop the DB using the root account:

su - dradmin -c "/opt/vertica/bin/adminTools -t stop_db -d drdata -p dbpass -i";

To get the status of the DB:

su - dradmin -c "/opt/vertica/bin/adminTools -t view_cluster";

Additional Information

https://www.vertica.com/docs/10.1.x/HTML/index.htm#Authoring/AdministratorsGuide/OperatingTheDatabase/StartingTheDatabase.htm#Command