ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Download and run the etlHealth.sh script in Performance Management

book

Article ID: 199748

calendar_today

Updated On:

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

Attachments

1601661761748__etlHealth.zip get_app