DB2 详细安装配置手册

DB2安装配置

版本1.0

北京中电广通科技有限公司

2012年6月4日

文档信息

版本修定：

版本

V1.0.0

作者

姜圣国

修改日期

2012/6/4

修改描述

初始版本

文档信息

DB2 软件安装

1.数据库安装

1.1 DB2A 分区安装DB2数据库软件

--root用户操作 （以下安装配置默认为按DB2 V9.5 ）

1.1.1、将数据库安装介质 *_aix64_ 拷贝到主机 DB2A 机的/tmp/db2media上

键入如下命令创建目录：

cd /tmp

mkdir db2media

将介质上传至/tmp/db2media目录

1.1.2、将安装介质解压

cd /tmp/db2media

gunzip *_aix64_

tar –xvf *_aix64_

1.1.3、给安装目录足够的权限

cd /tmp/

chmod –R 777 db2media

1.1.4、用Xmanager在控制台用root登陆,设置客户端变量

#export LANG=C

#export DISPLAY= “DB2A IP地址”:0.0 (本机IP地址)

并进入/tmp/db2media/server目录,

运行./db2setup 安装程序，如下所示：选择“Install New” （安装产品项）

文档信息

1、选择“Install a

Product”

选择“Install

New”

1.1.5直接选择“Next”

选择“Next”

文档信息

1.1.6、选择“Accept”接受Software License，并按“Next”继续

第一步：选

择“Accept”

第二步：选

择“Next”

1.1.7、按默认选择“Typicat …”，NEXT，直至DB2安装完毕，点“Finish”完成安装。

点““Finish”

文档信息

1.2 DB2A 分区安装DB2数据库语言包

--root用户操作

1.2.1、将安装包解压

cd /tmp/db2media

gunzip *_aix64_

mkdir db2pk –创建存放解压文件的目录

cd db2pk --进入该目录

tar -xvf /tmp/ db2media/*_aix64_ –解压到db2pk目录

1.2.2、解压后会在/tmp/db2media目录下产生db2pak目录

cd /tmp/db2media

chmod –R 777 db2pk

1.2.3、进入安装目录执行安装文件

cd /tmp/db2media /db2pk/nlpack

./db2setup

1.2.4、在出现的界面上选 择“Work with Existing”

第一步：选择

“Install a

Product”

第二步：选择

“Work with

Existing”

1.2.5、按默认点击“Launch DB2 Setup wizard”

文档信息

点击“Launch DB2

Setup wizard”

1.2.6、直接点“Next”

1.2.7、选择报告输出路径并点“Next”

文档信息

第一步：选

择报告输出

路径

第二步：点

“Next”

1.2.8、将“简体中文”移到右侧后点“Next”

第一步：将

简体中文移

到右侧

第二步：点

“Next”

文档信息

1.2.9、点“finish”

点“finish”

1.2.10、出现安装进度条

1.2.11、在安装成功界面点“finish”

文档信息

1.2.12、导入licence（确保license /db2ese_文件已传到/tmp/db2media）

cd /tmp/db2media

/opt/IBM/db2/V9.5/adm/db2licm -a db2ese_ （具体按实际路径操作）

1.2.13、查看db2的试用期

/opt/IBM/db2/V9.5/adm/db2licm –l （具体按实际路径操作）

出现Permanent

为成功

DB2配置

1、db2双机配置

Db2A主机上，在共享的磁盘阵列 /DB2文件系统上，

Mkdir 创建目录db2data 和db2log

然后创建如下用户和组： （以下参数参考生产系统UID 和 GID ）

文档信息

user user id group groupid home directory

db2inst1 302 db2iadm1 302 /db2/db2inst1

db2fenc1 303 db2fgrp1 303 /db2/db2fenc1

dasusr1 304 dasadm1 304 /home/dasusr1

命令行建立组和用户

mkgroup id=302 db2iadm1

mkgroup id=303 db2fgrp1

mkgroup id=304 dasadm1

mkuser id=219 pgrp=db2iadm1 groups=db2iadm1 home=/db2db2inst1 core=-1 data=491519

stack=32767 rss=-1 fsize=-1 db2inst1

mkuser id=302 pgrp=db2iadm1 groups=db2iadm1 home=/db2db2inst1 core=-1 data=491519

stack=32767 rss=-1 fsize=-1 db2inst1

mkuser id=303 pgrp=db2fgrp1 groups=db2fgrp1 home=/db2/db2fenc1 db2fenc1

mkuser id=304 pgrp=dasadm1 groups=dasadm1 home=/home/dasusr1 dasusr1

创建实例db2inst1 （以下参数参考生产系统数据库实例）

cd /opt/IBM/db2/V9.5/instance

./db2icrt -u db2fenc1 db2inst1

创建数据库

su - db2inst1

db2start

db2 create database “数据库名”on /db2/db2data using codeset utf-8 territory zh_CN pagesize 32

k

db2 terminate

db2stop

手工卸载文件系统和卷组

umount /db2

varyoffvg DB2DATAVG

DB2B主机，进行如下操作

输入卷组

importvg –y DB2DATAVG

mount /db2

建立用户和组如下，要与DB2A完全一致！

user user id group groupid home directory

db2inst1 302 db2iadm1 302 /db2/db2inst1

文档信息

db2fenc1 303 db2fgrp1 303 /db2/db2fenc1

dasusr1 304 dasadm1 304 /home/dasusr1

cp

/db2/db2inst1/sqllib/ /db2/db2inst1/sqllib.a/. Server2

cp

/db2/db2inst1/sqllib.a/

/db2/db2inst1/sqllib.a/. Server1

rm -r /db2/db2inst1/sqllib

mv /db2/db2inst1/sqllib.a /db2home/db2inst1/sqllib

cp /db2/db2inst1/sqllib/2 /db2home/db2inst1/sqllib/

(把该命令加到ha的启动脚本里）

db2许可证注册

FTP 将许可文件传入 /opt/IBM/db2/V9.5/license

db2licm –a /opt/IBM/db2/V9.5/license/db2ese_

设置db2 tcpip通讯端口

1. 设置环境变量

db2set db2comm=tcpip

2. 设置db2通讯端口

db2 update dbm cfg using SVCENAME 50000

3. 重启db2使设置生效。

db2stop force

db2start

( db2_2主机，进行如下操作

输入卷组

importvg –y dbvg hdiskpower0

mount /db2home

(如果dbvg已经存在，那么先将dbvg exportvg 掉)

建立用户和组如下，要与db2_1保持一致！

user user id group groupid home directory

db2inst1 302 db2iadm1 302 /db2home/db2inst1

db2fenc1 303 db2fgrp1 303 /db2home/db2fenc1

dasusr1 304 dasadm1 304 /home/dasusr1

创建实例db2inst1

mv /db2home/db2inst1/sqllib /db2home/db2inst1/sqllib.a

文档信息

cd /opt/IBM/db2/V9.5/instance

./db2icrt -u db2fenc1 db2inst1

cp

/db2home/db2inst1/sqllib/

/db2home/db2inst1/sqllib.a/rver2

cp

/db2home/db2inst1/sqllib.a/

/db2home/db2inst1/sqllib.a/rver1

rm -r /db2home/db2inst1/sqllib

mv /db2home/db2inst1/sqllib.a /db2home/db2inst1/sqllib

cp /db2home/db2inst1/sqllib/rver2 /db2home/db2inst1/sqllib/db2nodes.

cfg(在hacmp环境中把该命令加到ha的启动脚本里）

db2的hacmp脚本

在HNHRServer1,HNHRServer2的hascripts目录下，通过ftp传入和文件

然后用这两个文件，覆盖/hacmp下的和

)

$ db2 get dbm cfg

Database Manager Configuration

Node type = Enterprise Server Edition with local and remote clients

Database manager configuration release level = 0x0b00

CPU speed (millisec/instruction) (CPUSPEED) = 4.172374e-07

Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1.000000e+02

Max number of concurrently active databases (NUMDB) = 8

Federated Database System Support (FEDERATED) = NO

Transaction processor monitor name (TP_MON_NAME) =

Default charge-back account (DFT_ACCOUNT_STR) =

Java Development Kit installation path (JDK_PATH) =

/db2/db2inst1/sqllib/java/jdk64

Diagnostic error capture level (DIAGLEVEL) = 3

Notify Level (NOTIFYLEVEL) = 3

Diagnostic data directory path (DIAGPATH) =

文档信息

/db2/db2inst1/sqllib/db2dump

Default database monitor switches

Buffer pool (DFT_MON_BUFPOOL) = OFF

Lock (DFT_MON_LOCK) = OFF

Sort (DFT_MON_SORT) = OFF

Statement (DFT_MON_STMT) = OFF

Table (DFT_MON_TABLE) = OFF

Timestamp (DFT_MON_TIMESTAMP) = ON

Unit of work (DFT_MON_UOW) = OFF

Monitor health of instance and databases (HEALTH_MON) = ON

SYSADM group name (SYSADM_GROUP) = DB2IADM1

SYSCTRL group name (SYSCTRL_GROUP) =

SYSMAINT group name (SYSMAINT_GROUP) =

SYSMON group name (SYSMON_GROUP) =

Client Userid-Password Plugin (CLNT_PW_PLUGIN) =

Client Kerberos Plugin (CLNT_KRB_PLUGIN) =

Group Plugin (GROUP_PLUGIN) =

GSS Plugin for Local Authorization (LOCAL_GSSPLUGIN) =

Server Plugin Mode (SRV_PLUGIN_MODE) = UNFENCED

Server List of GSS Plugins (SRVCON_GSSPLUGIN_LIST) =

Server Userid-Password Plugin (SRVCON_PW_PLUGIN) =

Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED

Database manager authentication (AUTHENTICATION) = SERVER

Cataloging allowed without authority (CATALOG_NOAUTH) = NO

Trust all clients (TRUST_ALLCLNTS) = YES

Trusted client authentication (TRUST_CLNTAUTH) = CLIENT

Bypass federated authentication (FED_NOAUTH) = NO

Default database path (DFTDBPATH) = /db2/db2inst1

Database monitor heap size (4KB) (MON_HEAP_SZ) = 90

Java Virtual Machine heap size (4KB) (JAVA_HEAP_SZ) = 2048

Audit buffer size (4KB) (AUDIT_BUF_SZ) = 0

Size of instance shared memory (4KB) (INSTANCE_MEMORY) = AUTOMATIC

Backup buffer default size (4KB) (BACKBUFSZ) = 1024

Restore buffer default size (4KB) (RESTBUFSZ) = 1024

Sort heap threshold (4KB) (SHEAPTHRES) = 0

Directory cache support (DIR_CACHE) = YES

文档信息

Application support layer heap size (4KB) (ASLHEAPSZ) = 15

Max requester I/O block size (bytes) (RQRIOBLK) = 32767

Query heap size (4KB) (QUERY_HEAP_SZ) = 1000

Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10

Priority of agents (AGENTPRI) = SYSTEM

Max number of existing agents (MAXAGENTS) = 400

Agent pool size (NUM_POOLAGENTS) = 200(calculated)

Initial number of agents in pool (NUM_INITAGENTS) = 0

Max number of coordinating agents (MAX_COORDAGENTS) = (MAXAGENTS -

NUM_INITAGENTS)

Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS

Max number of client connections (MAX_CONNECTIONS) =

MAX_COORDAGENTS

Keep fenced process (KEEPFENCED) = YES

Number of pooled fenced processes (FENCED_POOL) = MAX_COORDAGENTS

Initial number of fenced processes (NUM_INITFENCED) = 0

Index re-creation time and redo index build (INDEXREC) = RESTART

Transaction manager database name (TM_DATABASE) = 1ST_CONN

Transaction resync interval (sec) (RESYNC_INTERVAL) = 180

SPM name (SPM_NAME) =

SPM log size (SPM_LOG_FILE_SZ) = 256

SPM resync agent limit (SPM_MAX_RESYNC) = 20

SPM log path (SPM_LOG_PATH) =

TCP/IP Service name (SVCENAME) =

Discovery mode (DISCOVER) = SEARCH

Discover server instance (DISCOVER_INST) = ENABLE

Maximum query degree of parallelism (MAX_QUERYDEGREE) = ANY

Enable intra-partition parallelism (INTRA_PARALLEL) = NO

db2 update dbm cfg using INTRA_PARALLEL YES

Maximum Asynchronous TQs per query (FEDERATED_ASYNC) = 0

No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC

No. of int. communication channels (FCM_NUM_CHANNELS) = AUTOMATIC

Node connection elapse time (sec) (CONN_ELAPSE) = 10

Max number of node connection retries (MAX_CONNRETRIES) = 5

文档信息

Max time difference between nodes (min) (MAX_TIME_DIFF) = 60

db2start/db2stop timeout (min) (START_STOP_TIME) = 10

#!/bin/sh

# *******************************************************

# DB2 ENVIRONMENT VARIABLES

# *******************************************************

db2set DB2_MMAP_READ=NO

db2set DB2_MMAP_WRITE=NO

db2set DB2_FMP_COMM_HEAPSZ=

db2set DB2_EVALUNCOMMITTED=YES

db2set DB2_SKIPINSERTED=YES

db2set DB2_SKIPDELETED=YES

db2set DB2_HASH_JOIN=NO

# *******************************************************

# DB2 DATABASE MANAGER SETTINGS; NOTE: MONITORING

# IS OFF TO REDUCE CPU; YOUR APPLICATION MAY REQUIRE

# MONITORS TO BE ON, SO CHANGE ACCORDINGLY

# *******************************************************

db2 update dbm cfg using NUMDB 4

db2 update dbm cfg using DFT_MON_BUFPOOL OFF

db2 update dbm cfg using DFT_MON_LOCK OFF

db2 update dbm cfg using DFT_MON_SORT OFF

db2 update dbm cfg using DFT_MON_STMT OFF

db2 update dbm cfg using DFT_MON_TABLE OFF

db2 update dbm cfg using DFT_MON_UOW OFF

db2 update dbm cfg using DFT_MON_TIMESTAMP OFF

db2 update dbm cfg using MON_HEAP_SZ 10000

db2 update dbm cfg using UDF_MEM_SZ 256

db2 update dbm cfg using JAVA_HEAP_SZ 512

db2 update dbm cfg using SHEAPTHRES 10000

db2 update dbm cfg using DIR_CACHE YES

db2 update dbm cfg using ASLHEAPSZ 15

db2 update dbm cfg using RQRIOBLK 65535

db2 update dbm cfg using QUERY_HEAP_SZ 16384

db2 update dbm cfg using DRDA_HEAP_SZ 128

# *******************************************************

文档信息

# DB2 DATABASE MANAGER SETTINGS FOR CONNECTIONS AND AGENTS

# SHOWN HERE SUPPORTS 1200 CONCURRENT CONNECTIONS!

# *******************************************************

db2 update dbm cfg using FENCED_POOL 200

db2 update dbm cfg using NUM_INITAGENTS 50

db2 update dbm cfg using MAXAGENTS 200

db2 update dbm cfg using MAX_COORDAGENTS 200

db2 update dbm cfg using NUM_INITFENCED 50

db2 update dbm cfg using NUM_POOLAGENTS 200

db2 update dbm cfg using MAX_CONNECTIONS 200

# *******************************************************

# UPDATE YOUR DATABASE SETTINGS

# *******************************************************

db2 update db cfg for yourdb using DFT_QUERYOPT 2

db2 update db cfg for yourdb using DBHEAP 1200

db2 update db cfg for yourdb using CATALOGCACHE_SZ 64

db2 update db cfg for yourdb using LOGBUFSZ 128

db2 update db cfg for yourdb using UTIL_HEAP_SZ 5000

db2 update db cfg for yourdb using LOCKLIST 1000

db2 update db cfg for yourdb using APP_CTL_HEAP_SZ 1000

db2 update db cfg for yourdb using APPGROUP_MEM_SZ 60000

db2 update db cfg for yourdb using SORTHEAP 256

db2 update db cfg for yourdb using STMTHEAP 4096

db2 update db cfg for yourdb using APPLHEAPSZ 4096

db2 update db cfg for yourdb using PCKCACHESZ 5000

db2 update db cfg for yourdb using STAT_HEAP_SZ 4384

db2 update db cfg for yourdb using MAXLOCKS 25

db2 update db cfg for yourdb using LOCKTIMEOUT 60

db2 update db cfg for yourdb using CHNGPGS_THRESH 60

db2 update db cfg for yourdb using NUM_IOCLEANERS 4

db2 update db cfg for yourdb using NUM_IOSERVERS 6

db2 update db cfg for yourdb using MAXAPPLS 1200

db2 update db cfg for yourdb using AVG_APPLS 1

db2 update db cfg for yourdb using MAXFILOP 64

db2 update db cfg for yourdb using LOGFILSIZ 1000

db2 update db cfg for yourdb using LOGPRIMARY 10

db2 update db cfg for yourdb using LOGSECOND 20

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

设置当前模式：

set current path = oais(模式名)

查看当前的模式：

db2 values(current path)

文档信息

设置为默认的、缺省的：

set current path = system path

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