In case there is a requirement to remove all the coding and development done on an existing TDV  (TIBCO Data Virtualization) instance and revert it to the state of a new fresh installation, please follow the  steps below. The steps are for a Clustered environment.

Note: This will remove all the work done in TDV, making it a fresh installation.

Steps to re-create Schema

1. Take the node out of the cluster.

2. Create a full server backup as a preventive measure.

3. Stop only the TDV server,  do not stop the repository.

4. Drop the schema as follows:

(a) List out all files under the directory
         <TDV_INSTALL>\conf\repository\postgresql
     that begin with the word 'composite_clean'.

Example
--------
cd D:\TIBCO_DV\conf\repository\postgresql
dir composite_clean*
--------

(b) If the list contains files named composite_clean-nnnnnnnnn.sql ('nnnnnnnnn' represents a version number), run repo_util.bat with the arguments:
     -dropSchema -schemaDropScript <highest versioned file>

For instance if the list is:

•      composite_clean-080200001.sql
•      composite_clean-080401001.sql
•      composite_clean.sql

     
Then composite_clean-080401001.sql is the highest versioned file, and the command is:

--------
D:\TIBCO_DV\bin>repo_util.bat -dropSchema -schemaDropScript              D:\TIBCO_DV\conf\repository\postgresql\composite_clean-080401001.sql
--------

(c) If the list does not contain any versioned files (i.e. only composite_clean.sql is present), the schemaDropScript argument is not required:

--------
D:\TIBCO_DV\bin>repo_util.bat -dropSchema  
--------

5. Start the TDV server and wait till a "Ready" message appears in cs_server.log (it may take several minutes for the message to appear ):    

Example
--------
INFO [main] 2022-04-05 14:52:33.908 -0700 CompositeServer - Ready
--------

6. Now the TDV instance will look like a fresh installation.

7. Add the node back to primary node.