DB2 - L

Expand all | Collapse all

DB2 zOS : DSNT408I SQLCODE = -30080, ERROR: COMMUNICATION ERROR 0004 (0000-087D0001)

  • 1.  DB2 zOS : DSNT408I SQLCODE = -30080, ERROR: COMMUNICATION ERROR 0004 (0000-087D0001)

    Posted 12 days ago
    Hello Experts, Good day, 
    In our account we have users accessing Db2 tables present in on DB2 subsystem from another DB2 subsystem (for example from DB2T they are accessing DB2P)

    When they do, the communication error occurs SQLCODE = -30080, ERROR: COMMUNICATION ERROR 0004 (0000-087D0001) 

    When i take a look at Syslog, there are some IST messages like below. I have removed some details and kept only the message id and error code

    IST663I INIT OTHER REQUEST FAILED, SENSE=087D0001 437                  
    IST664I      
    IST889I SID = D7433070A1EE70B7                                         
    IST1705I SORDER = SUBAREA FROM START OPTION                            
    IST1705I SSCPORD = PRIORITY FROM START OPTION                          
    IST894I ADJSSCPS TRIED  FAILURE SENSE   ADJSSCPS TRIED  FAILURE SENSE  
    IST895I    locname        08260000        ISTAPNCP        087D000E    
    IST314I END                   

    Can you help in this regard ?

    Regards
    Eswar


    ------------------------------
    Eswar PrasadChandrasekaranA
    ------------------------------


  • 2.  RE: DB2 zOS : DSNT408I SQLCODE = -30080, ERROR: COMMUNICATION ERROR 0004 (0000-087D0001)

    Posted 12 days ago
    Hi Eswar,

    It looks like a SNA network error. You'll need your network team to help.

    You might consider migrating from SNA to modern 21th-century IP communication instead :)

    ------------------------------
    Jørn Thyssen
    Rocket Software
    2021 IBM Champion
    ------------------------------