DB2 ERRORCODE以及SQLSTATE错误解决方案小结_想飞的鱼

http://blog.sina.com.cn/u/1580488167

首页博文目录关于我

个人资料

微博

加好友发纸条

写留言加关注

博客等级：
博客积分：

博客访问：
关注人气：
获赠金笔：0支
赠出金笔：0支
荣誉徽章：

正文字体大小：大中小

DB2 ERRORCODE以及SQLSTATE错误解决方案小结

(2012-08-18 22:27:40)

标签：

杂谈

分类：学习

he DB2 Content Manager installation is blocked: failure to connect to the DB2 database

Problem(Abstract)

The DB2 Content Manager installation is blocked by a failure to connect to the DB2 database. The problem is related to a DB2 connection failure with the DB2 Content Manager V8.4 installer. The error messages can be summarized as follows:

Error 1: DB2 return code is -4499, DB2 Content Manager return code is 3
CheckDBConnUtil00002 exception (com.ibm.db2.jcc.b.gm: [jcc][t4][2043][11550][3.50.152] Exception java.net.ConnectException: Error opening socket to server install01/9.123.114.105 on port 50,000 with message: A remote host refused an attempted connect operation.. ERRORCODE=-4499, SQLSTATE=08001)

Another message with the same error code can appear as follows:
CheckDBConnUtil00002 exception (com.ibm.db2.jcc.b.gm: [jcc][t4][2057][11264][3.50.152] The application server rejected establishment of the connection.An attempt was made to access a database, icmnlsdb, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004)

Error 2: DB2 return code is -4222, DB2 Content Manager return code is 9
CheckDBConnUtil00002 exception (com.ibm.db2.jcc.b.qm: [jcc][t4][10380][11951][3.50.152] Required property "install02" is unknown host. ERRORCODE=-4222, SQLSTATE=08001)

Error 3: DB2 return code is -4214, DB2 Content Manager return code is 5
CheckDBConnUtil00002 exception (com.ibm.db2.jcc.b.mm: [jcc][t4][2013][11249][3.50.152] Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000)

Symptom

DB2 connection failure with DB2 Content Manager V8.4 installer

http://www-01.ibm.com/support/docview.wss?uid=swg21322400&aid=1ERRORCODE以及SQLSTATE错误解决方案小结" />

Cause

Error 1: DB2 return code is -4499
Three problems might be the cause of this error.

DB2 is stopped.
The wrong DB2 database listening port number is specified.
The wrong database name is specified.

IXDBA.NET社区论坛
Error 2: DB2 return code is -4222
For this problem, the host name is probably specified incorrectly.

Error 3: DB2 return code is -4214
Three problems might be the cause of this error.

The user name is invalid
The password is invalid.
Both the user name and the password are invalid.

Resolving the problem

The following procedures might help you resolve the connection failure problem:
Resolving Error 1: DB2 return code is -4499

Check whether DB2 is started.
Check whether the database exists. Use the command

db2 list db directory to list the databases.

Check the DB2 listening port. The DB2 instance is listening on Port 50000 by default, but the port number might have been modified.
Restart DB2 or restart the computer on which DB2 is running, because there might be too many connections already active for DB2 to respond to the new request.
Resolving Error 2: DB2 return code is -4222
1. If the wrong host name is specified, or the DNS server cannot parse the host name, then you can use the command ping hostname, where hostname is the host name, to test the connection. You can also use the IP address directly in this command.
2. Check the privileges of folder /tmp/CM/db2cmv8. The DB2 Content Manager installer performs the su command to DB2 Content Manager accounts to test the connection. For example, if you have an icmadmin account as the library server administrator, the installer uses this account, creates a shell script under the /tmp/CM/db2cmv8 folder, and runs it to see the result. If the folder does not have the write and execute privileges for icmadmin, the connection test fails.
Resolving Error 3: DB2 return code is -4214
1. Check that the user name and password are specified correctly.
2. Check that the password does not contain special characters, such as the dollar sign ($).

阅读┊ 收藏 ┊ 喜欢 ▼ ┊打印┊举报/Report

前一篇：2012年08月08日

后一篇：招商银行一网通显示乱码——win7英文版

新浪BLOG意见反馈留言板　欢迎批评指正