Schema Creation Scripts

The following table describes the scripts that create the ATG Service schemas.

Note: If you have already created production and data warehouse schemas for your installation, use the existing schemas. Do not create new production and data warehouse schemas.

SQL File

Description

create-service-all

Each supported database has its own version of the service-all script in the <ATG10dir>/
Service10.1/Service/install/scripts/
database-vendor directory. This script runs a number of SQL files for the agent’s specific environment. You can use your own database tool to run the various SQL files outlined in the create-service-all script.

This script calls the service_agent_all.sql, the service_production_all.sql and the service_datawarehouse_all.sql files.

service-framework-agent-all

service-agent-all

The service-framework-agent-all script installs the service_framework_agent.sql and service_framework_agent_platform.sql files. The service-agent-all script installs the service_agent.sql file on the agent schema.

create-service-production-all

service-framework-production-all

The create-service-production-all script runs the service_self_service.sql file. the service-framework-production-all script runs the service_production_platform.sql, the svc_framework_shared_ddl.sql, the svc_framework_ticket_ddl.sql, the svc_response_ddl.sql, the unversioned_option_ddl.sql, the unversioned_svc_framework_ddl.sql, the useroption_ddl.sql and the svc_util_ddl.sql files. This script also installs the service-searchadmin.sql file on the production schema.

service-management-all

This adds the svc_user_profile_ddl.sql file to the management and publishing schema and creates Knowledge-specific external profile tables. When preview is enabled on the preview server, /atg/userprofiling/ProfileAdapterRepository is read from the publishing schema. This creates the necessary tables needed for the profile.

create-service-datawarehouse-all.sql

service-framework-datawarehouse-all.sql

(Optional) These SQL script install the service_datawarehouse.sql and service_platform_datawarehouse.sql.

Schema SQL files

The following schemas are installed during the installation process:

Schema

SQL File

Agent

service_framework_agent_all.sql
service_agent_all.sql

Production

service_framework_production_all.sql
service_production_all.sql
searchadmin_admin_ddl.sql
searchadmin_dictionary_ddl.sql
searchadmin_termweights_ddl.sql
searchadmin_queryrules_ddl.sql
searchadmin_tpo_ddl.sql
searchadmin_facet_ddl.sql

Publishing

bizui_all.sql
service_management_all.sql
versioned_refinement_ddl.sql
versioned_search_site_ddl.sql
searchtesting_ddl.sql

Data Warehouse

service_datawarehouse_all.sql
service_framework_datawarehouse_all.sql

Using MSSQL in Multi-Language Sites

Keep the following in mind for multi-language sites:

MSSQL and Performance

To significantly improve performance, set the sendStringParametersAsUnicode parameter in the Microsoft SQL server driver. If using the com.microsoft.jdbc.sqlserver.SQLServerDriver, make sure the data source URL includes sendStringParametersAsUnicode=false.

For example:

jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=admin;
sendStringParametersAsUnicode=false;SelectMethod=cursor
To Edit and Install the ATG Service Schemas

The create-service-all batch/shell script creates the database tables for all of the ATG Service modules, including Search. For more information, refer to Using Search with ATG Service.

Before running the scripts, CIM asks you to provide configuration information for the environment variables for your database. Provide the agent, production, and data warehouse database account name for your environment. Once you have completed the edits, CIM will continue running the create-service-all file.