7.3 Vertica

7.3.1 Configuration Issues

For failures related to Vertica cluster configuration or addition of servers to the Vertica cluster, you can check the following logs on the server on which Vertica role is enabled or to be enabled:

Installation Failure

Refer to the following logs:

  • Check vertica-install.log within /var/opt/microfocus/log/zenworks

  • Check vertica-admin-tools.log within /var/opt/microfocus/log/zenworks

  • Check zman.log within /var/opt/microfocus/log/zenworks/

  • Check vertica-install-prepare.log within /var/opt/microfocus/log/zenworks

  • Check vertica-post-database-creation.log within /var/opt/microfocus/log/zenworks

You can also refer to the following logs for detailed reports:

  • install.log available at /opt/vertica/log

  • adminTools.log available at /opt/vertica/log

7.3.2 Vertica Management Console

As the Diagnostics page in ZCC provides only an overview of the status of the Vertica database, to get an in-depth view of the Vertica database operations, you can use the Vertica management console, which is a third-party tool. This tool can be installed and accessed from any server.

For more information on installing the Vertica management console, see the Vertica Documentation.

After logging in to the Management console, you need to select the Import an existing database/cluster option. Using this option, you can import multiple Vertica database servers. While importing the database, you need to provide the database credentials, which can be obtained in one of the following ways:

  • Execute the following zman command

    zman server-role-vertica-get-credentials (zman srvgc)
  • Obtain the credentials from the zenworks-coreadmin web service by referring to the following steps:

    1. On your browser, type the server address of the Primary Server that is part of the Vertica cluster, along with zenworks-coreadmin. For example: https://10.0.0.0/zenworks-coreadmin.

    2. Select Test Service.

    3. Select Vertica Configuration and click Invoke.

For more information on using the Vertica management console, see the Vertica Documentation.