Required database components and settings

Relational database versions

Supported versions for your relational database are documented in the installation guide for your Infor Lawson System Foundation product and platform.

Operating system for the database client

The database interface layer utilizes third-party database client software to access data from the relational database server. The database client and server may run on different operating systems, utilizing connection software provided by the third-party database vendor. Lawson supports any configuration that the third-party relational database vendor certifies and supports between their database client and server. However, to be supported, the client software must be running on an operating system version that supports Lawson software products.

Required database products

When installing IBM DB2 products, you are given a list of products and features from which to choose. While the Lawson runtime system does not require that you install additional products, the following are needed for installation, setup, or performance analysis of the Lawson database:

  • Most SQL commands described in this document can be run from the Operations Navigator, or from another SQL tool such as STRSQL. The Operations Navigator is part of Client Access Express, provided with your IBM i system. STRSQL is part of the additional purchased IBM product 5722ST1.

Data at Rest Encryption Support

Lawson supports data at rest encryption for a variety of database and platform versions. For details, see the installation guide and release notes for your Infor Lawson System Foundation product and platform.

The IBM Database Encryption Expert is required to implement Data at Rest Encryption of tables. You can find out more about this component at http://www-306.ibm.com/software/data/db2imstools/database-encryption-expert/. You must create the encrypted table spaces before you install Lawson products.

The IBM Database Encryption Expert server, version 1.1.1, requires a dedicated server (32-bit Red Hat Linux, Update 4). The IBM Database Encryption Expert database agent is platform independent, but must be able to communicate with the IBM Database Encryption Expert server.

See Encryption of Data at Rest.

Required Database Settings

  • User and Group Naming Conventions

    IBM DB2 requires a maximum of eight characters in a user or group name. The first character of user IDs must be A-Z, #, or @.

    For more information on user naming conventions, see the IBM DB2 Security Administrator's Guide.

  • The following settings are required for required for Lawson internet applications data processing:

    Code page

    37
    Code set

    IBM037
    Sort order

    Binary

  • Lawson does not support the UTF-8 character set.