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

[informix@python ~] $cat .bash _ profile

PATH=$PATH:$HOME/bin

Export PATH

Export INFORMIXDIR=/opt/informix

Export INFORMIXSQLHOSTS=/opt/informix/etc/sqlhosts

Export ONCONFIG=onconfig.tramsserver

Export INFORMIXSERVER=testdb

Export PATH=$INFORMIXDIR/bin:.:$PATH

Informix profile

Cd $INFORMIXDIR/etc

Onconfig---- database parameter file

Sqlhosts / etc/services

Sqlhosts

# demo_on onipcshm on_hostname on_servername

Testdb onipcshm 192.168.12.128 7001

Testdb_net onsoctcp 192.168.12.128 7002

First column: database name and alias

Second column: agreement

Third column: machine name

Fourth column: Port

Tail / etc/services

Testdb 7001/tcp

Testdb_net 7002/tcp

Export INFORMIXDIR=/opt/informix

Export INFORMIXSQLHOSTS=/opt/informix/etc/sqlhosts

Export ONCONFIG=onconfig.tramsserver (same name under etc file)

Export INFORMIXSERVER=testdb (associated under sqlhosts, / etc/services)

(a) ROOTDBS configuration parameters (the items to be modified below are shown in bold italic red font)

ROOTPATH / dev/dbs/rrootdbs

ROOTOFFSIZE 40

ROOTSIZE 400000

(B) physical log parameters

PHYSFILE 50000

(C) logical log parameters

LOGFILES 3

LOGSIZE 10000

(d) diagnostic parameters

MSGPATH / opt/informix/online.log

Path where the Informix log file is located

ALARMPROGRAM / opt/informix/etc/log_full.sh

System alarm program path

TAPEDEV / dev/null

Database backup path

LTAPEDEV / dev/null

Logical log backup path

DBSERVERNAME db_online

Database SERVER name

DBSERVERALIASES db_online_net

Database SERVER alias

LOGSMAX 10

Maximum number of logical logs

(e) TEMP data space

DBSPACETEMP initial value is empty

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

DBSPACETEMP tempdbs

And restart the database Server. When configuring multiple tempdbs, separate them with commas.

(F) other

Change the path of other configuration items in the configuration file to / usr/informix/... All changed to / opt/informix/..., but the path in the comment does not need to be modified.

After the modification is completed, the save disk exits.

[informix@aaa ~ / etc] $cp sqlhosts.std sqlhosts

[informix@aaa ~ / etc] $vi sqlhosts

After commenting out the examples in the first two lines of the file, add the following two lines:

Db_online onipcshm 192.168.12.128 7002

Db_online_net onsoctcp 192.168.12.128 7001

Description:

(a) name of dbservername informix Server:

Must correspond to DBSERVERNAME and DBSERVERNAMEALIAS in the environment variables INFORMIXSERVER and onconfig files.

(B) connection mode:

Onipcshm means to connect to shared memory through the IPC (Internal process Control) mechanism, which is generally used on servers.

Onsoctcp means to connect through the network and uses the TCP/IP protocol, which is generally used on the client side.

(C) hostname hostname (usually ip)

Must correspond to the definition of the hostname in the / etc/hosts file.

(d) servicename service name (write port)

Must correspond to the servicename in / etc/services.

Edit the / etc/services file as root

[root@aaa root] # vi / etc/services add at the end of the file:

Testdb 7001/tcp

Testdb_net 7002/tcp

And save the exit. The 9001 and 9002 port numbers must be unique, that is, 7001 and 7002 port numbers are no longer allowed in this file.

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.