R3trans with option -d or -x is used to test the connection to the database with ABAP stack. However, when you execute it on JAVA only system, it fails with error.
<sid>adm> R3trans -x
This is R3trans version 6.24 (release 721 - 14.10.14 - 20:14:08).
unicode enabled version
2EETW169 no connect possible: "DBMS = DB6 --- DB2DBDFT = '<SID>'"
R3trans finished (0012).
4 ETW000 [ dev trc,00000] *** ERROR in DbSlConnectDB6[dbsldb6.c,1317] CON = 0 (BEGIN) 4020.002144
4 ETW000 [ dev trc,00000] &+ DbSlConnectDB6: can't find user <schema ID> in '/usr/sap/<SID>/SYS/global/dscdb6.conf'
To identify if it's a JAVA or ABAP system, execute following SQL:
db2 "select substr(tabschema,1, 20) tabschema, count(*) from syscat.tables group by tabschema"
JAVA system has tabschema SAP<SID>DB and ABAP system has tabschema SAP<SID> or SAPR3 or SAPSR3 depending on the release.
If you see both SAP<SID>DB and SAP<SID> in the result of tabschema, it means this is a dual stack system.
SAP on IBM DB2 for Linux, UNIX, and Windows
JAVA stack system
JAVA, R3trans, JDBC, , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.