http://blog.itpub.net/6110/viewspace-807165/

一台测试用DB2 8.1数据库出现问题,用户访问总抛如下错误:
SQL30082N  Attempt to establish connection failed with security reason "24"
("USERNAME AND/OR PASSWORD INVALID").  SQLSTATE=08001

当然用户名和密码都是正确的,没找到原因,于是重建数据库:

#db2idrop db2inst1
#db2icrt -u db2fence1 db2inst1
#db2 create database eos5 user tablespace managed by database using (file '/opt/IBM/db2data/eos5' 128000)
#db2 connect to eos5
#db2 grant dbadm on database tu group db2

完成之后,在server端访问没问题,但是发现50000端口没起来,查db2icrt帮助:
#db2icrt -help
原来在缺省参数情况下,它不会监听端口,重新删除建立实例:
#db2icrt -p 50000 -s ese -u db2fence1 db2inst1

在重建数据库的时候又发现问题,抛如下错误:
SQL1005N  The database alias "EOS5" already exists in either the local database directory or system database directory.
SQL1013N  The database alias name or database name "SAMPLE" could not be found.  SQLSTATE=42705

去drop数据库eos5,提示数据库不存在,uncatalog也没用,最后先给它catalog:
#db2 catalog database eos5 on /home/db2inst1
#drop database eos5

再重建,问题解决.