Informix Database Configuration Detailed explanation

1. Configuration Overview

The database configuration will be configured by database system, database log and database application system data to achieve the goal of database system optimization.

2. Example of marketing System database configuration

2.1 Planning Database Space

According to the idea of configuration, the database system is divided into three districts. respectively:

Rootdbs:informix system Area, we assign a E1_1DBS4 to it, in order to facilitate memory we will take the area named Yxroot.

The specific actions are:

#ln/dev/re1_1dbs4/dev/yx_root
#chowninformix:informix/dev/yx_root
#chmod664/dev/yx_root

Logdbs:informix Log area, we assign a number of E1_1DBS5 to it, in order to facilitate memory we will take the area of the individual named Yx_log.

The specific actions are:

#ln/dev/re1_1dbs5/dev/yx_loG
#chowninformix:informix/dev/yx_loG
#chmod664/dev/yx_log

Workdbs:informix data area, we assign the e1_1dbs0 of the first number to E1_1DBS3 to it, for the sake of memory, we will take the area individually named Yx_work.

The specific actions are:

#ln/dev/re1_1dbs0/dev/yx_dbs0
#ln/dev/re1_1dbs1/dev/yx_dbs1
#chowninformix:informix/dev/yx_dbs?
#chmod664/dev/yx_dbs?