Installation configuration of the Informix database under SuSE Linux 11

Informix is a family of relational database management systems (RDBMS) from IBM. Now fewer and fewer people are using it, major operators are still useful, work needs, still have to learn about installation.

system:

SUSE Linux Enterprise Server 11 (x86_64)



First, installation

1. Create informix group and user as root user, assuming the home directory of informix user is / opt / informix

# groupadd informix

# useradd -g informix -d / opt / informix -m -s / bin / csh informix

# passwd informix





2. As the informix user, create a .cshrc file in the / opt / informix directory, write the following content, and set environment variables

# su-informix

% vi .cshrc

setenv INFORMIXDIR / opt / informix #informix user home directory

setenv INFORMIXSERVER votle_smp1_online_net #server name

setenv ONCONFIG onconfig #another configuration file name

setenv PATH $ {PATH}: $ {INFORMIXDIR} / bin

After saving and exiting, execute:

% source .cshrc



3. As the root user (the same below), set the environment variables required to install IDS, and install IDS software

% exit

# INFORMIXDIR = / opt / informix

# export INFORMIXDIR



Decompress the database software and execute ./ids_install





At this point, the installation of Informix Dynamic Server has been completed.





Configuration

1. Setting of related environment variables

After Informix Dynamic Server is installed, it must be configured to run. Configuration refers to setting specific parameters for the operating environment of the database server. Configuration is mainly done by modifying files and setting environment variables.

This step is already configured during installation.



2. The establishment of raw equipment required by the database

There are two ways to store the data of the Informix database: the file system method and the raw disk method. Due to conditions, the file system method is adopted. To facilitate understanding and use, plan the original device file names used by each dbspace And the database space is as follows:


Raw device file Data space name Data space size

/ home / dbs / rrootdbs rootdbs 30M

/ home / dbs / rphydbs phydbs 51M (with 50M physical log)

/ home / dbs / rlogdbs logdbs 51M (with 10 logical logs, each 5M)

/ home / dbs / rtempdbs tempdbs 10M

/ home / dbs / rworkdbs1 workdbs 60M

/ home / dbs / rworkdbs 240M



a) Create a device file as the root user and modify the device file attributes:

mkdir / home / dbs

cd / home / dbs

touch rrootdbs

touch rlogdbs

touch rphydbs

touch rtempdbs

touch rworkdbs1

touch rworkdbs2

chown -R informix: informix / home / dbs

b) Empower devices (informix users and their group users need at least read and write permissions to these device files)

chmod 775 / home / dbs

chmod 661 / home / dbs / * dbs *



Edit the $ INFORMIXDIR / etc / onconfig file as the informix user. The name of onconfig is specified by .cshrc, which defines the core parameters of Informix Dynamic Server

#su-informix

> cd etc

> cp onconfig.std onconfig

> vi onconfig

i.ROOTDBS configuration parameters (the items to be modified below are indicated in bold italics)

ROOTPATH / home / dbs / rrootdbs

ROOTOFFSET40

ROOTSIZE30000

ii. Physical log parameters

PHYSFILE2000

iii. (c) Logical log parameters

LOGFILES3

LOGSIZE5000

iv. Diagnostic parameters

MSGPATH / opt / informix / online.log

Informix Dynamic Server log file path

v. Backup parameters

TAPEDEV / dev / null

Database backup path

LTAPEDEV / dev / null

Logical log backup path

vi. System configuration parameters

DBSERVERNAME votle_smp1_online

Database server instance name

DBSERVERALIASESvotle_smp1_online_net

Database server instance alias

vii. Shared memory parameters

LOCKS5000

Number of lock resources

LOGSMAX10

Maximum number of logical logs

viii. Temporary data space

DBSPACETEMP initial value is empty

Temporary data space. Note that its initial value is empty. After the database initialization is completed and rootdbs, workdbs, logdbs, phydbs, tempdbs are successfully established (note that their attributes are temporary data spaces), modify this parameter to:

DBSPACETEMP tempdbs



Edit $ INFORMIXDIR / etc / sqlhost file as informix user

> vi etc / sqlhost

votle_smp1_online onipcshm VOTLE-SMP1 sqlexec

votle_smp1_online_net onsoctcp VOTLE-SMP1 sqlexec_net




Its parameter format is as follows:

<dbservername> <nettype> <hostname> <servicename>

dbservername: the name of Informix Dynamic Server

Must correspond to DBSERVERNAME and DBSERVERALIASES in the environment variable INFORMIXSERVER and onconfig files.

nettype: connection method

onipcshm indicates that it is connected to shared memory through the IPC (Internal Process Control) mechanism, and is generally used for servers;

onsoctcp indicates that it is connected through the network and uses the TCP / IP protocol, which is generally used for clients.

hostname: host name

It must correspond to the definition of the host name in the / etc / hosts file.

servicename: service name

Must correspond to servicename in / etc / services.



Edit the / etc / services file as root

# vi / etc / services

Add at the end of the file:

sqlexec 9003 / tcp

sqlexec_net 9004 / tcp

And save and exit. The 9003 and 9004 port numbers must be unique, that is, the 9003 and 9004 port numbers are not allowed in this file.



 Login as informix user and start Informix Dynamic Server for the first time

# su-informix

> oninit -ivy



At this point, the informix database is installed.