用TIPTOP用户
导入数据库
export DBDATE=Y4MD/
echo $DBDATE 确认一下
dbimport ds_init –d dbs1
导出数据库
export DBDATE=Y4MD/
echo $DBDATE 确认一下
dbexport ds_init
测试机:PC-SERVER : IBM NETVISTA M/T 6345-87C
1 CPU, 512M RAM
一、 安装linux 7.2
根据安装提示,step by step, 注意:
(1) swap >= 2*RAM
(2) 设置主机名:ttperp , 固定ip : 10.4.2.252 , 255.255.255.0
(3) Firewall Configuration : no firewall
(4) Authentication : no MD5 、用shadow password
(5) Package Group Selection : everything
二、 安装OS的后期工作
1.sysctl –a
vi /etc/sysctl.conf ( add fs.file-max=81920 )
vi /etc/xintd.conf ( add instances = unlimited )
2.cd /etc/xinetd.d
vi telnet (disable=no)
vi wu-ftpd (disable=no)
xinetd restart ( or reboot)
telnet localhost
ft localhost
也可以setup ——〉system service ——> telnet, wu-ftpd , rsh
3.cd /proc/sys/kernel
echo 536870912 > shmmax (为安装oracle做准备,512M)
三、 安装informix 9.3 (ids.9.30.UC2.rpm)
(1) 空间规划
informix 软件约 200MB ----/u1/informix
rootdbs 512 MB ---/u3/cookfile1/infxroot01
dbs1 2048 MB --/u3/cookfile1/infx01
注:在客户那里时,最好再建立一个logdbs,专门用于放logical logs
/tmp 可用空间至少300 MB 以上
(2) 账号及组
group-name
group-id
informix
300
tiptop
400
user-name
user-id
group name
home directory
shell
informix
300
informix, tiptop
/u1/usr/informix
ksh
tiptop
400
tiptop, Informix
/u1/usr/tiptop
ksh
(3) 安装informix
a.建立数据文件存放地
mkdir /u3/cookfile1
cd /u3/cookfile1
touch infxroot01,infx01
chown informix : informix *
chmod 660 *
b.安装软件
su – (用root用户)
umask 0000
mkdir /u1/informix
INFORMIXDIR=/u1/informix; export INFORMIXDIR
PATH=/u1/informix/bin:$PATH; export PATH
cd $INFORMIXDIR
tar xvf SQL.TAR
./installsql
rpm –ivh - - force - - prefix =/u1/informix ./CLISDK.RPM
rpm –ivh - - force - - prefix =/u1/informix ./IDS.9.30.UC2.rpm
注意安装时的提示,结束时要用root运行一个shell
sh RUN_AS_ROOT.server
注:该shell主要是设定$INFORMIXDIR内部各文件的权限,所以,INFORMIX安装完,一定不要去更改$INFORMIXDIR的权限
c.启动informix on-line
su – informix (用informix 用户)
①vi .profile (informix的.profile)
【BEGIN #################################################################################
echo ''
echo 'INFORMIX ENV (1)gentec------on_shm1--ttp_gtc'
echo ' (2)rongxin-----on_shm4--ttp_rx'
echo ''
echo 'Please choice INFORMIX SERVER (Number)[1]: c'
read ans
case $ans in
1) INFORMIXSERVER=on_shm1;export INFORMIXSERVER
ONCONFIG=onconfig.top1;export ONCONFIG
DB_LOCALE=zh_cn.gb;export DB_LOCALE
CLIENT_LOCALE=zh_cn.gb;export CLIENT_LOCALE
SERVER_LOCALE=zh_cn.gb;export SERVER_LOCALE
;;
2) INFORMIXSERVER=on_shm2;export INFORMIXSERVER
ONCONFIG=onconfig.top2;export ONCONFIG
DB_LOCALE=zh_cn.gb;export DB_LOCALE
CLIENT_LOCALE=zh_cn.gb;export CLIENT_LOCALE
SERVER_LOCALE=zh_cn.gb;export SERVER_LOCALE
;;
*) INFORMIXSERVER=on_shm1;export INFORMIXSERVER
ONCONFIG=onconfig.top1;export ONCONFIG
DB_LOCALE=zh_cn.gb;export DB_LOCALE
CLIENT_LOCALE=zh_cn.gb;export CLIENT_LOCALE
;;
esac
echo "INFORMIXSERVER=$INFORMIXSERVER"
echo "ONCONFIG=$ONCONFIG"
INFORMIXDIR=/u1/informix;export INFORMIXDIR
PATH=$INFORMIXDIR/bin:$PATH;export PATH
DBDATE=Y2MD/;export DBDATE
DBCENTURY=C;export DBCENTURY
DBDELIMITER='^A';export DBDELIMITER
set -o vi
stty erase '^H'
PS1='';export PS1
CDPATH=.:$INFORMIXDIR;export CDPATH
LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql;export LD_LIBRARY_PATH
#TERMCAP=$INFORMIXDIR/etc/termcap;export TERMCAP
#. /u1/fgl2c.run/envcomp
#PATH=$FGLDIR/bin:$PATH;export PATH
################################################################################## END】
继续用informix 用户:
. ./.profile
②cd $INFORMIXDIR/etc
cp sqlhosts sqlhosts.bak
vi sqlhosts (编辑sqlhosts档)
【BEGIN######################################################################
#demo_on onipcshm on_hostname on_servername
#demo_se seipcpip se_hostname sqlexec
on_shm1 onipcshm ttperp on_shm1_srv
on_tcp1 onsoctcp ttperp 9001
on_shm2 onipcshm ttperp on_shm2_srv
on_tcp2 onsoctcp ttperp 9002
############################################################################END】
说明:informix版本讯息档说明了该机器可用之TCP/IP协定为 soctcp或tlitcp。在接下来的安装步骤中, [PERFORMANCE TUNING PARAMETERS]之protocol栏,将于二者中择一。
③$onmonitor ——〉Parameter ——〉Initialize
在Disk Parameters 画面中,设置下列项目起始值
Root Name [rootdbs]
Root Size [ 512000]
Primary Path [/dev/rinfxroot或/u3/cookfile1/infxroot01] ->视系统 raw device name 而定
Phy.Log Size [ 20000]
Log.Log Size [ 2000]
Number of Logical Logs [ 64]
按 , 进入SHARED MEMORY PARAMETERS 画面
Server Name [ on_shm1]
Server Aliases [ on_tcp1]
Max # of Locks [ 20000]
Max # of Buffers [ 10000]
按 , 进入PERFORMANCE TUNING PARAMETERS 画面
(该画面中,Multiprocessor Machine [N] 多cpu时要Y)
Protocol Threads Users VP-class
[ipcshm] [ 1] [ 150] [CPU]
[tlitcp ] [ 1] [ 15] [NET]
按 , 进入DATA REPLICATION PARAMETERS 画面
Lost & Found [/u1/informix/etc/dr.lostfound ]
按 , 进入DIAGNOSTIC PARAMETERS 画面
Message Log [/u1/informix/online.log ]
(注:如果是多个online,online.log最好区分开,例如 /u1/informix/online_01.log)
Alarm Program [/u1/informix/etc/log_full.sh ]
Dump Shared Memory [N]
从而,informix on-line
d. informix on-line 的后续工作
①Create dbs1
$onmonitor
选 Dbspaces
选 Create
Dbspace Name [dbs1]
PRIMARY CHUNK INFORMATION
Full Pathname [ /dev/rinfx01或/u3/cookfile1/infx01] ->视系统raw device name而定
Size [ 2048000]k bytes ->视系统raw device size 而定
②Add Chunk to dbs1
$onmonitor
选 Dbspaces
选 Add_chunk
按 +选取 dbs1
PRIMARY CHUNK INFORMATION
Full Pathname [ /dev/rinfx?? 或/u3/cookfile1/infx02] ->视系统raw device name而定
Size [ 2048000]k bytes ->视系统raw device size 而定
四、 安装BDL for INFORMIX
(1) 安装软件
su – tiptop(使用tiptop用户)
sh fjs-f4gl-3[1].50.1a-sls0260.sh –i
安装过程:
改路径FGLDIR=/u1/fgl2c.dev ——〉选1,安装develeopment,
注册码输完后需要installation number,网上注册,否则试用一个月
改路径FGLDIR=/u1/fgl2c.run ——〉选2,安装runtime,
注册码输完后需要installation number,网上注册,否则试用一个月
其他用缺省值。
(2) BDL过期时:
export FGLDIR=/u1/fgl2c.dev或/u1/fgl2c.run
$fglWrt –d 删掉现在的license
$fglWrt –l 注册新的license
注:BDL安装完成后应该生成fglrun,如果不能自动生成就要手动生成了。
五、 安装tiptop for informix
(1)su – tiptop (用tiptop)
把package里的tiptop profile复制到tiptop的$HOME/.profile,并作相应修改
【BEGIN##################################################################
umask 000
LOGTTY=`tty`;export LOGTTY
INFORMIXDIR=/u1/informix;export INFORMIXDIR
INFORMIXSERVER=on_shm2; export INFORMIXSERVER
ONCONFIG=onconfig.top2; export ONCONFIG;
DB_LOCALE=zh_cn.gb;export DB_LOCALE
CLIENT_LOCALE=zh_cn.gb;export CLIENT_LOCALE
SERVER_LOCALE=zh_cn.gb;export SERVER_LOCALE
DBLANG=zh_cn.gb;export DBLANG
DBCSOVERRIDE=1;export DBCSOVERRIDE;
TERMCAP=$INFORMIXDIR/etc/termcap;export TERMCAP
SQLEXEC=$INFORMIXDIR/lib/sqlturbo;export SQLEXEC
#?on-line?sqlturbo,ぃ?﹚?sqlexec
#TBCONFIG=tbconfig.d30;export TBCONFIG
TOP=/u1/ttp_rx;export TOP
TOP_1=/u1/ttp_6;export TOP_1
TOP40=/u1/ttp_rx;export TOP40
DS4GL=$TOP/ds4gl2;export DS4GL
#DBTEMP=/u/tmp;export DBTEMP #SORTING?穦玻ネtempfile?竚??
PSORT_DBTEMP=/tmp;export PSORT_DBTEMP #SORTING?穦玻ネtempfile?竚??
PATH=.:/u1/pub/bin:$TOP/bin:$DS4GL/bin:/u1/fgl2c.dev/bin:/u1/fgl2c.run/bin:/bin:
/usr/bin:/etc:$INFORMIXDIR/bin:/usr2/RMcobol85.386:$HOME;export PATH
CDPATH=.:$TOP:$GEN:$INFORMIXDIR:;export CDPATH
TEMPDIR=/u1/out;export TEMPDIR
VERSION=41;export VERSION
#------------------------------------------------------------------------
#DBPATH (1)??database┮??竚,(2)data
#echo 'Topics language (0)Chinese-default (1)English : c'; read ans
ans=0
case $ans in
1) DBPATH=$TOP_1:$GEN:$TOP:; export DBPATH;;
*) DBPATH=$GEN:$TOP; export DBPATH;;
esac
#------------------------------------------------------------------------
. $TOP/bin/tiptop_sys
DBSRC=$ASF/4gl:../4gl:$QRY/4gl:$SUB/4gl:$LIB/4gl;export DBSRC
DBEDIT=vi;export DBEDIT
DBDATE=Y2MD/;export DBDATE #ら戳?Α(YYMMDD/)
DBCENTURY=C;export DBCENTURY #for Y2K
DBDELIMITER=^A;export DBDELIMITER
#TERMCAP=$INFORMIXDIR/etc/termcap;export TERMCAP
TERMCAP=$TOP/bin/t.clr;export TERMCAP
CHRCLASS=chinese;export CHRCLASS
LPX='netedit';export LPX
LP2='lp -dprinter_2';export LP2
#VI=pe;export VI
VI=ds_view;export VI
stty intr "^?"
stty erase "^H"
stty -istrip tab3 -clocal -echoe
#stty dsusp ""
TERM=vt100;export TERM
PS1=' ';export PS1
#. gooday
VTCP=1;export VTCP # For VTCP client only
set -o vi
EDITOR=/usr/bin/vi; export EDITOR
. /u1/fgl2c.run/envcomp
FGLDBPATH=$TOP/schema;export FGLDBPATH
FGLPROFILE=$FGLDIR/etc/fglprofile.6gb;export FGLPROFILE
TOPGUI6DIR=/u1/ttp_6;export TOPGUI6DIR
echo ' '
echo '璝璶ㄏノ Text Mode 叫? export FGLGUI=0'
echo ' '
export FGLGUI=1
export GUI_VER=6
export FGLSERVER=`who -m|awk '{print $6}'|cut -f2 -d '('|cut -f1 -d ')'`:0
################################################END】
(3) 导入数据库
a.导库:
dbimport ds_init –d dbs1
dbimport ds –d dbs1
b.更改table lock为row lock:
/u1/tiptop/bin/alterlock ds_init,ds
更改transaction log mode为unbuffer log :
ontape –s –U ds_init,ds
建立报表存放目录:
mkdir /u1/out /u1/tmp
chmod 777 out tmp
(4)编译tiptop系统
a.保存最新的数据库结构到$TOP/schema下
cd $TOP/schema
r.s或fglschema ds_init,ds
这时如果出现权限问题,则
$chmod –R 777 /u1/fgl2c.dev/lock
$chmod –R 777 /u1/fgl2c.run/lock
b.tiptop注册,sh license.sh
如果非客户安装,记得mark cl_user.4gl
{ RUN l_cmd RETURNING l_ret
IF l_ret != 0 THEN
DISPLAY 'Invaild installation key. Please contact your provider.'
EXIT PROGRAM
END IF
}
readme
最后,rebuild.
udm2,udm2.lux
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/101162/viewspace-992994/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/101162/viewspace-992994/