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