Uninstalling the Teradata Data Warehouse Protector

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

This section outlines the uninstall process for the Protegrity Teradata Data Warehouse Protector.

1 - Uninstalling the Log Forwarder

Log in to the database 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 deletes 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 deletes the /rpagent/ directory and completes the uninstallation for the RPAgent.

3 - Dropping the User Defined Functions

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.
Enter the database password.
Press ENTER.
The connection to the Teradata database is established 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

Deleting the installation directory is the final stage in the process of uninstalling the Teradata Data Warehouse Protector.

To remove the installation directory:

Log in to the database 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.