用JDBC连接DB2的sample报错ERRORCODE=-4214

tail -n 100 db2diag.log有点不够，之前应该还会有些信息。收起

    密码问题，
1 查看该帐号是否被禁用或lock住。
2 修改密码。。。。。
3 restart instance。。。收起

这个license信息只是warning，DB2依然会使用全部的CPU收起

2010-11-29-09.14.47.011738   Instance:db2inst1   Node:000
PID:225296(db2star2)   TID:1   Appid:none
base sys utilities  LicCheckProcessors Probe:20

SQL8017W  The number of processors on this machine exceeds the defined
entitlement of "1" for the product "DB2 Enterprise Server Edition".  The
number of processors on this machine is "2".  You should purchase additional
processor based entitlements from your IBM representative or authorized dealer
and update your license using the License Center or the db2licm command line
utility. For more information on updating processor based licenses, refer to
the Quick Beginnings manual for your platform.  For more information on the
db2licm utility, refer to the DB2 Command Reference.

license有限制。。收起

现在的问题是从你最初要求不同
显然事情搞砸了
"Unexpected system error 0x9 has occurred.
This has been mapped to ZRC 0x83000009."  indicates bad file descriptor收起

貌似不是一个简单的问题。收起

噢，那可能是instance出现问题了，用root用户执行一下如下命令就可以了
/instance/db2iupdt db2inst1
类似的问题
http://www.db2china.net/club/vie ... =9360&extra=&page=1收起

哎 搞不明白了！重新建了个实例db2inst2收起

$ tail -n 100 db2diag.log
Unexpected system error 0x9 has occurred.
This has been mapped to ZRC 0x83000009.

PID:540786 TID:1 Node:000 Title: SYSTEM ERROR DESCRIPTION
A file descriptor does not refer to an open file.
2010-11-29-09.14.41.569494   Instance:db2inst1   Node:000
PID:610364(db2stop2)   TID:1   Appid:none
base sys utilities  stopdbm Probe:911

ADM7514W  Database manager has stopped.

2010-11-29-09.14.47.011738   Instance:db2inst1   Node:000
PID:225296(db2star2)   TID:1   Appid:none
base sys utilities  LicCheckProcessors Probe:20

SQL8017W  The number of processors on this machine exceeds the defined
entitlement of "1" for the product "DB2 Enterprise Server Edition".  The
number of processors on this machine is "2".  You should purchase additional
processor based entitlements from your IBM representative or authorized dealer
and update your license using the License Center or the db2licm command line
utility. For more information on updating processor based licenses, refer to
the Quick Beginnings manual for your platform.  For more information on the
db2licm utility, refer to the DB2 Command Reference.


2010-11-29-09.14.47.609500   Instance:db2inst1   Node:000
PID:557094(db2wdog 0)   TID:1   Appid:none
oper system services  sqloRunInstance Probe:98

DiagData
0000 0001                                     ....               

2010-11-29-09.14.47.609786   Instance:db2inst1   Node:000
PID:610370(db2sysc 0)   TID:1   Appid:none
oper system services  sqloRunInstance Probe:61

DiagData
0000 0001                                     ....               

2010-11-29-09.14.48.176815   Instance:db2inst1   Node:000
PID:610370(db2sysc 0)   TID:1   Appid:none
oper system services  sqloChangeFileOwnership Probe:100

errno: 0000 0001                                     ....               

2010-11-29-09.14.48.217245   Instance:db2inst1   Node:000
PID:610370(db2sysc 0)   TID:1   Appid:none
oper system services  sqloChangeFileOwnership Probe:100

errno: 0000 0001                                     ....               

2010-11-29-09.14.48.259139   Instance:db2inst1   Node:000
PID:610370(db2sysc 0)   TID:1   Appid:none
oper system services  sqloChangeFileOwnership Probe:100

errno: 0000 0001                                     ....               

2010-11-29-09.14.49.362623   Instance:db2inst1   Node:000
PID:548886(db2spmrsy 0)   TID:1   Appid:none
oper system services  sqloopenp Probe:20

errno: 0000 0011                                     ....               

2010-11-29-09.14.49.428192   Instance:db2inst1   Node:000
PID:225296(db2star2)   TID:1   Appid:none
base sys utilities  startdbm Probe:911

ADM7513W  Database manager has started.

2010-11-29-09.14.54.618781   Instance:db2inst1   Node:000
PID:225298(db2agent (SAMPLE) 0)   TID:1   Appid:none
oper system services  sqlockpw_int Probe:70

DiagData
0000 0020                                     ...                 

2010-11-29-09.14.54.661594   Instance:db2inst1   Node:000
PID:225298(db2agent (SAMPLE) 0)   TID:1   Appid:none
oper system services  sqlockpw_int Probe:75

Unexpected system error 0x9 has occurred.
This has been mapped to ZRC 0x83000009.

PID:225298 TID:1 Node:000 Title: SYSTEM ERROR DESCRIPTION
A file descriptor does not refer to an open file.
2010-11-29-09.18.28.530540   Instance:db2inst1   Node:000
PID:225298(db2agent (SAMPLE) 0)   TID:1   Appid:none
oper system services  sqlockpw_int Probe:70

DiagData
0000 0020                                     ...                 

2010-11-29-09.18.28.579785   Instance:db2inst1   Node:000
PID:225298(db2agent (SAMPLE) 0)   TID:1   Appid:none
oper system services  sqlockpw_int Probe:75

Unexpected system error 0x9 has occurred.
This has been mapped to ZRC 0x83000009.

PID:225298 TID:1 Node:000 Title: SYSTEM ERROR DESCRIPTION
A file descriptor does not refer to an open file.$收起

$ db2 connect to sample user db2inst1 using mypasswd
SQL0902C  A system error (reason code = "6029321") occurred.  Subsequent SQL
statements cannot be processed.  SQLSTATE=58005
$ 收起