为某金融行业客户实施DB2 pureScale技术验证实战案例
最近为一个金融行业的客户实施DB2 pureScale技术验证，具体内容包括硬件配置、存储规划、具体安装过程、建库与配置、WAS配置等。其中服务器使用Power 740双机双逻辑分区，双成员双CF。现在分享出来，具体的实施过程如下，由于写的比较简练，大家有问题的可以通过我的QQ号16198686进行详细讨论：
1,硬件配置
1.1，在hosts文件中指定所有节点的hostname,主机名可以用smit hostname或者smit tcpip来指定，这一步很关键，定下来后就不用修改了。
172.16.26.184 m0
172.16.26.185 cf0
172.16.26.186 m1
172.16.26.187 cf1
10.10.10.1 m0-ib0
10.10.10.2 cf0-ib0
10.10.11.2 cf0-ib1
10.10.10.3 m1-ib0
10.10.10.4 cf1-ib0
10.10.11.4 cf1-ib1
1.2，配置NTP，使得所有节点时间完全同步
Server:
#broadcastclient
#server 172.16.26.184 prefer
#fudge 172.16.26.184
server 127.127.1.0
driftfile /etc/ntp.drift
tracefile /etc/ntp.trace
client:
#broadcastclient
server 172.16.26.184
driftfile /etc/ntp.drift
tracefile /etc/ntp.trace
1.3，IB通讯端口配置，/etc/dat.conf,用1.2或者2.0都可以，但是要配置正确，否则会出现通讯错误
--1.2
hca0 u1.2 nonthreadsafe default /usr/lib/libdapl/libdapl.a(shr_64.o) IBM.1.1 "/dev/iba0 1 ib0" " "
hca1 u1.2 nonthreadsafe default /usr/lib/libdapl/libdapl.a(shr_64.o) IBM.1.1 "/dev/iba0 2 ib1" " "
--2.0
hca0 u2.0 nonthreadsafe default /usr/lib/libdapl/libdapl2.a(shr_64.o) IBM.1.1 "/dev/iba0 1 ib0" " "
hca1 u2.0 nonthreadsafe default /usr/lib/libdapl/libdapl2.a(shr_64.o) IBM.1.1 "/dev/iba0 2 ib1" " "
1.4，执行db2prereqcheck，进行检查
bash-3.00# ./db2prereqcheck -p -v 10.1.0.0
==========================================================================
Checking DB2 prerequisites for DB2 database version "10.1.0.0" on operating system "AIX"
Validating "kernel level " ...
Required minimum operating system kernel level: "6.1".
Actual operating system kernel level: "7.1".
Requirement matched.
Validating "AIX technology level and service pack " ...
Required minimum technology level: "0" Service pack: "3"
Actual technology level: "2" Service pack: "2"
Requirement matched.
Validating "XL C/C++ Runtime" ...
Required minimum "XL C/C++ Runtime" level: "11.1.0.1"
Actual version: "12.1.0.0"
Requirement matched.
Validating "openssh & Remote root login" ...
Found package "openssh" on host "p74020lpar1".
Remote root login is enabled on host "p74020lpar1".
Requirement matched.
Validating "IOPORTS" ...
The input/output completion Port (IOCP) is installed on host "p74020lpar1".
The input/output completion Port (IOCP) is enabled on host "p74020lpar1".
Requirement matched.
Validating "free space" ...
The directory "/tmp" has enough space on host "p74020lpar1".
Requirement matched.
Validating "free space" ...
The directory "/var" has enough space on host "p74020lpar1".
Requirement matched.
Validating "free space" ...
The directory "/home" has enough space on host "p74020lpar1".
Requirement matched.
Validating "free space" ...
The directory "/opt" has enough space on host "p74020lpar1".
Requirement matched.
Validating "free space" ...
The directory "/" has enough space on host "p74020lpar1".
Requirement matched.
Validating "uDAPL" ...
Required minimum "uDAPL" level: "7.1.0.15"
Actual version: "7.1.2.15"
Requirement matched.
DBT3533I The db2prereqcheck utility has confirmed that all installation prerequisites were met for DB2 database "server " "with DB2 pureScale feature ". Version: "10.1.0.0".
2，存储规划
存储使用V7000，共10个HDISK，为它们配置相同的PVID，并使用rendev命令为它们指定相同的盘符，HDISK[30,39]
--数据
hdisk30 00f7521f88be8382 None
hdisk31 00f7521f88be83f1 None
hdisk32 00f7521f88be85e4 None
hdisk33 00f7521f8897bf49 None
--日志
hdisk34 00f7521f88be8759 None
hdisk35 00f7521f88be87b2 None
--临时目录
hdisk36 00f7521f88be882d None
hdisk37 00f7521f88be888f None
--实例共享目录
hdisk38 00f7521f88be88ff None
--仲裁盘
hdisk39 00f7521f88be8969 None
（1）选定一个节点，使用lspv命令查看系统上的hdisk信息和PVID信息。
（2）在当前节点分区上，给所有的hdisk设置PVID，例如给hdisk9设置PVID如下所示：
chdev -l hdisk9 -a pv=yes
（3）在其他节点分区上，通过rmdev命令执行同样的步骤删除所有磁盘旧有的PVID信息，例如删除hdisk9上旧有的PVID信息，命令如下：
rmdev -dl hdisk9
（4）在其他节点上运行cfgmgr命令，这样系统将从存储中重新检索 PVID，即在第（2）步中设置的PVID信息，这样所有节点所有磁盘的PVID就完全一致了。
--必须用root账号创建文件系统，随后chown给db2sdin1
db2cluster -CFS -CREATE -FILESYSTEM db2data -DISK /dev/hdisk30,/dev/hdisk31,/dev/hdisk32,/dev/hdisk33 -MOUNT /db2fs/db2data
db2cluster -CFS -CREATE -FILESYSTEM db2log -DISK /dev/hdisk34,/dev/hdisk35 -MOUNT /db2fs/db2log
db2cluster -CFS -CREATE -FILESYSTEM db2temp -DISK /dev/hdisk36,/dev/hdisk37 -MOUNT /db2fs/db2temp
chown -R db2sdin1:db2iadm1 /db2fs
bash-3.00# /usr/lpp/mmfs/bin/mmlsconfig
Configuration data for cluster db2cluster_20130701202609.m0:
------------------------------------------------------------
myNodeConfigNumber 1
clusterName db2cluster_20130701202609.m0
clusterId 12032107047233353057
autoload yes
dmapiFileHandleSize 32
minReleaseLevel 3.5.0.3
maxFilesToCache 10000
pagepool 512M
verifyGpfsReady yes
worker1Threads 512
sharedMemLimit 2047M
failureDetectionTime 35
leaseRecoveryWait 35
totalPingTimeout 75
tiebreakerDisks gpfs1nsd
adminMode allToAll
File systems in cluster db2cluster_20130701202609.m0:
-----------------------------------------------------
/dev/db2data
/dev/db2fs1
/dev/db2log
/dev/db2temp
bash-3.00# ./db2cluster -cfs -stop -all
All specified hosts have been stopped successfully.
bash-3.00# /usr/lpp/mmfs/bin/mmchconfig usePersistentReserve=yes
Verifying GPFS is stopped on all nodes ...
mmchconfig: Processing disk gpfs2nsd
mmchconfig: Processing disk gpfs3nsd
mmchconfig: Processing disk gpfs4nsd
mmchconfig: Processing disk gpfs5nsd
mmchconfig: Processing disk gpfs1nsd
mmchconfig: Processing disk gpfs6nsd
mmchconfig: Processing disk gpfs7nsd
mmchconfig: Processing disk gpfs8nsd
mmchconfig: Processing disk gpfs9nsd
mmchconfig: Command successfully completed
mmchconfig: 6027-1371 Propagating the cluster configuration data to all
affected nodes. This is an asynchronous process.
bash-3.00# /usr/lpp/mmfs/bin/mmlsconfig | grep PersistentReserve
usePersistentReserve yes
bash-3.00# ./db2cluster -cfs -start -all
All specified hosts have been started successfully.
bash-3.00# /usr/lpp/mmfs/bin/mmlsnsd -X
Disk name NSD volume ID Device Devtype Node name Remarks
---------------------------------------------------------------------------------------------------
gpfs1nsd AC101AB851D17583 /dev/hdisk38 hdisk m0 pr=yes
gpfs2nsd AC101AB851D1AED0 /dev/hdisk30 hdisk m0 pr=yes
gpfs3nsd AC101AB851D1AED1 /dev/hdisk31 hdisk m0 pr=yes
gpfs4nsd AC101AB851D1AED2 /dev/hdisk32 hdisk m0 pr=yes
gpfs5nsd AC101AB851D1AED3 /dev/hdisk33 hdisk m0 pr=yes
gpfs6nsd AC101ABB51D1AF2B /dev/hdisk34 hdisk m0 pr=yes
gpfs7nsd AC101ABB51D1AF2C /dev/hdisk35 hdisk m0 pr=yes
gpfs8nsd AC101AB851D1AF47 /dev/hdisk36 hdisk m0 pr=yes
gpfs9nsd AC101AB851D1AF48 /dev/hdisk37 hdisk m0 pr=yes
3,安装过程
创建用户，并分别为root和db2sdin1建立SSH互信
mkgroup id=999 db2iadm1
mkgroup id=998 db2fadm1
mkuser id=1004 pgrp=db2iadm1 groups=db2iadm1 db2sdin1
mkuser id=1003 pgrp=db2fadm1 groups=db2fadm1 db2sdfe1
./db2_install
Task #8 end
Task #9 start
Description: Java support
Estimated time 13 second(s)
Task #9 end
Task #10 start
Description: SQL procedures
Estimated time 3 second(s)
Task #10 end
Task #11 start
Description: ICU Utilities
Estimated time 71 second(s)
Task #11 end
Task #12 start
Description: Java Common files
Estimated time 18 second(s)
Task #12 end
Task #13 start
Description: Base server support
Estimated time 484 second(s)
Task #13 end
Task #14 start
Description: Connect support
Estimated time 3 second(s)
Task #14 end
Task #15 start
Description: Relational wrappers common
Estimated time 3 second(s)
Task #15 end
Task #16 start
Description: DB2 data source support
Estimated time 13 second(s)
Task #16 end
Task #17 start
Description: Spatial Extender server support
Estimated time 17 second(s)
Task #17 end
Task #18 start
Description: IBM Software Development Kit (SDK) for Java(TM)
Estimated time 280 second(s)
Task #18 end
Task #19 start
Description: DB2 LDAP support
Estimated time 4 second(s)
Task #19 end
Task #20 start
Description: DB2 Instance Setup wizard
Estimated time 19 second(s)
Task #20 end
Task #21 start
Description: Integrated Flash Copy Support
Estimated time 489 second(s)
Task #21 end
Task #22 start
Description: General Parallel File System (GPFS)
Estimated time 100 second(s)
Task #22 end
Task #23 start
Description: Spatial Extender client
Estimated time 4 second(s)
Task #23 end
Task #24 start
Description: Communication support - TCP/IP
Estimated time 3 second(s)
Task #24 end
Task #25 start
Description: Tivoli SA MP
Estimated time 300 second(s)
Task #25 end
Task #26 start
Description: Base application development tools
Estimated time 45 second(s)
Task #26 end
Task #27 start
Description: DB2 Update Service
Estimated time 4 second(s)
Task #27 end
Task #28 start
Description: Parallel Extension
Estimated time 3 second(s)
Task #28 end
Task #29 start
Description: EnterpriseDB code
Estimated time 4 second(s)
Task #29 end
Task #30 start
Description: Replication tools
Estimated time 60 second(s)
Task #30 end
Task #31 start
Description: Cluster Caching Facility
Estimated time 18 second(s)
Task #31 end
Task #32 start
Description: Sample database source
Estimated time 4 second(s)
Task #32 end
Task #33 start
Description: itlm
Estimated time 3 second(s)
Task #33 end
Task #34 start
Description: DB2 Text Search
Estimated time 105 second(s)
Task #34 end
Task #35 start
Description: Command Line Processor Plus
Estimated time 6 second(s)
Task #35 end
Task #36 start
Description: Informix data source support
Estimated time 6 second(s)
Task #36 end
Task #37 start
Description: IBM DB2 pureScale Feature
Estimated time 3 second(s)
Task #37 end
Task #38 start
Description: First Steps
Estimated time 3 second(s)
Task #38 end
Task #39 start
Description: Product Signature for DB2 Enterprise Server Edition
Estimated time 6 second(s)
Task #39 end
Task #40 start
Description: Setting DB2 library path
Estimated time 180 second(s)
Task #40 end
Task #41 start
Description: Copying DB2 image
Estimated time 600 second(s)
Task #41 end
Task #42 start
Description: Installing or updating DB2 HA scripts for IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP)
Estimated time 40 second(s)
Task #42 end
Task #43 start
Description: Installing or updating DB2 Cluster Scripts for IBM General Parallel File System (GPFS)
Estimated time 40 second(s)
Task #43 end
Task #44 start
Description: Installing or updating DB2 SSH Utilities
Estimated time 5 second(s)
Task #44 end
Task #45 start
Description: Executing control tasks
Estimated time 20 second(s)
Task #45 end
Task #46 start
Description: Updating global registry
Estimated time 20 second(s)
Task #46 end
Task #47 start
Description: Updating the db2ls link
Estimated time 1 second(s)
Task #47 end
Task #48 start
Description: Registering DB2 licenses
Estimated time 5 second(s)
Task #48 end
Task #49 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #49 end
Task #50 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #50 end
Task #51 start
Description: Registering DB2 Update Service
Estimated time 30 second(s)
Task #51 end
Task #52 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #52 end
The execution completed successfully.
For more information see the DB2 installation log at
"/tmp/db2_install.log.14155828".
bash-3.00# ./db2cluster_prepare -instance_shared_dev /dev/hdisk38
DBI1446I The db2cluster_prepare command is running.
DB2 installation is being initialized.
Total number of tasks to be performed: 1
Total estimated time for all tasks to be performed: 60 second(s)
Task #1 start
Description: Creating IBM General Parallel File System (GPFS) Cluster and Filesystem
Estimated time 60 second(s)
Task #1 end
The execution completed successfully.
For more information see the DB2 installation log at
"/tmp/db2cluster_prepare.log".
DBI1070I Program db2cluster_prepare completed successfully.
bash-3.00# ./db2icrt -d -a SERVER_ENCRYPT -m m0 -mnet m0-ib0 -cf cf0 -cfnet cf0 -ib0 -instance_shared_dir /db2sd_20130701202751 -tbdev /dev/hdisk39 -u db2sdfe1 db2sdin1
DBI1446I The db2icrt command is running.
DB2 installation is being initialized.
Total number of tasks to be performed: 10
Total estimated time for all tasks to be performed: 1074 second(s)
Task #1 start
Description: Installing DB2 files on remote hosts
Estimated time 600 second(s)
Task #1 end
Task #2 start
Description: Installing or updating DB2 HA scripts for IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP)
Estimated time 40 second(s)
Task #2 end
Task #3 start
Description: Installing or updating DB2 Cluster Scripts for IBM General Parallel File System (GPFS)
Estimated time 40 second(s)
Task #3 end
Task #4 start
Description: Registering licenses on remote hosts
Estimated time 40 second(s)
Task #4 end
Task #5 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #5 end
Task #6 start
Description: Register NTP
Estimated time 40 second(s)
Task #6 end
Task #7 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #7 end
Task #8 start
Description: Initiating the remote host list
Estimated time 5 second(s)
Task #8 end
Task #9 start
Description: Configuring DB2 instances
Estimated time 300 second(s)
Task #9 end
Task #10 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #10 end
The execution completed successfully.
For more information see the DB2 installation log at
"/tmp/db2icrt.log.14811184".
Required: Review the following log file also for warnings or errors:
"/tmp/db2icrt_local.log.*"
DBI1070I Program db2icrt completed successfully.
bash-3.00# ./db2iupdt -add -m m1 -mnet m1-ib0 db2sdin1
DBI1446I The db2iupdt command is running.
DB2 installation is being initialized.
Total number of tasks to be performed: 10
Total estimated time for all tasks to be performed: 1074 second(s)
Task #1 start
Description: Installing DB2 files on remote hosts
Estimated time 600 second(s)
Task #1 end
Task #2 start
Description: Installing or updating DB2 HA scripts for IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP)
Estimated time 40 second(s)
Task #2 end
Task #3 start
Description: Installing or updating DB2 Cluster Scripts for IBM General Parallel File System (GPFS)
Estimated time 40 second(s)
Task #3 end
Task #4 start
Description: Registering licenses on remote hosts
Estimated time 40 second(s)
Task #4 end
Task #5 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #5 end
Task #6 start
Description: Register NTP
Estimated time 40 second(s)
Task #6 end
Task #7 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #7 end
Task #8 start
Description: Initiating the remote host list
Estimated time 5 second(s)
Task #8 end
Task #9 start
Description: Configuring DB2 instances
Estimated time 300 second(s)
Task #9 end
Task #10 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #10 end
The execution completed successfully.
For more information see the DB2 installation log at
"/tmp/db2iupdt.log.8978608".
DBI1070I Program db2iupdt completed successfully.
bash-3.00# ./db2iupdt -add -cf cf1 -cfnet cf1-ib0 db2sdin1
DBI1446I The db2iupdt command is running.
DB2 installation is being initialized.
Total number of tasks to be performed: 10
Total estimated time for all tasks to be performed: 1074 second(s)
Task #1 start
Description: Installing DB2 files on remote hosts
Estimated time 600 second(s)
Task #1 end
Task #2 start
Description: Installing or updating DB2 HA scripts for IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP)
Estimated time 40 second(s)
Task #2 end
Task #3 start
Description: Installing or updating DB2 Cluster Scripts for IBM General Parallel File System (GPFS)
Estimated time 40 second(s)
Task #3 end
Task #4 start
Description: Registering licenses on remote hosts
Estimated time 40 second(s)
Task #4 end
Task #5 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #5 end
Task #6 start
Description: Register NTP
Estimated time 40 second(s)
Task #6 end
Task #7 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #7 end
Task #8 start
Description: Initiating the remote host list
Estimated time 5 second(s)
Task #8 end
Task #9 start
Description: Configuring DB2 instances
Estimated time 300 second(s)
Task #9 end
Task #10 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #10 end
The execution completed successfully.
For more information see the DB2 installation log at
"/tmp/db2iupdt.log.14811176".
DBI1070I Program db2iupdt completed successfully.
bash-3.00# ./db2iupdt -update -cf cf0 -cfnet cf0-ib0,cf0-ib1 db2sdin1
DBI1446I The db2iupdt command is running.
DB2 installation is being initialized.
Total number of tasks to be performed: 10
Total estimated time for all tasks to be performed: 1074 second(s)
Task #1 start
Description: Installing DB2 files on remote hosts
Estimated time 600 second(s)
Task #1 end
Task #2 start
Description: Installing or updating DB2 HA scripts for IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP)
Estimated time 40 second(s)
Task #2 end
Task #3 start
Description: Installing or updating DB2 Cluster Scripts for IBM General Parallel File System (GPFS)
Estimated time 40 second(s)
Task #3 end
Task #4 start
Description: Registering licenses on remote hosts
Estimated time 40 second(s)
Task #4 end
Task #5 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #5 end
Task #6 start
Description: Register NTP
Estimated time 40 second(s)
Task #6 end
Task #7 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #7 end
Task #8 start
Description: Initiating the remote host list
Estimated time 5 second(s)
Task #8 end
Task #9 start
Description: Configuring DB2 instances
Estimated time 300 second(s)
Task #9 end
Task #10 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #10 end
The execution completed successfully.
For more information see the DB2 installation log at
"/tmp/db2iupdt.log.13959376".
DBI1070I Program db2iupdt completed successfully.
bash-3.00# ./db2iupdt -update -cf cf1 -cfnet cf1-ib0,cf1-ib1 db2sdin1
DBI1446I The db2iupdt command is running.
DB2 installation is being initialized.
Total number of tasks to be performed: 10
Total estimated time for all tasks to be performed: 1074 second(s)
Task #1 start
Description: Installing DB2 files on remote hosts
Estimated time 600 second(s)
Task #1 end
Task #2 start
Description: Installing or updating DB2 HA scripts for IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP)
Estimated time 40 second(s)
Task #2 end
Task #3 start
Description: Installing or updating DB2 Cluster Scripts for IBM General Parallel File System (GPFS)
Estimated time 40 second(s)
Task #3 end
Task #4 start
Description: Registering licenses on remote hosts
Estimated time 40 second(s)
Task #4 end
Task #5 start
Description: Setting default global profile registry variables
Estimated time 1 second(s)
Task #5 end
Task #6 start
Description: Register NTP
Estimated time 40 second(s)
Task #6 end
Task #7 start
Description: Initializing instance list
Estimated time 5 second(s)
Task #7 end
Task #8 start
Description: Initiating the remote host list
Estimated time 5 second(s)
Task #8 end
Task #9 start
Description: Configuring DB2 instances
Estimated time 300 second(s)
Task #9 end
Task #10 start
Description: Updating global profile registry
Estimated time 3 second(s)
Task #10 end
The execution completed successfully.
For more information see the DB2 installation log at
"/tmp/db2iupdt.log.13959422".
DBI1070I Program db2iupdt completed successfully.
4,DB2建库与配置
create database nc63 on /db2fs/db2data using codeset GBK territory CN;
环境变量
bash-3.00$ db2set
DB2_COMPATIBILITY_VECTOR=ORA
DB2RSHCMD=/bin/ssh
DB2COMM=TCPIP
DB2CODEPAGE=1386
DB2AUTOSTART=NO
--/etc/services，注意，一定不能设定为60000！
db2c_db2inst1 50000/tcp # DB2 connection service port
db2 update dbm cfg using SVCENAME db2c_db2inst1
db2set DB2COMM=TCPIP
bash-3.00$ db2 update db cfg using NEWLOGPATH /db2fs/db2log
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W One or more of the parameters submitted for immediate modification
were not changed dynamically. For these configuration parameters, the database
must be shutdown and reactivated before the configuration parameter changes
become effective.
bash-3.00$ db2 update db cfg for nc63 using auto_reval DEFERRED_FORCE
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W One or more of the parameters submitted for immediate modification
were not changed dynamically. For these configuration parameters, the database
must be shutdown and reactivated before the configuration parameter changes
become effective.
bash-3.00$ db2 update db cfg for nc63 using decflt_rounding ROUND_HALF_UP
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1418W Changing the database configuration parameter DECFLT_ROUNDING may
have unintended consequences. The value was not changed dynamically. All
applications must disconnect from this database before the changes become
effective. SQLSTATE=0168M
bash-3.00$ db2 update db cfg using LOCKTIMEOUT 30
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W One or more of the parameters submitted for immediate modification
were not changed dynamically. For these configuration parameters, the database
must be shutdown and reactivated before the configuration parameter changes
become effective.
bash-3.00$ db2 get db cfg | grep -i sortheap
Sort list heap (4KB) (SORTHEAP) = AUTOMATIC(17860)
bash-3.00$ db2 get db cfg | grep -i shr
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(89301)
bash-3.00$ db2 get db cfg | grep -i shr
Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = AUTOMATIC(1638400)
bash-3.00$ db2 get db cfg | grep -i sortheap
Sort list heap (4KB) (SORTHEAP) = AUTOMATIC(327680)
5，WAS配置
1, 替换驱动，db2jcc.jar，db2jcc_license_cu.jar
2，在WAS的/etc/hosts文件增加m0，m1
3，修改WAS的设置
配置数据源自定义属性：
enableSysplexWLB=true
clientRerouteAlternateServerName=172.16.50.12 --M1 IP地址
clientRerouteAlternatePortNumber=50000 --M1 端口
如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！
赞1作者其他文章
评论 3 · 赞 1
评论 0 · 赞 2
评论 0 · 赞 0
评论 11 · 赞 9
评论 8 · 赞 0
添加新评论24 条评论
2014-05-18 10:26
2014-04-14 15:09
2014-03-28 15:49
2014-03-27 14:58
2014-03-25 23:22
2013-09-15 22:37
2013-08-29 15:05
2013-08-29 09:51
2013-08-21 15:25
2013-08-16 17:08
2013-08-16 15:06
2013-08-16 14:42
2013-08-14 11:08
2013-08-12 14:15
2013-08-12 14:10
2013-08-12 10:59
2013-08-12 08:58
2013-08-12 01:10
2013-08-11 21:14
2013-08-11 19:35
2013-08-11 18:17
2013-08-11 17:05
2013-08-11 16:50
2013-08-11 16:42