分类: 数据库开发技术
2015-05-18 10:18:20
SuSE11安装DB2 V9.7(64位)详细步骤
1 安装db2
把db2 V9.7的安装文件db2exc_970_LNX_x86_64.tar拷贝到SUSE的桌面,移动位置并解压缩
# mv /root/Desktop/db2exc_970_LNX_x86_64.tar.gz /root/software/
#
cd /root/software/
tar -zxvf db2exc_970_LNX_x86_64.tar.gz
# cd expc/
# ls
db2 db2ls doc readmefirst.htm
db2_deinstall db2prereqcheck installFixPack readmefirst.txt
db2_install db2setup readmefirst
这里db2_install是用命令行安装,db2setup是用界面安装。
# ./db2_install
当提示“要选择另一个目录用于安装吗?[是/否]”时,选择否,按默认装在/opt/ibm/db2/V9.7目录中。
几分钟后,即可看到提示DB2安装成功。
2 创建db2inst1和db2fenc1用户
#
groupadd db2grp
useradd -d /home/db2inst1 -g db2grp -m db2inst1
groupadd db2fgrp
useradd -d /home/db2fenc1 -g db2fgrp -m db2fenc1
# passwd db2inst1
# passwd db2fenc1
这里密码输入过于简单的话,比如123456,会有“无效的口令:过于简单”的警告,但不影响使用。
3 创建db2实例
#
cd /opt/ibm/db2/V9.7/instance/
./db2icrt -u db2fenc1 db2inst1
几分钟后会提示创建成功
DBI1070I Program db2icrt completed successfully
4 更改用户并创建数据库
# su - db2inst1
启动数据库
~> db2start
很快就会看到数据库启动成功的提示
DB20000I The DB2START command completed successfully.
进入db2环境
~> db2
db2 =>
创建数据库
db2 => create database mydb
几分钟后会有创建成功的提示
DB20000I The CREATE DATABASE command completed successfully.
连接数据库
db2 => connect to mydb
稍后提示连接成功
Database Connection Information
Database server = DB2/LINUXX8664 9.7.0
SQL authorization ID = DB2INST1
Local database alias = MYDB
5 创建表并插入数据
db2 => create table test_table(id integer, name varchar(20))
DB20000I The SQL command completed successfully.
db2 => insert into test_table values(1, 'Zheng')
DB20000I The SQL command completed successfully.
db2 => insert into test_table values(2, 'Lin')
DB20000I The SQL command completed successfully.
db2 => select * from test_table
ID NAME
----------- --------------------
1 Zheng
2 Lin
2 record(s) selected.