Centralized Log Database

Initializing the Log Database

Important

• Message Server can only write logs to a PostgreSQL DBMS if the corresponding DB Server also supports PostgreSQL.
• If you are using the Oracle DBMS, Genesys strongly recommends that you use the SQL Plus command line utility initializing the Log Database.
• If you are setting up the Log Database for use in a multi-language environment, refer to the Framework Database Connectivity Reference Guide for additional information.

Prerequisites

• A DBMS is installed, and a blank database has been created.
• Message Server is installed and running.

Start of procedure

1. In your DBMS interface, go to the directory in which Message Server is installed and open the scripts folder.
2. Open the folder that matches your database type.
3. Load and execute the script that corresponds to your DBMS, as provided in the following table.

   DBMS	Script Name	Multi-language Script Name a
   DB2	init_db2.sql	init_multilang_db2.sql
   Microsoft SQL	init_mssql.sql	init_multilang_mssql.sql b
   Oracle	init_oracle.sql	init_multilang_oracle.sql
   PostgreSQL	init_postgre.sql	Not required
   Notes: a. Use the multi-language scripts if you are setting up your Centralized Log system in multi-language mode. b. A multi-language MS SQL database uses UCS-2 encoding instead of UTF-8 encoding. You must set utf8-ucs2=true in the dbclient section in the annex of the corresponding Database Access Point. Refer to the ''Framework Configuration Options Reference Manual'' for more information about this option.

4. Save the initialized database.

DBMS Adjustment

You must install and configure an SQL Server client for your database type. Refer to the Framework Database Connectivity Reference Guide for recommended environment settings for your database client.