在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