8.1 Disabling and Removing Vertica from the Zone

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)
```
Using the obtained dbadmin password, 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. 
```
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 respective Vertica and Kafka servers.

zenworks-connect.service: Execute the following commands in the order listed below:
```
systemctl stop zenworks-connect.service
```
```
systemctl disable zenworks-connect.service
```
zenworks-kafka.service: Execute the following commands in the order listed below:
```
systemctl stop zenworks-kafka.service
```
```
systemctl disable zenworks-kafka.service
```
zenworks-schema-registry.service: Execute the following commands in the order listed below:
```
systemctl stop zenworks-schema-registry.service
```
```
systemctl disable zenworks-schema-registry.service
```
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/novell/zenworks/datamodel and delete the files 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)\Novell\ZENworks\conf\datamodel and delete the files zenvertica_dmaccounts.properties and zenvertica.xml. Also, remove the entry vertica=zenvertica from the dmmappings.properties file.
Run the following query to remove the opaque entries related to Vertica from the database:
```
DELETE FROM ZOPAQUEDATA WHERE name LIKE '%vertica%'
```
Run the following query to remove the opaque entries related to Kafka from the database:
```
DELETE FROM ZOPAQUEDATA WHERE name LIKE '%kafka%'
```
Remove the following cluster ID file from all the Vertica nodes to stop the stream processors:

/etc/opt/novell/zenworks/loader/loader.cluster.id.

Remove the Vertica role from the database:

DELETE FROM ZZENSERVERROLES roles WHERE ROLES = 'Vertica'

Remove the Kafka role from the database:

DELETE FROM ZZENSERVERROLES roles WHERE ROLES = 'Kafka'

Remove the Kafka connector information from the database:
```
DELETE FROM ZVCONSUMERMETRICS;
```
Restart the ZENserver and ZENloader services on all the servers.

8.1.1 Enabling Vertica

Procure the obfuscated license file from Micro Focus Customer Support and copy the file in the location /etc/opt/novell/vertica.
Enable Kafka.
Enable Vertica. For more information, see Enabling Vertica.
Execute the data migration configure action using the Force option:
```
novell-zenworks-configure -c VerticaDBMigrate -Doption=force
```