SAP Knowledge Base Article - Preview

3299767 - DB6: R3trans hangs at function call "recvfrom"

Symptom

SAP system gets hang. Following symptoms are noticed:

  • Command "db2 connect to <SID>"  is working fine on database.
  • "R3trans -d" gets hang.

The generated trans.log shows the last entry as: "Connected ...."

4 ETW000  [     dev trc,00000]  Running with CLI driver.
4 ETW000  [     dev trc,00000]  Fri Jan 27 09:58:58 2023
4 ETW000  [     dev trc,00000]  CLI cfg for con_hdl=0:
4 ETW000  [     dev trc,00000]  DSN="ABC";UID="SAPABC";DATABASE=ABC;PROTOCOL=TCPIP;HOSTNAME=12345ABC00p;SERVICENAME=5912;
4 ETW000  [     dev trc,00000]  Connected to DB server type 'DB2/LINUXX8664'
4 ETW000  [     dev trc,00000]  Connected to DB server version '11.05.0700'
4 ETW000  [     dev trc,00000]  CURRENT DEGREE is 'ANY' .
4 ETW000  [     dev trc,00000]  Connected to 'ABC' as 'SAPABC' schema 'SAPABC' o.k.
4 ETW000  [     dev trc,00000]  Connected: con_hdl=0 ; appl_hdl=88888; appl_id="10.222.22.23.27452.230127015858" 
4 ETW000  [     dev trc,00000]  Current member="10.222.22.22:5912" 
4 ETW000  [     dev trc,00000]  Database code page is ok.
4 ETW000  [     dev trc,00000]  Database collating sequence is ok.
4 ETW000  [     dev trc,00000]  DB2_WORKLOAD=SAP is set in DB2 registry as required.
4 ETW000  [     dev trc,00000]  CLI Insert Buffering is disabled on single partition databases.
4 ETW000  [     dev trc,00000]  INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN'
4 ETW000  [     dev trc,00000]  Connection 0 opened (DBSL handle 0)
4 ETW000  [     dev trc,00000]  INFO: Unable to determine SAPDBHOST; defaulting to 'UNKNOWN'
4 ETW000  [     dev trc,00000]  NTAB: version is VERS_B, UNICODELG=2, SAP_UC_LN=2
4 ETW000 Connected to DBMS = DB6 --- DB2DBDFT = 'ABC' --- SYSTEM = 'ABC'.   <<<<< Last entry

OS trace collected following note 1730855 shows it is stuck at function call "recvfrom"

09:58:14.235484 sendto(4, "\0\203\320Q\0\1\0} \f\0D!\23P06               "..., 195, 0, NULL, 0) = 195
09:58:14.235531 recvfrom(4, "\0002\320R\0\1\0,\"\5\0\6\21I\0\0\0\6!\2$\27\0\5!P\1\0\f![\0"..., 131072, 0, NULL, NULL) = 407
09:58:14.235831 write(3, "4 ETW000 Connected to DBMS = DB6"..., 74) = 74   <<<<< This matches the last entry of R3trans
09:58:14.235946 uname({sysname="Linux", nodename="xc-s-zl18186", ...}) = 0
09:58:14.236001 sendto(4, "\0\203\320Q\0\1\0} \f\0D!\23P06               "..., 183, 0, NULL, 0) = 183
09:58:14.236053 recvfrom(4, "\0002\320R\0\1\0,\"\5\0\6\21I\0\0\0\6!\2$\27\0\5!P\1\0\f![\0"..., 131072, 0, NULL, NULL) = 391
09:58:14.236306 sendto(4, "\0\203\320Q\0\1\0} \f\0D!\23P06               "..., 183, 0, NULL, 0) = 183
09:58:14.236353 recvfrom(4, "\0002\320R\0\1\0,\"\5\0\6\21I\0\0\0\6!\2$\27\0\5!P\1\0\f![\0"..., 131072, 0, NULL, NULL) = 90
09:58:14.236547 sendto(4, "\0l\320\1\0\1\0f \6\0D!\23P06               "..., 108, 0, NULL, 0) = 108
09:58:14.236592 recvfrom(4, "\4\274\320S\0\1\4\266$\33\377\0\0\tPATCHHIST\1\0\1\27L\0\1\0\0"..., 131072, 0, NULL, NULL) = 1339
09:58:14.236866 sendto(4, "\0N\320Q\0\1\0H \r\0D!\23P06               "..., 308, 0, NULL, 0) = 308
09:58:14.236914 recvfrom(4, "\0Y\320C\0\1\0S$\10\0\0\0\0\00000000SQL11057\0\0\0\0"..., 131072, 0, NULL, NULL) = 319
09:58:14.237136 sendto(4, "\0S\320Q\0\1\0M \v\0D!\23P06               "..., 357, 0, NULL, 0) = 357
09:58:14.237181 recvfrom(4, 0x7f838eadc080, 131072, 0, 0, 0) = ? ERESTARTSYS (To be restarted if SA_RESTART is set)  <<< It hangs here
09:45:42.897044 --- SIGWINCH {si_signo=SIGWINCH, si_code=SI_KERNEL} ---   
09:45:42.897105 recvfrom(4, 0x7f838eadc080, 131072, 0, 0, 0) = ? ERESTARTSYS (To be restarted if SA_RESTART is set)


Read more...

Environment

  • SAP on IBM Db2 for Linux, UNIX, and Windows
  • Application server and database server are on Cloud

Product

SAP NetWeaver 7.5

Keywords

R3trans, recvfrom, ERESTARTSYS , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.