鲁达 DB2 V10.5.0.10 安装
本文档通过命令行方式Linux上安装db21.下载db2安装包
通过官网 下载DB2安装包，如果没有passport账号，只能下载Express版本的。
我这里下载的包是v10.5 解压包 # tar -zxvf v10.5 2. 预安装检查
root执行 检查是否满足安装条件: #cd server_t/ #ls db2 db2c db2c db2ckupgrade db2_deinstall db2_install db2ls db2prereqcheck db2setup ibm_im installFixPack nlpack #./db2prereqcheck -p -v 10.5.0.10 DBT3533I The db2prereqcheck utility has confirmed that all installation prerequisites were met. 检查可能会发现缺包，然后我们通过yum来安装缺省包。 可能会使用如下命令 yum install -y pam* yum install -y pam*.i686 yum install -y sg3_utils-* yum install -y ksh yum install -y libstdc++.i686 关闭selinux 修改/etc/sysconfig/selinux中，SELINUX=disabled 然后重启机器 查看selinux状态 # sestatus SELinux status: disabled3. 创建用户和组
root执行 创建组 #groupadd -g 999 db2iadm1 #groupadd -g 998 db2fadm1 #groupadd -g 997 dasadm1 用root用户创建用户 #useradd -u 1004 -g db2iadm1 -m -d /home/db2inst1 db2inst1 #useradd -u 1003 -g db2fadm1 -m -d /home/db2fenc1 db2fenc1 #useradd -u 1002 -g dasadm1 -m -d /home/dasusr1 dasusr1 4. 安装DB2
root执行 # ./db2_install DBI1324W Support of the db2_install command is deprecated. Default directory for installation of products - /opt/ibm/db2 *********************************************************** Install into default directory (/opt/ibm/db2) ? [yes/no] yes 【需要输入后Enter】 Specify one of the following keywords to install DB2 products. SERVER CONSV EXP CLIENT RTCL Enter "help" to redisplay product names. Enter "quit" to exit. *********************************************************** SERVER 【需要输入后Enter】 *********************************************************** Do you want to install the DB2 pureScale Feature? [yes/no] no 【需要输入后Enter】 DB2 installation is being initialized. Task #1 start Description: Checking license agreement acceptance Estimated time 1 second(s) Task #1 end 。。。。 此处省略1万字 Task #50 start Description: Updating global profile registry Estimated time 3 second(s) Task #50 end The execution completed successfully. For more information see the DB2 installation log at "/tm;. 安装成功，并且没有报错。 5. 创建实例
root执行 建实例 #/opt/ibm/db2/instance/db2icrt -u db2fenc1 db2inst1 db2inst1执行 设置TCPIP端口 $db2 update dbm cfg using SVCENAME 50000 启用端口，需要重启实例才能生效 $db2set DB2COMM=tcpip 重启实例 $db2stop force $db2start 6. 安装db2许可证
这里要有passport账号才能下载到，如果是express版本，不用执行，默认试用90天 $/opt/ibm/db2/adm/db2licm -a /db2/license 查看许可 $db2licm -l Product name: "DB2 Advanced Enterprise Server Edition" License type: "CPU Option" Expiry date: "Permanent" [这里Permanent，即可] Product identifier: "db2aese" Version information: "10.5" Enforcement policy: "Soft Stop" 到这里DB2 10.5.0.10就安装成功了。7. 创建sample数据库
db2inst1执行 创建sample数据库 $db2sampl 连接sample数据库 $db2 connect to sample 建表/插数/查询 $db2 "create table t1(c1 varchar(20))" $db2 "insert into t1 values(1)" $db2 "select * from t1" 8. 删除DB2软件
root执行 删除实例,记得先把实例停掉，否则会失败 #/opt/ibm/db2/instance/db2idrop db2inst1 卸载db2 #/opt/ibm/db2/install/db2_deinstall -a 删除db2用户 #userdel -r db2inst1 #userdel -r db2fenc1 #userdel -r dasusr1 删除db2组 #groupdel db2iadm1 #groupdel db2fadm1 #groupdel dasadm1