Deleting Repositories

You can delete repositories using either the repimexp utility or the RRCleanup utility.

repimexp utility. Using this utility, you can delete the existing repository using the /a t option.
RRCleanup utility. Using this utility, you can delete the existing repository or the orphan records from Siebel database as follows:
- Repository data. This option passes a valid repository as an argument to the RRCleanup utility to delete repository data from all repository tables. The RRCleanup utility deletes the LOVs (S_LST_OF_VAL) as well for this repository.
- Orphan records. This option does not require you to pass a repository name as an argument to the RRCleanup utility because orphan records do not have the valid repository in the Siebel system and the repository does not exist in the S_REPOSITORY table. The RRCleanup utility deletes the LOVs (S_LST_OF_VAL) as well for orphan Workspaces.
Note: A repository can contain multiple integration branches with each branch containing a copy of List of Value. Deleting a repository has a cascading effect on branches and LOVs.

The RRCleanup utility is located at this location (in Siebel Tools):
```
<Siebel_Home>\BIN\RRCleanup.exe
```
The RRCleanup utility is located at this location in the Siebel Server:
```
<Siebel_Home>\ses\siebsrvr\BIN\RRCleanup.exe
```
The following procedure shows how to run the RRCleanup Utility.

To run the RRCleanup utility

Open the Command Prompt window from your computer by clicking the Start button and then selecting the Run option.
The Run window appears.
Enter the value CMD in the Open field.
The Command Prompt window appears.
Change the directory in the Command Prompt window using one of the following commands:
```
cd <Siebel_Home>\BIN
```
or
```
cd <Siebel_Home>\ses\siebsrvr\BIN
```
Run the RRCleanup.exe utility.
The Command Prompt window opens and displays the following arguments and parameters, which you can use to run the RRCleanup utility:
- -t Siebel Table Owner (required)
- -u Username (required)
- -p Password (required)
- -o ODBC Data Source (required)
- -l Log File Name (default: RRCleanup.log)
- -r Repository Name (delete Runtime Repository data for repository name pass. For example: “Siebel Repository” )
- -a Orphan Flag (Pass Y if required to delete only orphan records)
- -s Siebsrvr/Tools Installation path specified (required)
- -b Repository Type ((R)unTime, (B)Both (DR and RR)) (required)
- -d DB Platform Name (Oracle, MSSQL, DB2UDB, or DB2390)
Use the following command to delete a particular repository data from repository tables:
```
RRCleanup.exe -t "Table Owner" -u "Siebel User Name" -p "Siebel User Name Password" 
-r "Repository Name" -o "ODBC Data Source" -s "Siebsrvr/Tools home location" -b Repository Type 
```
Note: For the -r argument, you can pass only one repository at a time as a parameter. For the -b argument, you can pass either of the repository types as parameter such as -b R to delete data from Runtime Repository tables or –b B to delete data from all repository tables.
Use the following command to delete orphan records:
```
RRCleanup.exe -t "Table Owner" -u "Siebel User Name" -p "Siebel User Name 
Password" -a Y -o "ODBC Data Source" -s "Siebsrvr/Tools home location" -b Repository Type 
```
Note: In one command, you can delete either a repository or orphan records but not both. However, if you pass a repository as parameter and the orphan flag is also set to true then the orphan takes precedence.
View the output stages that represent the progress of the tasks performed by the utility to ensure that the RRCleanup utility is run successfully.

About Removing Repository Data and/or Orphan Records

Before running the RRCleanup utility, note that the following options are available to remove Runtime Repository (RR) data and/or LOV orphan records:

Option 1, -b R: Removes all RR definitions only.
In a RR environment, all RR definitions will be removed but LOVs will remain. You could run this option before a Full Publish operation in a Design Time Repository (DR) environment (however, it is not necessary since Full Publish will do this automatically). For example, the following removes the RR "RepName" :
```
-r "RepName" -b R -a N     <-- (or just leave out -a N) -->
```
Option 2, -b B: Removes all RR and DR definitions for Workspace-enabled objects and LOVs. You should use this option in RR environments. For example, the following removes the DR, RR, and LOVs associated with "RepName" :
```
-r "RepName" -b B -a N     <-- (or just leave out -a N) --> 
```
This is the best option.

Tip: If you have orphaned data because you ran -b R for example instead of -b B, then using -a (without any -b) will get rid of that.
Option 3, -b B a Y: Removes any orphan data in DR, RR, or LOVs – that is, all records with a WS_ID that do not exist in S_WORKSPACE. If you use Option 2 all the time, then you would never have to do this.
```
-b B -a Y
```