接触DB2,第1招

 

*db2licm -l

INSTALL路崎岖!
还是推荐用DB2SETUP
DB2_INSTALL手动安装会出现很多问题,db2_install不自动安装LICENSE

在INSTALL PRODUCT之后,发现无DB2INST1 USER(原因可能是由于之前DB2_INSTALL过程建立USER和INSTANCE之后,没删INSTANCE而删了DB2INST1

的原因)
如下过程解决:
# ./db2icrt -u db2inst1 db2inst1
DBI1292E The instance db2inst1 is already in the
          instance list.

# ./db2iset -l
db2inst2
db2inst1
db2inst
# ./db2idrop db2inst1
DBI1070I Program db2idrop completed successfully.

# ./db2idrop db2inst2
DBI1131E The user ID db2inst2 is invalid.

# ./db2iset -l
db2inst
db2inst2

# ./db2icrt -u db2inst1 db2inst1
DBI1070I Program db2icrt completed successfully.

但是执行过程中提示:
A non-existing user ID, db2inst2 , db2inst
分析原因:在删DB2INST和DB2INST2 USERID之前没DROP INSTANCE

# ./db2iset -l
db2inst1
db2inst
db2inst2
# ./db2iset -d db2inst2
# ./db2iset -d db2inst
# ./db2iset -l
db2inst1

#su - db2inst1
$db2fs 建立SAMPLE库
$db2start

安装练习到此结束,经过这两天的折腾,倒是对DB2SETUP和MANUAL INSTALL有了更深刻的理解及掌握.

 

门外,阳光普照大地,宁静致远......