db2 連線報錯connect。 ERRORCODE=-4499, SQLSTATE=08001
在使用data studio連線遠端DB2資料庫時報錯如下:
[jcc][Thread:main][SQLException@5b775b77] java.sql.SQLException
[jcc][Thread:main][SQLException@5b775b77] SQL state = 08001
[jcc][Thread:main][SQLException@5b775b77] Error code = -4499
[jcc][Thread:main][SQLException@5b775b77] Message = [jcc][t4][2043][11550][4.13.111] 異常 java.net.ConnectException:開啟埠 50,000 上伺服器 192.168.1.107/192.168.1.107 的套接字時出錯,訊息為:Connection timed out: connect。 ERRORCODE=-4499, SQLSTATE=08001
[jcc][Thread:main][SQLException@5b775b77] Stack trace follows
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.13.111] 異常 java.net.ConnectException:開啟埠 50,000 上伺服器 192.168.1.107/192.168.1.107 的套接字時出錯,訊息為:Connection timed out: connect。 ERRORCODE=-4499, SQLSTATE=08001
com.ibm.db2.jcc.am.id.a(id.java:320)
Cause:
Error 1: DB2 return code is -4499
Four problems might be the cause of this error.
1、 Firewall is not stopped
2、DB2 is stopped.
3、The wrong DB2 database listening port number is specified.
4、The wrong database name is specified.
solution:
1、Check whether firewall is stopped.
chkconfig iptables off 永久性關閉
service iptables stop 重啟主機後失效
2、Check whether DB2 is started.
db2 list db directory
3、Check the DB2 listening port
db2 get dbm cfg |grep SVCENAME,檢視TCP/IP服務名稱和/etc/services中定義的db2服務名稱是否匹配
4、Check the DB2COMM
db2set -all 檢查DB2COMM是否是TCPIP
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/27015256/viewspace-768610/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ERRORCODE=-4499, SQLSTATE=08001 IBM官方站點對應的解決方案ErrorSQLIBM
- DB2 connect to database連線資料包錯DB2Database
- Navicat連線centos裡mysql報錯Host is not allowed to connect to this MySQL serverCentOSMySqlServer
- 連線mysql報錯lost connect to sever during query解決MySql
- HikariDataSource(broken because of SQLSTATE(08S01), ErrorCode(0))SQLError
- 連線oracle報錯Oracle
- DB2 -668 錯誤,sqlcode=-668 ,SQLSTATE=57016DB2SQL
- win10系統foxmail ssl連線出錯errorcode:5怎麼辦Win10AIError
- Arcgis連線HGDB報錯
- DBeaver連線MySQ報錯
- 連線DB2時出錯:encoding not supported??DB2Encoding
- 連線zk 報錯連線不上hbase jdbcJDBC
- Oracle連線Db2OracleDB2
- 連線mysql時提示is not allowed to connect不允許連線MySql
- navicate oracle 連線報錯問題Oracle
- 透過Amoeba連線mysql報錯MySql
- 連線MySQL錯誤:Can't connect to MySQL server (10060)MySqlServer
- 虛擬機器NAT模式下連線mysql報錯:Host '192.168.30.1' is not allowed to connect to this MySQL server虛擬機模式MySqlServer
- 報錯:1130-host ... is not allowed to connect to this MySql server 開放mysql遠端連線 不使用localhostMySqlServerlocalhost
- OGG Director連線報錯Access denied
- db2 遠端連線伺服器 解決-668 錯誤DB2伺服器
- oracle 到 db2 通用連線OracleDB2
- jive連線mssql2000報錯SQL
- 連線ORACLE報錯:ORA-12528Oracle
- go get報錯connect: connection refusedGo
- lua 中連結 Redis 使用域名報錯 failed to connect: no resolver defined to resolveRedisAI
- DB2 SQL之行合併(連線)DB2SQL
- Java 連線 DB2的工具類JavaDB2
- java通過jdbc連線oracle報錯No suitable driverJavaJDBCOracleUI
- rman連線AUXILIARY報錯ORA-12528UX
- Xtrabackup備份報錯Failed to connect to MySQL serverAIMySqlServer
- mysql遠端連線 Host * is not allowed to connect to this MySQL serverMySqlServer
- MySQL 8.0版本連線報錯:Could not create coMySql
- 用putty連線AWS,報錯“No supported authentication methods available"AI
- minio連線失敗報錯ValueError: path in endpoint is not allowedError
- docker phpmyadmin 連線宿主mysql資料庫報錯:mysqli::real_connect(): (HY000/2002): Connection refusedDockerPHPMySql資料庫
- VScode遠端連線伺服器連線不上,各種神奇的報錯VSCode伺服器
- PostgreSQLjdbc錯誤程式碼對映(SQLSTATE)SQLJDBC