Summarized from
DB2 9.7 Official Document
# tar -xzf DB2*.tar.gz
./db2_install
# adding instance/fenced/dasadmin groups
groupadd -g 999 db2iadm1
groupadd -g 998 db2fadm1
groupadd -g 997 dasadm1
# create db2 users and their home directories
useradd -u 1004 -g db2iadm1 -m -d /home/db2inst1 db2inst1 -p <password>
touch /home/db2inst1/.profile
chown db2inst1 /home/db2inst1/.profile
useradd -u 1002 -g dasadm1 -m -d /opt/ibm/db2/V9.7/dasusr1 dasusr1 -p <password>
touch /opt/ibm/db2/V9.7/dasusr1/.profile
chown dasusr1 /opt/ibm/db2/V9.7/dasusr1/.profile
useradd -u 1003 -g db2fadm1 -m -d /home/db2fenc1 db2fenc1 -p <password>
passwd db2inst1
passwd db2fenc1
passwd dasusr1
# add additional user to dasadm1 if needed
usermod -a -G dasadm1 <user>
# create instance
## new instance 'db2inst1' under db2inst1's home
<install_dir>/instance/db2icrt -p 50000 -u db2fenc1 db2inst1
## create das server under dasusr1' home
<install_dir>/instance/dascrt -u dasusr1
## add instance owner(db2inst1) to dasadm1 group
usermod -a -G dasadm1 db2inst1
# optional, create links for headers and libs
/opt/ibm/db2/V9.7/cfg/db2ln
# tcpip config: add following line into /etc/services
db2c_db2inst1 50000/tcp
# login as db2inst1 to configure this instance
## add following line to /home/db2inst1/.profile and re-login
. sqllib/db2profile
## set communication protocol
db2 update dbm cfg using svcename 50000
db2set DB2COMM=tcpip
## add licence
db2licm -a <licence_file_name>
## create sample database
db2sampl
# add Linux user as db2iadm1
## add user to db2idm1 group
usermod -a -G dasadm1 <username>
## login in as instance owner and connect to database sample
su - dbin2st1
db2 connect to sample
## grant DBADM privilege to db2iadm1 group
db2 GRANT DBADM ON DATABASE to group db2iadm1;
exit # exit login as db2inst1
## add following line to your ~/.profile
## . /db2home/db2inst1/sqllib/db2profile
分享到:
相关推荐
有下面几个文档 What's New for DB2 Version 9.7 PDF July, 2012 Quick Start Guide - DB2 Personal Edition1 PDF Quick Start Guide - DB2 Servers1 PDF Quick Start Guide - DB2 Connect1...Installing DB2 Servers
Installing Activ Test on Your PC
http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.1-latest/bk_installing_manually_boo k/content/rpm-chap1-11.html [bigdata@namenode1 scripts]$ pwd /home/bigdata/software/hadoop/share/scripts [big...
mcsa考试题库。exam:70-410 。Installing and Configuring Windows Server 2012 R2
节点和npm: ://docs.npmjs.com/getting-started/installing-node 码头工人: : #快速开始 克隆项目 git clone https://github.com/MauF/db2-node-js-test.git 运行db2 docker映像 docker run -i -t --...
OpenERP Installing Ubuntu9.04
Installing RAC on AIX
CIMCO FOR INSTALLING FOR MASTERCAM
Modbus Poll version 10.5.0 Build 1946 self-installing,包含序列号
Installing the Google Search Appliance.pdf Installing the Google Search Appliance.pdf Installing the Google Search Appliance.pdf Installing the Google Search Appliance.pdf Installing the Google Search...
ubuntu Installing swat for 802.11
Installing and configuring servers Chapter 2. Configuring server roles and features Chapter 3. Configuring Hyper-V Chapter 4. Deploying and configuring core network services Chapter 5. Installing and...
Installing Xenomai 3.x
• Installing Shared Services • Installing Essbase • Installing Essbase Admin Services • Launching EAS and validating Essbase • Externalizing Essbase Security into Shared Services
Requirements For Installing Oracle10gR2 On RHEL 5&OEL 5 (x86_64)
Installing Oracle 10G On Linux
PyPA Installing Packages.rar
Installing STLinux on Ubuntu
Compiling and Installing
Installing the Zend Debugger PDF