Informix安装配置精讲

Informix数据库配置详细解说-电脑资料1．配置概述本次数据库配置将采用数据库系统、数据库日志和数据库应用系统数据分开进行配置，以达到数据库系统优化的目的，。

2．营销系统数据库配置示例2.1 规划数据库空间根据配置的思想，将数据库系统分三个区。

分别是：rootdbs:informix系统区，我们将一号机的e1_1dbs4分配给它，为了便于记忆我们将该区取个名为yxroot。

具体操作为：#ln/dev/re1_1dbs4/dev/yx_root#chowninformix:informix/dev/yx_root#chmod664/dev/yx_rootlogdbs:informix日志区，我们将一号机的e1_1dbs5分配给它，为了便于记忆我们将该区取个别名为yx_log。

具体操作为：#ln/dev/re1_1dbs5/dev/yx_loG#chowninformix:informix/dev/yx_loG#chmod664/dev/yx_logworkdbs:informix数据区，我们将一号机的e1_1dbs0到e1_1dbs3分配给它，为了便于记忆我们将该区取个别名为yx_work。

具体操作为：#ln/dev/re1_1dbs0/dev/yx_dbs0#ln/dev/re1_1dbs1/dev/yx_dbs1#chowninformix:informix/dev/yx_dbs?#chmod664/dev/yx_dbs?2.2 Informix系统参数配置informix系统参数配置文件由如下文件决定：2.2.1 Informix启动环境文件：start_yx 文件内容如下：echo"startdbserveronyx"INFORMIXDIR=/usr/informix exportINFORMIXDIRTBCONFIG=tbconfig.yxDBDATE=Y4MD/PATH=$PATH:$INFORMIXDIR/bin:. exportPATHMAILTBCONFIG2.2.2 Informix配置文件：$INFORMIXDIR/etc/tbconfig.yx $cd$INFORMIXDIR/etc$cptbconfig.stdtbconfig.yx$vitbconfig.yx修改相应参数:ROOTPATH /dev/yx_rootROOTSIZE 1000000TAPEDEV /dev/nullPHYSFILE 100000LOGSIZE 100000LOGFILES 3LOGSIZE 100000MSGPATH /usr/informix/online_yx.loG CONSOLE /dev/consoleSERVERNUM 0DBSERVERNAME XXclic_yx#注:XX:按各地市名称来取#福州:fz 莆田:pt 泉州:qz 漳州:zz 龙岩:ly#三明:sm 南平:np 宁德:ndUSERS 300TRANSACTIONS 300LOCKS 200000BUFFERS 20000TBLSPACES 6000LOGSMAX 602.2.3 Informix网络连接配置文件：$INFORMIXDIR/etc/sqlhosts.yx该文件只有在C/S模式下和数据库联网才用到(略)2.3 Informix初始化操作：1．启动系统环境：以informix用户登录启动环境操作：#../start_yx2．初始化数据库系统区操作：tbinit-i3．创建数据库日志和工作区tbspaces–c–dyx_log–p/dev/yx_log–o0 –s870000tbspaces–c–dyx_work–p/dev/yx_dbs0 -o0 –s2000000tbspaces–ayx_work–p/dev/yx_dbs1 -o0–s20000004．移动数据库系统区的日志到新的数据库日志区a.在logdbs上生成逻辑日志，逻辑日志共取600M，每个日志100M，分6个。

Informix7.0安装及初始配置作者：出处：Unix爱好者家园 更新时间：2004年09月26日1.建立informix用户建立informix用户，其用户组为informix，用户目录可设为 /usr/Informix大体来说informix数据库的安装步骤如下：2.设置环境变量Informix必须的环境变量如上所示。

一般来说，所有环境变量在.profile文件中设置。

以下例子中假定DBSERVERNAME 为online：在/.profile 、/etc/profile、/usr/informix/.profile中设置以下变量：INFORMIXDIR=/usr/informixINFORMIXSERVER=onlineTERM=ansiPATH=$PATH:/usr/informix/binexport INFORMIXDIR INFORMIXSERVER TERM PATH3.安装盘挂载将Informix安装盘挂载到系统中命令为mount /dev/cd0 /mnt （以超级用户root执行此命令）4.安装产品4.1安装INFORMXI--SQL将informix安装盘挂载到/mnt目录下以后，依次执行以下命令进行安装：cd /usr/informix当出现下面的提示时, 按回车键继续进行安装：之后系统要求输入INFORMIX-SQL产品的序列号和活动码：安装程序设置完系统文件的权限并对相关文件进行初始化完毕后, 结束INFORMIX-SQL系统的安装工作。

4.2 安装INFORMIX-ONLINE文件拷贝完毕后, 在#号提示符后面输入下面的命令, 执行INFORMIX-ONLINE系统的安装程序：当出现下面的提示时, 按回车键继续进行安装：之后系统要求输入INFORMIX-ONLINE产品的序列号和活动码:安装程序设置完系统文件的权限并对相关文件进行初始化完毕后, 结束INFORMIX-ONLINE系统的安装工作。

RedHat7.2安装informix暨双机配置教程（QQ：1633748241）目录1.安装环境 (2)2.安装过程 (2)（1）建立informix用户组和用户 (2)（2）设置informix用户的环境变量 (2)（3）安装EsqlForLinux (2)（4）安装IDS2000-9.21.UC3-1 (3)（5）informix数据库的配置 (3)（6）informix相关配置文件的配置 (4)（7）以informix用户身份登录并第一次启动Online Server (6)（8）创建数据空间（dbspace）以存放系统及其它应用 (6)（9）将逻辑日志及物理日志移出rootdbs (7)（10）使Online Server正式运行 (8)rmix的ODBC设置 (9)（1）安装clientsdk-281-TC1.NT (9)（2）ODBC设置 (9)rmix的双机配置 (12)（1）双机环境 (12)（2）双机配置 (12)（3）安装informix数据库 (14)（4）配置和检测informix双机 (15)（4）双机测试 (16)RedHat7.2安装informix暨双机配置教程1.安装环境Win7+VMware6.5+RedHat7.2 Linux内核：2.4.7-10informix：EsqlForLinux+IDS2000-9.21.UC3-12.安装过程（1）建立informix用户组和用户以下操作全部由root用户执行[root@aaa root]#groupadd informix[root@aaa root]#useradd -g informix -d /opt/informix -m -s /bin/csh informix [root@aaa root]#passwd informix（2）设置informix用户的环境变量以下操作由informix用户执行[root@aaa root]#su - informix[root@aaa root]#vi .cshrc.cshrc文件内容如下：setenv INFORMIXDIR /opt/informixsetenv INFORMIXSERVER db_onlinesetenv ONCONFIG onconfigsetenv PATH ${PATH}:/bin:${INFORMIXDIR}:${INFORMIXDIR}/bin保存退出source使之生效[informix@aaa ~]$ source .cshrc（3）安装EsqlForLinux以下操作由root用户执行将EsqlForLinux.tar文件用root用户传至/opt/informix目录下[root@aaa root]# export INFORMIXDIR=/opt/informix[root@aaa root]# cd /opt/informix/解压tar文件[root@aaa informix]# tar xvf EsqlForLinux.tar安装[root@aaa informix]# ./installsqlEnter your serial number (for example, INF#X999999) >ACN#J334914Enter your serial number KEY (uppercase letters only) >OTRZLE注：在输入序列号及口令后，ESQL安装完毕。

经常在论坛中看到有新人寻求informix的安装步骤，回想自己当初刚接触时，也是得到了众多好心人的帮助。

如今将自己的实际经验与从前前辈们的安装文档自整理下放到这里，希望能对有需要的人有所帮助。

由于毕竟经验有限，其中难免有遗漏或者不足的地方，欢迎大家批评指正！1. 创建informix组和informix用户，组ID和用户ID为301（注：此处可根据需要自己设置），并为informix用户设置密码group:informixuser:informix2. 为Informix数据库安装创建文件系统，并赋予权限，例：/informixchown -R informix:informix /informix3. 修改环境变量.profile文件INFORMIXDIR=/informix;PA TH=$PA TH:$INFORMIXDIR/bin;ONCONFIG=onconfig.test;INFORMIXSERVER=online;TERMCAP＝$INFORMIXDIR/etc/termcap;TERM=vt100;export INFORMIXDIR PA TH ONCONFIG INFORMIXSERVER TERMCAP TERM4. 数据库安装必须用root用户安装安装目录选择informix./ids_install（此为10版本的集成安装，显示如下：Product Setup Type------------------------------------------------ ------------------------1. [ ] IBM Informix IConnect2. [x] IBM Informix Client-SDK Typical3. [x] IBM Informix Dynamic Server Typical4. [x] IBM Informix JDBC Driver）若为10以下的版本，可以选择进入SERVER文件夹，执行installserver进行安装。

实验5Informix软件安装及配置informix安装配置实验指导书深圳市讯⽅通信技术有限公司2009年8⽉⽬录1. 实验⽬的 (4)2. 实验器材 (4)3. 实验内容说明 (4)4. 实验步骤 (4)4.1安装INFORMIX前准备 (4)4.1.1 增加informix⽤户组 (4)4.1.2 增加informix⽤户 (5)4.1.3 激活informix⽤户 (5)4.2安装I NFORMIX数据库 (5)4.2.1 上传⽂件到服务器 (5)4.2.2 执⾏安装 (5)4.3配置INFORMIX数据库 (13)4.3.1 创建错误信息⽬录 (13)4.3.2 设置环境变量 (14)4.3.3 增加数据库服务信息 (14)4.3.4 配置数据库服务端⼝ (15)4.3.5 检查⽂件配置 (15)4.3.6 创建rootdbs数据库空间 (16)4.3.7 配置onconfig⽂件 (16)4.3.8 初始化数据库 (18)4.3.9 查看数据库运⾏状态 (18)4.3.10 启动后创建⽤户空间 (18)4.3.11 创建命令 (19)4.4启动关闭数据库 (20)5. 附录A：INFROMIX常⽤命令 (20)5.1 ONINIT (20)5.1.1 功能说明 (20)5.1.2 使⽤说明 (21)5.1.3 举例说明 (21)5.2 ONMODE (21)5.2.1 功能简述 (21)5.2.2 使⽤说明 (21)5.2.3 举例说明 (23)5.3 ONSPACES (23)5.3.1 功能简述 (23)5.3.2 使⽤说明 (23)5.3.3 举例说明 (24)5.4 ONSTAT (24)5.4.1 功能简述 (24)5.4.2 使⽤说明 (24)1. 实验⽬的1、通过本实验，让学⽣了解informix软件安装及配置。

2、了解informix软件特点，熟悉基本数据库操作。

2. 实验器材1、安装Linux AS4以上版本操作系统的PC机⼀台（或者LinuxAS4操作系统安装在虚拟机上）；2、informix数据库软件⼀套；3. 实验内容说明informix是IBM公司出品的关系数据库管理系统（RDBMS）家族。

Informix生产系统安装及配置一、ApplicationDB数据库安装与配置1、创建用户和用户组创建informix用户和informix组Informix用户挂载点/Informix2、修改环境变量修改informix用户的.profile文件，Vi .profile 添加以下内容：INFORMIXDIR=/Informix;PATH=$INFORMIXDIR/bin:$PATH;ONCONFIG=onconfig.loan;INFORMIXSERVER=loandb;export INFORMIXDIR PATH ONCONFIG INFORMIXSERVERexport TERM=vt100TERMINFO=$INFORMIXDIR/etc/typetab;TERMCAP=$INFORMIXDIR/etc/termcap;DBDATE=Y4MD-;Export TERMINFOR TERMCAP DBDATE3、安装数据库及组件Csdk安装：1）Cd /opt/Informix_setup/csdk2）Chmod 777 installclientsdk3）./installclientsdk4）根据安装向导填写安装路径/informix，其他选项按默认值选择，之后开始安装IDS安装：1)Cd /opt/Informix_setup/server2)Chmod 777 installserver3)./installserver4)根据安装向导填写安装路径/informix，其他选项按默认值选择，之后开始安装4、更改磁盘设备信息属组及权限并链接设备文件将所有为AppliactionDB数据库创建的裸设备的字符型设备文件（c类型）的属组更改为informix:InformixCd /devChownInformix:Informixrloan* rflow* rtemp* rphy* rlog*将所有为AppliactionDB数据库创建的裸设备的字符型设备文件（c类型）的权限更改为660Chmod 660 rloan* rflow* rtemp* rphy* rlog*Su –InformixMkdir data将所有为AppliactionDB数据库创建的裸设备的字符型设备文件（c类型）软链接到该目录下，例如：Ln –s /dev/rloan_rootdbsloan_rootdbs链接所在目录：Loan_data_01:/Informix/data/loan_data/Loan_data_02:/Informix/data/loan_data/Loan_index_data:/Informix/data/loan_index/Flow_data_01:/Informix/data/flow_data/Flow_data_02:/Informix/data/flow_data/Flow_index_data:/Informix/data/flow_index/Tempdbs:/Informix/data/temp_data/Rootdbs:/Informix/data/Phy_loan_log:/Informix/data/Log_loan_log:/Informix/data/5、创建onconfig脚本Su –InformixCd etcCponconfig.stdonconfig.loanOnconfig参数修改：################################################################### # Licensed Material - Property Of IBM## "Restricted Materials of IBM"## IBM Informix Dynamic Server# Copyright IBM Corporation 1996, 2009. All rights reserved.## Title: onconfig.std# Description: IBM Informix Dynamic Server Configuration Parameters ## Important: $INFORMIXDIR now resolves to the environment# variable INFORMIXDIR. Replace the value of the INFORMIXDIR# environment variable only if the path you want is not under# $INFORMIXDIR.## For additional information on the parameters:# /infocenter/idshelp/v115/index.jsp####################################################################################################################################### Root Dbspace Configuration Parameters#################################################################### ROOTNAME - The root dbspace name to contain reserved pages and # internal tracking tables.# ROOTPATH - The path for the device containing the root dbspace # ROOTOFFSET - The offset, in KB, of the root dbspace into the# device. The offset is required for some raw devices. # ROOTSIZE - The size of the root dbspace, in KB. The value of # 200000 allows for a default user space of about# 100 MB and the default system space requirements.# MIRROR - Enable (1) or disable (0) mirroring# MIRRORPATH - The path for the device containing the mirrored# rootdbspace# MIRROROFFSET - The offset, in KB, into the mirrored device## Warning: Always verify ROOTPATH before performing# disk initialization (oninit -i or -iy) to# avoid disk corruption of another instance###################################################################ROOTNAME rootdbsROOTPATH $INFORMIXDIR/data/loan_rootdbs（修改到rootdbs所在目录）ROOTOFFSET 256 （偏移量256K）ROOTSIZE 4000000（大小4G）MIRROR 0MIRRORPATH $INFORMIXDIR/tmp/demo_on.root_mirrorMIRROROFFSET 0#################################################################### Physical Log Configuration Parameters#################################################################### PHYSFILE - The size, in KB, of the physical log on disk. # If RTO_SERVER_RESTART is enabled, the# suggested formula for the size of PHSYFILE# (up to about 1 GB) is:# PHYSFILE = Size of BUFFERS * 1.1# PLOG_OVERFLOW_PATH - The directory for extra physical log files# if the physical log overflows during recovery # or long transaction rollback# PHYSBUFF - The size of the physical log buffer, in KB###################################################################PHYSFILE 39000000PLOG_OVERFLOW_PATH $INFORMIXDIR/tmpPHYSBUFF 128################################################################### # Logical Log Configuration Parameters################################################################### # LOGFILES - The number of logical log files# LOGSIZE - The size of each logical log, in KB# DYNAMIC_LOGS - The type of dynamic log allocation.# Acceptable values are:# 2 Automatic. IDS adds a new logical log to the# root dbspace when necessary.# 1 Manual. IDS notifies the DBA to add new logical # logs when necessary.# 0 Disabled# LOGBUFF - The size of the logical log buffer, in KB###################################################################LOGFILES 250LOGSIZE 10000DYNAMIC_LOGS 2LOGBUFF 64################################################################### # Long Transaction Configuration Parameters################################################################### # If IDS cannot roll back a long transaction, the server hangs# until more disk space is available.## LTXHWM - The percentage of the logical logs that can be# filled before a transaction is determined to be a # long transaction and is rolled back# LTXEHWM - The percentage of the logical logs that have been # filled before the server suspends all other# transactions so that the long transaction being# rolled back has exclusive use of the logs## When dynamic logging is on, you can set higher values for# LTXHWM and LTXEHWM because the server can add new logical logs# during long transaction rollback. Set lower values to limit the # number of new logical logs added.## If dynamic logging is off, set LTXHWM and LTXEHWM to# lower values, such as 50 and 60 or lower, to prevent long# transaction rollback from hanging the server due to lack of# logical log space.## When using Enterprise Replication, set LTXEHWM to at least 30%# higher than LTXHWM to minimize log overruns.###################################################################LTXHWM 70LTXEHWM 80################################################################### # Server Message File Configuration Parameters################################################################### # MSGPATH - The path of the IDS message log file# CONSOLE - The path of the IDS console message file###################################################################MSGPATH $INFORMIXDIR/online_loan.logCONSOLE $INFORMIXDIR/tmp/online.con################################################################### # Tblspace Configuration Parameters################################################################### # TBLTBLFIRST - The first extent size, in KB, for the tblspace # tblspace. Must be in multiples of the page size. # TBLTBLNEXT - The next extent size, in KB, for the tblspace# tblspace. Must be in multiples of the page size. # The default setting for both is 0, which allows IDS to manage# extent sizes automatically.## TBLSPACE_STATS - Enables (1) or disables (0) IDS to maintain# tblspace statistics###################################################################TBLTBLFIRST 0TBLTBLNEXT 0TBLSPACE_STATS 1################################################################### # Temporary dbspace and sbspace Configuration Parameters################################################################### # DBSPACETEMP - The list of dbspaces used to store temporary# tables and other objects. Specify a colon# separated list of dbspaces that exist when the# server is started. If no dbspaces are specified,# or if all specified dbspaces are not valid,# temporary files are created in the /tmp directory# instead.# SBSPACETEMP - The list of sbspaces used to store temporary# tables for smart large objects. If no sbspace# is specified, temporary files are created in# a standard sbspace.###################################################################DBSPACETEMP tempdbsSBSPACETEMP################################################################### # Dbspace and sbspace Configuration Parameters################################################################### # SBSPACENAME - The default sbspace name where smart large objects # are stored if no sbspace is specified during# smart large object creation. Some DataBlade# modules store smart large objects in this# location.# SYSSBSPACENAME - The default sbspace for system statistics# collection. Otherwise, IDS stores statistics# in the sysdistrib system catalog table.# ONDBSPACEDOWN - Specifies how IDS behaves when it encounters a# dbspace that is offline. Acceptable values# are:# 0 Continue# 1 Stop# 2 Wait for DBA action###################################################################SBSPACENAMESYSSBSPACENAMEONDBSPACEDOWN 2################################################################### # System Configuration Parameters################################################################### # SERVERNUM - The unique ID for the IDS instance. Acceptable # values are 0 through 255, inclusive.# DBSERVERNAME - The name of the default database server# DBSERVERALIASES - The list of up to 32 alternative dbservernames, # separated by commas###################################################################SERVERNUM 0DBSERVERNAME loandbDBSERVERALIASES loandbshm################################################################### # Network Configuration Parameters################################################################### # NETTYPE - The configuration of poll threads# for a specific protocol. The# format is:# NETTYPE <protocol>,<# poll threads> # ,<number of connections/thread># ,(NET|CPU)# You can include multiple NETTYPE# entries for multiple protocols.# LISTEN_TIMEOUT - The number of seconds that IDS# waits for a connection# MAX_INCOMPLETE_CONNECTIONS - The maximum number of incomplete# connections before IDS logs a Denial # of Service (DoS) error# FASTPOLL - Enables (1) or disables (0) fast# polling of your network, if your# operating system supports it.###################################################################NETTYPE s octcp,8,500,NET （网络协议用户4000）NETTYPE ipcshm,2,50,CPU （内存通道用户100）LISTEN_TIMEOUT 60MAX_INCOMPLETE_CONNECTIONS 1024FASTPOLL 1################################################################### # CPU-Related Configuration Parameters################################################################### # MULTIPROCESSOR - Specifies whether the computer has multiple # CPUs. Acceptable values are: 0 (single# processor), 1 (multiple processors or# multi-core chips)# VPCLASS cpu - Configures the CPU VPs. The format is:# VPCLASS cpu,num=<#>[,max=<#>][,aff=<#>]# [,noage]# VP_MEMORY_CACHE_KB - Specifies the amount of private memory# blocks of your CPU VP, in KB, that the# database server can access.# Acceptable values are:# 0 (disable)# 800 through 40% of the value of SHMTOTAL# SINGLE_CPU_VP - Optimizes performance if IDS runs with# only one CPU VP. Acceptable values are:# 0 multiple CPU VPs# Any nonzero value (optimize for one CPU VP) ###################################################################MULTIPROCESSOR 1VPCLASS cpu,num=8,noageVP_MEMORY_CACHE_KB 0SINGLE_CPU_VP 0################################################################### # AIO and Cleaner-Related Configuration Parameters################################################################### # VPCLASS aio - Configures the AIO VPs. The format is:# VPCLASS aio,num=<#>[,max=<#>][,aff=<#>][,noage] # CLEANERS - The number of page cleaner threads# AUTO_AIOVPS - Enables (1) or disables (0) automatic management # of AIO VPs# DIRECT_IO - Specifies whether direct I/O is used for cooked# files used for dbspace chunks.# Acceptable values are:# 0 Disable# 1 Enable direct I/O# 2 Enable concurrent I/O####################################################################VPCLASS aio,num=1CLEANERS 8AUTO_AIOVPS 1DIRECT_IO 0################################################################### # Lock-Related Configuration Parameters################################################################### # LOCKS - The initial number of locks when IDS starts. # Dynamic locking can add extra locks if needed. # DEF_TABLE_LOCKMODE - The default table lock mode for new tables.# Acceptable values are ROW and PAGE (default). ###################################################################LOCKS 1000000DEF_TABLE_LOCKMODE row################################################################### # Shared Memory Configuration Parameters################################################################### # RESIDENT - Controls whether shared memory is resident.# Acceptable values are:# 0 off (default)# 1 lock the resident segment only# n lock the resident segment and the next n-1# virtual segments, where n < 100# -1 lock all resident and virtual segments# SHMBASE - The shared memory base address; do not change# SHMVIRTSIZE - The initial size, in KB, of the virtual# segment of shared memory# SHMADD - The size, in KB, of additional virtual shared# memory segments# EXTSHMADD - The size, in KB, of each extension shared# memory segment# SHMTOTAL - The maximum amount of shared memory for IDS,# in KB. A 0 indicates no specific limit.# SHMVIRT_ALLOCSEG - Controls when IDS adds a memory segment and# the alarm level if the memory segment cannot# be added.# For the first field, acceptable values are:# - 0 Disabled# - A decimal number indicating the percentage# of memory used before a segment is added# - The number of KB remaining when a segment# is added# For the second field, specify an alarm level# from 1 (non-event) to 5 (fatal error).# SHMNOACCESS - A list of up to 10 memory address ranges# that IDS cannot use to attach shared memory.# Each address range is the start and end memory # address in hex format, separated by a hyphen. # Use a comma to separate each range in the list. ###################################################################RESIDENT 0SHMBASE 0x700000010000000SHMVIRTSIZE 32656SHMADD 8192EXTSHMADD 8192SHMTOTAL 0SHMVIRT_ALLOCSEG 0,3SHMNOACCESS################################################################### # Checkpoint and System Block Configuration Parameters################################################################### # CKPINTVL - Specifies how often, in seconds, IDS checks# if a checkpoint is needed. 0 indicates that# IDS does not check for checkpoints. Ignored # if RTO_SERVER_RESTART is set.# AUTO_CKPTS - Enables (1) or disables (0) monitoring of# critical resource to trigger checkpoints# more frequently if there is a chance that# transaction blocking might occur.# RTO_SERVER_RESTART - Specifies, in seconds, the Recovery Time# Objective for IDS restart after a server# failure. Acceptable values are 0 (off) and# any number from 60-1800, inclusive.# BLOCKTIMEOUT - Specifies the amount of time, in seconds,# for a system block.###################################################################CKPTINTVL 1800AUTO_CKPTS 1RTO_SERVER_RESTART 0BLOCKTIMEOUT 3600################################################################### # Transaction-Related Configuration Parameters################################################################### # TXTIMEOUT - The distributed transaction timeout, in seconds# DEADLOCK_TIMEOUT - The maximum time, in seconds, to wait for a# lock in a distributed transaction.# HETERO_COMMIT - Enables (1) or disables (0) heterogeneous# commits for a distributed transaction# involving an EGM gateway.###################################################################TXTIMEOUT 300DEADLOCK_TIMEOUT 60HETERO_COMMIT 0################################################################### # ontape Tape Device Configuration Parameters################################################################### # TAPEDEV - The tape device path for backups. To use standard# I/O instead of a device, set to stdio.# TAPEBLK - The tape block size, in KB, for backups# TAPESIZE - The maximum amount of data to put on one backup# tape. Acceptable values are 0 (unlimited) or any# positive integral multiple of TAPEBLK.###################################################################TAPEDEV /dev/nullTAPEBLK 32TAPESIZE 0################################################################### # ontapeLogial Log Tape Device Configuration Parameters################################################################### # LTAPEDEV - The tape device path for logical logs# LTAPEBLK - The tape block size, in KB, for backing up logical # logs# LTAPESIZE - The maximum amount of data to put on one logical# log tape. Acceptable values are 0 (unlimited) or any # positive integral multiple of LTAPEBLK.###################################################################LTAPEDEV /dev/nullLTAPEBLK 32LTAPESIZE 0################################################################### # Backup and Restore Configuration Parameters#################################################################### BAR_ACT_LOG - The ON-Bar activity log file location.# Do not use the /tmp directory. Use a# directory with restricted permissions.# BAR_DEBUG_LOG - The ON-Bar debug log file location.# Do not use the /tmp directory. Use a# directory with restricted permissions.# BAR_DEBUG - The debug level for ON-Bar. Acceptable# values are 0 (off) through 9 (high).# BAR_MAX_BACKUP - The number of backup threads used in a# backup. Acceptable values are 0 (unlimited)# or any positive integer.# BAR_RETRY - Specifies the number of time to retry a# backup or restore operation before reporting # a failure# BAR_NB_XPORT_COUNT - Specifies the number of data buffers that# eachonbar_d process uses to communicate# with the database server# BAR_XFER_BUF_SIZE - The size, in pages, of each data buffer.# Acceptable values are 1 through 15 for# 4 KB pages and 1 through 31 for 2 KB pages.# RESTARTABLE_RESTORE - Enables ON-Bar to continue a backup after a# failure. Acceptable values are OFF or ON.# BAR_PROGRESS_FREQ - Specifies, in minutes, how often progress# messages are placed in the ON-Bar activity# log. Acceptable values are: 0 (record only# completion messages) or 5 and above.# BAR_BSALIB_PATH - The shared library for ON-Bar and the# storage manager. The default value is# $INFORMIXDIR/lib/ibsad001 (with a# platform-specific file extension).# BACKUP_FILTER - Specifies the pathname of a filter program# to transform data during a backup, plus any# program options# RESTORE_FILTER - Specifies the pathname of a filter program# to transform data during a restore, plus any # program options# BAR_PERFORMANCE - Specifies the type of performance statistics# to report to the ON-Bar activity log for backup # and restore operations.# Acceptable values are:# 0 = Turn off performance monitoring (Default) # 1 = Display the time spent transferring data # between the IDS instance and the storage # manager# 2 = Display timestamps in microseconds# 3 = Display both timestamps and transfer # statistics###################################################################BAR_ACT_LOG $INFORMIXDIR/tmp/bar_act.logBAR_DEBUG_LOG $INFORMIXDIR/tmp/bar_dbug.logBAR_DEBUG 0BAR_MAX_BACKUP 0BAR_RETRY 1BAR_NB_XPORT_COUNT 20BAR_XFER_BUF_SIZE 31RESTARTABLE_RESTORE ONBAR_PROGRESS_FREQ 0BAR_BSALIB_PATHBACKUP_FILTERRESTORE_FILTERBAR_PERFORMANCE 0################################################################### # Informix Storage Manager (ISM) Configuration Parameters################################################################### # ISM_DATA_POOL - Specifies the name for the ISM data pool# ISM_LOG_POOL - Specifies the name for the ISM log pool###################################################################ISM_DATA_POOL ISMDataISM_LOG_POOL ISMLogs################################################################### # Data Dictionary Cache Configuration Parameters################################################################### # DD_HASHSIZE - The number of data dictionary pools. Set to any# positive integer; a prime number is recommended. # DD_HASHMAX - The number of entries per pool.# Set to any positive integer.###################################################################DD_HASHSIZE 31DD_HASHMAX 10################################################################### # Data Distribution Configuration Parameters#################################################################### DS_HASHSIZE - The number of data Ddstribution pools.# Set to any positive integer; a prime number is# recommended.# DS_POOLSIZE - The maximum number of entries in the data# distribution cache. Set to any positive integer.###################################################################DS_HASHSIZE 31DS_POOLSIZE 127################################################################### User Defined Routine (UDR) Cache Configuration Parameters################################################################### PC_HASHSIZE - The number of UDR pools. Set to any# positive integer; a prime number is recommended.# PC_POOLSIZE - The maximum number of entries in the# UDR cache. Set to any positive integer.###################################################################PC_HASHSIZE 31PC_POOLSIZE 127#################################################################### SQL Statement Cache Configuration Parameters#################################################################### STMT_CACHE - Controls SQL statement caching. Acceptable# values are:# 0 Disabled# 1 Enabled at the session level# 2 All statements are cached# STMT_CACHE_HITS - The number of times an SQL statement must be# executed before becoming fully cached.# 0 indicates that all statements are# fully cached the first time.# STMT_CACHE_SIZE - The size, in KB, of the SQL statement cache# STMT_CACHE_NOLIMIT - Controls additional memory consumption.# Acceptable values are:# 0 Limit memory to STMT_CACHE_SIZE# 1 Obtain as much memory, temporarily, as needed # STMT_CACHE_NUMPOOL - The number of pools for the SQL statement# cache. Acceptable value is a positive# integer between 1 and 256, inclusive.###################################################################STMT_CACHE 0STMT_CACHE_HITS 0STMT_CACHE_SIZE 512STMT_CACHE_NOLIMIT 0STMT_CACHE_NUMPOOL 1################################################################### # Operating System Session-Related Configuration Parameters################################################################### # USEOSTIME - The precision of SQL statement timing.# Accepted values are 0 (precision to seconds)# and 1 (precision to subseconds). Subsecond# precision can degrade performance.# STACKSIZE - The size, in KB, for a session stack# ALLOW_NEWLINE - Controls whether embedded new line characters # in string literals are allowed in SQL# statements. Acceptable values are 1 (allowed) # and any number other than 1 (not allowed).# USELASTCOMMITTED - Controls the committed read isolation level.# Acceptable values are:# - NONE Waits on a lock# - DIRTY READ Uses the last committed value in # place of a dirty read# - COMMITTED READ Uses the last committed value # in place of a committed read# - ALL Uses the last committed value in place # of all isolation levels that support the last # committed option###################################################################USEOSTIME 0STACKSIZE 64ALLOW_NEWLINE 0USELASTCOMMITTED NONE################################################################### # Index Related Configuration Parameters################################################################### # FILLFACTOR - The percentage of index page fullness# MAX_FILL_DATA_PAGES - Enables (1) or disables (0) filling data# pages that have variable length rows as# full as possible# BTSCANNER - Specifies the configuration settings for all # btscanner threads. The format is:# BTSCANNER num=<#>,threshold=<#>,rangesize=<#>, # alice=(0-12),compression=[low|med|high|default] # ONLIDX_MAXMEM - The amount of memory, in KB, allocated for# the pre-image pool and updator log pool for# each partition.###################################################################FILLFACTOR 90MAX_FILL_DATA_PAGES 0BTSCANNER num=1,threshold=5000,rangesize=-1,alice=6,compression=default ONLIDX_MAXMEM 5120#################################################################### Parallel Database Query (PDQ) Configuration Parameters#################################################################### MAX_PDQPRIORITY - The maximum amount of resources, as a# percentage, that PDQ can allocate to any# one decision support query# DS_MAX_QUERIES - The maximum number of concurrent decision# support queries# DS_TOTAL_MEMORY - The maximum amount, in KB, of decision# support query memory# DS_MAX_SCANS - The maximum number of concurrent decision# support scans# DS_NONPDQ_QUERY_MEM - The amount of non-PDQ query memory, in KB.# Acceptable values are 128 to 25% of# DS_TOTAL_MEMORY.# DATASKIP - Specifies whether to skip dbspaces when# processing a query. Acceptable values are:# - ALL Skip all unavailable fragments# - ON <dbspace1><dbspace2>... Skip listed# dbspaces# - OFF Do not skip dbspaces (default)###################################################################MAX_PDQPRIORITY 100DS_MAX_QUERIESDS_TOTAL_MEMORYDS_MAX_SCANS 1048576DS_NONPDQ_QUERY_MEM 128DATASKIP#################################################################### Optimizer Configuration Parameters# OPTCOMPIND - Controls how the optimizer determines the best# query path. Acceptable values are:# 0 Nested loop joins are preferred# 1 If isolation level is repeatable read,# works the same as 0, otherwise works same as 2# 2 Optimizer decisions are based on cost only# DIRECTIVES - Specifies whether optimizer directives are# enabled (1) or disabled (0). Default is 1.# EXT_DIRECTIVES - Controls the use of external SQL directives.# Acceptable values are:# 0 Disabled# 1 Enabled if the IFX_EXTDIRECTIVES environment# variable is enabled# 2 Enabled even if the IFX_EXTDIRECTIVES# environment is not set# OPT_GOAL - Controls how the optimizer should optimize for# fastest retrieval. Acceptable values are:# -1 All rows in a query# 0 The first rows in a query# IFX_FOLDVIEW - Enables (1) or disables (0) folding views that# have multiple tables or a UNION ALL clause.# Disabled by default.# AUTO_REPREPARE - Enables (1) or disables (0) automatically# re-optimizing stored procedures and re-preparing# prepared statements when tables that are referenced # by them change. Minimizes the occurrence of the# -710 error.####################################################################OPTCOMPIND 2DIRECTIVES 1EXT_DIRECTIVES 0OPT_GOAL -1IFX_FOLDVIEW 0AUTO_REPREPARE 1#################################################################### Read-ahead Configuration Parameters####################################################################RA_PAGES - The number of pages, as a positive integer, to# attempt to read ahead#RA_THRESHOLD - The number of pages, as a postive integer, left# before the next read-ahead group。

Informix 11.50 for Windows安装配置一、测试环境
操作系统：Windows Server 2008 64bit
Informix版本：Informix Ultimate Edition 11.5 for Windows 64
二、安装
1.解压iif.11.50.FC9TL.win2003.zip文件，双击运行setup.exe进行安装。

2.选项需要安装的组件包（这里使用了默认的IDS,DBDK,CSDK）
3.点击Next继续执行
4.阅读并接受协议，点击Next
5.选择Typical方式进行安装
6.选择安装目录，这里安装路径设置为“E:\informix11.5”。

7.设置informix 用户密码
8.确认安装信息，点击“Next”
9.等待IDS安装结束，点击“Finish”。

10.自动加载DBDK安装程序
11.点击Next执行安装
12.设置DBDK安装目录
13.点击Done完成DBDK安装
14.自动加载CSDK安装程序
15.选择接受许可协议
16.设置本地信息，默认Windows用户
17.选择Custom进行安装
18.为Client-SDK设置路径
19.点击Next后，进行安装
20.完成CSDK 安装
21.全部完成安装后，程序组里增加了IDS,DBDK,CSDK 三组，在IDS 的程序组里：以数据库服务名(ids1150)为标题的链接可视为informix 的console 接口，server instance manager 可以管理instance，modifyinstallation 可以管理informix 安装组件。

l i n u x6下i n f o r m i x_11.7安装配置手册新开局linux6 下informix_11.7安装配置手册本文仅适用于数据库挂载本地盘的情况。

本文中逻辑日志设置为19个，逻辑日志，物理日志以及tempdbs的大小设置为2G，rootdbs设置为5.1G，其他地区可根据局方划分虚拟空间的大小灵活调整。

建立informix账户useradd –u 500 –g 500 –d /home/Informix –s /bin/bash Informix确认shell类型如果shell类型不是bash则修正informix账户shell类型chsh –s /bin/bash informix编辑informix环境变量INFORMIXDIR=/home/informixINFORMIXSERVER=hbcdr1PATH=$PATH:$INFORMIXDIR/binLD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INFORMIXDIR/lib:$INFORM IXDIR/lib/esqlexport INFORMIXDIR INFORMIXSERVER PATH解压informix_11.7安装包解压后文件切换账户至root进行安装直接ENTER回车选1并回车选1回车或直接按回车键指定安装路径，并选Y回车确认；我们常用/home/Informix，如果不指定informix默认安装到/opt/IBM/informix中此处选1或者按ENTER默认Typical此处选2，不要默认选项此处选1并回车确认此处直接回车确认此处直接回车，系统自动安装安装完毕回到informix账户下如果是本地磁盘做数据库则在informix账户下建立chunklink目录并执行数据库空间mkdir /home/Informix/chunklinkcd /home/Informix/chunklinktouch rootdbstouch tempdbstouch logdbstouch phydbstouch datadbs1 datadbs2 datadbs3 datadbs4 datadbs5chmod 660 *dbs*编辑onconfig文件cp onconfig.std onconfig根据现场主机实际情况编辑onconfig文件注意rootdbs方面ROOTNAME rootdbsROOTPATH /home/informix/chunklink/rootdbsROOTOFFSET 10000ROOTSIZE 5100000Logdbs方面LOGFILES 2LOGSIZE 200000DYNAMIC_LOGS 3LOGBUFF 64FULL_DISK_INIT 1在初始化之前设置成1 初始化完成后会自动变成0 DBSERVERNAME ivpndb2 要根据现场实际情况变更LOCKS 6000000 锁的数量要根据预计的业务量进行调整共享内存方面SHMVIRTSIZE 1024000SHMADD 128000备份方面TAPEDEV /home/informix/ph.dat 备份文件名和路径TAPEBLK 1024TAPESIZE 24000000 备份文件大小编辑sqlhosts文件修改services文件用root编辑/etc/services增加7787端口初始化oninit –ivy初始化执行时间较长因为要将本地磁盘空间先划分出一部分作为rootdbs 这个耗时较长此时online.log日志中可见到FULL_DISK_INIT变成0初始化完成onstat –d可见rootdbs划分其他必要空间各划分2G作为tempdbs logdbs phydbs空间onspaces -c -d tempdbs -t -p /home/informix/chunklink/tempdbs -o 0 -s 2000000 onspaces -c -d logdbs -p /home/informix/chunklink/logdbs -o 0 -s 2000000 onspaces -c -d phydbs -p /home/informix/chunklink/phydbs -o 0 -s 2000000划分datadbs空间【耗时长，划一个datadbs大约需要10分钟】这里只划分4个出来【4*20G=80G 划分80G作为数据库数据空间】onspaces -c -d datadbs -p /home/informix/chunklink/datadbs1 -o 0 -s 20000000 onspaces -a datadbs -p /home/informix/chunklink/datadbs2 -o 0 -s 20000000 onspaces -a datadbs -p /home/informix/chunklink/datadbs3 -o 0 -s 20000000 onspaces -a datadbs -p /home/informix/chunklink/datadbs4 -o 0 -s 20000000系统在执行上述命令的时候，同时在chunklink目录下可观察到datadbs1在增大修改数据库状态从online变成静止onmode –s变更逻辑日志/*可以指定文件大小，且此处执行的条数要和逻辑日志个数一致/onparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 -ionparams -a -d logdbs -s 100000 –i另开一窗口onstat –l可见新增的逻辑日志begin是从3开始0级备份在informix家目录下touch ph.dat备份文件并执行0级备份执行19次onmode –l 同时onstat –l可见到onmod e –c 重定位onmode –c重定位checkopint点此时U---C-L重定位到number20上删除系统默认逻辑日志onparams -d -l 1 -yonparams -d -l 2 -yonparams -d -l 3 -yonparams -d -l 4 -yonparams -d -l 5 -yonparams -d -l 6 -yonparams -d -l 7 -yonparams -d -l 8 -yonparams -d -l 9 -yonparams -d -l 10 -y onparams -d -l 11 -y onparams -d -l 12 -y onparams -d -l 13 -y onparams -d -l 14 -y onparams -d -l 15 -y onparams -d -l 16 -yonparams -d -l 17 -yonparams -d -l 18 -yonparams -d -l 19 -y此时number 1中还有系统自带逻辑日志先0备再删除ontape –s –L 0onparams -d -l 1 –yonmod e –m 恢复在线状态重启数据库Onmode –kyOninit –vy完成如果安装过程中出问题需要重新安装请删除/home/Informix/chunklink/下的文件并重新touch相关数据空间且要修改onconfig配置文件中的FULL_DISK_ONIT为1在执行oninit –ivy其余步骤和本文一致。

Informix安装完成后进行配制一、测试是否已经连接先点击开始→所有程序→Informix Clinet SDK→ILogin Demo如下图就会弹出一个测试是否联通了的测试界面如下点击File→Run就会弹出如下图然后在这个页面里输入相应的信息如下图里面的server里填写的是数据库服务名：enipas_online_net Hostname里填写的是数据库IP地址：221.5.135.13 Servicename里填写的是数据库端口：9003Protocolname里填写的是onsoctcpUsername 里填写的是用户名scutestPassword 里填写的是密码scutestStores Database 里填写的是数据库名：scpdb填写完后再点击OK进行测试如出现下面的窗口就是连接测试成功然后关闭这个重启电脑（informix客户端安装后一定要重启后才能使用）二、配制informix点击开始→所有程序→Informix Client SDK →Informix Setnet32 如下图就会弹出点击Server Information 如下图在这里填写完相应信息如下图在informix Server里填写数据库服务名：enipas_online_net HostName 里填写数据库IP地址：221.5.135.13 Protocolname里填写的是onsoctcpService Name里填写的是数据库端口：9003然后点击Host Information 就会弹出如下页面在这里填写数据库的用户名和密码如下图然后点击确定就会弹出如下信息点击确定就可以了三、配制informix的ODBC数据源重启后开始配制informix的ODBC数据源: 如下图1、点击开始→管理工具→数据源就会弹出下图2、就会出现下图点击添加就会出现下图选择INFORMIX 3.30 32 BIT就会出现下图在Data Source Name里输入连接名cqwtin7 然后点击Connetction在Connetction 里的Server Name里输入数据库服务名：enipas_online_net 然后再填写Database Name 里输入数据库名scpdb在User Id里输入用户名scutestPassword 里输入密码scutest然后点击Test Connection进行连接测试如果成功就可以了。

INFORMIX数据库安装配置文档一、INFORMIX Online 7.24安装步骤1·建立INFORMIX组、用户在天腾主机系统安装完成的前提下，以root用户注册，执行#sysadm→users→add 菜单，先增加informix用户组，再增加informix用户。

用户创建完成后，按CTRL+d 退出root用户，在login:状态下以informix用户身份注册，在$提示符下，输入id命令，检查informix用户创建的正确性。

(注：创建informix用户时，请注意口令失效期需大于1，口令有效期不要注明。

同时informix用户号和组号需大于或等于100。

可参见TANDEM S4206主机上用户帐号管理配置文档)2·INFORMIX 环境变量的设置与INFORMIX相关的环境变量有以下几种：RMIXDIR变量(指定Informix的工作目录)：INFORMIXDIR=/informix; export INFORMIXDIRb.PATH变量（使得Informix命令可被用户使用）：PATH = $PATH: $INFORMIXDIR/bin ; export PATHc.ONCONFIG变量（指定Informix Online 的初始化配置文件）：ONCONFIG =onconfig.lyg; export ONCONFIGRMIXSERVER变量（指定数据库服务器名字）：INFORMIXSERVER=lygserver ; export INFORMIXSERVERe. LANG和LC_CTYPE变量（支持Online的汉化语言包）：LANG=chinese; export LANGLC_CTYPE=C; export LC_CTYPE以上环境变量已附加到/etc/profile文件中。

3·INFORMIX Online 7.X数据库空间的分布。

Tandem S4206主机上I nformix Online数据库系统空间的使用和划分有以下约定：Online自身系统数据库sysmaster、sysutils等位于根数据库空间rootdbs；Online系统临时数据位于数据库空间tmpdbs；Online系统逻辑日志位于数据库空间loglog；Online系统物理日志位于数据库空间phylog；Online系统工作数据位于数据库空间workdbs；构成Informix Online数据库空间的所有chunk均为原始设备（又称生设备或raw disk），所有chunk的用户主、用户组均为informix，用户权限为660。