Creating Versioned Search Tables

If you plan to use the ATG Search add-on features (Search Merchandising and Faceted Search) with ATG Merchandising, perform the following steps to install the necessary database tables.

  1. To create tables that provide versioning support to ATG Search Integration, run the versioned_refinement_ddl.sql script located in the following directory:

    <ATG9dir>/DAF/Search/Versioned/sql/db_components/database-vendor

    To create the tables on an SOLID evaluation database, open a command prompt and enter the following command, which includes the default arguments for a SOLID database:

    <ATG9dir>DAS\solid\i486-unknown-win32\solsql.exe "tcp 1313"
    publishing publishing <ATG9dir>\DAF\Search\Versioned\sql
    \db_components\solid\versioned_refinement_ddl.sql

    where <ATG9dir> is the path to your ATG 9.3 directory, 1313 is the port for your SOLID database, and publishing is the username and password used for the ATG Merchandising table space on SOLID.

  2. To create database tables that support the combination of ATG Merchandising, ATG Commerce and the add-on ATG Search features, run the dcs_search_versioned_ddl.sql script located in the following directory:

    <ATG9dir>/DCS/Search/Versioned/sql/install/database-vendor

    To install the tables on an SOLID evaluation database, open a command prompt and enter the following command, which includes the default arguments for a SOLID database:

    <ATG9dir>DAS\solid\i486-unknown-win32\solsql.exe "tcp 1313"
    publishing publishing <ATG9dir>\DCS\Search\Versioned\sql\install\
    solid\dcs_search_versioned_ddl.sql

    where <ATG9dir> is the path to your ATG 9.3 directory, 1313 is the port for your SOLID database, and publishing is the username and password used for the ATG Merchandising table space on SOLID.

 
loading table of contents...