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
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.
SAP Knowledge Base Article - Preview