Database Preinstallation Tasks

Your databases are configured by the installation programs, based on answers you gave during installation. Before you install the IBM DB2 database, Infor Lawson System Foundation, or Lawson applications, perform the following tasks and collect the information shown in this section.

Perform this task Collect this information

Add environment variables and required values to the %PATH% variable.

The choices you see in the installation program depend on what the installation program detects in the %PATH% variable on the Lawson server machine.

  1. Define an environment variable for the %DB2HOME% directory.

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

For information and instructions, see the documentation provided with the database and/or the operating system.

The installation location of the GEN, LOGAN, and application databases.

The %DB2HOME% directory path for each instance.

Determine the initial number of simultaneous database connections

The installation program asks for the number of simultaneous database connections that you allow. A database connection is one driver job, or one open data area for each running program.

The default value is 500; you may need to increase this value significantly. Use this value to calculate the starting values of the USERS, FOREIGN, and IFILES parameters in the Lawson ladb.cfg file. Individually tune these values as required after installation.

The number of simultaneous database connections.

Determine the local alias for the DB2 database

or

Determine the name of the database on the DB2 database server

The DB2 client must be installed and configured to connect to the DB2 server. This value is the alias name as cataloged on the local system.

 The local alias or the name for the DB2 database

Determine database user name (ID) and password

  • The login name (user name) and password for the database user who accesses Lawson data at run-time.

    These values are mapped to the LOGINNAME and PASSWORD parameters in the IBM database driver configuration file.

 The login name and password for the database user.

Determine the schema to use when creating tables

Use the schema name to keep the data for this Lawson data set separate from any other data stored in the database. All tables are created with this name as the table owner.

Use a unique schema name for each Lawson data area. Lawson recommends that you use the format EnvironmentName_DataAreaName; for example, 100TEST_GEN and 100TEST_LOGAN. The schema name cannot exceed 18 characters in length.

 The schema (owner) for tables.

Determine how to configure and name IBM DB2 table spaces

The data and index table space names for each product line.