Where can I find etlHealth.sh
Where can I find etlHealth
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:
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.
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: