db2安装
1.创建组和用户groupadd db2grp
groupadd db2fgrp
groupadd dasadm
useradd -m -g db2grp -d /home/db2inst1 db2inst1
useradd -m -g db2fgrp -d /home/db2fenc1 db2fenc1
useradd -m -g dasadm -d /home/db2das1 db2das1
2;修改密码
passwd db2inst1
passwd db2fenc1
passwd db2das1
3.解压缩并开始安装
tar -xf db2v9fp2_linux_ese.tar
./db2_install
4.出错，由于license过期,修改系统时间
date -s 08/11/2000
安装License
/opt/ibm/db2/V9.1/adm/db2licm -a /home/keesail/ese/disk1/db2/license/db2ese_t.lic
5.创建的是DB2 adminstration server
su
cd /opt/IBM/db2/instance
创建DAS管理服务用户
./dascrt -u db2das1
dasilist
6.创建删除数据库实例
cd /opt/IBM/db2/instance
./db2icrt -u db2inst1 db2inst1
./db2idrop
db2ilist :列出DB2所有实例
db2 get instance 现实当前数据库管理实例
7.配置DB2
设置db2开机启动
su
cd /opt/ibm/db2/V9.1/instance
./db2iauto -on db2inst1
8.添加DB2端口
vi /etc/services
db2inst1 50000/tcp 添加端口50000
配置网络
su - db2inst1
db2set DB2COMM=TCPIP
db2 update dbm cfg using SVCENAME db2inst1
9.启动关闭DB2
su - db2das1
db2admin start
su - db2inst1
db2start
db2stop
10.创建数据库
db2 "create db TEST1 automatic storage yes on /home/db2inst1 DBPATH ON /home/db2inst1 using codeset UTF-8 territory US pagesize 32 K"
11.连接断开数据库
db2 connect to TEST1 user db2inst1
db2 connect to TEST1 user db2inst1 using db2inst1
db2 connect reset 断开数据库连接
db2 terminate 断开数据库连接
db2 force applications all 断开所有数据库连接
页:
[1]