Linux下安装informix11.5数据库

Linux下安装informix11.5数据库

Linux下安装informix数据库

1.准备安装文件

a)        到IBM官方网站下载informix安装包11.5(IDS11.5)。。

b)        将IDS11.5拷贝到linux系统下。

2.配置Java环境

a)        在linux下安装jdk,安装informix需要用GUI图形安装,必须用root用户安装JDK。

b)        安装完jdk后,设置环境变量。

i.              用root用户修改文件.bash_profile。增加如下代码:

export  JAVA_HOME=/root/jdk 1.6.0_18
export  CLASSPATH=$CLASSPATH/JAVA_HOME/lib/JAVA_HOME/jre/lib
export  PATH=$JAVA_HOME/bin/JAVA_HOME/jre/bin/PATH/HOMR/bin

3.配置informix环境

a)        以root用户新建informix组和informix用户

i.              建立informix组:#groupadd -g 20000 informix

ii.              建立informix用户并设置密码:

#useradd -u 20000 -g 20000 -d  /opt/Informix  -m  Informix

# passwd Informix

# Changing password for user informix.

New password:                   //输入informix

BAD PASSWORD: it is based on a dictionary word

Retype new password:            //再次输入informix

passwd: all authentication tokens updated successfully.

iii.              修改informix用户环境变量

用informix用户登录,修改/opt/Informix/.bash_profile,增加如下内容:

export INFORMIXDIR=/opt/informix
PATH=$INFORMIXDIR/bin:$PATH
export PATH
export INFORMIXSERVER=tramsserver
export ONCONFIG=onconfig.tramsserver
export CLIENT_LOCALE=zh_CN.gb
export DB_LOCALE=zh_CN.gb
export SERVER_LOCALE=zh_CN.gb
export DBLANG=en_us
export INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts
export INFORMIXTERM=$INFORMIXDIR/etc/termcap
LD_LIBRARY_PATH=$INFORMIXDIR/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
export TERMCAP=$INFORMIXDIR/etc/termcap
export INFORMIXTERM=TERMCAP

4.安装数据库

a)        用root用户解压IDS11.5压缩包。执行./ids_install,弹出安装界面,在选择安装路径时,要与新建用户是选择的用户所属目录一直,如红色标识(/opt/Informix)

5.Informix环境变量设置

新建etc/onconfig.tramsserver文件,根据$INFORMIXDIR/etc/onconfig.std模板进行,内

容如下:

$cd

$cd etc

$cp onconfig.std onconfig.tramsserver

$vi onconfig.tramsserver

# Root数据库空间配置

ROOTNAME   rootdbs              # Root数据库空间名

ROOTPATH    /opt/informix/data/rootdbs # Root数据库空间路径

ROOTOFFSET     100              # 偏移量(Kbytes)

ROOTSIZE        30000          # 空间大小(Kbytes)

# Disk Mirroring Configuration Parameters

MIRROR          0               # Mirroring flag (Yes = 1, No = 0)

MIRRORPATH                  # Path for device containing mirrored root

MIRROROFFSET    0               # Offset into mirrored device (Kbytes)

# Physical Log Configuration

PHYSDBS         rootdbs         # Location (dbspace) of physical log

PHYSFILE        2000            # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES        6                # Number of logical log files

LOGSIZE         2000            # Logical log size (Kbytes)

LOG_BACKUP_MODE MANUAL # Logical log backup mode (MANUAL, CONT)

# Tablespace Tablespace Configuration in Root Dbspace

TBLTBLFIRST     0               # First extent size (Kbytes) (0 = default)

TBLTBLNEXT      0           # Next extent size (Kbytes) (0 = default)

# Security

# DBCREATE_PERMISSION:

# By default any user can create a database. Uncomment DBCREATE_PERMISSON to

# limit database creation to a specific user. Add a new DBCREATE_PERMISSION

# line for each permitted user.

#DBCREATE_PERMISSION    informix

# DB_LIBRARY_PATH:

# When loading a (C or C++) shared object (for a UDR or UDT), IDS checks that

# the user-specified path starts with one of the directory prefixes listed in

# the comma-separated list of prefixes in DB_LIBRARY_PATH. The string

# “$INFORMIXDIR/extend” must be included in DB_LIBRARY_PATH in order for

# extensibility and IBM supplied blades to work correctly.

# DB_LIBRARY_PATH $INFORMIXDIR/extend

# IFX_EXTEND_ROLE:

# 0 (or off) => Disable use of EXTEND role to control who can register

#               external routines.

# 1 (or on) => Enable use of EXTEND role to control who can register

#               external routines. This is the default behaviour.

#

IFX_EXTEND_ROLE 1# To control the usage of EXTEND role.

# Diagnostics

MSGPATH    /opt/informix/log/online.log  #系统日志文件路径

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 #警告程序路径

ALRM_ALL_EVENTS 0      # Triggers ALARMPROGRAM for any event occur

TBLSPACE_STATS 1      # Maintain tblspace statistics

# System Archive Tape Device

TAPEDEV         /dev/null       # Tape device path

TAPEBLK         32              # Tape block size (Kbytes)

TAPESIZE     10240   # Maximum amount of data to put on tape (Kbytes)

# Log Archive Tape Device

LTAPEDEV        /dev/null       # Log tape device path

LTAPEBLK        32              # Log tape block size (Kbytes)

LTAPESIZE       10240 # Max amount of data to put on log tape (Kbytes)

# Optical

STAGEBLOB                       # Informix Dynamic Server staging area

# System Configuration

SERVERNUM       0     # Unique id corresponding to a OnLine instance

DBSERVERNAME   cmsserver       #默认的数据库名称database name

DBSERVERALIASES                 # 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

LOCKS           200000          # 最大锁数量

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         0x44000000    # Shared memory base address

SHMVIRTSIZE     8192      # initial virtual shared memory segment size

SHMADD          8192 # Size of new shared memory segments (Kbytes)

EXTSHMADD    8192 # Size of new extension shared memory segments (

Kbytes)

SHMTOTAL        0      # Total shared memory (Kbytes). 0=>unlimited

CKPTINTVL       300             # Check point interval (in sec)

TXTIMEOUT       0x12c           # Transaction timeout (in sec)

STACKSIZE       32              # Stack size (Kbytes)

# Dynamic Logging

# DYNAMIC_LOGS:

#    2 : server automatically add a new logical log when necessary. (ON)

#    1 : notify DBA to add new logical logs when necessary. (ON)

#    0 : cannot add logical log on the fly. (OFF)

# When dynamic logging is on, we can have higher values for LTXHWM/LTXEHWM,

# because the server can add new logical logs during long transaction rollback.

# However, to limit the number of new logical logs being added, LTXHWM/LTXEHWM

# can be set to smaller values.

#

# If dynamic logging is off, LTXHWM/LTXEHWM need to be set to smaller values

# to avoid long transaction rollback hanging the server due to lack of logical

# log space, i.e. 50/60 or lower.

#

# In case of system configured with CDR, the difference between LTXHWM and

# LTXEHWM should be atleast 30% so that we could minimize log overrun issue.

DYNAMIC_LOGS    2

LTXHWM          70

LTXEHWM         80

# System Page Size

# BUFFSIZE – OnLine no longer supports this configuration parameter.

#            To determine the page size used by OnLine on your platform

#            see the last line of output from the command, ‘onstat -b’.

# Recovery Variables

# OFF_RECVRY_THREADS:

# Number of parallel worker threads during fast recovery or an offline restore.

# ON_RECVRY_THREADS:

# Number of parallel worker threads during an online restore.

OFF_RECVRY_THREADS   10 # Default number of offline worker threads

ON_RECVRY_THREADS    1   # Default number of online worker threads

# Data Replication Variables

# DRAUTO: 0 manual, 1 retain type, 2 reverse type

DRAUTO          0               # DR automatic switchover

DRINTERVAL      30    # DR max time between DR buffer flushes (in sec)

DRTIMEOUT       30              # DR network timeout (in sec)

DRLOSTFOUND  / opt /informix/etc/dr.lostfound # DR lost+found file path

DRIDXAUTO       0             # DR automatic index repair. 0=off, 1=on

# CDR Variables

CDR_EVALTHREADS 1,2     # evaluator threads (per-cpu-vp,additional)

CDR_DSLOCKWAIT 5       # DS lockwait timeout (seconds)

CDR_QUEUEMEM    4096    # Maximum amount of memory for any CDR queue (Kbytes)

CDR_NIFCOMPRESS 0 # Link level compression (-1 never, 0 none, 9 max)

CDR_SERIAL        0,0       # Serial Column Sequence

CDR_DBSPACE           # dbspace for syscdr database

CDR_QHDR_DBSPACE    # CDR queue dbspace (default same as catalog)

CDR_QDATA_SBSPACE   # List of CDR queue smart blob spaces

# CDR_MAX_DYNAMIC_LOGS

# -1 => unlimited

# 0 => disable dynamic log addition

# >0 => limit the no. of dynamic log additions with the specified value.

# Max dynamic log requests that CDR can make within one server session.

CDR_MAX_DYNAMIC_LOGS    0 # Dynamic log addition disabled by default

# Backup/Restore variables

BAR_ACT_LOG   / opt /informix/bar_act.log # ON-Bar Log file – not in /tmp please

BAR_DEBUG_LOG / opt /informix/bar_dbug.log # ON-Bar Debug Log – not in /tmp please

BAR_MAX_BACKUP 0

BAR_RETRY       1

BAR_NB_XPORT_COUNT 20

BAR_XFER_BUF_SIZE 31

RESTARTABLE_RESTORE     ON

BAR_PROGRESS_FREQ       0

# Informix Storage Manager variables

ISM_DATA_POOL   ISMData

ISM_LOG_POOL    ISMLogs

# Read Ahead Variables

RA_PAGES                   # Number of pages to attempt to read ahead

RA_THRESHOLD             # Number of pages left before next group

# DBSPACETEMP:

# OnLine equivalent of DBTEMP for SE. This is the list of dbspaces

# that the OnLine SQL Engine will use to create temp tables etc.

# If specified it must be a colon separated list of dbspaces that exist

# when the OnLine system is brought online. If not specified, or if

# all dbspaces specified are invalid, various ad hoc queries will create

# temporary files in /tmp instead.

DBSPACETEMP     tmpdbs          # Default temp dbspaces

# DUMP*:

# The following parameters control the type of diagnostics information which

# is preserved when an unanticipated error condition (assertion failure) occurs

# during OnLine operations.

# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.

DUMPDIR         / opt /informix/tmp   # Preserve diagnostics in this directory

DUMPSHMEM       1               # Dump a copy of shared memory

DUMPGCORE       0               # Dump a core image using ‘gcore’

DUMPCORE        0   # Dump a core image (Warning:this aborts OnLine)

DUMPCNT         1      # Number of shared memory or gcore dumps for

# a single user’s session

FILLFACTOR      90      # Fill factor for building indexes

# method for OnLine to use when determining current time

USEOSTIME   0    # 0: use internal time(fast), 1: get time from OS(slow)

# Parallel Database Queries (pdq)

MAX_PDQPRIORITY 100    # Maximum allowed pdqpriority

DS_MAX_QUERIES       # Maximum number of decision support queries

DS_TOTAL_MEMORY        # Decision support memory (Kbytes)

DS_MAX_SCANS 1048576   # Maximum number of decision support scans

DS_NONPDQ_QUERY_MEM -1 # Non PDQ query memory (Kbytes)

DATASKIP        off    # List of dbspaces to skip

# OPTCOMPIND

# 0 => Nested loop joins will be preferred (where

#      possible) over sortmerge joins and hash joins.

# 1 => If the transaction isolation mode is not

#      “repeatable read”, optimizer behaves as in (2)

#      below. Otherwise it behaves as in (0) above.

# 2 => Use costs regardless of the transaction isolation

#      mode. Nested loop joins are not necessarily

#      preferred. Optimizer bases its decision purely

#      on costs.

OPTCOMPIND      2    # To hint the optimizer

DIRECTIVES      1    # Optimizer DIRECTIVES ON (1/Default) or OFF (0)

ONDBSPACEDOWN   2   # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT

OPCACHEMAX      0    # Maximum optical cache size (Kbytes)

# HETERO_COMMIT (Gateway participation in distributed transactions)

# 1 => Heterogeneous Commit is enabled

# 0 (or any other value) => Heterogeneous Commit is disabled

HETERO_COMMIT   0

SBSPACENAME      # Default smartblob space name – this is where blobs

# go if no sbspace is specified when the smartblob is

# created. It is also used by some datablades as

# the location to put their smartblobs.

SYSSBSPACENAME    # Default smartblob space for use by the Informix

# Server. This is used primarily for Informix Server

# system statistics collection.

BLOCKTIMEOUT    3600            # Default timeout for system block

SYSALARMPROGRAM / opt /informix/etc/evidence.sh # System Alarm program path

# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS

OPT_GOAL        -1

ALLOW_NEWLINE   0   # embedded newlines(Yes = 1, No = 0 or anything

but 1)

#Create Index Online Shared Memory usage limitation

ONLIDX_MAXMEM   5120            # Per pool per index (Kbytes)

#Timeout for client connection request

LISTEN_TIMEOUT 10              # Timeout (in Seconds)

#Following are the deprecated configuration parameters, instead of these

#use BUFFERPOOL configuration parameter

#BUFFERS, LRUS, LRU_MIN_DIRTY, LRU_MAX_DIRTY

IFX_FOLDVIEW    0       # fold multiple tables or union all view with ansi joins

#

# The following are default settings for enabling Java in the database.

# Replace all occurrences of /usr/informix with the value of $INFORMIXDIR.

#VPCLASS        jvp,num=1       # Number of JVPs to start with

JVPJAVAHOME    / opt /informix/extend/krakatoa/jre # JRE installation root dire

ctory

JVPHOME         / opt /informix/extend/krakatoa # Krakatoa installation directory

JVPPROPFILE     / opt /informix/extend/krakatoa/.jvpprops # JVP property file

JVPLOGFILE      / opt /informix/jvp.log  # JVP log file.

JDKVERSION    1.3              # JDK version supported by this server

# The path to the JRE libraries relative to JVPJAVAHOME

JVPJAVALIB    /bin

# The JRE libraries to use for the Java VM

JVPJAVAVM     jsig:hpi:jvm:java:net:zip:jpeg

# use JVPARGS to change Java VM configuration

#To display jni call

#JVPARGS        -verbose:jni

# Classpath to use upon Java VM start-up (use _g version for debugging)

#JVPCLASSPATH /usr/informix/extend/krakatoa/krakatoa_g.jar:/usr/informix/extend/kra

katoa/jdbc_g.jar

JVPCLASSPATH / opt /informix/extend/krakatoa/krakatoa.jar:/usr/informix/extend/krakat

oa/jdbc.jar

# The following parameters are related to the buffer pool

#BUFFERPOOL      default,buffers=1000,lrus=8,lru_min_dirty=50,lru_max_dirty=60

BUFFERPOOL      size=2k,buffers=5000,lrus=8,lru_min_dirty=50,lru_max_dirty=60

注意以上红色部分,修改正确的informix安装路径,并在$INFORMIXDIR目录下新建data、log两个目录

D.     touch数据库空间文件,并注意修改为660模式

$cd

$mkdir data

$mkdir log

$cd data

$touch rootdbs

$chmod 660 rootdbs

$cd ../tmp

$touch tmpdbs

$chmod 660 tmpdbs

E.      新建etc/sqlhosts文件,根据sqlhosts.std模板进行修改,内容如下:

tramsserver     onsoctcp localhost sqlexec

其中sqlexec需要在/etc/services中定义

# Local services

sqlexec         9088/tcp

6.Informix数据库初始化

a)        使用informix登录

b)        执行onmonitor

$onmonitor

Dynamic Server:   Status Parameters Dbspaces Mode Force-Ckpt …

Status menu to view Dynamic Server.

—————————–Off-Line——- Press CTRL-W for Help. ——–

c)        选择Parameters,再选择Initialize执行初始化,默认读取的就是上一节中的onconfig.cmsserver中的配置,可以一直按ESC继续

其中在Non PDQ Query Memory处修改为空

d)       确认安装,输入y

Do you really want to continue? (y/n)

WARNING: The ROOT DBspace will be initialized.

All previous data will be destroyed.

e)         等到处理完毕,直接回车

Initializing, please wait …

Press Return to continue.

f)         安装完成,执行oninit测试是否成功启动,执行onmode –ky是否成功关闭

$oninit

$onmode -ky

g)        可以在$INFORMIXDIR/log/online.log中看到启动关闭日志

19:11:40 ‘sysmaster’ database built successfully.

19:11:40 ‘sysutils’ database built successfully.

19:11:40 ‘sysuser’ database built successfully.

……

19:12:01 Maximum server connections 1

19:12:02 IBM Informix Dynamic Server Stopped.

h)        安装完成

以下文章点击率最高

Loading…


发表评论

电子邮件地址不会被公开。 必填项已用*标注