| # Informix Dynamic Server Before you install the ERP LN software, first install the Informix software. To install the Informix software, use the Informix Installation Manuals. Hard and softwareRequirements Various hardware configurations can install ERP LN with Informix Dynamic Server. To find the correct hardware equipment a request for sizing can be applied for at Infor. Undersized hardware can cause serious problems while working with the ERP LN software. Following IBM software is required to install ERP LN 6.1 : IBM INFORMIX IConnect. IBM INFORMIX Dynamic Server. IBM INFORMIX Server Administrator (ISA). All OS patches required by Informix must be installed. Information about required patches can be found in Informix machine notes. Nomenclature Several Informix products exist. The official name of the Informix product that ERP LN supports is the Informix Dynamic Server. Throughout this chapter, Informix Dynamic Server is called Informix. Disk space assignment For good performance you need a good hard disk layout. A database such as Informix Dynamic Server will perform a lot of disk activities. It is useful if work can be distributed to several hard disks. After disk space is once allocated for the database, undoing the allocations can be very time-consuming. Factors such as disk capacity, number of concurrent users, and number of companies are important for your plan. The following table shows guidelines which are appropriate: for an average ERP LN installation:
dbspace | Disk space | Description
rootdbs | 100 MB | The space used internal by Informix Dynamic server; the size depends on the number of companies and the size of the tables.
bsi_phy | 300 MB | Stores the physical log..
bsi_log | 300 MB | Space to store the logical log.
bsi_tmp | 300 MB | Used for sorting data.
bsi_dbs | 2 GB | The space used for table data. The size depends on the number of companies and the amount of data that must be stored.
bsi_idx | 2 GB | This dbspace is used for indexes. The size depends on the number of companies and the amount of data that must be stored.
A minimum of two disks must be available for the Informix database, in which case the division can be as follows:
Disk 1 | Disk 2
rootdbs | bsi_phy
bsi_log | bsi_dbs
| bsi_idx
| bsi_tmp
With three disks, the dbspaces can be divided as follows:
Recommended dbspace configuration for three disks
Disk 1 | Disk 2 | Disk 3
rootdbs | bsi_tmp | bsi_dbs
bsi_phy | bsi_log | bsi_idx
Ideally, data and indexes can be divided over as many disks as possible. With 4 disks, the dbspaces can be divided as follows:
Disk 1 | Disk 2 | Disk 3 | Disk 4
rootdbs | bsi_tmp | bsi_dbs | bsi_idx
bsi_phy | bsi_log |  |
CLIENT_LOCALE -> Define the client locale. DB_LOCALE -> Define the database locale. NLS_LANG -> Define the NLS language. Installation process overview Informix installations are version and system-dependent. Check your Informix documentation for the installation procedure for the Informix version that you want to install. You must install the following three products: INFORMIX Dynamic Server INFORMIX IConnect. INFORMIX Server Administrator (ISA) Informix Dynamic Server installation Informix Dynamic Server installations are version and system-dependant. To install these, refer to the Informix Dynamic Server Installation Guide. You do not need to configure a server instance for ERP LN usage yet. It is recommended you first create a default setup with 100 MByte root dbspace. This way the Informix Dynamic Server installation can be tested before ERP LN will be installed. The procedure to setup Informix server for ERP LN usage will be described later. At this stage the user must go ahead with I-Connect and Server Administrator installation. Informix I-Connect installation For the specific installation procedure, refer to the Informix I-Connect Installation Guide . Informix Server Administrator (ISA) installation For the specific installation procedure, refer to the Informix Server Administrator Installation Guide. After installation, the user must be able to connect Informix Server Administrator through internet browser. Login and add the local Informix server to the server-selection page. After the Informix server is added, select this Informix Server and run the following tests: Is it possible change server mode to online/offline? Is it possible to create a new dbspace? Before you continue with the ERP LN installation, ensure the Informix server is online. Informix Server Setup for ERP LN usage A new Informix Server instance for ERP LN usage must be created. The required configuration depends on how the ERP LN database will be created. There are two different ways to create an ERP LN database. Automatic database setup Manual database setup The automatic database setup method requires minimal manual Informix instance configuration. A running instance with 100 MB root dbspace is required. If the automatic database setup method is used the Installation Wizard will run the following: changes settings in onconfig file creates new dbspaces creates logical logs Detailed information about automatic database setup and Informix instance reconfiguration can be found in the Informix Appendix in this document. If the manual database setup method is chosen the user is responsible for the Informix server instance configuration and database creation. The user must ensure all required prerequisites as described in the Informix Appendix are followed. The manual configuration is more flexible; however the user must have sufficient knowledge. Note The Installation Wizard will not perform any automatic database server reconfiguration if the ERP LN database is found in its database server. Informix Server Administrator configuration The Installation Wizard requires that the newly created Informix server is listed in Informix Server Administrator. Add the new created Informix Server to the selection-page. After the server is added you must test if the mode can be changed to online/offline. Before continue with the ERP LN installation, ensure the Informix server is online. Informix IDS 10 Before you install ERP LN, extend the value of SHMADD in your onconfig file to the following:
    SHMADD 32768 # Size of new shared mem. segments (Kbytes)
If you use the standard value (8192), you can reach the maximum number of shared memory segments. As a restult, the database stops responding. If all the required Informix software is installed and configured, you are ready to start the Staging Wizard. For more information, refer to the Overall installation Guide for Infor ERP LN Products (U9498 US). |