安装IBM DB2报错问题

1.安装IBM DB2报错问题

①创建分区实例的进程失败。返回值为"4294965337"。

②SQL1390C 未定义环境变量 DB2INSTANCE 或该变量无效。

解决方法：

1. 在运行中输入 "CMD", 进入命令窗口
2. 输入如下命令：db2icrt db2
3. 输入如下命令：set db2instance=db2

 

2.使用IBM Db2 Data Management Console连接Db2报错问题

①HWCREP0011E: 未能连接到存储库数据库。Exception java.net.ConnectException: Error opening socket to server localhost/127.0.0.1 on port 25,000 with message: Connection refused: no further information. ERRORCODE=-4499, SQLSTATE=08001

②HWCREP0011E: 未能连接到存储库数据库。Required property "db2c_DB2" is unknown host. ERRORCODE=-4222, SQLSTATE=08001

③HWCREP0011E: 未能连接到存储库数据库。A communication error occurred during operations on the connection's underlying socket, socket input stream, or socket output stream.  Error location: Reply.fill() - insufficient data (-1).  Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001

④HWCREP0011E: 未能连接到存储库数据库。Timeout getting a transport object from pool. ERRORCODE=-4210, SQLSTATE=57033

⑤Error for batch element #2: "DB2ADMIN" does not have the privilege to perform operation "CREATE TABLE".. SQLCODE=-552, SQLSTATE=42502

⑥HWCREP0011E: 未能连接到存储库数据库。Connection authorization failure occurred. Reason: Security mechanism not supported. ERRORCODE=-4214, SQLSTATE=28000

⑦HWCREP0011E: 未能连接到存储库数据库。Connection authorization failure occurred. Reason: User ID or Password invalid. ERRORCODE=-4214, SQLSTATE=28000

⑧Error for batch element #2: "DB2ADMIN" does not have the privilege to perform operation "CREATE TABLE".. SQLCODE=-552, SQLSTATE=42502