下面是我在linux的字符模式下安装DB2 V8.2的过程。
*******************************************************
Create user
*******************************************************
groupadd dasadm
groupadd db2fenc
groupadd db2grp
useradd -d /opt/dasusr1 -g dasadm dasusr1
useradd -d /opt/db2fenc1 -g db2fenc db2fenc1
useradd -d /opt/db2inst1 -g db2grp db2inst1
*******************************************************
Install Software
*******************************************************
./db2_install
*******************************************************
Create instance
*******************************************************
cd /opt/IBM/db2/V8.1/instance/
./dascrt dasusr1 (CREATE DAS SERVER)
./db2icrt -s ese -u db2fenc1 db2inst1 (CREATE INSTANCE)
./db2iset -l (list current instance name)
./db2iset -d instance_name (delete a instance)
/opt/IBM/db2/V8.1/cfg/db2ln
*******************************************************
Instance update
*******************************************************
db2set DB2_EXTENDED_OPTIMIZATION=ON
db2set DB2_DISABLE_FLUSH_LOG=ON
db2set AUTOSTART=YES
db2set DB2_STRIPED_CONTAINERS=ON
db2set DB2_HASH_JOIN=Y
db2set DB2COMM=tcpip
db2set DB2_PARALLEL_IO=*
db2 update dbm cfg using SVCENAME db2inst1
*******************************************************
Create database
*******************************************************
db2 "CREATE DATABASE MYDB02 ALIAS MYDB02"
*******************************************************
Alter default bufferpool size
*******************************************************
db2 "CONNECT TO MYDB02 USER db2inst1 USING db2inst1"
db2 "ALTER BUFFERPOOL IBMDEFAULTBP IMMEDIATE SIZE 4000"
db2 "CONNECT RESET"
*******************************************************
Re-create userspace and indexspace for user data
*******************************************************
cd /opt/db2inst1
mkdir MYDB02
db2 "CONNECT TO MYDB02 USER db2inst1 USING db2inst1"
db2 "DROP TABLESPACE USERSPACE1"
db2 "CREATE REGULAR TABLESPACE USERSPACE1 PAGESIZE 4 K MANAGED BY DATABASE USING ( FILE '/opt/db2inst1/MYDB02/U1_1' 131072 ) EXTENTSIZE 16 BUFFERPOOL IBMDEFAULTBP DROPPED TABLE RECOVERY ON"
db2 "COMMENT ON TABLESPACE USERSPACE1 IS 'USERSPACE1'"
db2 "CREATE REGULAR TABLESPACE INDEXSPACE1 PAGESIZE 4 K MANAGED BY DATABASE USING ( FILE '/opt/db2inst1/MYDB02/I1_1' 131072 ) EXTENTSIZE 16 BUFFERPOOL IBMDEFAULTBP DROPPED TABLE RECOVERY OFF"
db2 "COMMENT ON TABLESPACE INDEXSPACE1 IS 'INDEXSPACE1'"
db2 "CONNECT RESET"
|