1、cd 解压目录 ./db2install.sh 运行
默认路径或者自己输入路径
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.
使用bigtable-sql连接数据库,如下: