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
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...
节点和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 --...
CIMCO FOR INSTALLING FOR MASTERCAM
OpenERP Installing Ubuntu9.04
- **Installing the Alfresco Tomcat bundle on Linux**:对于 Linux 平台,同样提供了仅安装 Alfresco 和 Tomcat 的捆绑包的方法。 - **Installing Alfresco on Mac (full installation)**:Mac 用户的完整安装指南...
### 安装Activ Test软件至个人电脑的知识点详解 #### 一、背景介绍 随着信息技术的发展,越来越多的专业技能认证考试采用计算机化的方式进行。其中,ECDL(欧洲计算机驾驶执照)作为一项广泛认可的计算机操作技能...
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 and Configuring Windows Server 2012 Exam Ref 70-410》是一本针对Microsoft认证考试70-410的专业辅导教材。本书由Craig Zacker编写,并由Microsoft Press出版。以下是本书中...
根据给定的文件信息,我们可以提炼以下知识点: 1. **Windows Server 2012 R2安装与配置**: - MCSA(Microsoft Certified Solutions Associate)认证考试涉及到Windows Server 2012 R2的安装与配置,其中考试编号...
Installing Unity很快就学到安装希望大家好好学习天天向上
Installing Your Driver on Windows Millennium INF File Guide
安装 Mumax 3.9.1 和 Gnuplot 5.2 在 Windows 10 中的步骤指南 在这篇文章中,我们将一步步指导用户安装 Mumax 3.9.1 和 Gnuplot 5.2 在 Windows 10 操作系统中。这篇文章将为用户提供详细的安装步骤和相关知识点,...
根据提供的文件信息,我们可以得出《Exam 70-410 Installing and Configuring Windows Server 2012 Lab Manual》是一本针对微软认证考试70-410的专业实验手册,该手册主要围绕Windows Server 2012的安装与配置进行...
文件列表如下: Installing TensorFlow for Java _ TensorFlow.pdf; libtensorflow_jni-cpu-windows-x86_64-1.4.1.zip; libtensorflow-1.4.1.jar;
TUTORIAL FOR INSTALLING MINIX-386 MINIX 升级到 MINIX-386的经典 John Nall写的关于如何使用Bruce Evans的补丁程序将MINIX 1.5.10版升级到MINIX-386的说明。
Installing TeX fonts
Installing Avaya S8800 Server
Vissim是一款广泛应用于交通模拟和分析的软件,版本4.3在安装过程中可能会遇到一些问题,特别是"installing plug-ins, please wait"这一步骤可能导致安装停滞。这个问题通常是由于系统环境、软件冲突或者安全软件...