Build an Informix development environment based on Linux platform

The Informix relational database management system is a cross-platform, full-featured RDBMS, transformed into Ordbms, has a variety of features, and can be easily connected to a variety of GUI front-end tools. At present, Informix database products have been widely used in China's financial and insurance industry. Linux is a very popular operating system today, powerful, open source, you can easily build their own personalized network server. Informix Enterprise Database management System Informix on-line Dynamic Server, small and Medium database management system Informix SE, development tools oriented to C language ESQL/C, Rapid development tool 4GL and a range of products can run on the Linux platform. Here's how to build a Linux based small Informix client/server way database development environment.

Software Environment

Linux:redhat Linux 6.0, the other version you can try it on your own. If you are using Slackware, Debian, or other versions of Linux, select the Informix product specifically designed for these editions.

Database: Informix-se 7.24.uc5&& esql/c Bundle on Linux;informix Client 2.50.td1.

Hardware environment

Server: Because the database server needs to handle a large number of data operations, there is a high demand for hardware. We choose the configuration is Pⅲ800mhz processor, 128M of memory, 20G quntum fireball hard disk, Realtek 8139 10/100m Adaptive network card.

Client: Celeron 433MHz processor, 64M memory, 6G Seagate Hard Drive, Realtek 8139 10/100m Adaptive network card.

Network cable and Hub: If you develop a host/character terminal mode information system, you also need to configure multiple user cards and terminals. Multi-user cards can be selected with Startec C9531 or other compatible Linux multi-user cards.

Preparatory work

(1) First build LAN, then install RedHat Linux 6.0 on the server, configure the network (in the following steps we assume the server name is Db_server);

(2) According to the need to choose to install Windows95 or Linux on the client, configure the network;

(3) Ensure that the client and server can ping each other;

(4) Modify the Linux system/etc directory of Hosts files, Windows system \ \ The hosts file in the directory, add the LAN computer IP address and host name information, configure the network communication files;

(5) Configure the HOSTS.EQUIV files in the server-side/etc/directory. The host name in the network contains a domain name, such as "db_server.Informix.net", but is used on the host to represent its own name as "Db_server". If you are unsure, add the names of both formats to the Hosts.equiv file in the/etc/directory.

Install Informix-se Kit

The Informix-se kit includes ESQL/C, Informix-se and I-connect.

(1) Register with "root" user on the server.

(2) Create an Informix group to perform an action:

#groupadd-G 777 Informix (assuming that the Informix group is numbered 777)

(3) Create Informix Users and perform actions:

#useradd-U 777-g informix Informix (set up a user Informix that is subordinate to the Informix group with user number 777)

(4) Creating DBA users, the role of DBA users is primarily to create, maintain, and manage users ' databases. For security reasons, it is best not to treat the DBA user as a member of the Informix group.

(5) Create an installation directory for Informix Products:

#mkdir/usr/informix

#chown Informix.informix/usr/informix

#chmod 755/usr/informix

(6) Setting the environment variable:

#export Informixdir=/usr/informix, and then add $informixdir/bin to the program's search path, and the installer needs to use it to find the files that are needed #export path= $PATH: $ Informixdir/bin.

(7) Install ESQL/C, download the Informix products from the Internet, assume that the files are stored in the/mnt/cdrom directory and perform actions: