DB2 Universal Database

This chapter describes in highlights how to prepare the DB2 software for a ERP LN installation. To install the DB2 software, use the DB2 installation Manuals.

Overview of the installation process

DB2 installations are version-dependant and system-dependent. Ensure you check your DB2 documentation for the DB2 version you want to install.

On the DB2 UDB medium, the autorun feature automatically starts the set-up program. This program determines the system language and launches the setup program for it.

The user interface for the db2setup script is a series of windows in which you are asked to enter information. Respond to the installation prompts. Online Help is available to walk you through the installation steps. To start the online Help, click Help. To end the installation, click Cancel.

Note

If a DB2 product is already installed on the workstation, you must install the product on the same drive and in the same directory.

DB2 setup creates user name for installation

During the installation of DB2, you must provide a user name and password that the administration server can use to log on to the system and start itself as a service.

By default, the set-up program fills the User Name, Password, and Confirm Password fields with db2admin. You can accept these default values or provide your own. If you provide your own user name, ensure it is eight characters or less in length and complies with DB2’s naming rules. The user name will be removed from the system when the installation is complete, unless the administration server uses the user name.

If the user name does not exist, the set-up program creates the user name specified for the administration server. The set-up program will do the following:

  • Verify if the user name is a member of the administrators group.
  • Verify if the password is valid.
  • Check if the user name used to install DB2 has the Act as Part of the Operating System advanced user right.
Note

If you use the default user name db2admin, and did not change the default password for this user name, you must change this password immediately after the installation.

To install DB2 Universal Database FixPak

You can download the latest DB2 FixPak directly from DB2’s Service and Support Web page. Alternatively, order the FixPak directly from IBM support.

To install a DB2 FixPak, first verify all software requirements for this FixPak have been met. In addition, verify your current DB2 installed version is suitable for the Infor ERP software. Follow the instructions in the Fixpak.readme file, which is available with the FixPak for platform-specific FixPak install procedure.

db2cli.ini file

Before you start the ERP installation, edit the Db2cli.ini file. You can find the db2cli.ini file in the sqllib directory %INSTANCEHOME%/sqllib.

Add the following entry under the common section of the .ini file

[common]

MultiConnect=3

IgnoreWarnings=1

CloseOpen=1

UseLightOutputSQLDA=1

Specific ERP LN installation note

During the installation of ERP LN, the installation wizard presents several dialog boxes of Database Device Locations and Sizes with Database Data Files configuration. This represents the tablespace which will contain the actual data.

Specify the Directory and File Names for the following files:

  • Database Data Files.
  • Database Index Files.
  • Database Temporary Files.

There are two options to store your data on the file system:

  1. SMS tablespace: Automatically increases in size in case more data must be stored.
  2. DMS tablespace: Size is fixed; the database administrator needs to increase the size in case more space is needed. DMS offers the highest performance.

For more information, refer to the online help of the installation wizard.

If all the required DB2 software is installed and configured, you can start the Staging Wizard. For more information, refer to the Overall installation Guide for Infor ERP LN Products (U9498 US).