| # Informix Dynamic Server Before you install the 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 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 LN software. Following IBM software is required to install ERP LN 6.1 : IBM INFORMIX IConnect. IBM INFORMIX Dynamic Server. 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 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 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 | 4 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 | 4 GB | This dbspace is used for indexes. The size depends on the number of companies and the amount of data that must be stored.
bsi_sbs | 4 GB | This space is used for Smart BLOB objects.
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
| bsi_sbs
With three disks, the dbspaces can be divided as follows:
Disk 1 | Disk 2 | Disk 3
rootdbs | bsi_tmp | bsi_dbs
bsi_phy | bsi_log | bsi_idx
| bsi_sbs |
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 |  |
| bsi_sbs |  |
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 products: INFORMIX Dynamic Server INFORMIX IConnect. Informix Dynamic Server installation Informix Dynamic Server installations are version and system-dependant. To install these, refer to the Informix Dynamic Server Installation Guide. At this stage it is necessary to create a server instance by means of a default setup with 100 MByte of root dbspace. The procedure to setup Informix server for LN usage will be described later. At this stage the user must go ahead with I-Connect installation. Informix I-Connect installation For the specific installation procedure, refer to the Informix I-Connect Installation Guide . Informix Server Setup for ERP LN usage A new Informix Server instance for LN usage must be created. The required configuration depends on how the LN database will be created. There are two different ways to create an 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. 注意 The Installation Wizard will not perform any automatic database server reconfiguration if the LN database is found in its database server. Informix IDS 11.5 Before you install LN, extend the SHMADD, LOCKS and FILLFACTOR values 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 result, the database stops responding. LOCKS must have a minimum of 50000 and the FILLFACTOR must be set on 60. After the installation of LN the DBSPACETEMP and the SBSPACETEMP must be set to bsi_tmp. 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 LN Products (U9498 US). |