linux系统安装db2数据库安装文档

1、db2数据库安装1. 解压db2安装包，如果是已解压文件，可以无视第一步输入命令 tar -zxvf v97_linuxx64_server.tar.gzmedia/reaamerirst/zn_cn/ntmi/reaamerirst. ntm media/readmefirst/zh_cn/txt/media/readmefirst/zh_cn/txt/readmefirsttxt media/readmefi rst/zh_tw/media/readmefirst/zh_tw/html/ media/readmefirst/zh_tw/html/readmefirst.htm media/

2、readmefirst/zh_tw/txt/media/readmefirst/zh_tw/txt/readmefirsttxt medi a/readmefi rst.htmmedi a/readmef i rst. txtrootpublicdb opt# isdb2_9.7_for_lpnuxi»edia解压完目录下会生成一个文件夹，如media2. 运行安装程序在解压目录(media)下找到db2_install文件rootpublicdb media# is"db2 db2_deinstall db2_install db21s db2prereqcheck db

3、2setup doc rootpublicdb media# ./db2_1nstall输入命令./db2_install执行，显示以下内容.要选择另一个目录用于安装吗？ yes/no输入no默认安装opt下，选择yes自己输入安装目录root(apublicdb media# 7/db2_install*warning：the 32 bit library file libstdc+.so.6 is not found on the system. 32bit applications may be affected.default directory for installation of

4、 products - /opt/ibm/db2/v9.70*0 令 *仃"仃*w 令* 令仃 * 仃 “we 令仃 *do you want to choose a different directory to install yes/no ?这里我们选择默认路径安装，输入no然后回车输入esedo you want to choose a different directory to install yes/no ? nospecify one of the following keywords to install db2 products.eseclientrtclenter

5、 "help" to redisplay product names.enterto exit注意：安装文件时可能会遇到缺少libstdc+. so. 6文件esewarning：the 32 bit library file libstdc+.so.6 is not found on the system. 32-bit applications may be affected.db2 installation is being initialized.total number of tasks to be performed: 47total estimated tim

6、e for all tasks to be performed: 2019task #1 startdescription: checking licensw agreement acceptanceestimated time 1 second(s)task #1 end运行yum install libstdc+ so. 6命令下载文件task #47 startdescription: updating global profile registry estimated time 3 second(s)task 047 enda minor error occurred while in

7、stalling "db2 enterprise server edition ” on this computer some features may not function correctlyfor more information see the db2 installation log atm/tmp/db2_install. log. 1456*.rootopublicdb media# yum install hbstdc+.so.6loaded plugins: fastestmlrrorsetting up install processdetermining fa

8、stest mirrorscould not retrieve mirrorlist http:/mirrorlisttosorg/?release-64arch-x86_64&repo-os4infra-stock error was14 : pycurl error 6 resolve host 'mirrorlist.vwniosorg”could not retrieve mirrorlist http:/mirrorlist .centosorg/?release-64arch-x86_644repo-extras&1nfra-stock error was

9、14: pycurl error 6 "couldrtt resolve host 'mirrorlist.cantosorg""could not retrieve mirrorlist http:/mirrorlist.tentosorg/?release-64arch-x86_644repo-updates&infra-stock error was 14: pycurl error 6 resolve host 'mirrorlistcentosorg*m* base: centosustc* extras:

10、.vn* nndtp! ftn.situ.pdu.rnpackagearchversionrepositoryinstalling:libstdcw16864.4.7-18.el6baseinstalling for deperxlencies:qlibc libgcc16862.12-1.209.el6_9.2updates16864.4.7-18.el6basenss-softokn-freebl16863.14.3-23.3.el6.8baseupdating for dependencies:gllbcx86.642.12-1.209.e16.9.2updatesglibc-comon

11、x86_642.12-1.209.el6_9.2updatestransaction suaiaryinstall upgrade4 package(s)2 package(s)total download size: 23 h is this ok y/n: y|3, 安装完成后，创建db2运行所需要的用户组和用户groupadd -g 901 db2iadmlgroupadd -g 902 db2fadmlgroupadd -g 903 dasadmluseradd -g db2iadml -u 801 -d /home/db2instl -m db2instl useradd -g db

12、2fadml -u 802 -d /home/db2fencl -m db2fencl useradd -g dasadml -u 803 一d /home/dasadml 一m dasusrlyootpublicdb media# groupadd -g 901 db2iadml *'rootpublicdb media# groupadd -g 902 db2fadmlyootpublicdb media# groupadd -g 903 dasadmlrootpublicdb medial# useradd -g db2iadml -u 801 -d /home/db2instl

13、 -m db2instl rootpublicdb media# useradd -g db2fadml -u 802 -d /home/db2fencl -m db2fenclrootpublicdb medial# useradd -g dasadml -u 803 -d /home/dasadml -m dasusrl6 创建完用户组和用户后，为db2instl创建密码，这里我们选择将密码设置成和用户一样db2instl (注意是db2inst 1是1不是l)输入命令：passwd db2instltrootpublicdb1 media# passwd db2instlchanging

14、 password for user db2instl.new password:bad password： it is based on a dictionary wordretype riw password:passwd: all authentication tokens updated successfully.rootpub11cdb media#7,设置密码后我们创建一个实例首先输入命令cd /opt/ibm/db2/v9. 7/instance进入该文件下，然后输入命令./dascrt -u dasusrl回车执行文件显示成功后在执行./db2icrt 一u db2instl

15、db2instl 命令rootcapublicdb media# cd /opt/ibm/db2/v9. 7/instance rootpublicdb instanceh iscoaaondaslistdasutildb2ckupgradedb2iautodascrtdasnigrdb2chkfdb2clpiadb2icknadasdropdasupatdb2ckaigdb2dbikhkdb2icktsrootpublicdb instanew律./dascrt -u dasusrl sql4406w the db2 administration server was started dbi

16、1070i program dascrt completed successfully.db2icrt db2idb« db2idefsdb2idrop db2iexec db2iinfodb2ilist db2inchk db2inigrsuccessfully.rootpublicdb instance# ./db2icrt -u db2instl db2instl dbi1070i program db2icrt completed successfully.&创建完成后我们启动实例yootpublicdb instance# su - dasusrl:dasusrl(

17、apublicdb das/dasprofile:dasusrlpubli cdb $ db2admin startsql4409w the db2 administration server is already active.dasusrl(apubl 1 cdb $ su db2instlpassword:db2instlpublicdb $ . sql1ib/db2profiledb2i nstl(apubl i cdb j $ db2start03/16/2018 03:48:2000 sql1063n db2start processing was successful.sql10

18、63n db2start processing was successful.db2i nstl(apubl 1 cdb $ 9关闭.启动数据库db2instlpubli cdb $ db2stop03/16/2018 03:50:0300 sql1064n db2stop processing was successful.sql1064n db2stop processing was successful.db2instkpublicdb $ db2start03/16/2018 03:50:3000 sql1063n db2start processing was successful.

19、sql1063n db2start processing was successful.db2instl(apublicdb10 创建样本库9 -v -2 b d/ s t 2pb od -/ /,db2i nstlpubli cdb 二$ cddb2instlpublicdb bin$ creating database 'sample'connect mg to database "sample"creating tables and data in schema "db2tnstt'creating tables with xml c

20、olumns and xml data in schema mdb2inst1m. fdb2sampl* processing complete.db2instlpublicdb bin$设置db2自启动 进入日录 cd /opt/i bm/db2/v9. 7/i nstance输入命令./db2iauto -on db2instldb2instl(publicdb bin$ cd /opt/ibm/db2/v9>7/1 nstance db2instl(apublicdb instance$ /db2iauto -on db2instl12 配置 tcpip进入目录 /etc/serv

21、ices；db2instlpublicdb bin$ cd /opt/ibm/db2/v9.7/instance ；db2instlpublicdb instance$ /db2iauto -on db2instl ；db2instl(apublicdb instance$ su - db2instlpassword:；db2instlpublicdb $；db2instlpublicdb j$ tcp/ip service name ssl service namedb2instlpublicdb48129/tcp48129/udp48556/tcp48556/udp48619/tcp486

22、19/udp60000/tcp60001/tcp60002/tcp60003/tcpdb2set db2comm=tcpip db2 get dbm cfg igrepblp5 blp5 com-bardac-dw com-bardac-dw iqobject iqobject db2_ab2instl db2_db2instl_l db2_db2instl_2 db2_db2instl_end db2i nstl<apubl i cdb $tail /etc/services修改成如下db2 db2instl50000/tcpsvcename(svcename)= (ssl_svcen

23、ame)=bloomberg locator bloomberg locator com-bardac-dw com-bardac-dw iqobject iqobjectdb2_db2instl_ldb2 db2£n3t1 250001/tup50002/tcpdb2 4b2instl end50003/tup也可通过工具找到文件修改flashfxp录(d)査看(v)帮助(h)文件(f)编辑(z)搜索(y)格式(o)査看(v)nimcontroller 48000/udp nimspooler nimspooler nimhub nimhubnimgtw nimgtw 3gpp-c

24、bsp48001/tcp48001/udp48002/tcp 48002/udp 48003/tcp 48003/udp48049/tcp 48128/tcp 48128/udpisn etservisn etservblp548129/tcpblp548129/udpcom-bardac-dw 48556/tcp com-bardac-dw 48556/udpiqobject 48619/tcpiqobject 48619/udp# nimbus controller# nimbus spooler# nimbus spooler# nimbus hub# nimbus hub# nimbu

25、s gateway# nimbus gateway# 3gpp cell broadcast service protocol# image systems network services# image systems network services# bloomberg locator# bloomberg locator# com-bardac-dw# com-bardac-dw# iqobject# iqobjectdb2_db2inst150000/tcpdb2db2inst1_150001/tcpdb2db2instl2 50002/tcpdb2db2instlend 50003

26、/tcp|行：10778 unix ansi 已修改修改完成后输入一下命令更新文件重启启动数据库db2instl(apublicdb db2 update dbm cfg using svcename 50000db20000i the update database manager configuration command completed successfully.db2instlpublicdb $ db2stop03/16/2018 04:04:0300 sql1064n db2stop processing was successful.sql1064n db2stop proc

27、essing was successful.db2instlpublicdb $ db2start03/16/2018 04:04:1100 sql1063n db2start processing was successful.sql1063n db2start processing was successful.db2instlpublicdb注意这里需要将50000端口加入防火墙信任或者关闭防火墙db2新建用户创建数据库流程1. 添加用户useradd -g users -d /home/phjrpt -s /bin/bash -m phjrpt2. 设置密码passwd phjrptr

28、ootpublicdb useradd -g users -d /home/phjrpt -s /bin/bash -m phjrpt rootpublicdb passwd phirptchanging password for user pnjrpt.new password:bad password： it is based on a dictionary wordbad password： is too simpleretype new password:passwd: all authentication tokens updated successfully.root<apu

29、blicdb #3. 创建数据库db2 create database phjrpt4. 连接数据库db2 connect to phjrpt5. 给phjrpt用户授予dba权限db2 grant dbadm on database to user phjrptrootpublicdb su db2instldb2instlpublicdb $ db2 create database phjrptdb20000i the create database command completed successfully. db2instlpublicdb $ db2 connect to phjr

30、ptdatabase connection informattondatabase server= db2/linuxx8664 9.7.0sql authorization id » db2inst1local database alias = phjrptdb2instl<apublicdb db2 grant dbadm on database to user phjrpt db20000i the sql command completed successfully.db2instlpublicdb $ |6. 为该用户创建schemadb2 create schema phj