To create the database tables for the Oracle ATG Web Commerce Adaptive Scenario Engine, run the SQL scripts provided for the DAS, DPS, and DSS modules, as described in the following sections.
Oracle ATG Web Commerce Portal Note: The table creation scripts for Oracle ATG Web Commerce Portal also create the tables for the Oracle ATG Web Commerce Adaptive Scenario Engine; you do not need to create the DAS, DPS, and DSS tables separately. See Creating Database Tables for ATG Portal for details.
Creating the DAS Tables
To create the database tables in the DAS module, run the das_ddl.sql
script from the following directory:
<ATG11dir>/DAS/sql/install/database-vendor
The 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:
<ATG11dir>/DAS/sql/db_components/
database-vendor
Script Name | Purpose |
---|---|
| Creates tables for event-listener registrations for distributed caching mode in the GSA |
| Creates a table for the switching data source service |
| Creates tables for the Dynamo Message System |
| Creates the Dynamo Staff Repository for the GSA |
| Creates tables to store delayed JMS messages |
| Creates a table for managing ID spaces |
| Creates a table for storing caching information from the integration repository |
| Creates tables for Nucleus security data |
Creating the DPS Tables
To create the database tables for DPS, run the dps_ddl.sql
script from the following directory:
<ATG11dir>/DPS/sql/install/database-vendor
The 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:
<ATG11dir>/DPS/sql/db_components/
database-vendor
Script Name | Purpose |
---|---|
| Creates tables for the logging and reporting subsystem |
| Initializes the logging and reporting tables |
| Creates tables for the DPS schema |
Creating the DSS Tables
To create the database tables for DSS, run the dss_ddl.sql
script from the following directory:
<ATG11dir>/DSS/sql/install/database-vendor
The 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:
<ATG11dir>/DSS/sql/db_components/
database-vendor
Script Name | Purpose |
---|---|
| Creates tables used by sample mappers to record Oracle ATG Web Commerce startup and shutdown events |
| Creates tables used by sample mappers to record DPS events |
| Creates tables used by sample mappers to record DSS audit trail events |
| Creates tables for the DSS Scenario Engine |