Download and run the etlHealth.sh script in Performance Management

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Where can I find etlHealth.sh

Where can I find etlHealth

Download etlHealth.sh 

Download etlHealth

Resolution

Script etlHealth.sh is attached to this KB in etlHealth.zip.

Download to a DR node. Any one works. Make it executable after extracting it from the zip.

chmod 775 etlHealth.sh

2020-10-02: Updated version of script tied to r3.7.16/r20.2.4 release attached to KB article.

Can run as follows:

1. ./etlHealth.sh <dauser> <dapass>
   Sample run:
   
2. ./etlHealth.sh <dradmin> <dbpass> -S
   Sample run:
   

Note, running with dradmin requires the -S flag. Not using it results in this error:

Can also add -v for verbose output. Example commands as follows.

1. ./etlHealth.sh <dauser> <dapass> -v
2. ./etlHealth.sh <dradmin> <dbpass> -S -v

Additional Information

Edit the etlHealth.sh script and set the appropriate vsql location. The OOB location is: /opt/vertica/bin/vsql

Run the following syntax to locate the vsql file: find / -name vsql

 

This is the expected result without any error and the PASS result:

it