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:

  • IBM DB2 Command Line Processor (CLP)

    This utility dynamically executes SQL requests and/or IBM DB2 commands between local and remote databases and can create the database and table spaces.

    Note: There are two methods of using the CLP. One method is prefixing all CLP commands with db2. The second method is using the CLP in interactive mode by typing db2 and pressing Enter. In the interactive mode, type CLP commands without prefixing them with db2. However, the interactive mode does not allow you to do piping or other operating system functions at the CLP command, nor does it allow you to recall commands.

  • IBM DB2 Control Center

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 database, user, or group name. The first character of user IDs must be A-Z, #(X'7B'), $ (X'5B'), or @ (X'7C').

    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

    1252
    Code set

    IBM-1252
    Sort order

    Binary (identity)

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