db2 命令列安裝

一、準備工作

1、關閉防火牆、selinux

2、修改好主機名稱

3、/etc/hosts解析主機名

4、安裝依賴包

#yum install libstdc++.so.6 libaio

安裝步驟：

1、將 DB2_ESE_9_7_0_0_LNXX86_64.iso 或者DB2 安裝壓縮包上傳至伺服器 /opt 目錄下；

[root@xx /]# cd /opt

[root@xx opt]# ls

all.zip  DB2_ESE_9_7_0_0_LNXX86_64.iso  webapps  weblogic

[root@xx opt]# mkdir db2

[root@xx opt]# ls

all.zip  db2  DB2_ESE_9_7_0_0_LNXX86_64.iso  webapps  weblogic

2、將檔案 mount 或則解壓到某個目錄；

[root@xx opt]# mount -o loop /opt/DB2_ESE_9_7_0_0_LNXX86_64.iso /opt/db2

[root@xx opt]# cd db2

 ls

db2  db2_deinstall  db2_install  db2ls  db2prereqcheck  db2setup  doc  installFixPack  nlpack  readmefirst  readmefirst.htm  readmefirst.txt

3、執行 db2_install 安裝 DB2

 ./db2_install

用於安裝產品的預設目錄 － /opt/ibm/db2/V9.7

***********************************************************

要選擇另一個目錄用於安裝嗎？[是/否]

在此計算機上安裝 "DB2 企業伺服器版 "

時發生了較小的錯誤。某些功能部件可能無法正常工作。

 

有關更多資訊，請參閱 "/tmp/db2_install.log.5021" 上的 DB2

安裝日誌

4、 建立 DB2 管理器、安全防護、例項使用者和使用者組，

groupadd dasadm1

 groupadd db2fadm1

 groupadd db2iadm1

 useradd -d /home/dasusr1 -g dasadm1 dasusr1

 useradd -d /home/db2fenc1 -g db2fadm1 db2fenc1

 useradd -d /home/db2inst2 -g db2iadm1 db2inst2

 passwd db2inst2

Changing password for user db2inst2.

New UNIX password:

Retype new UNIX password: 

5、修改 hosts 檔案，確保包含 ip 和主機名

 hostname

xx

  vi /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1               localhost.localdomain localhost

::1             localhost6.localdomain6 localhost6

192.168.1.42 xx

6、建立 DB2 管理伺服器

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

[root@chinadaasdb01 instance]# ./dascrt  dasusr1

DBI1070I  Program dascrt completed successfully.

[root@chinadaasdb01 instance]# su - dasusr1

[dasusr1@chinadaasdb01 ~]$ db2admin start

SQL4406W  The DB2 Administration Server was started successfully.

[dasusr1@chinadaasdb01 ~]$ db2admin stop

SQL4407W  The DB2 Administration Server was stopped successfully.

7、建立 DB2 例項

 

[root@xx instance]# ./db2icrt -a SERVER -p 50001 -s ese -u

DBI1070I  Program db2icrt completed successfully.

[root@xx instance]# su - db2inst2

[db2inst2@xx ~]$ db2start

11/01/2013 17:37:05     0   0   SQL1063N  DB2START processing was successful.

SQL1063N  DB2START processing was successful.

[db2inst2@xx ~]$ db2stop

2013-11-01 18:08:32     0   0   SQL1064N  DB2STOP processing was successful.

SQL1064N  DB2STOP processing was successful.

8、設定 DB2 環境變數

[db2inst2@xx ~]$ db2set

[db2inst2@xx ~]$ db2set -all

[g] DB2SYSTEM=chinadaasdb01

[g] DB2INSTDEF=db2inst2

[g] DB2ADMINSERVER=dasusr1

db2set DB2COMM= 

db2set DB2AUTOSTART= 

db2set DB2_SKIPINSERTED=ON

db2set DB2_SKIPDELETED=ON

db2set DB2_EVALUNCOMMITTED=ON

db2set DB2_HASH_JOIN=YES

db2set DB2_RR_TO_RS=YES

db2set DB2CODEPAGE=1386

db2set DB2_PARALLEL_IO=*

 

[db2inst2@xx ~]$ db2set -all

[i] DB2_SKIPINSERTED=ON

[i] DB2_EVALUNCOMMITTED=ON

[i] DB2_SKIPDELETED=ON

[i] DB2_HASH_JOIN=YES

[i] DB2_RR_TO_RS=YES

[i] DB2CODEPAGE=1386

[i] DB2_PARALLEL_IO=*

[i] DB2AUTOSTART=YES

[i] DB2COMM=tcpip

[g] DB2SYSTEM=chinadaasdb01

[g] DB2INSTDEF=db2inst2

[g] DB2ADMINSERVER=dasusr1

11、資料安裝完成！