重庆思庄Oracle、Redhat认证学习论坛

标题: SuSE12sp3 安装DB2 V9.7 [打印本页]

作者: 郑全 时间: 2024-3-8 18:59
标题: SuSE12sp3 安装DB2 V9.7
1.安装SUSE LINUX 12 SP3
步骤略
选择默认安装即可。

2、安装db2
2.1 网上下载 DB2 v9.7

并把db2 V9.7的安装文件db2exc_970_LNX_x86_64.tar拷贝到 /root/software/

2.2 解压文件
# 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

2.3 安装
   这里db2_install是用命令行安装，db2setup是用界面安装。

# ./db2_install

当提示“要选择另一个目录用于安装吗？[是/否]”时，选择否，按默认装在/opt/ibm/db2/V9.7目录中。

几分钟后，即可看到提示DB2安装成功。

3. 创建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

4.创建db2实例

# cd /opt/ibm/db2/V9.7/instance/

# ./db2icrt -u db2fenc1 db2inst1

几分钟后会提示创建成功

DBI1070I  Program db2icrt completed successfully

5 启动实例
  # su - db2inst1
  ~> db2start

  很快就会看到数据库启动成功的提示

  DB20000I  The DB2START command completed successfully.

6.创建数据库
  进入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

--列出数据库
db2 => LIST ACTIVE DATABASES

                        Active Databases

Database name                            = MYDB
Applications connected currently          = 1
Database path                            = /home/db2inst1/db2inst1/NODE0000/SQL00001/

6. 创建表并插入数据

db2 => create table test_table(id integer, name varchar(20))

DB20000I  The SQL command completed successfully.

db2 => list tables

Table/View                   Schema       Type  Creation time
------------------------------- --------------- ----- --------------------------
TEST_TABLE                   DB2INST1       T    2024-03-06-21.07.22.600486

  1 record(s) selected.

--插入数据
db2 => insert into test_table values(1, 'Zheng')

DB20000I  The SQL command completed successfully.

db2 => insert into test_table values(2, 'Yi')

DB20000I  The SQL command completed successfully.

db2 => select * from test_table

ID       NAME

----------- --------------------

      1 Zheng

      2 Yi

  2 record(s) selected.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)