Using Siebel Tools > Managing Repositories >

Deleting Repositories

You can delete repositories either using the repimexp utility or the RRcleanup utility. You use repimexp utility by using the option /a t to delete the existing repository.

You use the RRCleanup utility to delete the existing repository or the orphan records from the Siebel database. Using this utility, you can delete:

• 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 Siebel system and the repository does not exist in the S_REPOSITORY table.

• Repository data.

  This option passes a valid repository as an argument to the RRCleanup utility to delete all repository data from all repository tables.

• Only runtime repository data.

  This option passes a valid repository as an argument to the RRCleanup utility to delete all runtime repository data from all run-time tables.

In Siebel Tools, the RRCleanup utility is located at this location:

<Siebel_Home>\BIN\RRCleanup.exe

In the Siebel Server, the RRCleanup utility is located at this location:

<Siebel_Home>\ses\siebsrvr\BIN\RRCleanup.exe

To run the RRCleanup utility

1. Open the Command Prompt window from your computer by clicking the Start button and then selecting the Run option.

   The Run window appears.

2. Enter the value CMD in the Open field.

   The Command Prompt window appears.

3. Change the directory in the Command Prompt window using one of the following commands:

   cd <Siebel_Home>\BIN\RRCleanup.exe

   or

   cd <Siebel_Home>\ses\siebsrvr\BIN\RRCleanup.exe

4. The Command Prompt window 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. e.g. "Siebel Repository")
   • -a Orphan Flag (Pass Y if required to delete only orphan records)
   • -s Server Tool (Pass that contains odbcsql.exe usually <tools>\bin)
   • -b RepositoryType ((R)unTime, (D)esignTime) (required)
5. 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 "Path that contains odbcsql command" -b "Repository Type"

6. View the output stages that represent the progress of the tasks performed by the utility to ensure that the RRCLeanup utility is run successfully.