Uninstalling the Protector

1: Uninstalling the Log Forwarder
2: Uninstalling the RPAgent
3: Uninstalling the User Defined Functions (UDFs)
4: Removing the Installation Directory

This page discusses the uninstallation process for the Protegrity Teradata Data Warehouse Protector.

1 - Uninstalling the Log Forwarder

Log in to the server as the user with the required permissions.
Navigate to the /opt/protegrity/logforwarder/bin/ directory.
To stop the Log Forwarder, run the following command:
```
./logforwarderctrl stop
```

Press ENTER.
The command stops the Log Forwarder.

Stopping Logforwarder with PID: 20658
Please Wait

To verify the status of Log Forwarder, run the following command:
```
./logforwarderctrl status
```
Press ENTER.
The status of the Log Forwarder appears.
```
Logforwarder is not running
```
Navigate to the /opt/protegrity/ directory.
To remove the /logforwarder/ directory, run the following command.
```
rmdir logforwarder
```
Press ENTER.
The command removes the the /logforwarder/ directory and completes the uninstallation for the Log Forwarder.

2 - Uninstalling the RPAgent

Log in to the server as the user with the required permissions.
Navigate to the /opt/protegrity/rpagent/bin/ directory.
To stop the RPAgent, run the following command:
```
./rpagentctrl stop
```

Press ENTER.
The command stops the RPAgent.

Stopping RP Agent (PID: 10856)
Please Wait

To verify the status of RPAgent, run the following command:
```
./rpagentctrl status
```
Press ENTER.
The status of the RPAgent appears.
```
RP Agent is not running
```
Navigate to the /opt/protegrity/ directory.
To remove the /rpagent/ directory, run the following command:
```
rmdir rpagent
```
Press ENTER.
The command removes the /rpagent/ directory and completes the uninstallation for the RPAgent.

3 - Uninstalling the User Defined Functions (UDFs)

Log in to the server as the user with the required permissions.
Navigate to the /opt/protegrity/databaseprotector/teradata/sqlscripts/ directory.

To start the bteq utility, run the following command:

/opt/protegrity/databaseprotector/teradata/sqlscripts/ # bteq

Press ENTER.
The prompt to log in to the database appears.
```
Enter your logon or BTEQ command:
```
To log in to the database, run the following command:
```
.logon <username>
```
Press ENTER.
The prompt to enter the database password appears.
To proceed with the removal of the UDFs, type the database password.
Press ENTER.
The connection to the Teradata database is completed successfully.
```
*** Logon successfully completed.
```
To remove the installed UDFs from the Teradata Data Warehouse Protector, run the following query:
```
.run file=dropobjects.sql
```

Press ENTER.
The script removes each of the UDFs and the following message for each of the removed UDF appears.

*** Function has been dropped.
*** Warning: 5607 Check output for possible warnings encountered in compiling and/or linking UDF/XSP/UDM/UDT.
*** Total elapsed time was 1 second.

To remove the Varchar Unicode UDFs installed on the Teradata Data Warehouse Protector, run the following query:
```
.run file=dropvarcharunicode.sql
```

Press ENTER.
The script removes each of the UDFs and the following message for each of the removed UDF appears.

*** Function has been dropped.
*** Warning: 5607 Check output for possible warnings encountered in compiling and/or linking UDF/XSP/UDM/UDT.
*** Total elapsed time was 1 second.

To remove the Decimal UDFs installed on the Teradata Data Warehouse Protector, run the following query:
```
.run file=dropdecimalobjects.sql 
```

Press ENTER.
The script removes each of the UDFs and the following message for each of the removed UDF appears.

*** Function has been dropped.
*** Warning: 5607 Check output for possible warnings encountered in compiling and/or linking UDF/XSP/UDM/UDT.
*** Total elapsed time was 1 second.

4 - Removing the Installation Directory

You must delete the installation directory to complete the process of uninstalling the Teradata Data Warehouse Protector.
To remove the installation directory:

Log in to the server as the user with the required permissions.
Navigate to the /opt/protegrity/ directory.
To delete the installation directory, run the following command:
```
rm -rf /databaseprotector/
```
Press ENTER.
The command deletes the files and the sub-directories within the specified directory.
This step completes the uninstallation process of the Teradata Data Warehouse Protector.