linux下安装db2 v9.7,在Linux下安裝DB2 V9.7

1  從安裝包中解壓后執行./db2_install

2. 默認安裝路徑

[root@localhost ~]# cd /opt/ibm/db2/V9.7/instance

3. 添加用戶組

[root@localhost etc]# groupadd db2iadm1

[root@localhost etc]# groupadd db2fadm1

4. 查看組號

[root@localhost etc]# cat group

5. 添加用戶

[root@localhost etc]# useradd -g 501 db2inst1

[root@localhost etc]# useradd -g 502 db2fenc1

6. 設置密碼

[root@localhost etc]# passwd db2inst1

[root@localhost etc]# passwd db2fenc1

7. 建立實例

[root@localhost instance]# ./db2icrt -a server -u db2fenc1 db2inst1

DBI1070I  Program db2icrt completed successfully.

實例目錄：位於/home/db2inst1/sqllib中

8. 建立sample數據庫[db2inst1@localhost bin]$ pwd

/home/db2inst1/sqllib/bin

[db2inst1@localhost bin]$ db2sampl

Starting the DB2 instance...

Creating database "SAMPLE"...

Connecting to database "SAMPLE"...

Creating tables and data in schema "DB2INST1"...

Creating tables with XML columns and XML data in schema "DB2INST1"...

Stopping the DB2 instance...

'db2sampl' processing complete.

--9. 針對WINDOWS:嘗試在其他目錄中建立db2inst2 INSTANCE,需提前設置好DB2INSTPROF變量

[root@localhost instance]# useradd -g 501 db2inst2

[root@localhost instance]# useradd -g 501 db2fenc2

查看全球級的變量

[root@localhost adm]# pwd

/opt/ibm/db2/V9.7/adm

[root@localhost adm]# ./db2set -all

[g] DB2SYSTEM=localhost.localdomain

[g] DB2INSTDEF=db2inst1

查看實例級的變量

[db2inst1@localhost adm]$ pwd

/home/db2inst1/sqllib/adm

[db2inst1@localhost adm]$ ./db2set -all

[g] DB2SYSTEM=localhost.localdomain

[g] DB2INSTDEF=db2inst1

設置DB2INSTPROF

[root@localhost adm]# pwd

/opt/ibm/db2/V9.7/adm

[root@localhost adm]# ./db2set DB2INSTPROF="/testdb2inst" -g

使用root用戶建立db2inst2實例

[root@localhost instance]# ./db2icrt -a server -u db2fenc2 db2inst2

DBI1070I  Program db2icrt completed successfully.

10.設置實例端口號,通訊方式

[db2inst1@localhost ~]$ db2 update dbm cfg using SVCENAME 50000

DB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed successfully.

[db2inst1@localhost ~]$ db2set DB2COMM=TCPIP

11.創建das並啟動

[root@localhost instance]# groupadd -g 503 dasadm1

[root@localhost instance]# useradd -g dasadm1 dasusr1

[root@localhost instance]# ./dascrt -u dasusr1

SQL4406W  The DB2 Administration Server was started successfully.

DBI1070I  Program dascrt completed successfully.

[root@localhost etc]# passwd dasusr1

啟動(作為dasadm_group中的一員)：

[dasusr1@localhost ~]$ db2admin start

12.自動啟動實例

[root@localhost instance]# ./db2iauto -on db2inst1

13.查看變量

[db2inst1@localhost bin]$ db2set -all

[i] DB2COMM=TCPIP

[i] DB2AUTOSTART=YES

[g] DB2SYSTEM=localhost.localdomain

[g] DB2INSTPROF=/testdb2inst

[g] DB2ADMINSERVER=dasusr1

14.查看或者更改DAS配置

db2 get admin cfg

db2 update admin cfg using