存储规划与DB2安装调优Word下载.docx
- 文档编号:16679377
- 上传时间:2022-11-25
- 格式:DOCX
- 页数:10
- 大小:20.49KB
存储规划与DB2安装调优Word下载.docx
《存储规划与DB2安装调优Word下载.docx》由会员分享,可在线阅读,更多相关《存储规划与DB2安装调优Word下载.docx(10页珍藏版)》请在冰豆网上搜索。
1个LV*100G-----------------------数据库目录
1个LV*20G------------------------数据库日志目录
●HDISK13---HDISK14
2块盘打成productvg,用于ETL文件存放
●HDISK15---HDISK16
2块盘打成db2homevg,用于存所有的实例
2.详细划分步骤
1.
2.
2.1划分VG
mkvg-f-ydb2vg-s256hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mkvg-f-ydb2logvg-s256hdisk9hdisk10hdisk11hdisk12
mkvg-f-yproductvg-s256hdisk13hdisk14
mkvg-f-ydb2homevg-s256hdisk15hdisk16
激活vg
varyonvgdb2vg
varyonvgdb2logvg
varyonvgproductvg
varyonvgdb2homevg
2.2DB2VG划分
(1)7个多节点数据表空间lv,400G(裸设备条带化)
每个分50G,db2vg的pps256MPP数即50*1024/256=200
mklv-ylv_tbs01-traw-S128Kdb2vg200hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mklv-ylv_tbs02-traw-S128Kdb2vg200hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mklv-ylv_tbs03-traw-S128Kdb2vg200hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mklv-ylv_tbs04-traw-S128Kdb2vg200hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mklv-ylv_tbs05-traw-S128Kdb2vg200hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mklv-ylv_tbs06-traw-S128Kdb2vg200hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mklv-ylv_tbs07-traw-S128Kdb2vg200hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mklv-ylv_tbs00-traw-S128Kdb2vg200hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
(2)8个多节点临时表空间lv,40G(裸设备条带化)
每个分5G,db2vg的pps256MPP数即5*1024/256=20
mklv-ylv_tbs_tmp00-traw-S128Kdb2vg20hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mklv-ylv_tbs_tmp01-traw-S128Kdb2vg20hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mklv-ylv_tbs_tmp02-traw-S128Kdb2vg20hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mklv-ylv_tbs_tmp03-traw-S128Kdb2vg20hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mklv-ylv_tbs_tmp04-traw-S128Kdb2vg20hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mklv-ylv_tbs_tmp05-traw-S128Kdb2vg20hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mklv-ylv_tbs_tmp06-traw-S128Kdb2vg20hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
mklv-ylv_tbs_tmp07-traw-S128Kdb2vg20hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
(3)划1个单节点数据表空间lv,200G(与多节点比较用)
mklv-ylv_tbs_bak-traw-S128Kdb2vg800hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
(4)划1个单节点数据表空间lv,300G(前端数据)
mklv-ylv_tbs_data-traw-S128Kdb2vg1200hdisk1hdisk2hdisk3hdisk4hdisk5hdisk6hdisk7hdisk8
2.3DB2LOGVG划分
数据库目录、数据库日志文件空间
●1个lv上建文件系统(数据库目录文件)
mklv-ylv_db2path-tjfs2-S128Kdb2logvg400hdisk9hdisk10hdisk11hdisk12
crfs-vjfs2-d/dev/lv_db2path-m/db2path
mount/db2path
●8个lv建文件系统(数据库日志文件),指定到/db2_log/db2inst1下,每个节点20G
mklv-ylv_lognode00–S128K-tjfs2db2logvg80hdisk9hdisk10hdisk11hdisk12
mklv-ylv_lognode01–S128K-tjfs2db2logvg80hdisk9hdisk10hdisk11hdisk12
mklv-ylv_lognode02–S128K-tjfs2db2logvg80hdisk9hdisk10hdisk11hdisk12
mklv-ylv_lognode03–S128K-tjfs2db2logvg80hdisk9hdisk10hdisk11hdisk12
mklv-ylv_lognode04–S128K-tjfs2db2logvg80hdisk9hdisk10hdisk11hdisk12
mklv-ylv_lognode05–S128K-tjfs2db2logvg80hdisk9hdisk10hdisk11hdisk12
mklv-ylv_lognode06–S128K-tjfs2db2logvg80hdisk9hdisk10hdisk11hdisk12
mklv-ylv_lognode07–S128K-tjfs2db2logvg80hdisk9hdisk10hdisk11hdisk12
mklv–ylv_log1–tjfs2logdb2logvg1
crfs-vjfs2-d/dev/lv_lognode00-m/db2_log/db2inst1/NODE0000
crfs-vjfs2-d/dev/lv_lognode01-m/db2_log/db2inst1/NODE0001
crfs-vjfs2-d/dev/lv_lognode02-m/db2_log/db2inst1/NODE0002
crfs-vjfs2-d/dev/lv_lognode03-m/db2_log/db2inst1/NODE0003
crfs-vjfs2-d/dev/lv_lognode04-m/db2_log/db2inst1/NODE0004
crfs-vjfs2-d/dev/lv_lognode05-m/db2_log/db2inst1/NODE0005
crfs-vjfs2-d/dev/lv_lognode06-m/db2_log/db2inst1/NODE0006
crfs-vjfs2-d/dev/lv_lognode07-m/db2_log/db2inst1/NODE0007
挂载文件系统
mount/db2_log/db2inst1/NODE0000
mount/db2_log/db2inst1/NODE0001
mount/db2_log/db2inst1/NODE0002
mount/db2_log/db2inst1/NODE0003
mount/db2_log/db2inst1/NODE0004
mount/db2_log/db2inst1/NODE0005
mount/db2_log/db2inst1/NODE0006
mount/db2_log/db2inst1/NODE0007
2.4ETLVG划分
1个LV,建ETL文件系统
mklv-ylv_etl-tjfs2-S128Kproductvg800hdisk13hdisk14//200G
mklv-ylv_log2-tjfs2logproductvg1
crfs-vjfs2-d/dev/lv_etl-m/etl
mount/etl
2.5建实例db2home文件系统
mklv-ylv_db2home-tjfs2-S128Kdb2homevg280hdisk15hdisk16
crfs-vjfs2-d/dev/lv_db2home-m/db2home
mount/db2home
2.6赋属主
chown-Rdb2inst1:
db2iadm1/db2_log
db2iadm1/db2path
db2iadm1/db2home
db2iadm1/dev/lv_tbs*/dev/rlv_tbs*
三、DB2安装与配置
1.安装介质
1.拷贝安装介质到指定目录:
如/tmp/db2soft
2.解压:
tar-xvf安装介质.tar
3.安装:
/tmp/db2soft/exe]#
./db2_install-b/opt/ibm/db2/V9.7
4.安装补丁
解压后进入补丁安装目录:
./installFixPack-b
/opt/ibm/db2/V9.7
2.创建实例组、实例用户、实例
创建组:
mkgroup-aid=1100db2iadm1
mkgroup-aid=1101
db2fadm1
创建db2inst1用户:
mkuserid=1100pgrp=db2iadm1
groups=db2iadm1home=/db2home/db2inst1
db2inst1
密码:
passwddb2inst1
创建db2fenc1用户:
mkuserid=1101pgrp=db2fadm1
groups=db2fadm1home=/db2home/db2fenc1
db2fenc1
passwddb2fenc1
创建实例:
在安装目录:
/opt/ibm/db2/V9.7/instance]#./db2icrt-p50000-u
db2fenc1
3.修改相关配置
(1)修改db2nodes.cfg
位置在instance用户的$HOME/sqllib/.文件格式是:
<
logicport>
<
hostname>
//主机名要与/etc/hosts的主机名一致或hostname命令查看
0r2010
1r2011
2r2012
3r2013
4r2014
5r2015
6r2016
7r2017
(2)检查services文件(多节点配置自动生成多个服务端口)
vi
/etc/services
-G跳到最后一行
DB2c_db2inst1
50000/tcp
//要与dbm
SVCENAME一致
DB2_db2inst1
60000/tcp
DB2_db2inst1_1
60001/tcp
DB2_db2inst1_2
60002/tcp
DB2_db2inst1_3
60003/tcp
DB2_db2inst1_4
60004/tcp
DB2_db2inst1_5
60005/tcp
DB2_db2inst1_6
60006/tcp
DB2_db2inst1_7
60007/tcp
DB2_db2inst1_END
60008/tcp
4.验证RSH服务远程登录
多节点部署需确认系统下rsh服务开启,并能实现远程登录
(1)编辑双方的/etc/hosts.equiv
(加对方的ip地址)
(2)实例用户下的$HOME目录下建.rhosts文件,内容是power6-1
(3)确定/etc/hosts文件的格式正确:
10.1.252.67power6-1
5.调整实例参数
db2setDB2COMM=tcpip
db2setdb2country=86
db2setDB2CODEPAGE=1386
db2setdb2_parallel_io=*:
8
db2setDB2_ANTIJOIN=no
db2setdb2_hash_join=yes
db2setDB2_INLIST_TO_NLJN=yes
db2setDB2_NEW_CORR_SQ_FF=ON
db2setdb2_binsort=yes
db2updatedbmcfgusingSVCENAMEDB2c_db2inst1
db2updatedbmcfgusingSHEAPTHRES
1048576(4G)
db2updatedbmcfgusingintra_parallelNO
db2updatedbmcfgusingNUM_POOLAGENTS0;
db2stop重启实例生效
6.建库
createdatabase
testdb
on/db2_path
usingcodesetgbkterritorycn
7.建缓冲池
CREATEBUFFERPOOLBUFFER32IMMEDIATEALLDBPARTITIONNUMSSIZE
65536PAGESIZE32K
//初始值可设置可用内存的(OLTP内存的25%,OLAP内存的40%)
8.建表空间
(1)单节点数据表空间(与多节点对比)
CREATETABLESPACEDB_DATA1INDATABASEPARTITIONGROUPNODE0_GRPPAGESIZE32KMANAGEDBYdatabase
using(device'
/dev/rlv_tbs_bak'
200G)ONDBPARTITIONNUM(0)
extentsize32prefetchsizeautomaticbufferpoolBUFFER32
nofilesystemcaching;
//extentsize(块页数)=每块盘条带深度128k*8块磁盘/32k(页大小)=32
(2)单节点数据表空间(前端数据展现)
CREATETABLESPACEDB_DATAINDATABASEPARTITIONGROUPNODE0_GRPPAGESIZE32KMANAGEDBYdatabase
/dev/rlv_tbs_data'
300G)ONDBPARTITIONNUM(0)
(3)多节点数据表空间
建分区组:
CREATEDATABASEPARTITIONGROUPNODE_GRPON
DBPARTITIONNUM(1,2,3,4,5,6,7);
CREATEDATABASEPARTITIONGROUPNODE0_GRPON
DBPARTITIONNUM(0);
表空间:
CREATETABLESPACETBS_DATAINDATABASEPARTITIONGROUPNODE_GRPPAGESIZE32KMANAGEDBYdatabase
/dev/rlv_tbs01'
50G)ONDBPARTITIONNUM
(1)
/dev/rlv_tbs02'
50G)ONDBPARTITIONNUM
(2)
/dev/rlv_tbs03'
50G)ONDBPARTITIONNUM(3)
/dev/rlv_tbs04'
50G)ONDBPARTITIONNUM(4)
/dev/rlv_tbs05'
50G)ONDBPARTITIONNUM(5)
/dev/rlv_tbs06'
50G)ONDBPARTITIONNUM(6)
/dev/rlv_tbs07'
50G)ONDBPARTITIONNUM(7)
(4)多节点
临时表空间
CREATETEMPORARYTABLESPACETBS_TMPINDATABASEPARTITIONGROUPIBMTEMPGROUPPAGESIZE32KMANAGEDBYdatabase
using(device'
/dev/rlv_tbs_tmp00'
5G)ONDBPARTITIONNUM(0)
/dev/rlv_tbs_tmp01'
5G)ONDBPARTITIONNUM
(1)
/dev/rlv_tbs_tmp02'
5G)ONDBPARTITIONNUM
(2)
/dev/rlv_tbs_tmp03'
5G)ONDBPARTITIONNUM(3)
/dev/rlv_tbs_tmp04'
5G)ONDBPARTITIONNUM(4)
/dev/rlv_tbs_tmp05'
5G)ONDBPARTITIONNUM(5)
/dev/rlv_tbs_tmp06'
5G)ONDBPARTITIONNUM(6)
/dev/rlv_tbs_tmp07'
5G)ONDBPARTITIONNUM(7)
9.调整数据库参数
db2updatedbcfgfortestdbusingNEWLOGPATH/db2_log/db2inst1
db2updatedbcfgfortestdbusingLOGBUFSZ512//日志内部缓冲区
db2updatedbcfgfortestdbusingCATALOGCACHE_SZ512
db2updatedbcfgfortestdbusingSORTHEAP65536(256M)
db2updatedbcfgfortestdbusingSHEAPTHRES_SHR1048576
db2updatedbcfgfortestdbusingAPPLHEAPSZ512
db2updatedbcfgfortestdbusingLOCKLIST10240
db2updatedbcfgfortestdbusingMAXLOCKS30
db2updatedbcfgfortestdbusingLOCKTIMEOUT180
db2updatedbcfgfortestdbusingPCKCAC
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 存储 规划 DB2 安装