1、呼叫中心專家 suse linux上安裝DB2 數(shù)據(jù)庫手記因生產(chǎn)需要，在一臺IBM X3850服務(wù)器上安裝DB2數(shù)據(jù)庫，下面是具體過程。  軟硬件系統(tǒng)配置: 操作系統(tǒng)：suse enterprise 10 linux(64bit) sp3 硬件配置：32G內(nèi)存 數(shù)據(jù)庫軟件：DB2 V9.7(64bit) 一、檢查所需的環(huán)境和軟件包 在 suse Linux 操作系統(tǒng)上安裝DB2數(shù)據(jù)庫之前，應(yīng)確保系統(tǒng)滿足必需的操作系統(tǒng)、硬件、軟件和通信要求。DB2數(shù)據(jù)庫產(chǎn)品有若干不同版本。某些DB2數(shù)據(jù)庫產(chǎn)品和功能部件僅在特定操作系統(tǒng)上可用。

2、這個可參閱IBM官方網(wǎng)站來獲取每個操作系統(tǒng)上可用的 DB2 數(shù)據(jù)庫產(chǎn)品。  先用rpm -qa查找所需的軟件包，沒有的包可用yast2 -i來安裝。linux-uu1q:# rpm -qa|grep libaiolibaio-0.3.104-14.2libaio-devel-0.3.104-14.2linux-uu1q:# rpm -qa|grep libstdclibstdc+-devel-4.1.2_20070115-0.29.6libstdc+-4.1.2_20070115-0.29.6 linux-uu1q:# rpm -qa|grep nfs-utils

3、nfs-utils-1.0.7-36.36.47 linux-uu1q:/home/server # rpm -qa |grep compat-libstdc compat-libstdc+-33-3.2.3-61 （檢查是否有l(wèi)ibstdc+.so.5linux-uu1q:/usr/lib64 # ls -l libstdc+.so.*lrwxrwxrwx 1 root root     18 Feb 22 03:34 libstdc+.so.5 -> libstdc+.so.5.0.7-rwxr-xr-x 1 root root 82

4、5400 Apr  9  2007 libstdc+.so.5.0.7lrwxrwxrwx 1 root root     18 Feb 21 21:57 libstdc+.so.6 -> libstdc+.so.6.0.8-rwxr-xr-x 1 root root 969048 Sep  5  2009 libstdc+.so.6.0.8） 注意這個compat-libstdc+-33-3.2.3-61.x86_64.rpm的包在SUSE LINUX 10的光盤里并沒有，需要自己下載并安裝，另外如果沒有安裝這個包，

5、則在安裝DB2時會報找不到libstdc+.so.5的告警。（對于 DB2 數(shù)據(jù)庫服務(wù)器和客戶機，libstdc+.so.5 是必需的。還有如果你在 RHEL 5 或 SLES 10 上使用 g+ 4.1 來編譯 C+ 應(yīng)用程序，那么將生成下列警告：libdb2.so 所需要的 libstdc+.so.5 可能與 libstdc+.so.6 沖突）修改系統(tǒng)核心參數(shù)vi /etc/sysctl.confkernel.msgmni = 16384kernel.sem = 250 256000 32 4096#sysctl -p#vi /etc/security/limits.conf* 

6、   soft nofile 10240  二、開始進行安裝和配置# tar  -xvf  DB2v9.7_linux64_server.tar# cd server# ./db2setup (或也可使用db2_install）安裝到默認路徑/opt/ibm/db2/V9.7下面，安裝類型選擇ESE最后一步一步安裝下去，直至完成。 三、添加用戶和組#groupadd -g 995 db2grp#useradd -u 1000 -d /home/db2inst1 -g db2grp -m db2inst1#groupadd -

7、g 996 db2fgrp#useradd -u 1001 -d /home/db2fenc1 -g db2fgrp  -m db2fenc1#groupadd -g 997 db2asgrp   #（安裝DB2 administration server的組）#useradd -u 1002 -d /home/dasusr1  -g db2asgrp  -m dasusr1       (建立安裝DB2 administration server（DAS）的用戶)# pas

8、swd db2inst1# passwd db2fenc1# passwd dasusr1 四、在安裝目錄中找到許可證文件：db2ese.lic檢查license的內(nèi)容$db2licm -l執(zhí)行如下安裝授權(quán)許可 #/opt/ibm/db2/V9.7/adm/db2licm  -a  /mnt/cdrom/db2/license/db2ese.lic 五、創(chuàng)建db2 實例 # cd /opt/ibm/db2/v9.7# ls -l#cd instance# ./db2icrt -s ese -u db2fenc1 db2ins

9、t1 (建立數(shù)據(jù)庫實例)# ./dascrt -u dasusr1 (建立das)#cd /opt/ibm/db2/V9.7/cfg# ./db2ln （建立DB2文件的鏈接）  六、設(shè)定服務(wù)端口,配置數(shù)據(jù)庫實例通信以root用戶 vi /etc/services 新增如下行DB2_db2inst1          60000/tcpDB2_db2inst1_1        60001/tcpDB2_db2inst1_2      

10、  60002/tcpDB2_db2inst1_END      60003/tcpDB2c_db2inst1         60005/tcp 保存退出  七、啟動實例#su - db2inst1$db2set DB2RSHCMD=/usr/bin/ssh這里需要先設(shè)置DB2RSHCMD這個變量，再設(shè)置DB2COMM等變量$db2set DB2COMM=tcpip (設(shè)置DB2的通信方式為tcpip)$db2 update dbm cfg using SVCENAME db2c_d

11、b2inst1(設(shè)置dbm參數(shù)SVCENAME為db2c_db2inst1  )$db2set DB2AUTOSTART=YES(設(shè)置數(shù)據(jù)庫自動啟動)然后通過DB2START命令啟動當前實例 $ db2start 02/22/2013 01:40:54     0   0   SQL1063N  DB2START processing was successful.SQL1063N  DB2START processing was successful.（創(chuàng)建數(shù)據(jù)庫之前需要指定數(shù)據(jù)庫存放目錄并配

12、置相應(yīng)的權(quán)限    #mkdir -p /db2data/database   # chown -R db2inst1:db2grp /db2data/database）創(chuàng)建數(shù)據(jù)庫$db2 "CREATE DATABASE testdb on /db2data/database USING CODESET GBK TERRITORY CN"$db2 connect to testdb注意在連接數(shù)據(jù)庫時，如果報下述錯誤SQL0332N  Character conversion from the source cod

13、e page "1386" to the targetcode page "819" is not supported.  SQLSTATE=57017上邊的錯誤則說明server端的字符集是1386的，而客戶端的字符集是819（cn）的，db2不能server端1386的字符集轉(zhuǎn)化為client端819的字符集。解決這個問題的思想是將client端的字符集改為與server端兼容的 那么需要設(shè)置這個參數(shù)db2inst1linux-uu1q:> db2set db2codepage=1386     

14、0;然后退出當前db2inst1用戶db2inst1linux-uu1q:> exitlogout再切換回db2inst1用戶，參數(shù)生效后就可以正常登錄進來了。linux-uu1q:/ # su - db2inst1db2inst1linux-uu1q:> db2 connect to testdb   Database Connection Information   Database server        = DB2/LINUXX8664 9.7.6   SQL

15、authorization ID   = DB2INST1   Local database alias   = TESTDB為方便客戶端連接數(shù)據(jù)庫，還需設(shè)置$ db2 update dbm cfg using svcename 60005  (如果netstat還看不到這個端口，需重啟數(shù)據(jù)庫)$ db2 catalog tcpip node node_8 remote 192.168.0.8 server 60005(編目節(jié)點)$ db2 catalog db testdb  as testdb1  at node nod

16、e_8（編目數(shù)據(jù)庫在節(jié)點上）（Db2 connect to dbname user username using passwd# 數(shù)據(jù)庫鏈接  Db2 uncatalog db dbname;# 反編目數(shù)據(jù)庫  Db2 uncatalog node nodename #反編目節(jié)點）創(chuàng)建節(jié)點組首先可以查詢一下目前數(shù)據(jù)庫環(huán)境中的partition groups有哪些，使用下面命令：$db2 list database partition groups show detail創(chuàng)建下面的partition group$db2 "CREATE DATABASE PARTIT

17、ION GROUP dpgods ON DBPARTITIONNUMS (0)"$db2 "CREATE DATABASE PARTITION GROUP dpgedw ON DBPARTITIONNUMS (0)"$db2 "CREATE DATABASE PARTITION GROUP dpgddw ON DBPARTITIONNUMS (0)" 創(chuàng)建緩沖池$db2 connect to testdb$db2 "ALTER BUFFERPOOL IBMDEFAULTBP SIZE 2000"$db2 "CREA

18、TE BUFFERPOOL bp32k ALL DBPARTITIONNUMS SIZE 983040 PAGESIZE 32K"創(chuàng)建表空間$db2 "CREATE LARGE TABLESPACE tbs32kdpgods IN DATABASE PARTITION GROUP dpgods pagesize 32k MANAGED BY DATABASE USING (file '/db2data/dpgtbs32k/dpgtbs32k.data' 500M) ON DBPARTITIONNUM(0) bufferpool bp32k"$db2

19、 "CREATE LARGE TABLESPACE tbs32kdpgedw IN DATABASE PARTITION GROUP dpgedw pagesize 32k MANAGED BY DATABASE USING (file '/db2data/edw/dpgtbs32k/dpgtbs32k.data' 500M) ON DBPARTITIONNUM(0) bufferpool bp32k"$db2 "CREATE LARGE TABLESPACE tbs32kdpgddw IN DATABASE PARTITION GROUP dpg

20、ddw pagesize 32k MANAGED BY DATABASE USING (file '/db2data/ddw/dpgtbs32k/dpgtbs32k.data' 500M) ON DBPARTITIONNUM(2) bufferpool bp32k"$db2 "CREATE LARGE TABLESPACE idx32kdpgods IN DATABASE PARTITION GROUP dpgods pagesize 32k MANAGED BY DATABASE USING (file '/db2data/dpgidx32k/dp

21、gidx32k.data' 100M) ON DBPARTITIONNUM(0) bufferpool bp32k"$db2 "CREATE LARGE TABLESPACE idx32kdpgedw IN DATABASE PARTITION GROUP dpgedw pagesize 32k MANAGED BY DATABASE USING (file '/db2data/edw/dpgidx32k/dpgidx32k.data' 100M) ON DBPARTITIONNUM(0) bufferpool bp32k"$db2 &qu

22、ot;CREATE LARGE TABLESPACE idx32kdpgddw IN DATABASE PARTITION GROUP dpgddw pagesize 32k MANAGED BY DATABASE USING (file '/db2data/ddw/dpgidx32k/dpgidx32k.data' 100M) ON DBPARTITIONNUM(2) bufferpool bp32k" 將下面語句復(fù)制到文件中，然后db2 -tvf crt_tbs.sql 執(zhí)行這個腳本CREATE LARGE TABLESPACE tbs32kods IN

23、 DATABASE PARTITION GROUP IBMDEFAULTGROUP pagesize 32k MANAGED BY DATABASEUSING (file '/db2data/ods/tbs32k/tbs32k_0.data' 1000M) ON DBPARTITIONNUM(0)USING (file '/db2data/ods/tbs32k/tbs32k_1.data' 1000M) ON DBPARTITIONNUM(1)USING (file '/db2data/ods/tbs32k/tbs32k_2.data' 1000

24、M) ON DBPARTITIONNUM(2)USING (file '/db2data/ods/tbs32k/tbs32k_3.data' 1000M) ON DBPARTITIONNUM(3)autoresize yes  bufferpool bp32k;CREATE LARGE TABLESPACE tbs32kedw IN DATABASE PARTITION GROUP IBMDEFAULTGROUP pagesize 32k MANAGED BY DATABASEUSING (file '/db2data/edw/tbs32k/tbs32k_0.

25、data' 1000M) ON DBPARTITIONNUM(0)USING (file '/db2data/edw/tbs32k/tbs32k_1.data' 1000M) ON DBPARTITIONNUM(1)USING (file '/db2data/edw/tbs32k/tbs32k_2.data' 1000M) ON DBPARTITIONNUM(2)USING (file '/db2data/edw/tbs32k/tbs32k_3.data' 1000M) ON DBPARTITIONNUM(3)autoresize yes

26、  bufferpool bp32k;CREATE LARGE TABLESPACE tbs32kddw IN DATABASE PARTITION GROUP IBMDEFAULTGROUP pagesize 32k MANAGED BY DATABASEUSING (file '/db2data/ddw/tbs32k/tbs32k_0.data' 1000M) ON DBPARTITIONNUM(0)USING (file '/db2data/ddw/tbs32k/tbs32k_1.data' 1000M) ON DBPARTITIONNUM(1)

27、USING (file '/db2data/ddw/tbs32k/tbs32k_2.data' 1000M) ON DBPARTITIONNUM(2)USING (file '/db2data/ddw/tbs32k/tbs32k_3.data' 1000M) ON DBPARTITIONNUM(3)autoresize yes  bufferpool bp32k;CREATE LARGE TABLESPACE idx32kods IN DATABASE PARTITION GROUP IBMDEFAULTGROUP pagesize 32k MANAG

28、ED BY DATABASEUSING (file '/db2data/ods/idx32k/idx32k_0.data' 100M) ON DBPARTITIONNUM(0)USING (file '/db2data/ods/idx32k/idx32k_1.data' 100M) ON DBPARTITIONNUM(1)USING (file '/db2data/ods/idx32k/idx32k_2.data' 100M) ON DBPARTITIONNUM(2)USING (file '/db2data/ods/idx32k/idx

29、32k_3.data' 100M) ON DBPARTITIONNUM(3)autoresize yes  bufferpool bp32k;CREATE LARGE TABLESPACE idx32kedw IN DATABASE PARTITION GROUP IBMDEFAULTGROUP pagesize 32k MANAGED BY DATABASEUSING (file '/db2data/edw/idx32k/idx32k_0.data' 100M) ON DBPARTITIONNUM(0)USING (file '/db2data/ed

30、w/idx32k/idx32k_1.data' 100M) ON DBPARTITIONNUM(1)USING (file '/db2data/edw/idx32k/idx32k_2.data' 100M) ON DBPARTITIONNUM(2)USING (file '/db2data/edw/idx32k/idx32k_3.data' 100M) ON DBPARTITIONNUM(3)autoresize yes  bufferpool bp32k;CREATE LARGE TABLESPACE idx32kddw IN DATABAS

31、E PARTITION GROUP IBMDEFAULTGROUP pagesize 32k MANAGED BY DATABASEUSING (file '/db2data/ddw/idx32k/idx32k_0.data' 100M) ON DBPARTITIONNUM(0)USING (file '/db2data/ddw/idx32k/idx32k_1.data' 100M) ON DBPARTITIONNUM(1)USING (file '/db2data/ddw/idx32k/idx32k_2.data' 100M) ON DBPAR

32、TITIONNUM(2)USING (file '/db2data/ddw/idx32k/idx32k_3.data' 100M) ON DBPARTITIONNUM(3)autoresize yes  bufferpool bp32k;CREATE SYSTEM TEMPORARY TABLESPACE tmp32kPAGESIZE 32kMANAGED BY SYSTEMUSING ('/db2data/database/db2inst1/NODE0000/SQL00001/systmptbs_32k') ON DBPARTITIONNUM (0)

33、USING ('/db2data/database/db2inst1/NODE0001/SQL00001/systmptbs_32k') ON DBPARTITIONNUM (1)USING ('/db2data/database/db2inst1/NODE0002/SQL00001/systmptbs_32k') ON DBPARTITIONNUM (2)USING ('/db2data/database/db2inst1/NODE0003/SQL00001/systmptbs_32k') ON DBPARTITIONNUM (3)BUFFER

34、POOL bp32k;CREATE USER TEMPORARY TABLESPACE usrtmp32kPAGESIZE 32kMANAGED BY DATABASEUSING (FILE '/db2data/database/db2inst1/NODE0000/SQL00001/usrtmptbs_32k/tbs32k_0.data' 100M) ON DBPARTITIONNUM(0)USING (FILE '/db2data/database/db2inst1/NODE0001/SQL00001/usrtmptbs_32k/tbs32k_1.data'

35、100M) ON DBPARTITIONNUM(1)USING (FILE '/db2data/database/db2inst1/NODE0002/SQL00001/usrtmptbs_32k/tbs32k_2.data' 100M) ON DBPARTITIONNUM(2)USING (FILE '/db2data/database/db2inst1/NODE0003/SQL00001/usrtmptbs_32k/tbs32k_3.data' 100M) ON DBPARTITIONNUM(3)bufferpool bp32k;九、配置數(shù)據(jù)庫和實例的相關(guān)參數(shù)

36、：#su - db2inst1$db2_all "db2 update db cfg for testdb using LOGPRIMARY 16"$db2_all "db2 update db cfg for testdb using LOGSECOND 4"$db2_all "db2 update db cfg for testdb using LOGFILSIZ 130048"$db2_all  "db2 update db cfg for testdb using SORTHEAP 5120"$db2_all  "db2 update db cfg for testdb using LOCKLIST 204800"$db2_all "db2 update db cfg for testdb using MAXLOCKS 30"$db2_all "db2