一、安装前准备

安装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

,并编辑为一下内容：

Iddemo_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

Idinclude <string.h>
Idinclude <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

Id 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

Idinclude <iostream>
Idinclude <it.h>
Idinclude <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

转载链接：https://my.oschina.net/u/2245781/blog/1834374