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
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:
/ 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
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.