2468860 - DB6: R3trans -x fails in JAVA only environment

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.

For example:

<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).

trans.log indicates:

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