REDHAT 7.3 DB2 安装记录
2006-02-14 21:58:03 来源:WEB开发网核心提示:最近在自己的linux平台安装了一套DB2 PE 7.2,做研究用,REDHAT 7.3 DB2 安装记录,在安装过程还是出了一些问题,所以把安装记录贴上来,给大家做个参考,由于linux的中文问题
最近在自己的linux平台安装了一套DB2 PE 7.2,做研究用。在安装过程还是出了一些问题,所以把安装记录贴上来,给大家做个参考。
由于linux的中文问题,所以为英文的,较为简单
1.before
readhat : need pdksh*.rpm - donwload from redhat
user: db2inst1/db2fenc1/db2as
.bash_profile :
export DB2DIR=/usr/IBMdb2/V7.1
export PATH=$PATH:$DB2DIR/bin
!!!!!above is err
chage user's shell -> ksh
2.db2setup
DB2SYSTEM set to test
install on /usr/IBMdb2
3.postinst
3.1 /usr/IBMdb2/V7.1/instance/db2icrt -a AuthType -u FencedID InstName
3.2 /usr/IBMdb2/V7.1/instance/dasicrt ASName
(use /usr/IBMdb2/V7.1/install/db2setup)
3.3 /usr/IBMdb2/V7.1/adm/db2licm -a /cdrom/db2/license/db2udbpe.lic
3.4 /usr/IBMdb2/V7.1/cfg/db2ln
check /tmp/db2setup.log :
/usr/IBMdb2/V7.1/instance/db2icrt -a SERVER -u db2fenc1 db2inst1
Output log of the above command:
DBI1768W Unable to modify the .profile or the .login file of
user db2inst1.
Explanation: DB2 has failed to modify the .profile file or the
.login file of this user. These files may not exist, or you may
not have write permission to them. Without the modification you
need to set your environment manually each time when you log in
as this user to use DB2.
User Response: Add the following line to the .profile file or
the .login file:
. sqllib/db2profile to the .profile file, or
source sqllib/db2cshrc to the .login file
See the Quick Beginning Guide for more details on how to set the
DB2 environment automatically.
DBI1070I Program db2icrt completed successfully.
4.verify
1.su - db2inst1
db2sampl
db2 connect to sample
db2 "select * from staff where dept = 20"
db2 connect reset
have err msg but OK AFTER . sqllib/db2profile to the .profile file
5. stop
su - db2inst1 ; db2stop
su - db2as ; db2admin stop
- ››db2 对float类型取char后显示科学计数法
- ››DB2中出现SQL1032N错误现象时的解决办法
- ››DB2 锁升级示例
- ››db2诊断系列之---定位锁等待问题
- ››db2 命令选项解释
- ››DB2 最佳实践: 使用 DB2 pureXML 管理 XML 数据的...
- ››DB2 9.5 SQL Procedure Developer 认证考试 735 准...
- ››DB2 9.5 SQL Procedure Developer 认证考试 735 准...
- ››DB2 9.5 SQL Procedure Developer 认证考试 735 准...
- ››DB2 基础: 表空间和缓冲池
- ››DB2 XML 编程,第 1 部分: 理解 XML 数据模型
- ››DB2 pureScale 实战
更多精彩
赞助商链接