Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    kualaumpur
    Posts
    33

    Unanswered: DIA5000C error ! help required

    Hi all,

    we are using AIX 5 and DB2 UDB 8 , while running some batches(update statements) the following errors logged in the db2diag , and one of the connection aborted .

    It has happened few times after periodical basis.

    any help will be appreciated .

    regards





    2004-04-12-16.49.31.897119 Instance:eptinst1 Node:000
    PID:43294(db2agent (P_LOADDB) 0) TID:1 Appid:AC1D0149.O31C.0E0CF2054944
    DRDA Application Server sqljsCopySplitData Probe:52 Database:P_LOADDB

    DIA0001E An internal error occurred. Report the following error code :
    "ZRC=0x800A009D".

    2004-04-12-16.49.32.011977 Instance:eptinst1 Node:000
    PID:43294(db2agent (P_LOADDB) 0) TID:1 Appid:AC1D0149.O31C.0E0CF2054944
    DRDA Application Server sqljsCopySplitData Probe:2 Database:P_LOADDB

    DIA5000C A DRDA AS token "RECOVERABLE" was detected. The diagnostic data
    returned is (SRVDGN): "FUNCTION ID = 0329 , PROBE POINT = 0002 , TRACE POINT =
    0052 , SUBCODE1 = 81360012, SUBCODE2 = 00000057, SUBCODE3 = 0000000C, ERROR MSG
    = AGENT: CMNMGR Read Failure".
    ALERT :24


    Dump File:/export/home/devinst1/sqllib/db2dump/432941.000 Data:**** DRDA ASCB ****


    Dump File:/export/home/devinst1/sqllib/db2dump/432941.000 Data:**** DRDA CMNMGR CB ****


    Dump File:/export/home/devinst1/sqllib/db2dump/432941.000 Data:**** RECEIVE BUFFER ****


    Dump File:/export/home/devinst1/sqllib/db2dump/432941.000 Data:**** SEND BUFFERS ****


    Dump File:/export/home/devinst1/sqllib/db2dump/432941.000 Data:**** CONNECTION HANDLE ****


    Dump File:/export/home/devinst1/sqllib/db2dump/432941.000 Data:**** DRDA ATTRIBUTES ****


    Dump File:/export/home/devinst1/sqllib/db2dump/432941.000 Data:**** AS UCINTERFACE ****


    Dump File:/export/home/devinst1/sqllib/db2dump/432941.000 Data:*** INPUT SQLDD ***

    2004-04-12-16.49.32.047473 Instance:eptinst1 Node:000
    PID:43294(db2agent (P_LOADDB) 0) TID:1 Appid:AC1D0149.O31C.0E0CF2054944
    DRDA Application Server sqljsDrdaAsDriver Probe:100 Database:P_LOADDB

    DIA0001E An internal error occurred. Report the following error code :
    "ZRC=0x81360012".

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    IBM publishes an "internal return codes" document now, can be useful for these things. I believe it's a free d/l from their web site in the library section.

    ZRC=0x800A009D
    Error during reading of FDOCA data

    ZRC=0x81360012
    Isn't in there...

    FDOCA is part of the DRDA communications that db2 uses between client and server. In general this would be one to ask the good folks at IBM... But it seems to be a drda (communications) issue of some kind, could be flakey network connectivity or something of that nature?
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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