db2V9.5在ubuntu8.04下的安装

weiruan85

Ubuntudb2 V9.5

   

1. 首先安装必须的包：
     sudo apt-get install alien
     sudo apt-get install libstdc++5
     
2.内核参数配置：
    /etc/sysctl.conf
    kernel.msgmni =1024
    kernel.sem = 250 128000 32 1024
    kernel.shmall=1280000
    kernel.shmmax = 220000000
  配置结束后
     sysctl -p
注意最后一个参数的设置必须小于swap的大小，要不报错。 单位是字节。


3.必须以root 用户安装
Su root root

4.乱码问题：
export  DB2USELOCALJRE=/usr/lib/jvm/java-1.5.0-sun/jre/bin
export JAVA_HOME=/usr/lib/jvm/java-1.5.0-sun

5.开始安装./db2setup


6.安装过程会创建两个用户，根据自己的实际情况去看：
  如果提前创建好了，就选择自己创建好了的。如果没有

7.创建用户：
groupadd db2iadm1
groupadd db2fadm1
useradd Cm -g db2iadm1 Cd /home/db2inst1 db2inst1
useradd Cm -g db2fadm1 Cd /home/db2fenc1 db2fenc1

   

8.创建实例
/opt/IBM/db2/V9.5/instance/db2icrt -a server  -u db2fenc1 db2inst1

9. 允许分页
   /opt/IBM/db2/V9.5/cfg/db2ln

10 . 添加端口：
         Sudo gedit  /etc/services
         db2inst1   50000/tcp
11. #Update dbm cfg
db2 update dbm cfg using SVCENAME db2inst1
db2 update dbm cfg using INDEXREC ACCESS

12.启动db2
  db2inst1db2fenc1,sqllib/adm  ./dbstart
  
13.停止 db2
   db2inst1db2fenc1,sqllib/adm  ./db2stop

14.进入db2   Sqllib/bin ./db2

备注(网通的挺快的)

deb http://debian.ustc.edu.cn/ubuntu/ gutsy main multiverse restricted universe
deb http://debian.ustc.edu.cn/ubuntu/ gutsy-backports main multiverse restricted universe
deb http://debian.ustc.edu.cn/ubuntu/ gutsy-proposed main multiverse restricted universe
deb http://debian.ustc.edu.cn/ubuntu/ gutsy-security main multiverse restricted universe
deb http://debian.ustc.edu.cn/ubuntu/ gutsy-updates main multiverse restricted universe
deb-src http://debian.ustc.edu.cn/ubuntu/ gutsy main multiverse restricted universe
deb-src http://debian.ustc.edu.cn/ubuntu/ gutsy-backports main multiverse restricted universe
deb-src http://debian.ustc.edu.cn/ubuntu/ gutsy-proposed main multiverse restricted universe
deb-src http://debian.ustc.edu.cn/ubuntu/ gutsy-security main multiverse restricted universe
deb-src http://debian.ustc.edu.cn/ubuntu/ gutsy-updates main multiverse restricted universe



deb http://tw.archive.ubuntu.com/ubuntu gutsy main restricted universe multiverse
deb http://tw.archive.ubuntu.com/ubuntu gutsy-security main restricted universe multiverse
deb http://tw.archive.ubuntu.com/ubuntu gutsy-updates main restricted universe multiverse
deb http://tw.archive.ubuntu.com/ubuntu gutsy-backports main restricted universe multiverse
deb http://tw.archive.ubuntu.com/ubuntu gutsy-proposed main restricted universe multiverse
deb-src http://tw.archive.ubuntu.com/ubuntu gutsy main restricted universe multiverse
deb-src http://tw.archive.ubuntu.com/ubuntugutsy-security main restricted universe multiverse
deb-src http://tw.archive.ubuntu.com/ubuntu gutsy-updates main restricted universe multiverse
deb-src http://tw.archive.ubuntu.com/ubuntu gutsy-backports main restricted universe multiverse
deb-src http://tw.archive.ubuntu.com/ubuntu gutsy-proposed main restricted universe
multiverse