Uninstalling Redwood Server

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 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

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

Example for DB2

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

Example script for SQL Server

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:

• 6.3.1 Uninstalling Redwood Server from UNIX
• 6.3.2 Uninstalling Redwood Server from Microsoft Windows

onsiteTopic