Jump to: navigation, search

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.

Retrieved from "https://docs.genesys.com/Documentation:FR:Dep:DepLogDB:8.5.0 (2019-08-20 07:45:41)"
This page was last modified on May 20, 2014, at 12:41.

Feedback

Comment on this article:

blog comments powered by Disqus