Solved: Remoted DB2 connection from SAP

Former Member · ‎10-04-2011

Hello Experts,

We have a requirement to connect the remote DB DB2 (No SAP) which is on I series from our SAP ECC EHP 5 system so I made a below entry in table DBCON -

Database connection - PRMS_TEST

DBS - DB4

Username - SAP

*Password ***********

Connection Information - AS4_HOST=S1031993;AS4_DB_LIBRARY=RMTLIB

but while doing the test connection, it gives the below error-

B  Loading DB library '/usr/sap/ECD/DVEBMGS00/exe/dbdb4slib.so' ...
M  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/ECD/DVEBMGS00/exe/dbdb4slib.so") FAILED
  "/usr/sap/ECD/DVEBMGS00/exe/dbdb4slib.so: cannot open shared object file: No such file or directory"  [dlux.c       445]
M  {root-id=000C298267DF1EE0BBC9171365715368}_{conn-id=00000000000000000000000000000000}_0
B  *** ERROR => Couldn't load library '/usr/sap/ECD/DVEBMGS00/exe/dbdb4slib.so'
 [dbcon.c      5263]
B  {root-id=000C298267DF1EE0BBC9171365715368}_{conn-id=00000000000000000000000000000000}_0
B  ***LOG BYG=> could not load library for database connection PRMS_TEST  [dbds         886]
B  ***LOG BZY=> unexpected return code 8192       calling DBDS       [dbacds       1536]

My SAP environment is -

SAP - ECC EHP 5

Kernel Release 720 patch 90

OS - Red Hat Linux 5.5 - 64 bit

Database - DB2 (DB6)

Kindlly let us know if I have to put the file dbdb4slib.so in kernel directory and from where I can get this file and if my DBCON entry is correct ?

Regards

Saurabh Mishra

Former Member · ‎10-12-2011

Thanks a lot Dorothea,

I changed the entry from DB4 to DB6 in DBCO t-code , infact in note 663756 it's mentioned to create a entry DB6 and after that when I tried to test the connection from SE38 and it gives below licensing error -

Could not open connection PRMS_TEST1                     .
sql error      1.598- occured:
SQL1598N  An attempt to connect to the database server failed because of a licensing problem.  SQLSTATE=42968

But I am not sure do we need a license for Linux system or AS-400 system from the above error ?

Connection information in DBCO t-code is -DB6_DB_NAME=S1031993;DB6_DB_TYPE=DB2/400;DB6_DB_HOST=S1031993;DB6_DB_SVCENAME=446;

and DBS is DB6.

Also I found the error detail on below page but it is pointing to z/os instead of AS400 even my jdbc bind error is related to z/os, not sure if I mentioned Z/os somewhere.

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.messages.sql...

Kindly suggest.

Regards

Saurabh Mishra

Edited by: saumishr on Oct 12, 2011 8:31 PM

Former Member · ‎10-18-2011

Helo DOrothea,

Above is the answer of this forum and I think SAP has to update it's note for the license part as well.

You're Awesome man, I will assign all points to your answers.

Thanks a lot!!

Regards

Saurabh Mishra

Former Member · ‎10-17-2011

Hello Dorothea,

We have successfully establish the connection by renaming the directory - /usr/sap/SID/SYS/global/db6 after stopping the SAP.

Actually SAP is using a CLI driver by default.

Also we have created a below report to test the connection successfully-

*&---------------------------------------------------------------------*
*& Report  ZDBCONNET
*&
*&---------------------------------------------------------------------*
*&
*&
*&---------------------------------------------------------------------*

REPORT  ZDBCONNET.

DATA: COUNT TYPE I.
DATA: TABNAME(30) TYPE C.
*** Establish Connection
EXEC SQL.
CONNECT TO 'PRMS_TEST1'
ENDEXEC.

EXEC SQL.
SELECT COUNT(*) FROM QSYS2.SYSTABLES INTO :COUNT
ENDEXEC.
WRITE: COUNT, ' tables in QSYS2.SYSTABLES. '.

*** Disconnect Connection
EXEC SQL.
DISCONNECT 'PRMS_TEST1'
ENDEXEC.

As currently we have a temp license so I guess this connection will not work after the temp license expiration.

Also what are the steps required for CLI driver connection.

Thanks a lot Dorothea for all your help.

Regards

Saurabh Mishra

Former Member · ‎10-13-2011

Hello Dorothea,

I don't have license file db2jcc_license_cisuz.jar but only a temp license of 90 days that came from IBM after installing the DB2.

Even I think so that this error is also related to I series as well.

I also got the below reply from SAP after converting message to high priority-

Hello Saurabh,

To connect secondary DB you need follow some special steps.
Because we see some issue before that some customer using DB6 dbsl to connect
to iSeries need addtional license fee, so we consider below suloution will help
you.

If you are using XDA on IBM i you need a Windows Application Server.
(note 523381)
If you are using XDN you can connect directly via AIX (Note: 1460139)

Please also check note 1257635
Considerations for Database Multi-Connect:
Please Install Gateway Instance on IBM i Note: 1541772

Then add profile parameter dbs/db4/driver_type = XDN to default profile
Call transaction SE38.

Run the following report: ADBC_TEST_CONNECTION
To see if you can succeed.

Many Thanks With Warm Regards


SAP on IBM i Systems
Active Global Support

I am not sure why they release the note 663756 if that is not a solution, let's see if I get another useful reply from SAP.

Also I am not sure about the XDA and XDN so will send the respective notes to our AS400 team so they can confirm the same.

I appreciate your response on all my queries which was really useful.

Regards

Saurabh Mishra

Edited by: saumishr on Oct 17, 2011 11:27 AM

Former Member · ‎10-12-2011

Hello Dorothea,

Might be below information will be useful for you -

sapecdci1:ecdadm 51> db2 connect to ecd

Database Connection Information

Database server = DB2/LINUXX8664 9.7.4
SQL authorization ID = ECDADM
Local database alias = ECD

sapecdci1:ecdadm 52> db2set -all | grep DB2COMM
<i> DB2COMM=TCPIP [DB2_WORKLOAD]
sapecdci1:ecdadm 53> cd /db2/db2ecd/sqllib/java/
sapecdci1:ecdadm 54> ls db*
db2dbgm.jar db2jcc4.jar db2jcc_license_cu.jar db2umplugin.jar
db2java.zip db2jcc.jar db2policy.jar

sapecdci1:ecdadm 56> db2 get dbm cfg | grep -i svcename
TCP/IP Service name (SVCENAME) = sapdb2ECD
SSL service name (SSL_SVCENAME) =
sapecdci1:ecdadm 57> grep db2 /etc/services
ibm-db2 523/tcp # IBM-DB2
ibm-db2 523/udp # IBM-DB2
questdb2-lnchr 5677/tcp # Quest Central DB2
Launchr
questdb2-lnchr 5677/udp # Quest Central DB2
Launchr
sapdb2ECD 5912/tcp # SAP DB2 Communication Port
DB2_db2ecd 5914/tcp
DB2_db2ecd_1 5915/tcp
DB2_db2ecd_2 5916/tcp
DB2_db2ecd_END 5917/tcp

Regards

Saurabh Mishra

Edited by: saumishr on Oct 12, 2011 12:42 PM

Former Member · ‎10-11-2011

Hello Dorothea,

I also tried to copy the dbdb4slib.so file from the DB2/400 kernel and copied it to /usr/sap/ECD/DVEBMGS00/exe and the execute the ADBC_TEST_CONNECTION from SE38 for the same DBCON entry but the same issue is occuring but some little-endian issue (might be library is not compatible)

B  Loading DB library '/usr/sap/ECD/DVEBMGS00/exe/dbdb4slib.so' ...
M  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/ECD/DVEBMGS00/exe/dbdb4slib.so") FAILED
  "/usr/sap/ECD/DVEBMGS00/exe/dbdb4slib.so: ELF file data encoding not little-endian"  [dlux.c       445]
M  {root-id=000C298267DF1ED0BD84EDB29A144E54}_{conn-id=00000000000000000000000000000000}_0
B  *** ERROR => Couldn't load library '/usr/sap/ECD/DVEBMGS00/exe/dbdb4slib.so'

Also I found the license file db2jcc_license_cu.jar in same directory

sapecdci1:ecdadm 56> pwd
/usr/sap/ECD/DVEBMGS00/exe
sapecdci1:ecdadm 57> ls db*
db2jcc.jar  *db2jcc_license_cu.jar*  db6level  db6pmudf  db6util  dbdb4slib.so  dbdb6slib.so  dbdb6slib.so.old  dbhdbslib.so  dbsdbslib.so  dbsdbslib.so.old

db6_clidriver:
adm  bin  bnd  cfg  cfgcache  conv  db2dump  lib  license  msg  security64
sapecdci1:ecdadm 58>

Let me know if I can copy this to /sapmnt/ECD/global/db6/LINUXX86_64/db6_clidriver/license as per your point 1-

1) You do seem to have a license file (db2jcc_license_cu.jar). Copy it into /usr/sap/<SAPSYSTEMNAME>/SYS/global/db6/<OS>/db6_clidriver/license as the instructions say.

I think we are missing the license file db2jcc_license_cisuz.jar on remote DB as per the note 663756-

The BIND commands must be executed by a runtime client.
Alternatively, you can use the DB2Binder utility from Note 784264
to bind the CLI packages. For this, you require a DB2 Connect
license file for the target database (for example,
db2jcc_license_cisuz.jar).

Kindly suggest.

Regards

Saurabh Mishra

Former Member · ‎10-11-2011

Hello Dorothea,

I did all the required setting and while binding I am getting below error-

sapecdci1:db2ecd 57> java com.ibm.db2.jcc.DB2Binder -url "jdbc:db2://S1031993:446/S1031993:traceFile=jcctrace.out;" -user sap -password <os-400 password>
[jcc][108][10149]DB2Binder stopped: Failure to create connection for binding.
  SQLCODE: -4230
  SQLSTATE: 42968
  Message: [jcc][t4][10509][13454][3.62.56] Connection to the data server failed. The IBM Data Server for JDBC and SQLJ license was invalid
or was not activated for the DB2 for z/OS subsystem. If you are connecting directly to
the data server and using DB2 Connect Unlimited Edition for System z, perform the
activation step by running the activation program in the license activation kit.
If you are using any other edition of DB2 Connect, obtain the license file,
db2jcc_license_cisuz.jar, from the license activation kit, and follow the installation
directions to include the license file in the class path. ERRORCODE=-4230, SQLSTATE=42968

Is this license problem of DB2 connect on my linux m/c or the remote OS 400 side and why it is giving error for z/os as my remote db is OS400 (i series) ? am I doing something wrong ?

and while testing through SE38 (ADBC_TEST_CONNECTION), it still giving the same error-

B Tue Oct 11 10:55:11 2011
B  Loading DB library '/usr/sap/ECD/DVEBMGS00/exe/dbdb4slib.so' ...
M  *** ERROR => DlLoadLib()==DLENOACCESS - dlopen("/usr/sap/ECD/DVEBMGS00/exe/dbdb4slib.so") FAILED
  "/usr/sap/ECD/DVEBMGS00/exe/dbdb4slib.so: cannot open shared object file: No such file or directory"  [dlux.c       445]
M  {root-id=000C298267DF1ED0BD84EDB29A144E54}_{conn-id=00000000000000000000000000000000}_0
B  *** ERROR => Couldn't load library '/usr/sap/ECD/DVEBMGS00/exe/dbdb4slib.so'
 [dbcon.c      5263]
B  {root-id=000C298267DF1ED0BD84EDB29A144E54}_{conn-id=00000000000000000000000000000000}_0
B  ***LOG BYG=> could not load library for database connection PRMS_TEST  [dbds         886]
B  ***LOG BZY=> unexpected return code 8192       calling DBDS       [dbacds       1536]

Regards

Saurabh Mishra

Edited by: saumishr on Oct 12, 2011 7:07 AM

Former Member · ‎10-10-2011

Thanks a lot Dorothea, I will follow these steps and I am sure that it will work. will let you know the status.

Regards

Saurabh Mishra

Former Member · ‎10-08-2011

As per note 663756, I can use the DB2 CLI driver as I am on Kernel release 720 (see below) -

If you use a DB2 CLI driver client, the following changes are required in
the procedure described above because the CLI driver does not support DB2
CLP and BIND commands:
o The CATALOG commands are omitted.
o The target host and port must be entered in the table DBCON.
For example, the CON ENV row looks as follows:
DB6_DB_NAME=HOSTDB;DB6_DB_TYPE=DB2/390;DB6_DB_HOST=<hostname>;
DB6_DB_SVCENAME=<portnum>;
o The BIND commands must be executed by a runtime client.
Alternatively, you can use the DB2Binder utility from Note 784264
to bind the CLI packages.

Is that mean that I need to only maintain the DBCON entry as all other commands are omitted for CLI driver and license file is mandatory or temp license will work ?

As per note 784264, I checked my CLASSPATH directory and it contain the JDBC driver file -

sapecdci1:db2ecd 58> pwd
/db2/db2ecd/db2_software/java
sapecdci1:db2ecd 59> ls db2*.jar
db2dbgm.jar  db2jcc4.jar  db2jcc.jar  db2jcc_license_cu.jar  db2policy.jar  db2umplugin.jar
sapecdci1:db2ecd 60> db2set -all
[e] DB2DBDFT=ECD
<i> DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=YES [DB2_WORKLOAD]
<i> DB2_BLOCKING_WITHHOLD_LOBLOCATOR=NO [DB2_WORKLOAD]
<i> DB2_AGENT_CACHING_FMP=OFF [DB2_WORKLOAD]
<i> DB2_TRUST_MDC_BLOCK_FULL_HINT=YES [DB2_WORKLOAD]
<i> DB2_CREATE_INDEX_COLLECT_STATS=YES [DB2_WORKLOAD]
<i> DB2_ATS_ENABLE=YES [DB2_WORKLOAD]
<i> DB2_RESTRICT_DDF=YES [DB2_WORKLOAD]
<i> DB2_DUMP_SECTION_ENV=YES [DB2_WORKLOAD]
<i> DB2_OPT_MAX_TEMP_SIZE=10240 [DB2_WORKLOAD]
<i> DB2_WORKLOAD=SAP
<i> DB2_TRUNCATE_REUSESTORAGE=IMPORT [DB2_WORKLOAD]
<i> DB2_MDC_ROLLOUT=DEFER [DB2_WORKLOAD]
<i> DB2_ATM_CMD_LINE_ARGS=-include-manual-tables [DB2_WORKLOAD]
<i> DB2_SKIPINSERTED=YES [DB2_WORKLOAD]
<i> DB2_VIEW_REOPT_VALUES=YES [DB2_WORKLOAD]
<i> DB2_OBJECT_TABLE_ENTRIES=65532 [DB2_WORKLOAD]
<i> DB2_OPTPROFILE=YES [DB2_WORKLOAD]
<i> DB2_IMPLICIT_UNICODE=YES [DB2_WORKLOAD]
<i> DB2_RUNTIME_DEBUG_FLAGS=TOLERANT_FLOAT [DB2_WORKLOAD]
<i> DB2STMM=APPLY_HEURISTICS:YES [DB2_WORKLOAD]
<i> DB2_INLIST_TO_NLJN=YES [DB2_WORKLOAD]
<i> DB2_MINIMIZE_LISTPREFETCH=YES [DB2_WORKLOAD]
<i> DB2_REDUCED_OPTIMIZATION=4,INDEX,JOIN,NO_TQ_FACT,NO_HSJN_BUILD_FACT,STARJN_CARD_SKEW,NO_SORT_MGJOIN,CART OFF,CAP OFF [DB2_WORKLOAD]
<i> DB2NOTIFYVERBOSE=YES [DB2_WORKLOAD]
<i> DB2TERRITORY=1
<i> DB2_INTERESTING_KEYS=YES [DB2_WORKLOAD]
<i> DB2_EVALUNCOMMITTED=YES [DB2_WORKLOAD]
<i> DB2_EXTENDED_OPTIMIZATION=NLJOIN_KEYCARD,IXOR [DB2_WORKLOAD]
<i> DB2_ANTIJOIN=EXTEND [DB2_WORKLOAD]
<i> DB2COMPOPT=327685,131776 [DB2_WORKLOAD]
<i> DB2ATLD_PORTS=60000:65000
<i> DB2ENVLIST=INSTHOME SAPSYSTEMNAME dbs_db6_schema DIR_LIBRARY LD_LIBRARY_PATH
<i> DB2COMM=TCPIP [DB2_WORKLOAD]
[g] DB2FCMCOMM=TCPIP4
[g] DB2SYSTEM=sapecdci1
[g] DB2INSTDEF=db2ecd

sapecdci1:db2ecd 61> java com.ibm.db2.jcc.DB3Binder
Exception in thread "main" java.lang.NoClassDefFoundError: com.ibm.db2.jcc.DB3Binder
   at gnu.java.lang.MainThread.run(libgcj.so.7rh)
Caused by: java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB3Binder not found in gnu.gcj.runtime.SystemClassLoader{urls=[file:/db2/db2ecd/sqllib/java/db2jcc_license_cu.jar,file:/db2/db2ecd/sqllib/java/db2jcc.jar,file:/db2/db2ecd/sqllib/function/,file:./,file:/db2/db2ecd/sqllib/java/db2java.zip,file:./,file:/db2/db2ecd/sqllib/java/db2java.zip,file:./], parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}
   at java.net.URLClassLoader.findClass(libgcj.so.7rh)
   at java.lang.ClassLoader.loadClass(libgcj.so.7rh)
   at java.lang.ClassLoader.loadClass(libgcj.so.7rh)
   at gnu.java.lang.MainThread.run(libgcj.so.7rh)

sapecdci1:db2ecd 62> db2 get dbm cfg | grep -i svcename
 TCP/IP Service name                          (SVCENAME) = sapdb2ECD
 SSL service name                         (SSL_SVCENAME) =

Former Member · ‎10-08-2011

Thanks a lot Dorthea,

I checked the license in my system and found that we have a temp license for dbconnect, can we make a test connection by using this temp license -

sapecdci1:db2ecd 51> db2licm -l
Product name:                     "DB2 Enterprise Server Edition"
License type:                     "CPU Option"
Expiry date:                      "Permanent"
Product identifier:               "db2ese"
Version information:              "9.7"
Enforcement policy:               "Soft Stop"
Features:
DB2 Database Partitioning:        "Licensed"
DB2 Performance Optimization ESE: "Licensed"
DB2 Storage Optimization:         "Licensed"
DB2 Advanced Access Control:      "Not licensed"
DB2 Geodetic Data Management:     "Not licensed"
IBM Homogeneous Replication ESE:  "Not licensed"

*Product name:                     "DB2 Connect Server"*
*License type:                     "Trial"*
Expiry date:                      "12/13/2011"
Product identifier:               "db2consv"
Version information:              "9.7"

Also how can I found out the port number for DBCON entry - DB6_DB_SVCENAME=<portnum>;

Currently my connection information from DBCON entry looks like -

DB6_DB_NAME=HOSTDB;DB6_DB_TYPE=DB2/400;DB6_DB_HOST=S1031993;DB6_DB_SVCENAME=446;

Kindly let me know what other steps are required or if I missed any of your suggestion.

Regards

Saurabh

Edited by: saumishr on Oct 8, 2011 8:45 PM

Will paste the rest of content in another message for formatting purpose.

Former Member · ‎10-07-2011

Thanks Dorothea/Volker,

Could you please share the document as well for connecting it via DB2 connect, what are the steps for installing the db2 connect and integration it to AS 400.

I also have some DB2 specific questions-

What are the steps required for this configuration on AS 400 side and any other specific requirement.

It would be really helpful if SAP or IBM has any specific guide for the same.

Is that mean that anyhow I need to purchase the license for DB connect ?

What is JDBC CLI, ODBC drivers ?

Regards

Saurabh Mishra

Former Member · ‎10-06-2011

Thanks All,

But still I have a question that I read somewhere that from netweaver 7.0 kernel release we can directly use CLI driver to connect the AS/400 DB2.

Is anyone aware of that, I will do more search in this regard and will let you know the link where I read that also not sure How can we check that we are using CLI driver or do we require extra license cost for CLI driver and what are the steps for same.

Regards

Saurabh Mishra

former_member196504 · ‎10-05-2011

Hello,

as of today there is no way to connect from a Linux/x86_64 application server via DBCON to DB2 for IBM i. To get this going you would need the XDN-Server installed on you IBM i box and the DBSL specific to DB2 for IBM i compiled for Linux/x86_64. The latter one is simply not existing today.

Best Regards, Christian Hölters, SAP Development on IBM i.

Former Member · ‎10-04-2011

Hi,

I guess correct note for my environment is Note 663756 - DB6 Multiconnect on DB2 for zOS DB2 for i with DB6 DBSL, but actually I don't have much Idea about the DB2 and couldn't understand some of the requirement like -

Patch text: "DB6: multiconnect to DB2/390 or DB2/400 database"

also not sure from where I can get the license for DB2 connect.

Our SAP system environment is -

OS - Red Hat Linux (X86_64)

SAP - ECC EHP 5 (Basis Patch level 😎

Kernel - 720 unicode level 90

DB2 9.7 FP 4

Regards

Saurabh Mishra

Former Member · ‎10-04-2011

Hi Saurabh,

yes, as you can see in the dev trace, this is reqired.

I would guess, you are in good luck, that XDN was developed, as with XDA this would not be possible.

I do not know, how the official support for this solution is - from my point of view, it should work fine.

You need the LIB_DBSL for DB2/400, that you can download for your platform and then you need to set the system for XDN as described in the following note:

Note 1257635 - DB4: DBSL Direct Drive for DB2 for IBM i (DB2/400)

(in your case, you do need the XDN server as well - that might be the biggest issue, as you might not be familiar with OS/400 based SAP systems ...)

As you are the first one (?) to use that, it might not work out of the box ...

Regards

Volker Gueldenpfennig, consolut international ag

http://www.consolut.com http://www.4soi.de http://www.easymarketplace.de

Remoted DB2 connection from SAP

Accepted Solutions (1)

Accepted Solutions (1)

Answers (14)

Answers (14)

Re: SAC - Blending Support in Optimized Design Mod...

sap.ui.RichTextEditor conflicting with sap cap app...

Re: Mass Update a Zfield in Std Table with Split &...

Re: Deploy failed. Detail: Request failed with sta...

Re: CAP Autentication error