Uninstalling Redwood Server

on-site-related topic

When you want to remove Redwood Server from your systems, you must know on which systems you installed the central Redwood Server as well as the Platform Agents, if applicable.

Central Redwood Server

You can use a simple select statement to generate a script for this, or ask Redwood Software Services for a specific jsp to do the work for you. The below examples are provided for your convenience, beware that incorrectly using these queries could result in data-loss.

Example script for Oracle

Copy
SELECT 'DROP TABLE <schema_name>.' || table_name || ';' FROM sys.all_tables
WHERE table_name like 'JCS_%' and owner = '<schema_name>';

Example for DB2

Copy
SELECT 'DROP TABLE <schema_name>.' || TABNAME || ';' FROM SYSCAT.TABLES
WHERE TABNAME like 'JCS_%' and TABSCHEMA = '<schema_name>';

Example script for SQL Server

Copy
SELECT 'DROP TABLE <database>.<schema_name>.' + name + ';' FROM sys.sysobjects
WHERE name like 'JCS_%';

Variable Description
<schema_name> The name of the schema/owner of the table
<database> For SQL Server only! The name of the database. Required if you do not use the USE <database> clause at the beginning of your script.

Note: Do not forget the commit or go keyword.

Note: Review the generated script to make sure only Redwood Server tables are removed, in the unlikely event that you have tables in that schema with a name starting with JCS_, you need to remove your tables from the script or they will be dropped.

Note: Redwood strongly recommended using a separate database schema/user for the Redwood Server tables.

Uninstalling Platform Agents

When you decide to uninstall Redwood Server Platform Agents from a server, you need to first remove the services from the server and then remove the software as such. On UNIX systems, additional steps may be necessary depending on the user switching mode chosen.

For instructions on how to remove Redwood Server please refer to the following sections: