Set up the RDBMS

Lawson has the following setup requirements for all supported databases.

  1. Install the database client software on the Lawson server machine.
  2. Establish a database user and password.
  3. Create the database, observing the following guidelines:
    Database Guidelines
    Oracle

    The installation program will prompt for the TNS name or the SID. If you set up a SID, the SID name must not exceed 20 characters.

    Lawson does not support the UTF-8 character set.

    The client server character set must match that of the operating system where the client server runs.

    For more information, see Oracle's NLS_LANG FAQ at http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm.

    The Oracle database must be created with the following character set:

    NLS_CHARACTERSET= WE8MSWIN1252

    If Oracle is on a remote server, set the NLS_LANG variable on the Lawson server to the following character set: NLS_CHARACTERSET= WE8MSWIN1252

    SQL Server

    The database name must not exceed 20 characters.

    Sort Order Binary Order

    For Arabic language, use ARABIC_BIN collation.

    For all other languages, use Latin1_General_BIN collation.
    DB2

    The local alias name must not exceed 20 characters.

    Code page 1252

    Code set IBM-1252

    Sort order Binary (identity)
  4. Set up tablespaces for tables and indexes for both GEN and LOGAN.
  5. Verify that you can connect to the database before you begin the Lawson installation.
  6. Set an environment variable defining your Database_HOME directory.
    Database Directory
    Oracle ORACLE_HOME\bin
    SQL Server

    SQL Server 2008

    SQLSERVER_HOME\100\Tools\BINN

    DB2

    %DB2HOME% must equal DB2INSTANCE\sqllib (the sqllib subdirectory in the home directory of the DB2 instance owner).

    %DB2INSTANCE% must equal the DB2 database instance name.
  7. Verify that the directory location of the database client command is in the PATH variable on your Lawson server machine.
  8. Add the following database environment variables to the environment variable script.

    Database_HOME

    PATH