| # DB2 Universal Database Before you install ERP LN on a Unix system that uses DB2 as the database server, you must meet several preconditions described in the following sections. In addition, check the DB2 appendix of this manual for extra information about DB2. Requirements A technical consultant is able to determine the system requirements for both ERP LN installation and database as this differs for each company. Check the support matrix of the lnfor Enterprise Server - Technical Notes for the latest Porting Set .This matrix supplies information about the supported Operating systems and RDBMS's. IBM DB2 Universal Database Installation Prerequisites contain the requirements for the database. It describes the minimum for installation and a variable part for each user. If you plan to install DB2 on one server and the ERP LN database driver on another machine (the client), you must meet some minimal disk space requirements. Refer to the DB2 documentation for more information about the disk space requirements for DB2. Disk space ERP LN A minimum of 250 MB for the ERP LN software environment (BSE). A minimum of 1.5Gb (native) or 3Gb (unicode) for the ERP LN database. db2cli.ini file For best results, you must edit the Db2cli.ini file before you start the ERP LN installation. You can find the Db2cli.ini file in the DB2 instance’s home directory:
    $DB2INSTANCEPATH/cfg/db2cli.ini
Add the following entry under the [common] section of the .ini file `[common]` `MultiConnect=3` Overview of the installation process DB2 installations are version and system-dependant. This chapter provides in highlights how to install DB2 UDB for ERP LN. In addition, check your DB2 documentation for the installation procedure for the DB2 version that you want to install. The DB2 UDB version comes with an installation script called db2setup. The user interface for the db2setup script is a series of windows that ask you to enter information The following items provide tips to help you to navigate through the windows: To select an option and continue to enter information in the window, move the cursor to the option with the arrow keys, and press the SPACEBAR to choose the option. To select an option that enables you to customize the settings, move the cursor to the option with the ARROW KEYS and press ENTER. To enable all options in the window, move the cursor to the OK field at the bottom of the window, and press ENTER. To return to the previous window, move the cursor to the Cancel field and press ENTER. Install DB2 Universal Database Install the FixPack after the installation of DB2 UDB. Refer to the support matrix in the technical notes for the latest portingset for specific information. Log on as a user that meets the requirements to install DB2. Shut down any other programs so that the setup program can update files as required. Insert the DB2 UDB medium into the drive. Online help is available to guide you through the remaining steps of the installation. To activate the online Help, click Help. Install DB2 Universal Database fixpack You can download the latest DB2 fixpack directly from DB2’s Service and Support Web page. Alternatively, order the fixpack directly from IBM support. To install a DB2 fixpack, first verify that all the software requirements for this fixpack have been met. In addition, verify your current DB2 installed version is suitable for the Infor ERP software. Refer to the support matrix in the technical notes for the latest porting set. Follow the instructions in the fixpack.readme file, which is available with the fixpack for platform-specific fixpack install procedure. Link DB2 libraries Make sure that you create a symbolic link for the correct version of DB2 libraries under /usr/lib. To create this symbolic link, use the db2ln utility. The db2ln utility creates a symbolic link to /usr/lib/$LIBNAME. Symbolic links to previous versions of DB2 will be removed. You can find db2ln in:
    <DB2INSTALLDIR>/cfg
If links to the /usr/lib directory from previous versions of DB2 exist, these links are automatically replaced with a link to the newer DB2 version if you enter the db2ln command. Please check IBM DB2’s documentation if you want to re-establish a symbolic ink to a previous version of DB2. Let op! You can only establish symbolic links for one version of DB2 on a specific system. Prepare DB2 for ERP LN installation Before you can install ERP LN, you must perform the following tasks: Change the DB2 profile. Add UNIX group accounts for ERP LN. Add UNIX user accounts for ERP LN. Modify the UNIX user account root. Use the remote database option set. These tasks are described in detail in Appendix DB2 of this document. For each of these tasks, you must be logged on as the UNIX user root. bse_vars file During the installation of the ERP LN software, a dialog box appears that enables you to change the bse_vars file. If more versions of DB2 are installed on the same system, you must set a shared library path environment variable. This environment variable enables you to use the correct libraries with the DB2 version you want to use for the ERP LN installation. The environment variable must, if not present, be placed in the bse_vars file. Create an entry for the shared library path environment variable and make this entry point to the path where the DB2 libraries are installed. If a environment variable is already present in the bse_vars file you must add the path where the DB2 libraries reside. Your platform type determines which path is added to the variable. The name of the variable also varies by platform. On AIX `LIBPATH= <DB2INSTALLDIR>/lib` On HP-UX `SHLIB_PATH=<DB2INSTALLDIR>/lib` Other Unix/Linux platforms `LD_LIBRARY_PATH=<DB2INSTALLDIR>/lib` Database Device Locations and sizes with Database Data files During the installation of ERP LN the installation wizard will present the dialog box Database Device Locations and Sizes with Database Data Files configuration. This represents the tablespace which will contain the actual data. There are two options to store your data on the file system: SMS tablespace: Automatically increases in size in case more data must be stored. 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). |