Informix Basic installation steps-ibm aix environment (similar to sun and HP)

First, of course we need to obtain the installation package of the Informix database. The installation packages are different for different systems. In fact, the basic installation steps are similar.
1. Obtain the installation package of the Informix database and upload it to a directory in the system.
2. Create an Informix group and an Informix user
IBM: Create an Informix user by mkuser or useradd and an Informix group by mkgroup
HP: useradd creates a user and groupadd creates a group
Sun: useradd creates a user and groupadd creates a group.
3. Plan the space of the Informix database. The following space is required for the Informix database to be installed: rootdbs, tempdbs, phydbs, logdbs, and workdbs. Generally, the Informix database is installed in the/opt/Informix directory or/usr/Informix directory.
Use the touch command to create rootdbs, tempdbs, phydbs, logdbs, and workdbs. If the data volume is large, you can create a raw LV separately.
After the preceding settings, the LV or DBs are granted the corresponding permissions.
Chown Informix: Informix * DBS *
Chmod 660 * DBS *
4. Start to install the Informix database.
Copy the installation package to/opt/Informix (assuming that Informix is installed in this directory) and decompress the installation package under Informix.
Edit. cshrc Environment Variables
Setenv informixdir/opt/Informix
Setenv path $ informixdir/bin: $ path
Setenv onconfig
Save and exit. Source. chsrc makes the environment variable take effect.
In the previous environment, run the su command to switch to the root user. Note that the environment variables will not change during the switchover.
#./Installserver (Informix 7.3) or #./ids_install (informix9.4) is automatically installed.
5. modify the configuration file
Modify the following configuration files:/opt/Informix/etc/sqlhosts,/opt/Informix/etc/onconfig/etc/services
The following is a typical example of these files.
/Opt/Informix/etc/sqlhosts File
Hostname_online onipcshm hostname sqlexec
Hostname_online_net onsoctcp hostname sqlexec_net (for IBM and HP)
Hostname_online_net ontlitcp hostname sqlexec_net (with Sun)

/Etc/services file
Sqlexec 9002/tcp
Sqlexec_net 9003/tcp

The/opt/Informix/etc/onconfig file is too long and only key files are pasted. Here we use ibm aix as an example.

# Root dbspace Configuration

Rootname rootdbs # Root dbspace name
Rootpath/dev/rlvrootdbs # path for device containing root dbspace
Rootoffset 40 # offset of root dbspace into device (Kbytes)
Rootsize 256000 # size of root dbspace (Kbytes)

# Disk configuring configuration parameters

Mirror 0 # flushing flag (Yes = 1, no = 0)
Export path # path for device containing mirrored Root
Mirroffset 0 # offset into mirrored device (Kbytes)

# Physical log Configuration

Physdbs phydbs # location (dbspace) of physical log
Physfile 500000 # physical log file size (Kbytes)

# Logical log Configuration

Logfiles 10 # Number of logical log files
Logsize 50000 # logical log size (Kbytes)

# Diagnostics

Msgpath/opt/Informix/online. log # system Message Log File Path
Console/dev/console # system console message path

# To automatically backup logical logs, edit alarmprogram. SH and set
# Backuplogs = y
Alarmprogram/opt/Informix/etc/alarmprogram. Sh # alarm program path
Tblspace_stats 1 # maintain tblspace statistics

# System archive tape device

# Tapedev/dev/null # tape device path
Tapedev/usr/informixdata
Tapeblk 128 # tape block size (Kbytes)
Tapesize 20400000 # maximum amount of data to put on tape (Kbytes)

# Log archive tape device

# Ltapedev/dev/null # log tape device path
Ltapedev/opt/Informix/data/logbackdev
Ltapeblk 64 # log tape block size (Kbytes)
Ltapesize 8192000 # Max amount of data to put on log tape (Kbytes)

# Optical

Stageblob # Informix Dynamic Server Staging Area

# System Configuration

Servernum 1 # unique ID corresponding to a online instance
Dbservername hostname_online # Name of default Database Server
Dbserveraliases hostname_online_net # list of alternate dbservernames
Nettype # configure poll thread (s) for nettype
Deadlock_timeout 60 # Max time to wait of lock in distributed env.
Resident 0 # Forced residency flag (Yes = 1, no = 0)

Multiprocessor 0 #0 for single-processor, 1 for multi-processor
Numcpuvps 1 # Number of user (CPU) VPS
Single_cpu_vp 0 # If non-zero, limit number of CPU VPs to one

Noage 0 # process aging
Aff_sproc 0 # affinity start Processor
Aff_nprocs 0 # affinity Number of processors

# Shared memory Parameters

Lock S 500000 # maximum number of locks
Buffers 50000 # maximum number of shared Buffers
Numaiovps # Number of Io VPS
Physbuff 32 # physical log buffer size (Kbytes)
Logbuff 32 # logical log buffer size (Kbytes)
Cleaners 1 # Number of buffer cleaner processes
Shmbase 0x700000010000000 # shared memory base address
Shm1_size 8000 # initial virtual shared memory segment size
Shmadd 8192 # size of new Shared Memory segments (Kbytes)
Shmtotal 0 # Total shared memory (Kbytes). 0 => Unlimited
Ckptintvl 300 # Check Point interval (in Sec)
LRUs 8 # Number of LRU queues
Lru_max_dirty 2 # LRU percent dirty begin cleaning limit
Lru_min_dirty 1 # LRU percent dirty end cleaning limit
Txtimeout 300 # transaction timeout (in Sec)
Stacksize 64

Mirror 0 # flushing flag (Yes = 1, no = 0)
Export path # path for device containing mirrored Root
Mirroffset 0 # offset into mirrored device (Kbytes)

Different systems have different shmbase values. Be sure to pay attention to them here. Otherwise, an error will be reported during database initialization.
The shmbase parameters vary when Informix 9.4 is installed on three minicomputers.
Solaris: shmbase 0x10a000000l # shared memory base address
AIX: shmbase 0x700000010000000 # shared memory base address
HP-UX: shmbase 0 # shared memory base address

Note that before the database performs oninit-IV, the space of phydbs and logdbs should be rootdbs, and the sum of phydbs and logdbs should be less than the rootdbs space. Otherwise, oninit-IV cannot be initialized.

6. Use oninit-IV to initialize Informix. Normally, the database should be online.
Informix initialization process

% Oninit-IV

This action will initialize IBM Informix dynamic server;
Any existing IBM Informix Dynamic Server databases will not be accessible-
Do you wish to continue (y/n )? Y
Checking group membership to determine Server Run modesucceeded
Reading configuration file'/Opt/Informix/etc/onconfig'... Succeeded
Creating/informixtmp/. infxdirs... succeeded
Creating Infos File"/Opt/Informix/etc/. Infos. mscp_online1"..."/Opt/Informix/etc/. conf. mscp_online1"... Suc
Ceeded
Writing to Infos file... succeeded
Checking config parameters... succeeded
Allocating and attaching to shared memory... succeeded
Creating resident pool 231712 Kbytes... succeeded
Creating buffer pool 3962016 Kbytes... succeeded
Creating buffer pool 37992 Kbytes... succeeded
Initializing rhead structure... succeeded
Initializing ASF... succeeded
Initializing dictionary cache and SPL routine cache... succeeded
Bringing up adm vp... succeeded
Creating VP classes... succeeded
Onlining 6 additional CPU VPs... succeeded
Onlining 2 Io VPs... succeeded
Initialization of encryption... succeeded
Forking main_loop thread... succeeded
Initializing Dr structures... succeeded
Forking 1'Ipcshm'Listener threads... succeeded
Forking 1'Soctcp'Listener threads... succeeded
Starting tracing... succeeded
Initializing 15 flushers... succeeded
Initializing log/checkpoint information... succeeded
Opening primary chunks... succeeded
Opening mirror chunks... succeeded
Initializing dbspaces... succeeded
Validating chunks... succeeded
Creating Database Partition
Initialize async log flusher... succeeded
Forking btree cleaner... succeeded
Initializing dbspacetemp list
% Checking database partition index... succeeded
Checking location of physical log... succeeded
Initializing dataskip structure... succeeded
Checking for temporary tables to drop
Forking onmode_mon thread... succeeded
Verbose output complete: mode = 5

Use onstat-. If the following prompt is displayed, the database Initialization is successful.
IBM Informix Dynamic Server version 9.40.fc2 -- On-line -- up 12 days at 05:44:38 -- 303532 Kbytes

7. Use onspaces to create other data spaces, remove phydbs and logdbs from rootdbs, and use oninit-Vy to restart the database.