我在笔记本电脑上安装virtualbox 虚拟机,创建了3个虚拟机,操作系统为:Red Hat Enterprise Linux Server release 6.5 x86_64,集群环境相关信息如下:
[db2inst1@db2node02 ~]$ id
uid=1002(db2inst1) gid=1002(db2iadm1) groups=1002(db2iadm1)
[db2inst1@db2node02 ~]$ db2instance -list
ID TYPE STATE HOME_HOST CURRENT_HOST ALERT PARTITION_NUMBER LOGICAL_PORT NETNAME
-- ---- ----- --------- ------------ ----- ---------------- ------------ -------
0 MEMBER STARTED db2node02 db2node02 NO 0 0 db2node02
1 MEMBER STARTED db2node03 db2node03 NO 0 0 db2node03
128 CF PRIMARY db2node01 db2node01 NO - 0 db2node01
HOSTNAME STATE INSTANCE_STOPPED ALERT
-------- ----- ---------------- -----
db2node03 ACTIVE NO NO
db2node01 ACTIVE NO NO
db2node02 ACTIVE NO NO
[db2inst1@db2node02 ~]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.5 (Santiago)
[db2inst1@db2node02 ~]$ uname -a
Linux db2node02.site 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux
[db2inst1@db2node02 ~]$ db2 connect to sample
Database Connection Information
Database server = DB2/LINUXX8664 10.5.3
SQL authorization ID = DB2INST1
Local database alias = SAMPLE
[db2inst1@db2node02 ~]$ db2 list tables
Table/View Schema Type Creation time
------------------------------- --------------- ----- --------------------------
ACT DB2INST1 T 2014-06-19-01.28.16.679158
ADEFUSR DB2INST1 S 2014-06-19-01.28.25.510100
CATALOG DB2INST1 T 2014-06-19-01.28.31.995655
CL_SCHED DB2INST1 T 2014-06-19-01.28.07.532654
CUSTOMER DB2INST1 T 2014-06-19-01.28.29.948760
DEPARTMENT DB2INST1 T 2014-06-19-01.28.09.588481
DEPT DB2INST1 A 2014-06-19-01.28.11.021167
EMP DB2INST1 A 2014-06-19-01.28.12.096774
EMPACT DB2INST1 A 2014-06-19-01.28.16.623625
EMPLOYEE DB2INST1 T 2014-06-19-01.28.11.035260
EMPPROJACT DB2INST1 T 2014-06-19-01.28.16.234712
EMP_ACT DB2INST1 A 2014-06-19-01.28.16.643414
EMP_PHOTO DB2INST1 T 2014-06-19-01.28.12.116153
EMP_RESUME DB2INST1 T 2014-06-19-01.28.13.434678
INVENTORY DB2INST1 T 2014-06-19-01.28.29.470885
IN_TRAY DB2INST1 T 2014-06-19-01.28.17.385250
ORG DB2INST1 T 2014-06-19-01.28.17.660252
PRODUCT DB2INST1 T 2014-06-19-01.28.28.361956
PRODUCTSUPPLIER DB2INST1 T 2014-06-19-01.28.37.128241
PROJ DB2INST1 A 2014-06-19-01.28.15.705919
PROJACT DB2INST1 T 2014-06-19-01.28.15.714240
PROJECT DB2INST1 T 2014-06-19-01.28.14.883098
PURCHASEORDER DB2INST1 T 2014-06-19-01.28.31.075506
SALES DB2INST1 T 2014-06-19-01.28.18.133196
STAFF DB2INST1 T 2014-06-19-01.28.17.892015
STAFFG DB2INST1 T 2014-06-19-01.28.23.184619
SUPPLIERS DB2INST1 T 2014-06-19-01.28.34.516046
VACT DB2INST1 V 2014-06-19-01.28.18.799602
VASTRDE1 DB2INST1 V 2014-06-19-01.28.19.080367
VASTRDE2 DB2INST1 V 2014-06-19-01.28.19.175069
VDEPMG1 DB2INST1 V 2014-06-19-01.28.18.977604
VDEPT DB2INST1 V 2014-06-19-01.28.18.414114
VEMP DB2INST1 V 2014-06-19-01.28.18.753675
VEMPDPT1 DB2INST1 V 2014-06-19-01.28.19.053136
VEMPLP DB2INST1 V 2014-06-19-01.28.19.481821
VEMPPROJACT DB2INST1 V 2014-06-19-01.28.18.952787
VFORPLA DB2INST1 V 2014-06-19-01.28.19.346456
VHDEPT DB2INST1 V 2014-06-19-01.28.18.730671
VPHONE DB2INST1 V 2014-06-19-01.28.19.439066
VPROJ DB2INST1 V 2014-06-19-01.28.18.776631
VPROJACT DB2INST1 V 2014-06-19-01.28.18.856220
VPROJRE1 DB2INST1 V 2014-06-19-01.28.19.230250
VPSTRDE1 DB2INST1 V 2014-06-19-01.28.19.268700
VPSTRDE2 DB2INST1 V 2014-06-19-01.28.19.297805
VSTAFAC1 DB2INST1 V 2014-06-19-01.28.19.373393
VSTAFAC2 DB2INST1 V 2014-06-19-01.28.19.400209
46 record(s) selected.
[db2inst1@db2node02 ~]$ db2 list db directory
System Database Directory
Number of entries in the directory = 1
Database 1 entry:
Database alias = SAMPLE
Database name = SAMPLE
Local database directory = /db2sd_20140515230242/db2inst1
Database release level = 10.00
Comment =
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =
[db2inst1@db2node02 ~]$ db2 get dbm cfg |grep SVC
TCP/IP Service name (SVCENAME) = 50000
SSL service name (SSL_SVCENAME) =
[db2inst1@db2node02 ~]$ tail -n 10 /etc/services
cthags 12348/udp
#DB2_db2inst1 60000/tcp
DB2_db2inst1 50000/tcp
DB2_db2inst1_1 60001/tcp
DB2_db2inst1_2 60002/tcp
DB2_db2inst1_3 60003/tcp
DB2_db2inst1_4 60004/tcp
DB2_db2inst1_END 60005/tcp
DB2CF_db2inst1 56001/tcp
DB2CF_db2inst1_MGMT 56000/tcp
[db2inst1@db2node02 ~]$ netstat -an |grep 50000
tcp 0 0 192.168.28.202:50000 0.0.0.0:* LISTEN
tcp 0 0 192.168.28.202:57274 192.168.28.203:50000 ESTABLISHED
tcp 0 0 192.168.28.202:50000 192.168.28.203:44980 ESTABLISHED
[db2inst1@db2node02 ~]$
从笔记本电脑上连接虚拟机db2node02截图:
使用IBM data Studio工具连接DB2 pureScale 集群member 0报错截图:
连接尝试未成功。
摘要
SQL4499N 与数据源断开连接导致发生致命错误。
请尝试以下建议来帮助解决问题:
确保已启动数据服务器。
检查使用的数据库名称是否为实际数据库名称,而不是别名。
检查主机是否为有效的名称或 IP 地址,端口号是否为可与数据服务器通信的有效端口号。
要进一步诊断问题,请返回“属性”部分,然后使用“跟踪”页面来启用跟踪。请联系数据库管理员,并提供跟踪和其他可用的支持信息。
完整消息内容: [jcc][t4][2030][11211][4.16.53] 在对连接的底层 socket、socket input stream 或 socket output stream 执行操作期间
发生通信错误。错误位置:Reply.fill() - socketInputStream.read (-1)。消息:Connection reset。
说明
说明:尝试访问了找不到、未启动或不支持事务的数据库。
用户响应:确保系统数据库目录中存在指定的数据库名称。如果系统数据库目录中不存在数据库名称,那么数据库不存在或未编目数据库名称。如果需要,请发出 db2start 命令,然后重新提交当前命令。
SQLSSTATE: 08004
支持
连接属性
数据库: SAMPLE
URL: jdbc:db2://192.168.28.202:50000/SAMPLE:retrieveMessagesFromServerOnGetMessage=true;securityMechanism=11;
用户名: db2inst1
密码: (未显示)
环境
驱动程序类名 = com.ibm.db2.jcc.DB2Driver
驱动程序版本 = 4.16.53
驱动程序 JAR 文件路径 = C:IBMBPMSharedpluginscom.ibm.datatools.db2_2.2.0.v20130525_0720driverdb2jcc4.jar;C:IBMBPMSharedpluginscom.ibm.datatools.db2_2.2.0.v20130525_0720driverdb2jcc_license_cisuz.jar
操作系统名称 = Windows 7
操作系统体系结构 = amd64
操作系统版本 = 6.1
JVM 实施供应商 = IBM Corporation
JVM 运行时 = Java(TM) SE Runtime Environment
Java 版本 = JRE 1.7.0 IBM J9 2.6 Windows 7 amd64-64 Compressed References 20130205_137358 (JIT enabled, AOT enabled)
J9VM - R26_Java726_SR4_20130205_1656_B137358
JIT - r11.b03_20130131_32403
GC - R26_Java726_SR4_20130205_1656_B137358_CMPRSS
J9CL - 20130205_137358
启动程序 = D:IBMDS4.1.0eclipse.exe
堆栈跟踪
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2030][11211][4.16.53] 在对连接的底层 socket、socket input stream 或 socket output stream 执行操作期间
发生通信错误。错误位置:Reply.fill() - socketInputStream.read (-1)。消息:Connection reset。 ERRORCODE=-4499, SQLSTATE=08001com.ibm.db2.jcc.am.fd.a(Unknown Source)
com.ibm.db2.jcc.t4.a.a(Unknown Source)
com.ibm.db2.jcc.t4.a.a(Unknown Source)
收起