Creating Database Tables for ATG Adaptive Scenario Engine

To create the database tables for the ATG Adaptive Scenario Engine, run the SQL scripts provided for the DAS, DPS, and DSS modules, as described in the following sections.

ATG Portal Note: The table creation scripts for ATG Portal also create the tables for the ATG 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:

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

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

Script name

Purpose

create_gsa_subscribers_ddl.sql

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

create_sds.sql

Creates a table for the switching data source service

create_sql_jms_ddl.sql

Creates tables for the Dynamo Message System

create_staff_ddl.sql

Creates the Dynamo Staff Repository for the GSA

dms_limbo_ddl.sql

Creates tables to store delayed JMS messages

id_generator.sql

Creates a table for managing ID spaces

integration_data_ddl.sql

Creates a table for storing caching information from the integration repository

nucleus_security_ddl.sql

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:

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

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

Script name

Purpose

logging_ddl.sql

Creates tables for the logging and reporting subsystem

logging_init.sql

Initializes the logging and reporting tables

user_ddl.sql

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:

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

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

Script name

Purpose

das_mappers.sql

Creates tables used by sample mappers to record ATG startup and shutdown events

dps_mappers.sql

Creates tables used by sample mappers to record DPS events

dss_mappers.sql

Creates tables used by sample mappers to record DSS audit trail events

scenario_ddl.sql

Creates tables for the DSS Scenario Engine

 
loading table of contents...