Shulou(Shulou.com)05/31 Report--

This article mainly shows you "Suse11.4 + DB2 10.5fp8 pureScale how to install and deploy", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "Suse11.4 + DB2 10.5fp8 pureScale how to install and deploy" this article.

1. Install the Suse 11.4 operating system

192.168.1.98 psfc

192.168.1.95 psnode1

192.168.1.96 psnode2

Operating system Suse11.4

DB2 version of DB2 10.5fp8

File system restrictions:

/ var at least 2G remaining space

/ tmp at least 2G remaining space

/ ibmdb2/V10.5 at least 6G remaining space

two。 Configure shared storage

Use vSphere Client

Add a new hard disk in psfc with a size of 20g, select SCSI1:0, set the postset to zero, and set the SCSI controller to "virtual"

Add an existing hard disk in psnode1 and select the SCSI1:0,SCSI controller set to "virtual"

Add an existing hard disk in psnode2 and select the SCSI1:0,SCSI controller set to "virtual"

3. Install the necessary packages

Check the installation source

Zypper lr-d

Zypper rr 1

Configure installation sourc

Zypper addrepo-c-f-t yast2-n SLES-11-SP4-DVD-x86_64-GM-ISO iso:/?iso=/software/SLES-11-SP4-DVD-x86_64-GM-DVD1.iso DVDISO

Zypper lr-d

Zypper clean

Zypper refresh

Install the necessary packages

Need to install such as the following package

Zypper-non-interactive-no-gpg-checks install-ylR libstdc++*

Zypper-non-interactive-no-gpg-checks install-ylR glibc++*

Zypper-non-interactive-no-gpg-checks install-ylR cpp

Zypper-non-interactive-no-gpg-checks install-ylR gcc

Zypper-non-interactive-no-gpg-checks install-ylR gcc-c++

Zypper-non-interactive-no-gpg-checks install-ylR kernel-default

Zypper-non-interactive-no-gpg-checks install-ylR kernel-default-devel

Zypper-non-interactive-no-gpg-checks install-ylR kernel-default-base

Zypper-non-interactive-no-gpg-checks install-ylR kernel-source

Zypper-non-interactive-no-gpg-checks install-ylR kernel-syms

Zypper-non-interactive-no-gpg-checks install-ylR binutils

Zypper-non-interactive-no-gpg-checks install-ylR OpenSSH

Zypper-non-interactive-no-gpg-checks install-ylR sg3_utils

Zypper-non-interactive-no-gpg-checks install-ylR ntp

4. Modify environment variabl

Vi / etc/profile.local add content

Export PATH=/root/bin:/usr/sbin/rsct/bin:/ibmdb2/V10.5:$PATH

Export PATH=/usr/lpp/mmfs/bin:$PATH

Export DB2USENONIB=TRUE

Export DB2_CFS_GPFS_NO_REFRESH_DATA=true

Then execute #. / etc/profile.local

Mkdir-p / ibmdb2/V10.5

# vi ~ / .profile

Set-o vi

Export DB2DIR=/ibmdb2/V10.5

5. Edit / etc/hosts

Add the hostnames and IP addresses of the three machines

6. Create a DB2 user

Groupadd-g 401 db2grp

Groupadd-g 402 db2fgrp

Groupadd-g 403 db2oper

Useradd-u 401-g db2grp-m-d / db2inst/db2inst1-s / bin/bash db2inst1

Usermod-g db2grp-m-d / db2inst/db2inst1-s / bin/bash db2inst1

Echo "db2inst1:abcd1234" | / usr/sbin/chpasswd

Useradd-u 402-g db2fgrp-m-d / home/db2fenc1-s / bin/bash db2fenc1

Usermod-g db2fgrp-R dialout,video-m-d / home/db2fenc1-s / bin/bash db2fenc1

7. Configure SSH mutual trust

Both root and DB2 instance users need (db2inst1)

# ssh-keygen-t rsa

Then enter all the way and use the default value. The id_dsa.pub public key is generated under / root/.ssh or under .ssh of the current user directory, and the file is copied to the corresponding directory of the other machine and executed:

# cat id_rsa.pub > > ~ / .ssh/authorized_keys

Chmod 600 authorized_keys

Note that this is done under both root and db2inst1 users to ensure that root and db2inst1 users running ssh suse2 on suse1 and suse2 running ssh suse1 directly connect without any prompts or passwords.

# mkdir / root/.ssh

# su-db2inst1-c "mkdir-p / db2inst/db2inst1/.ssh"

Ssh psnode2 date

Ssh psnode1 date

Ssh psfc date

8. Modify kernel parameters

Vi / etc/sysctl.conf

The following is added at the end of the document:

= configuration of 4G memory =

# DB2 10.5 Cconfiguration Parameter

Kernel.shmmni = 32768

Kernel.shmmax = 4294967296

Kernel.shmall = 2097152

Kernel.sem = 250 2048000 32 8192

Kernel.msgmni = 4096

Kernel.msgmax = 65536

Kernel.msgmnb = 65536

Vm.swappiness = 0

Vm.overcommit_memory = 0

To make the configuration changes effective:

# sysctl-p

To ensure that the above parameters take effect after restart, execute the following command:

# / sbin/chkconfig-- level 35 boot.sysctl on

Run ipcs-l to view memory

# ipcs-l

9. Configure Shell restrictions

Root user execution

# vi / etc/security/limits.conf

Add the following to the end of the file:

Db2inst1 soft core unlimited

Db2inst1 hard core unlimited

Db2inst1 soft memlock unlimited

Db2inst1 hard memlock unlimited

Db2inst1 soft rss unlimited

Db2inst1 hard rss unlimited

Db2inst1 soft nofile unlimited

Db2inst1 hard nofile 1048576

Db2inst1 soft stack unlimited

Db2inst1 hard stack unlimited

10. Install the DB2 10.5 PureScale feature

Decompression medium

Using the root user login environment, execute the following command to extract the media (please operate the appropriate files according to the installation version)

# cd / ibmdb2/software

# tar xzvf v10.5fp8_linuxx64_server_t.tar.gz

4.1.2 pre-installation check

Enter the media installation directory

# cd server_t

Check before installation:

#. / db2prereqcheck-s-l-p

Start the installer using db2_install

# echo $DB2DIR

Confirm that the $DB2DIR environment variable is set to take effect

# umask 0022

#. / db2_install-b $DB2DIR-l / tmp/db2install.log

Select SERVER

Select YES

# cat / tmp/db2install.log

Check for errors during installation!

-- register for license

# cd $DB2DIR/adm

View license

#. / db2licm-l

Register for license

#. / db2licm-a / ibmdb2/software/db2aese_c_v10.5.lic

View license

#. / db2licm-l

11. GPFS cluster configuration

Create a GPFS cluster

Cd / ibmdb2/V10.5/bin

. / db2cluster-cfs-create-host psfc-domain gpfsdomain

. / db2cluster-cfs-add-host psnode1

. / db2cluster-cfs-add-host psnode2

. / db2cluster-cfs-add-license

/ usr/lpp/mmfs/bin/mmlscluster

. / db2cluster-cfs-start-all

Create a GPFS file system

Mmgetstate-a

. / db2cluster-cfs-create-filesystem gpfs1nsd-disk / dev/sdc-mount / gpfs1nsd

. / db2cluster-cfs-list-filesystem

Mmlsnsd

Mmlsfs all

Modify shared folder permissions

Chown db2inst1:db2grp / gpfs1nsd

twelve。 Create a DB2 instance

Cd / ibmdb2/V10.5/instance

. / db2icrt-d-cf psfc-cfnet psfc-m psnode1-mnet psnode1-instance_shared_dir / gpfs1nsd-tbdev / dev/sdb-u db2fenc1 db2inst1

Start the instance

Db2set DB2_CA_TRANSPORT_METHOD=SOCKETS

Db2start

Db2instance-list

13. New member node

Mmgetstate-a

/ ibmdb2/V10.5/instance/db2iupdt-d-add-m psnode2-mnet psnode2 db2inst1

Su-db2inst1-c "db2start member 1"

Db2instance-list

14. Create a DB2 database

Set registration variable

Su-db2inst1

Db2set DB2COMM=TCPIP

Db2set DB2CODEPAGE=1386

Db2set DB2COUNTRY=CN

Db2set DB2TERRITORY=86

Db2set DB2_PARALLEL_IO=*

Db2set DB2_USE_ALTERNATE_PAGE_CLEANING=ON

Db2set DB2_EVALUNCOMMITTED=ON

Db2set DB2_CAPTURE_LOCKTIMEOUT=ON

Db2set DB2_LOAD_COPY_NO_OVERRIDE=NONRECOVERABLE

Db2set AUTOSTART=NO

Db2 terminate

Db2set

Set instance parameters

Su-db2inst1

Db2 update dbm cfg using SVCENAME 50001

Db2 update dbm cfg using SYSMON_GROUP db2oper

Db2 update dbm cfg using MON_HEAP_SZ 10240

Db2 update dbm cfg using DIAGSIZE 5120

Db2 update dbm cfg using HEALTH_MON OFF

Db2 update dbm cfg using DFTDBPATH / gpfs1nsd

Db2 update dbm cfg using DFT_MON_BUFPOOL ON

Db2 update dbm cfg using DFT_MON_LOCK ON

Db2 update dbm cfg using DFT_MON_SORT ON

Db2 update dbm cfg using DFT_MON_STMT ON

Db2 update dbm cfg using DFT_MON_TABLE ON

Db2 update dbm cfg using DFT_MON_TIMESTAMP ON

Db2 update dbm cfg using DFT_MON_UOW ON

Db2 update dbm cfg using AUTHENTICATION SERVER_ENCRYPT

# set instance memory 1GB = 262144 * 4k

# db2 update dbm cfg using INSTANCE_MEMORY 262144

Db2 update dbm cfg using MAX_COORDAGENTS 1100 MAX_CONNECTIONS 1100

Db2 update dbm cfg using DISCOVER DISABLE

Db2 update dbm cfg using DISCOVER_INST DISABLE

Db2 terminate

Db2start

Db2 get dbm cfg | egrep "SVCENAME | SYSMON_GROUP | MON_HEAP_SZ | DIAGSIZE | HEALTH_MON | DFT_MON_ | AUTHENTICATION | INSTANCE_MEMORY | MAX_COORDAGENTS | MAX_CONNECTIONS | DISCOVER"

Mkdir / gpfs1nsd/data1 / gpfs1nsd/data2 / gpfs1nsd/data3 / gpfs1nsd/data4 / gpfs1nsd/data5 / gpfs1nsd/data6 / gpfs1nsd/data7 / gpfs1nsd/data8

Mkdir / gpfs1nsd/SAMPLEDB

Mkdir / gpfs1nsd/db2log / gpfs1nsd/db2logmir / gpfs1nsd/db2arch

Db2 update dbm cfg using DFTDBPATH / gpfs1nsd/SAMPLEDB

Db2 create db SAMPLEDB on / gpfs1nsd/data1,/gpfs1nsd/data2,/gpfs1nsd/data3,/gpfs1nsd/data4 DBPATH on / gpfs1nsd/SAMPLEDB

Db2 "alter database SAMPLEDB add storage on'/ gpfs1nsd/data5'"

Db2 "alter database SAMPLEDB add storage on'/ gpfs1nsd/data6'"

Db2 "alter database SAMPLEDB add storage on'/ gpfs1nsd/data7'"

Db2 "alter database SAMPLEDB add storage on'/ gpfs1nsd/data8'"

PureScale cannot rebalance the container. Restart a new stripe set after the original tablespace is used up. It is recommended that the storage path be expanded compared with the same period last year.

Set database parameters

Db2 update db cfg for SAMPLEDB using MAXAPPLS 200

Db2 update db cfg for SAMPLEDB using LOCKLIST AUTOMATIC

Db2 update db cfg for SAMPLEDB using MAXLOCKS AUTOMATIC

Db2 update db cfg for SAMPLEDB using LOCKTIMEOUT 60

Db2 update db cfg for SAMPLEDB using SORTHEAP AUTOMATIC

Db2 update db cfg for SAMPLEDB using SHEAPTHRES_SHR AUTOMATIC

Db2 update db cfg for SAMPLEDB using LOGFILSIZ 2560 LOGPRIMARY 10 LOGSECOND 5

Db2 update db cfg for SAMPLEDB using NEWLOGPATH / gpfs1nsd/db2log

Db2 update db cfg for SAMPLEDB using MIRRORLOGPATH / gpfs1nsd/db2logmir

Db2 update db cfg for SAMPLEDB using LOGBUFSZ 4096

Db2 update db cfg for SAMPLEDB using SOFTMAX 100

Db2 update db cfg for SAMPLEDB using REC_HIS_RETENTN 90

Db2 update db cfg for SAMPLEDB using AUTO_DEL_REC_OBJ OFF

Db2 update db cfg for SAMPLEDB using AUTO_MAINT OFF

Db2 update db cfg for SAMPLEDB using DISCOVER_DB DISABLE

Db2 update db cfg for SAMPLEDB using UTIL_HEAP_SZ 51200

Db2 terminate

Db2 force applications all; sleep 5; db2stop force; db2start

Db2 activate db SAMPLEDB

Db2 get db cfg for SAMPLEDB | egrep "territory | code | MAXAPPLS | LOCKLIST | MAXLOCKS | LOCKTIMEOUT | SORTHEAP | SHEAPTHRES_SHR | LOGFILSIZ | LOGPRIMARY | NUM_LOG_SPAN | LOGPATH | LOGBUFSZ | SOFTMAX | REC_HIS_RETENTN | AUTO_ | DISCOVER_DB | UTIL_HEAP_SZ | DATABASE_MEMORY"

Turn on archiving mode

Db2 update db cfg for SAMPLEDB using LOGARCHMETH1 DISK:/gpfs1nsd/db2arch

Db2 update db cfg for SAMPLEDB using TRACKMOD ON

Db2 terminate

Db2 force applications all; db2stop force; db2start

Db2 backup db SAMPLEDB to / dev/null

Db2 archive log for db SAMPLEDB

Db2 get db cfg for SAMPLEDB | egrep "LOGARCHMETH1 | TRACKMOD | LOGFILSIZ | LOGPRIMARY | LOGSECOND"

Db2 activate db SAMPLEDB

Db2pd-d SAMPLEDB-dbcfg | egrep "LOGARCHMETH1 | TRACKMOD | LOGFILSIZ | LOGPRIMARY | LOGSECOND"

Db2pd-d SAMPLEDB-logs

These are all the contents of the article "how to install and deploy Suse11.4 + DB2 10.5fp8 pureScale". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.