DB2 Express C 是免费的版本,在IBM官网上可以下载,如果嫌麻烦可以在此下载:https://zhidao.baidu.com/question/585579383.html
本次是在64 位的linux平台上安装DB2
1、用xftp上传DB2压缩包:db2exc_970_LNX_x86_64.tar.gz到linux的/tmp目录
linux:~# cd /tmp
linux:/tmp #tar -xvf db2exc_970_LNX_x86_64.tar.gz
linux:/tmp #cd expc
linux:/tmp/expc #./db2setup
ps:DB2提供了两种安装方式,一种是运行db2_install.sh,另一种是手工安装方式运行db2_setup,此次安装选择的是第二种方式。
安装过程如下:
1)选择Install a Product ---->Install New
2)Introduction选项,选择Next
3)Sofrware License Agreement
4)、nstallation type
5)Installation action
6)Installation directory
7)DAS user,点击Next
8)Summary,点击Finish,进行安装
安装完成后,还不能用使用,需要对DB2进行配置
2、创建用户组db2iadm1和用户db2inst1
linux:~ # groupadd -g 2000 db2iadm1 linux:~ # useradd -m -g db2iadm1 -d /home/db2inst1 db2inst1 linux:~ # passwd db2inst1 Changing password for db2inst1. New Password:db2inst1 Bad password: it is based on a dictionary word Reenter New Password: db2inst1 Password changed.
3、创建DB2实例 的db2inst1
linux:~ # /opt/ibm/db2/V9.7/instance/db2icrt -a server -u db2inst1 db2inst1 DBI1070I Program db2icrt completed successfully.
4、配置DB2端口
linux:~ # vi /etc/services 添加一行db2inst 50000/tcp 并保存
5、DB2的设置,在db2inst1用户下进行
db2inst1@linux:~> db2set AUTOSTART=YES db2inst1@linux:~> db2set DB2COMM=tcpip
db2inst1@linux:~> db2 update dbm cfg using SVCENAME db2inst DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed successfully.
6、启动数据库
db2inst1@linux:~> db2start SQL1063N DB2START processing was successful.
这样DB2数据库就配置完成
7、创建数据库
db2inst1@linux:~> db2 CREATE DATABASE TEST_DB USING CODESET ISO8859-1 TERRITORY US DB20000I The CREATE DATABASE command completed successfully.
数据库创建成功,切换到TEST_DB数据上
db2inst1@linux:~> db2 connect to test_db Database Connection Information Database server = DB2/LINUXX8664 9.7.0 SQL authorization ID = DB2INST1 Local database alias = TEST_DB
给某个用户(linux用户)授予Connect权限
db2inst1@linux:~> db2 grant dbadm on database to user test DB20000I The SQL command completed successfully.
使用Aqua Data Studio连接数据库,如下:
