To disable Vertica:
Run the following zman command on any server to obtain the Vertica database superuser password.
server-role-vertica-get-credentials (zman srvgc)
Before performing the below steps, ensure that you switch to the dbadmin user by running the su dbadmin command.
Run the following command to stop the Vertica database on one of the servers on which Vertica is installed:
/opt/vertica/bin/admintools -t stop_db -d zenworks -p <dbadmin_password> --force.
NOTE:Substitute <dbadmin_password> with the password obtained in step 1.
Run the following drop database command on one of the servers on which Vertica is installed:
/opt/vertica/bin/admintools -t drop_db -d zenworks
Stop all the cluster nodes. To identify these nodes, run the following command on one of the servers on which Vertica is installed:
/opt/vertica/bin/admintools -t list_host
If a node is listed, then run the following command to stop the node:
/opt/vertica/bin/admintools -t stop_node -s <comma separated list of hosts>.
Disable the following services on the Vertica servers:
zenworks-vertica.service: Execute the following commands in the order listed below:
systemctl stop zenworks-vertica.service
systemctl disable zenworks-vertica.service
Delete the following datamodel files on all the servers.
On a Linux server: Navigate to /etc/opt/microfocus/zenworks/datamodel and delete the files zenvertica_dmsuperaccount.properties, zenvertica_dmaccounts.properties and zenvertica.xml. Also, remove the entry vertica=zenvertica from the dmmappings.properties file.
On a Windows server: Navigate to C:\Program Files (x86)\Micro Focus\ZENworks\conf\datamodel and delete the files. zenvertica_dmsuperaccount.properties, zenvertica_dmaccounts.properties and zenvertica.xml. Also, remove the entry vertica=zenvertica from the dmmappings.properties file.
Remove the cluster ID file from all the Vertica nodes to stop the stream processors using the following command:
/etc/opt/microfocus/zenworks/loader/loader.cluster.id.
Remove the Vertica role from the database:
DELETE FROM ZZENSERVERROLES WHERE ROLES = 'Vertica'
You can use DBeaver to connect to the database. For more information, see Using DBeaver to Export SQL Query Results in the ZENworks Database Management Reference.
NOTE:If you are using embedded PostgreSQL, run zman dgc to get the credentials for ZENworks database, and then connect to zendatabase. If you are using external database, then connect to zendatabase and run the queries.
Run the following query to remove the opaque entries related to Vertica from the database:
DELETE FROM ZOPAQUEDATA WHERE name LIKE '%vertica%'
Restart the ZENserver and ZENloader services on all the servers.
Procure the obfuscated license file from Micro Focus Customer Support and copy the file in the location /etc/opt/microfocus/vertica.
Enable Kafka. For more information, see Configuring Vertica.
Enable Vertica. For more information, see Enabling Vertica.
Execute the data migration configure action using the Force option:
microfocus-zenworks-configure -c VerticaDBMigrate -Doption=force