Destroying Database Tables for ATG Adaptive Scenario Engine

This section covers the following topics:

Destroying the DAS Tables

To destroy all DAS tables, run the drop_das_ddl.sql script from the following directory:

<ATG9dir>/DAS/sql/install/database-vendor

The drop_das_ddl.sql script is derived from the subscripts listed in the table below. If necessary, you can run these subscripts individually from the following directory:

<ATG9dir>/DAS/sql/uninstall/database-vendor

Script name

Purpose

drop_dms_limbo_ddl.sql

Destroys the tables used to store delayed JMS messages

drop_gsa_subscribers_ddl.sql

Destroys the tables for event-listener registrations for distributed caching mode in the GSA

drop_id_generator.sql

Destroys the table for managing ID spaces

drop_integration_data_ddl.sql

Destroys the table that stores caching information from the integration repository

drop_nucleus_security_ddl.sql

Destroys the tables for Nucleus security data

drop_sds.sql

Destroys the table for the switching data source service

drop_sql_jms_ddl.sql

Destroys the tables for the Dynamo Message System

drop_staff_ddl.sql

Destroys the Dynamo Staff Repository for the GSA

Destroying the DPS Tables

To destroy all DPS tables, run the drop_dps_ddl.sql script from the following directory:

<ATG9dir>/DPS/sql/install/database-vendor

The drop_dps_ddl.sql script is derived from the subscripts listed in the table below. If necessary, you can run these subscripts individually from the following directory:

<ATG9dir>/DPS/sql/uninstall/database-vendor

Script name

Purpose

drop_logging_ddl.sql

Destroys the tables for the logging and reporting subsystem

drop_user_ddl.sql

Destroys the tables for the DPS schema

Destroying the DSS Tables

To destroy all DSS tables, run the drop_dss_ddl.sql script from the following directory:

<ATG9dir>/DSS/sql/install/database-vendor

The drop_dss_ddl.sql script is derived from the subscripts listed in the table below. If necessary, you can run these subscripts individually from the following directory:

<ATG9dir>/DSS/sql/uninstall/database-vendor

Script name

Purpose

drop_das_mappers.sql

Destroys the DAS sample mapper tables

drop_dps_mappers.sql

Destroys the DPS sample mapper tables

drop_dss_mappers.sql

Destroys the DSS sample mapper tables

drop_scenario_ddl.sql

Destroys the DSS Scenario Engine tables

 
loading table of contents...