系统集成Db2SQL1036C

SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030?

DB2 CONNECT TO FEPDBSQL1036C  An I/O error occurred while accessing the database.  SQLSTATE=58030db2diag.log日志2020-09-18-15.21.26.310483+480 I133531754E420       LEVEL: InfoPID     : 17837                TID : 2305843009876374...显示全部

DB2 CONNECT TO FEPDB
SQL1036C  An I/O error occurred while accessing the database.  SQLSTATE=58030

db2diag.log日志
2020-09-18-15.21.26.310483+480 I133531754E420       LEVEL: Info
PID     : 17837                TID : 2305843009876374064PROC : db2sysc 0
INSTANCE: db2i4jn              NODE : 000
HOSTNAME: jntestdb
EDUID   : 22                   EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:117
MESSAGE : DIA3219I Client connecting from IP address = "10.249.24.22", port = 
          "2242".

2020-09-18-15.21.26.310618+480 I133532175E435       LEVEL: Info
PID     : 17837                TID : 2305843009876374064PROC : db2sysc 0
INSTANCE: db2i4jn              NODE : 000
HOSTNAME: jntestdb
EDUID   : 22                   EDUNAME: db2tcpcm 0
FUNCTION: DB2 UDB, base sys utilities, sqeAppServices::CreateAppl, probe:100
DATA #1 : <preformatted>
Addr[20000000277F7EA0] Nodes=[1]:: Appl[0 1520]AppNodes[1],krcbNodes[1],maxNode=[0]

2020-09-18-15.21.26.311290+480 I133532611E468       LEVEL: Warning
PID     : 17837                TID : 2305843009859596848PROC : db2sysc 0
INSTANCE: db2i4jn              NODE : 000           DB   : APPDB
APPHDL  : 0-1520
HOSTNAME: jntestdb
EDUID   : 26                   EDUNAME: db2agent (APPDB) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 66 bytes
Password validation for user db2i4jn failed with rc = -2146498587

2020-09-18-15.21.26.311387+480 E133533080E742       LEVEL: Info
PID     : 17837                TID : 2305843009859596848PROC : db2sysc 0
INSTANCE: db2i4jn              NODE : 000           DB   : APPDB
APPHDL  : 0-1520
HOSTNAME: jntestdb
EDUID   : 26                   EDUNAME: db2agent (APPDB) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsPostProcessingConnectAttach, probe:647
MESSAGE : DIA5000C A DRDA AS token "INFORMATIONAL ONLY" was detected.  The 
          diagnostic data returned is (SRVDGN): "FUNCTION ID = 0013 , PROBE 
          POINT = 0647 , TRACE POINT = 0160 , SUBCODE1 = FFFFFFFF8005006D, 
          SUBCODE2 = FFFFFFFFFFFFF999, SUBCODE3 = 0000000000000000, ERROR MSG = 
          SQLAM: CONNECT failed. See sqlcode".

2020-09-18-15.21.26.311501+480 I133533823E516       LEVEL: Info
PID     : 17837                TID : 2305843009859596848PROC : db2sysc 0
INSTANCE: db2i4jn              NODE : 000           DB   : APPDB
APPHDL  : 0-1520
HOSTNAME: jntestdb
EDUID   : 26                   EDUNAME: db2agent (APPDB) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsPostProcessingConnectAttach, probe:160
MESSAGE : ZRC=0x8005006D=-2147155859=SQLE_CA_BUILT
          "SQLCA has been built and saved in component specific control block."

2020-09-18-15.21.26.311572+480 I133534340E193     LEVEL: Info
PID:17837 TID:2305843009859596848 NODE:000 Title: DRDA ASCB
Dump File:/home/db2i4jn/sqllib/db2dump/17837.26.000.dump.bin

2020-09-18-15.21.26.311647+480 I133534534E198     LEVEL: Info
PID:17837 TID:2305843009859596848 NODE:000 Title: DRDA CMNMGR CB
Dump File:/home/db2i4jn/sqllib/db2dump/17837.26.000.dump.bin

2020-09-18-15.21.26.311710+480 I133534733E195     LEVEL: Info
PID:17837 TID:2305843009859596848 NODE:000 Title: DSS SEGMENT
Dump File:/home/db2i4jn/sqllib/db2dump/17837.26.000.dump.bin

2020-09-18-15.21.26.311785+480 I133534929E198     LEVEL: Info
PID:17837 TID:2305843009859596848 NODE:000 Title: RECEIVE BUFFER
Dump File:/home/db2i4jn/sqllib/db2dump/17837.26.000.dump.bin

2020-09-18-15.21.26.311851+480 I133535128E196     LEVEL: Info
PID:17837 TID:2305843009859596848 NODE:000 Title: SEND BUFFERS
Dump File:/home/db2i4jn/sqllib/db2dump/17837.26.000.dump.bin

2020-09-18-15.21.26.311908+480 I133535325E201     LEVEL: Info
PID:17837 TID:2305843009859596848 NODE:000 Title: CONNECTION HANDLE
Dump File:/home/db2i4jn/sqllib/db2dump/17837.26.000.dump.bin

2020-09-18-15.21.26.311969+480 I133535527E199     LEVEL: Info
PID:17837 TID:2305843009859596848 NODE:000 Title: DRDA ATTRIBUTES
Dump File:/home/db2i4jn/sqllib/db2dump/17837.26.000.dump.bin

2020-09-18-15.21.26.312033+480 I133535727E198     LEVEL: Info
PID:17837 TID:2305843009859596848 NODE:000 Title: AS UCINTERFACE
Dump File:/home/db2i4jn/sqllib/db2dump/17837.26.000.dump.bin

2020-09-18-15.21.26.312099+480 I133535926E776       LEVEL: Info
PID     : 17837                TID : 2305843009859596848PROC : db2sysc 0
INSTANCE: db2i4jn              NODE : 000           DB   : APPDB
APPHDL  : 0-1520
HOSTNAME: jntestdb
EDUID   : 26                   EDUNAME: db2agent (APPDB) 0
FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -1639   sqlerrml: 0
 sqlerrmc: 
 sqlerrp : SQLEXSLS
 sqlerrd : (1) 0x800F07E5      (2) 0x000007E5      (3) 0x00000000
           (4) 0x00000000      (5) 0x00000000      (6) 0x00000000
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)    
           (7)      (8)      (9)      (10)        (11)     
 sqlstate: 08001

收起
参与12

查看其它 1 个回答Catch的回答

CatchCatch软件架构设计师vmware

好的,不好意思,已经上传

附件:

附件图标db2diag.rar (28.32 KB)

系统集成 · 2020-09-18
浏览4046

回答者

Catch
软件架构设计师vmware
擅长领域: 服务器关系型数据库存储

Catch 最近回答过的问题

回答状态

  • 发布时间:2020-09-18
  • 关注会员:2 人
  • 回答浏览:4046
  • X社区推广