Required Database Components and Settings

Relational Database Versions

Supported database versions 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.

Additional Required Database Products

When installing IBM DB2 products, you are given a list of products and features from which to choose. While the Lawson run-time system does not require that you install additional products, the following are needed for installation, set up, 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

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 IBMDB2 Security Administrator's Guide.

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

    Code page

    819

    Note: When connecting to DB2/390 from a Unix or Windows system, if the CODEPAGE setting in the DB2/390 ZPARMS does not exactly match the code page that is being used by the client, there is additional overhead due to code page conversion. See the documentation from the operating system vendor to determine the appropriate code page setting.
    Code set

    ISO8859-1
    Sort order

    Binary (identity)

    Note: 

    An error occurs if the CCSID in DSNZPARM is not equal to 819. To fix the error, set the code page to 819 by typing the following command:

    db2 update admin cfg das_codepage 819

  • Lawson does not support the UTF8 character set.