Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    77

    Unanswered: Message "DIA5000C A DRDA AS token "RECOVERABLE" was detected." in db2diag.log

    DB2 WSE 11.1.1 on Windows Server 2012

    This message appears sometimes. I have no clue what causes these messages.
    No calls from users and database works without apparent problems.
    Is there a solution, a fix or a workaround?

    Code:
    2017-09-28-05.43.02.948000-240 E4750622F811         LEVEL: Error
    PID     : 2420                 TID : 6104           PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000           DB   : CCMFXXX
    APPHDL  : 0-53740              APPID: 10.8.4.115.51450.170928093945
    AUTHID  : DB2CCMF              HOSTNAME: ACOM12K41
    EDUID   : 6104                 EDUNAME: db2agent (CCMFXXX) 0
    FUNCTION: DB2 UDB, DRDA Application Server, sqljsParseSqlSttGrpNOC, probe:418
    MESSAGE : DIA5000C A DRDA AS token "RECOVERABLE" was detected.  The diagnostic 
              data returned is (SRVDGN): "FUNCTION ID = 0052 , PROBE POINT = 0418 , 
              TRACE POINT = 0040 , SUBCODE1 = FFFFFFFF804B009D, SUBCODE2 = 
              00000000000009C8, SUBCODE3 = 0000000000000000, ERROR MSG = Parser: 
              Invalid value".
    
    2017-09-28-05.43.02.948000-240 I4751435F710         LEVEL: Error
    PID     : 2420                 TID : 6104           PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000           DB   : CCMFXXX
    APPHDL  : 0-53740              APPID: 10.8.4.115.51450.170928093945
    AUTHID  : DB2CCMF              HOSTNAME: ACOM12K41
    EDUID   : 6104                 EDUNAME: db2agent (CCMFXXX) 0
    FUNCTION: DB2 UDB, DRDA Application Server, sqljsParseSqlSttGrpNOC, probe:40
    MESSAGE : ZRC=0x804B009D=-2142568291=SQLJS_DTAMCH
              "Error during reading of FDOCA data"
    DATA #1 : DDM Object, PD_TYPE_DDM_OBJECT, 16 bytes
    
    	data length : 2510
    	codepoint   : 0x2414 ( SQLSTT )
    	length      : 2514 ( COMPLETE )
    
    2017-09-28-05.43.02.948000-240 I4752147F189       LEVEL: Error
    PID:2420 TID:6104 NODE:000 Title: **** DRDA ASCB ****
    Dump File:C:\ProgramData\IBM\DB2\DB2COPY1\DB2\2420.6104.000.dump.bin
    
    2017-09-28-05.43.02.948000-240 I4752338F562         LEVEL: Warning
    PID     : 2420                 TID : 6104           PROC : db2syscs.exe
    INSTANCE: DB2                  NODE : 000           DB   : CCMFXXX
    APPHDL  : 0-53740              APPID: 10.8.4.115.51450.170928093945
    AUTHID  : DB2CCMF              HOSTNAME: ACOM12K41
    EDUID   : 6104                 EDUNAME: db2agent (CCMFXXX) 0
    FUNCTION: DB2 UDB, common communication, sqlcctcplogIPAddress, probe:50
    MESSAGE : DIA3220W Client sent data from IP address = "10.8.4.115", port = 
              "64200".
    
    2017-09-28-05.43.02.948000-240 I4752902F194       LEVEL: Error
    PID:2420 TID:6104 NODE:000 Title: **** DRDA CMNMGR CB ****
    Dump File:C:\ProgramData\IBM\DB2\DB2COPY1\DB2\2420.6104.000.dump.bin
    
    2017-09-28-05.43.02.948000-240 I4753098F191       LEVEL: Error
    PID:2420 TID:6104 NODE:000 Title: **** DSS SEGMENT ****
    Dump File:C:\ProgramData\IBM\DB2\DB2COPY1\DB2\2420.6104.000.dump.bin
    
    2017-09-28-05.43.02.948000-240 I4753291F194       LEVEL: Error
    PID:2420 TID:6104 NODE:000 Title: **** RECEIVE BUFFER ****
    Dump File:C:\ProgramData\IBM\DB2\DB2COPY1\DB2\2420.6104.000.dump.bin
    
    2017-09-28-05.43.02.948000-240 I4753487F192       LEVEL: Error
    PID:2420 TID:6104 NODE:000 Title: **** SEND BUFFERS ****
    Dump File:C:\ProgramData\IBM\DB2\DB2COPY1\DB2\2420.6104.000.dump.bin
    
    2017-09-28-05.43.02.948000-240 I4753681F197       LEVEL: Error
    PID:2420 TID:6104 NODE:000 Title: **** CONNECTION HANDLE ****
    Dump File:C:\ProgramData\IBM\DB2\DB2COPY1\DB2\2420.6104.000.dump.bin
    
    2017-09-28-05.43.02.948000-240 I4753880F195       LEVEL: Error
    PID:2420 TID:6104 NODE:000 Title: **** DRDA ATTRIBUTES ****
    Dump File:C:\ProgramData\IBM\DB2\DB2COPY1\DB2\2420.6104.000.dump.bin
    
    2017-09-28-05.43.02.948000-240 I4754077F194       LEVEL: Error
    PID:2420 TID:6104 NODE:000 Title: **** AS UCINTERFACE ****
    Dump File:C:\ProgramData\IBM\DB2\DB2COPY1\DB2\2420.6104.000.dump.bin

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,545
    Provided Answers: 11
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •