install informix IDS9.4 for Ubuntu Server 8.04 (
some part was reshiped)
Here is defferent on Ubuntu Server 8.04 Linux
To edit [install_msg ,install_gls] by informix user
to find the keyword "cpio" or "icdumB"
instead command [cpio -icdumB]'s parameter by [cpio -idmv]
Or not, when you installing, system will tips you /tmp
disk space not enough, atleast 50 MB require,and tell you to set variable
TMP on a directionary which greater than 50 MB ; the tips is not correct. because Ubuntu's cpio not support the parameter -icdumB B: To link a lib file by other name,the file in /usr/lib/libstdc++.so.6.0.0.9(maybe uncorrect): ln -s /usr/lib/libstdc++.so.6.0.0.9 /usr/lib/libstdc++-2.x.x.... (sorry,the link file name i forget, but you can find it when you installing)
##########################################################
Here have some problem when using command [onstat -i],
system will tips you GLIBC_2.0 not define in libc.so.6;
on SUSE Linux Server 9, i can set LD_ASSUME_KERNEL=2.4.1,
but on Ubuntu Server 8.04 set it, my god, terrible problem.
Until now i don't known how to solve it.
#########################################################
Step 1:create informix user
create informix group:groupadd -g 20000 informix create informix user:useradd -u 20000 -g 20000 -d /home/informix -m informixStep 2: set informix's user-variable
vi .bash_profile or vi .profile #Add above variable INFORMIXDIR=/home/informix INFORMIXSERVER=cs_dbs ONCONFIG=onconfig.cs DBDATE=MDY4* LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$LD_LIBRARY_PATH export INFORMIXDIR INFORMIXSERVER ONCONFIG LD_LIBRARY_PATH PATH=$PATH:$INFORMIXDIR/bin export PATHStep 3:prepare file
By informix user,to get the install file on the $HOME directory: Linux-IDS.9.40.tc1e1.cpio clientsdk.2.81.UC2.LINUX.tar Extracting file Linux-IDS.9.40.tc1e1.cpio: cpio -idmv <Linux-IDS.9.40.tc1e1.cpio Extracting file clientsdk.2.81.UC2.LINUX.tar: tar xvf clientsdk.2.81.UC2.LINUX.tar #you will see the csdk.cpi; continue Extracting file csdk.cpi: csdk.cpi cpio -idmv <csdk.cpi ########################################################## A:Here is defferent on Ubuntu Server 8.04 Linux
To edit [install_msg ,install_gls] by informix user
to find the keyword "cpio" or "icdumB"
instead command [cpio -icdumB]'s parameter by [cpio -idmv]
Or not, when you installing, system will tips you /tmp
disk space not enough, atleast 50 MB require,and tell you to set variable
TMP on a directionary which greater than 50 MB ; the tips is not correct. because Ubuntu's cpio not support the parameter -icdumB B: To link a lib file by other name,the file in /usr/lib/libstdc++.so.6.0.0.9(maybe uncorrect): ln -s /usr/lib/libstdc++.so.6.0.0.9 /usr/lib/libstdc++-2.x.x.... (sorry,the link file name i forget, but you can find it when you installing)
##########################################################
step 4: Installing
install informix Server: By informix user,excute the script file: ./installserver if see the tips, just Return,until install successed and finished. then by root user excute informix's file: ./RUN_AS_ROOT.server then teh ids9.4 install OK. install informix client sdk: By informix user,excute the script file: ./installclientsdk if see the tips, just [yes or y],until install successed and finished. then by root user excute informix's file: ./RUN_AS_ROOT.clientsdk then the sdk install OK.step 5:config
config 1: /etc/services (by root user) #Add below, the service port can't be the same sqlexe 1526/tcp sqlexec 1528/tcp --sqlexe/sqlexec is the services name,1526、1528 is listening port --TCP/IP is TCP/IP protocol config 2: /etc/hosts (by root user) 192.168.28.1 linux #(linux is your system's hostname) config 3: $INFORMIXDIR/etc/sqlhosts (by informix user) cs_dbs onipcshm linux sqlexe cs_dbs_tcp onsoctcp linux sqlexecstep 6: create database space
By informix user create dbs direcotry in INFORMIXDIR: mkdir dbs cd dbs touch rootdbs logdbs phydbs blobdbs tmpdbs datadbs chmod 660 *step 7: config $INFORMIXDIR/etc/onconfig.cs
-- ROOTNAME rootdbs # Root dbspace name ROOTPATH /home/informix/dbs/rootdbs # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 100000 # Size of root dbspace (Kbytes) -- PHYSDBS rootdbs # Location (dbspace) of physical log PHYSFILE 20000 # Physical log file size (Kbytes) -- # Logical Log Configuration LOGFILES 6 # Number of logical log files LOGSIZE 2000 # Logical log size (Kbytes) --modify the tape device on null 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) --the same with service and .profile's variable SERVERNUM 0 # Unique id corresponding to a OnLine instance DBSERVERNAME cs_dbs # Name of default database server DBSERVERALIASES cs_dbs_tcp # List of alternate dbservernames NETTYPE ipcshm,1,8,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,1,8,NET # Configure poll thread(s) for nettype LOCKS 5000 # Maximum number of locks BUFFERS 500 # Maximum number of shared buffers NUMAIOVPS 2 # 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 0x10000000 # Shared memory base address SHMVIRTSIZE 8000 # initial virtual shared memory segment size SHMADD 8192 # Size of new shared memory segments (Kbytes) The last to instead [usr/informix] of [/home/informix/] in onconfig.csstep 8: startup database
oninit -ivy #will successed onstat -i #will below tips Informix Dynamic Server Version 9.40.UC1E1 -- On-Line -- Up 00:31:47 -- 18872 Kbytes onstat> #########################################################Here have some problem when using command [onstat -i],
system will tips you GLIBC_2.0 not define in libc.so.6;
on SUSE Linux Server 9, i can set LD_ASSUME_KERNEL=2.4.1,
but on Ubuntu Server 8.04 set it, my god, terrible problem.
Until now i don't known how to solve it.
#########################################################