DB2的安装配置和数据库创建

1 DB2软件的安装

前面一系列的配置是为了LINUX能与局域网内的其他主机访问和共享文件。现就开始安装配置DB2数据库服务，首先通过SAMBA服务拷贝DB2安装软件到LINUX系统中。命令安装如下：

[root@localhost samba_share]# ls

DB2 db2_v9_ese_linux_32.tarsmb.conf

[root@localhost samba_share]#tar -zxvf db2_v9_ese_linux_32.tar

...........................

[root@localhost samba_share]# ls

DB2 db2_v9_ese_linux_32.tar.gz ese_t smb.conf

[root@localhost samba_share]# cd ese_t

[root@localhost ese_t]# ls

disk1

[root@localhost ese_t]# ls disk1

db2 db2_install db2setup doc installFixPack

[root@localhost ese_t]# cd disk1

 [root@localhost disk1]#./db2_install

Default directory for installation of products - /opt/ibm/db2/V9.1

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

Do you want to choose a different directory to install [yes/no] ?

no

Specify one or more of the following keywords,

separated by spaces, to install DB2 products.

 CLIENT            #客户端

 RTCL

 ESE              #服务器

Enter "help" to redisplay product names.

Enter "quit" to exit.

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

ESE

DB2 installation is being initialized.

..省略...........

A minor error occurred while installing "DB2 Enterprise Server Edition" on

this computer. Some features may not function correctly.

#由于安装包的license已经过期  ，但可以修改系统时间到license有效时间范围来重新添加license

For more information see the DB2 installation log at

"/tmp/db2_install.log.5469".

在安装的过程中，由于license时间到2009年12月，现修改LINUX系统时间：

[root@localhost sqllib]$date -s2009/9/18

Fri Sep 18 00:00:00 CST 2009

[root@localhost sqllib]$/opt/IBM/db2/V9.1/adm/db2licm -a /mnt/cdrom/db2/license/db2pe.lic

#修改系统时间后进行注册产品

2数据库实例的创建与参数配置

在创建数据库实例时，需要创建实例用户，在创建时使用db2ins1与db2fenc1（受保护用户）.当然，用户也可以按自己需要命名。

[root@localhost sqllib]$useradd–m -g db2inst1–d /home/db2inst1 db2inst1   

#-m是判断文件不存在的话，新建文件

[root@localhost sqllib]$useradd –m -g db2fenc1 –d /home/db2fenc1 db2fenc1

创建实例：

[root@localhost instance]# /opt/ibm/db2/V9.1/instance/db2icrt -a server -u db2fenc1 db2inst1

DBI1070I Program db2icrt completed successfully.

实例创建完成后，需要对一些文件和参数进行配置。

1、允许SMS的多页分配

 [root@localhost instance]#/opt/IBM/db2/V9.1/cfg/db2ln

2、添加DB2端口

##########################################################

[root@localhost sqllib]$vi /etc/services

………………省略

………………

# Local services

DB2_db2ins1    60000/tcp

DB2_db2ins1_1  60001/tcp

DB2_db2ins1_2  60002/tcp

DB2_db2ins1_END 60003/tcp

db2inst1       50000/tcp                添加端口50000

DB2_db2belle   60004/tcp

DB2_db2belle_1 60005/tcp

DB2_db2belle_2 60006/tcp

DB2_db2belle_END       60007/tcp

##################################################################

2、 实例配置

#######################################################################

[root@localhost adm]# su db2inst1

[db2inst1@localhost adm]$ db2set DB2_EXTENDED_OPTIMIZATION=ON

[db2inst1@localhost adm]$ db2set DB2_DISABLE_FLUSH_LOG=ON

[db2inst1@localhost adm]$ db2set AUTOSTART=YES

[db2inst1@localhost adm]$ db2set DB2_STRIPED_CONTAINERS=ON

[db2inst1@localhost adm]$ db2set DB2_HASH_JOIN=Y

[db2inst1@localhost adm]$ db2set DB2COMM=tcpip

[db2inst1@localhost adm]$ db2set DB2_PARALLEL_IO=*

[db2inst1@localhost adm]$ db2set DB2CODEPAGE=1386

[db2inst1@localhost adm]$ db2 update dbm cfg using SVCENAME db2inst1

DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed

successfully.

[db2inst1@localhost adm]$ db2 update dbm cfg using INDEXREC ACCESS

DB20000I The UPDATE DATABASE MANAGER CONFIGURATION command completed

successfully.

############################################################################

参数设置完后，可以启动DB2服务

[db2inst1@localhost adm]$db2start

创建DAS管理服务：

################################################################################33

[root@d0736 mnt]$useradd db2admin  #添加db2admin用户

useradd: user db2admin exists

[root@d0736 mnt]$passwd db2admin

Changing password for user db2admin.

New UNIX password:

BAD PASSWORD: it is based on a dictionary word

Retype new UNIX password:

passwd: all authentication tokens updated successfully.
[root@d0736 mnt]$cd /opt/ibm/db2/V9.1/instance

[root@d0736instance]$ ./dascrt -u db2admin  #创建DAS管理服务用户

SQL4406W The DB2 Administration Server was started successfully.

DBI1070I Program dascrt completed successfully. 

  [root@d0736instance]$ su db2admin

  [root@d0736instance]$ db2admin start   #启动DAS服务

####################################################################################

3数据库的创建及缓冲池、表空间的设置

一、数据库创建

查看实例参数：

[db2ins1@localhostdel]$db2set -all

[i] DB2_EXTENDED_OPTIMIZATION=ON

[i] DB2_DISABLE_FLUSH_LOG=ON

[i] AUTOSTART=YES

[i] DB2_STRIPED_CONTAINERS=ON

[i] DB2_HASH_JOIN=Y

[i] DB2COMM=tcpip

[i] DB2CODEPAGE=1386        ###代码页

[i] DB2_PARALLEL_IO=*

[i] DB2AUTOSTART=YES

[g] DB2SYSTEM=d0736.belle.com

[g] DB2INSTDEF=db2ins1

[g] DB2ADMINSERVER=db2inst1

数据库建立：

[db2ins1@localhostdel]$db2 create db report using codesetGBKTERRITORY CN

####GBK对应1386代码页

DB20000I The CREATE DATABASE command completed successfully.

[db2ins1@localhostdel]$db2 connect to report

  Database Connection Information

 Database server       = DB2/LINUX9.1.0

 SQL authorization ID  = DB2INS1

 Local database alias  = REPORT

4DB2数据库实践学习

一、对于客户端连接数据库，首先需要建节点：

Db2 catalog tcpip nodenodenameremoteIPserver 50000;#编目节点

Db2 catalog dbdbnameasaliasnemeat nodenodename;#编目数据库在节点上

Db2 connect to dbname user username using passwd;#数据库链接

Db2 uncatalog db dbname;#反编目数据库

Db2 uncatalog node nodename ;#反编目节点