一、安装前准备
安装JDK（略）
到IBM官网上下载informix软件：iif.12.10.FC9DE.linux-x86_64.tar放在某个大家都可以访问的目录比如：/mypkg，并解压到该目录下。
创建informix用户、组和安装目录：
sudo adduser --home /opt/informix informix二、准备informix环境变量
在.bashrc追加下面内容（在informix用户和日常登录的用户都加。OS用户同事也是informix用户）
export INFORMIXSERVER=ifxserver
export INFORMIXDIR=/opt/informix
export ONCONFIG=onconfig.ifxserver
export INFORMIXSQLHOSTS=$INFORMIXDIR/etc/sqlhosts.ifxserver
export PATH=$INFORMIXDIR/bin:/usr/bin:${PATH}:.
export DB_LOCALE=zh_CN.utf8
export CLIENT_LOCALE=zh_CN.utf8三、创建数据库文件的安装目录
su - informix
mkdir $INFORMIXDIR/dbs
touch $INFORMIXDIR/dbs/rootdbs
chmod 660 $INFORMIXDIR/dbs/rootdbs四、数据库软件安装
使用root用户执行/mypkg/ids_install文件进行安装， 注意这里从用户informix 切换到 root 用户时，su root 而不是su - root，这样可以保留informix环境，站长站，安装时不需要即可安装到指定目录:
安装过程中选择不创建实例,其他都选择默认选项。
===============================================================================
Server Instance
---------------
Type 'back' to go to the previous step or 'quit' to cancel the installation.
Create a database server instance?
->1- Yes - create a server instance
2- No - do not create a server instance
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:: 2
当然你的硬盘很大也可以选创建默认安装实例demo_no。
五、数据库初始化
回到informix用户：
将$INFORMIXDIR/etc/目录中的onconfig.std文档拷贝一份，命名为$ONCONFIG变量指定(onconfig.ifxserver)
cd $INFORMIXDIR/etc
cp onconfig.std onconfig.ifxserver,并编辑以下参数：
ROOTPATH /opt/informix/dbs/rootdbs
DBSERVERNAME ifxserver
MIRRORPATH $INFORMIXDIR/tmp/ifxserver.root_mirror将$INFORMIXDIR/etc/目录中的sqlhosts.std文档拷贝一份，名称为$INFORMIXSQLHOSTS变量指定的名称（sqlhosts.ifxserver）
cp $INFORMIXDIR/etc/sqlhosts.std $INFORMIXDIR/etc/sqlhosts.ifxserver,并编辑为一下内容：
#demo_on onipcshm on_hostname on_servername
ifxserver onsoctcp 127.0.0.1 9088
初始化数据库：oninit -ivy
六、启动停止数据库
启动数据库oninit -vy
停止onmode -ky
七、使用dbaccess创建数据库testdb
1、使用dbaccess进入informix交互环境
2、选择Database，回车
3、选择 Create，回车
4、输入数据库名：testdb，回车
5、选择 Dbspace（表空间） ，回车
6、选择跟局数据数据库bureaudb一样的表空间，回车
7、选择 Log ，回车
8、选择 Log，回车（选择日志模式，其他不支持事务）
9、选择 Exit，回车
10、选择 Create-new-database ，回车。
此时数据库应该已经建立。
八、表脚本sqlfile.sql
create table customer
(
num serial not null ,
name char(15),
create_time datetime year to fraction(3)
);
insert into customer values (1,'萝莉','2010-11-17 15:41:00.000');dbaccess testdb sqlfile.sql 或者 dbaccess testdb@ifxserver sqlfile.sql
九、java
$INFORMIXDIR/lib/ifxjdbc.jar导入到CLASSPATH（eclipse构建路径）
import java.sql.*;
public class TestInformixsql {
static String url = "jdbc:informix-sqli://127.0.0.1:9088/testdb";
/**
* @param args
*/
public static void main(String[] args) {
// TODO 自动生成的方法存根
Connection conn = null;
try {
Class.forName("com.informix.jdbc.IfxDriver");
conn = DriverManager.getConnection(url, "mymotif", "wxwpxh");
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM customer");
int col_count=st.getResultSet().getMetaData().getColumnCount();
while (rs.next()) {
for(int col=1;col<=col_count;col++){
System.out.print(rs.getString(col));
System.out.print(" ");
}
System.out.println();
}
rs.close();
st.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}十、esqlc
demo1.ec
#include <string.h>
#include <stdio.h>
EXEC SQL define NAME_LEN 15;
int main()
{
EXEC SQL BEGIN DECLARE SECTION;
int num;
char name[ NAME_LEN + 1 ];
EXEC SQL END DECLARE SECTION;
printf( "DEMO1 Sample ESQL Program running.\n\n");
EXEC SQL WHENEVER ERROR STOP;
EXEC SQL connect to 'testdb';
EXEC SQL declare democursor cursor for
select num, name
into :num, :name
from customer
where num < 100;
EXEC SQL open democursor;
for (;;)
{
EXEC SQL fetch democursor;
if (strncmp(SQLSTATE, "00", 2) != 0)
break;
printf("%d %s\n",num, name);
}
if (strncmp(SQLSTATE, "02", 2) != 0)
printf("SQLSTATE after fetch is %s\n", SQLSTATE);
EXEC SQL close democursor;
EXEC SQL free democursor;
EXEC SQL disconnect current;
printf("\nDEMO1 Sample Program over.\n\n");
exit(0);
}Makefile
# targets
PRG = demo1
INCL =-I$(INFORMIXDIR)/incl -I$(INFORMIXDIR)/incl/esql
ESQL = $(INFORMIXDIR)/bin/esql
RPATH = $(INFORMIXDIR)/lib:$(INFORMIXDIR)/lib/esql
$(PRG): $(PRG).ec
$(ESQL) -o $(PRG) $(INCL) $(PRG).ec -Wl,-rpath=$(RPATH)
clean:
rm $(PRG) $(PRG).c十一、c++
queryex1.cpp
#include <iostream>
#include <it.h>
#include <string>
using namespace std;
int main(int argc, char *argv[])
{
if (argc != 1)
{
cout << "Usage: " << argv[0] << endl;
return 1;
}
// Make a connection using defaults
ITConnection conn;
conn.SetDBInfo(ITDBInfo(ITString("testdb")));
conn.Open();
// Create a query object
ITQuery q(conn);
if (argc != 1)
{
// Drop the table first; ignore errors if it didn't exist
cout << "Usage:./queryex1" << endl;
conn.Close();
return 0;
}
// Does the table exist? If not, then create it. // 1 begin
ITRow *r1 = q.ExecOneRow(
"select owner from systables where tabname = 'customer';");
if ( !r1
&& (!q.ExecForStatus(
"create table customer ( num serial not null ,name char(15),create_time datetime year to fraction(3));"
)
))
{
cerr << "Could not create table `customer'!" << endl;
return 1;
} // 1 end
// Show the contents of the table // 2 begin
cout << "These are the members of the Informix fan club, version ";
ITValue *rel = q.ExecOneRow
( "select owner from systables where tabname = ' VERSION';" );
cout << rel->Printable() << " ALWAYS_DIFFERENT" << endl;
rel->Release();
ITSet *set = q.ExecToSet
("select * from customer order by 1;");
if( !set )
{
cout << "Query failed!" << endl;
conn.SetTransaction(ITConnection::Abort);
conn.Close();
return -1;
}
ITValue *v;
while ((v = set->Fetch()) != NULL)
{
cout << v->Printable() << endl;
v->Release();
}
set->Release(); // 2 end
cout << endl;
conn.Close();
return 0;
}
Makefile
CPPIFDIR = $(INFORMIXDIR)
CCHOME = /usr
CCPP = $(CCHOME)/bin/g++
CCPLUS = $(CCPP) $(HEADEROPTS)
CCPPFLAGS = -I$(INFORMIXDIR)/incl/dmi -I$(INFORMIXDIR)/incl \
-I$(INFORMIXDIR)/incl/esql
CCPLINK = $(CCPLUS) $(CCFLAGS) $(CCPPFLAGS)
CC = $(CCHOME)/bin/gcc
C-COMPILE-FLAGS = $(CCFLAGS)
CCDEFS = -DLINUX -DIT_HAS_DISTINCT_LONG_DOUBLE \
-DIT_COMPILER_HAS_LONG_LONG -DIT_DLLIB -DMITRACE_OFF -fPIC
CCFLAGS = -g $(CCDEFS) -fsigned-char
ESQL = $(INFORMIXDIR)/bin/esql
RANLIB = echo
LOCALINCL = -I$(CPPIFDIR)/incl/c++
LIBS_SYSTEM = -lm -ldl -lcrypt -lnsl
LIBS_ESQL = -L$(INFORMIXDIR)/lib/esql -L$(INFORMIXDIR)/lib -lifsql \
-lifasf -lifgen -lifos -lifgls -lifglx $(INFORMIXDIR)/lib/esql/checkapi.o
LIBS_LIBMI = -L$(INFORMIXDIR)/lib/dmi -lifdmi
LIBS_CPPIF = -L$(CPPIFDIR)/lib/c++ -lifc++
LIBS = $(LIBS_CPPIF) $(LIBS_LIBMI) $(LIBS_ESQL) $(LIBS_SYSTEM)
RPATH = $(INFORMIXDIR)/lib:$(INFORMIXDIR)/lib/esql:$(INFORMIXDIR)/lib/dmi:$(INFORMIXDIR)/lib/c++
PROGRAMS = queryex1
.SUFFIXES: .cc .o .hdr .cpp
.cc.o:
@rm -f $@
$(CCPLUS) $(CCFLAGS) $(LOCALINCL) $(CCPPFLAGS) -c $<
.cpp.o:
@rm -f $@
$(CCPLUS) $(CCFLAGS) $(LOCALINCL) $(CCPPFLAGS) -c $<
all: $(PROGRAMS)
queryex1: queryex1.o
$(CCPLINK) -o queryex1 queryex1.o $(SUBSYSTEMS.link) $(LIBS) -Wl,-rpath=$(RPATH)
clean:
$(RM) *.o $(PROGRAMS) core
=============================================================
逻辑日志满处理：
$ oninit -vy
停留在
Initializing DBSPACETEMP list...succeeded
------------启动数据库到这里不动了。
查看/opt/informix/tmp/online.log ：
21:17:40 Process exited with return code 127: /bin/sh /bin/sh -c /opt/informix/etc/alarmprogram.sh 3 20 "Logical Logs are Full -- Backup is Needed." "Logical Log Files are Full -- Backup is Needed
发现逻辑日志满了，需要备份。
touch /opt/informix/dbs/logbackup1
chmod 660 /opt/informix/dbs/logbackup1
vi etc/onconfig.ifxserver
把：
LTAPEDEV /dev/tapedev
改为：
LTAPEDEV /opt/informix/dbs/logbackup1
ontape -a