Shulou(Shulou.com)06/01 Report--

1. Prepare the database before installation

Create informix groups and users

Use root users to create informix groups and informix users, and change passwords

Groupadd informix

Useradd-g informix-d / opt/informix-m informix

Passwd informix

Chmod 755 / opt/informix

Create a database installation directory

Suppose you store the data files of the database in the / dbs directory

Mkdir dbs

Chown informix:informix / dbs

Cd / dbs

Touch rootdbs

Chown informix:informix rootdbs

Chmod 660 rootdbs

Prepare the informix environment variable

Export INFORMIXSERVER=ifxserver

Export INFORMIXDIR=/opt/informix

Export ONCONFIG=onconfig.ifxserver

Export INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts.ifxserver

Export PATH=$INFORMIXDIR/bin:/usr/bin:$ {PATH}:.

Install JDK

2. Database installation

Use root users to execute ids_install files for installation

3. Database initialization

Make a copy of the onconfig.std document in the / opt/informix/etc/ directory, named $ONCONFIG variable specified (onconfig.ifxserver), and edit the following parameters:

ROOTPATH / dbs/rootdbs

DBSERVERNAME ifxserver

Copy the sqlhosts.std document in the / opt/informix/etc/ directory with the name specified by the $INFORMIXSQLHOSTS variable (sqlhosts.ifxserver), and edit it as:

Ifxserver onsoctcp IP port

Initialize the database: oninit-ivy

4. Database configuration

Create dbspace (create operating system files in the / dbs directory and modify the file attribute to 660. the owner is informix:informix)

Touch datadbs1 llogdbs plogdbs

Onspaces-c-d datadbs1-p / dbs/datadbs1-o 0-s 200000-k 8k

Onspaces-c-d plogdbs-p / dbs/plogdbs-o 0-s 2000000

Onspaces-c-d llogdbs-p / dbs/llogdbs-o 0-s 2000000

Add physical and logical logs

Onparams-p-s 1999000-d plogdbs-y

Onparams-a-d llogdbs-s 100000

5. Informix installation is complete

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.