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
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 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 Table spaces and schemas are used to determine the library that objects resolve to on the IBM i machine. These are the same libraries that you will CREATE COLLECTION for.	The data and index table space names for each product line.