topic Talend with DB2 MVS Connextion : Connection failure in Installing and Upgrading

Talend with DB2 MVS Connextion : Connection failure

Anonymous — Sat, 16 Nov 2024 14:27:24 GMT

La difficulté que je rencontre se matérialise par le message d'anomalie du produit :
Connection failure. You must change the Database Settings.
The application server rejected establishment of the connection. An attempt was made to access a database, BHC00003, which was not found. DB2ConnectionCorrelator: null
les paramètres qui sont utilisés sont :
DB Type : IBM DB2
Login de mon User MVS
Password de mon User MVS
Server : adresse IP du MVS
Port : celui du DB2 sur MVS
Database : BHC00003
(le pb se pose avec ou sans alimentation des paramètres DRDA du DB2 MVS)
ps : les paramètres DRDA du DB2 MVS sont situés dans les tables :
SYSIBM.LOCATIONS
SYSIBM.IPNAMES
SYSIBM.USERNAMES
Voyez-vous le problème qui se pose ?

Re: Talend with DB2 MVS Connextion : Connection failure

Anonymous — Fri, 15 Feb 2008 15:54:09 GMT

Hello,
I'm not a DB2 Mainframe expert but as far as I can read in DB2 for z/OS and OS/390: Ready for Java redbook ( http://www.redbooks.ibm.com/abstracts/sg246435.html), you need to enable JDBC Access
The JDBC drivers are installed through SMP/E as a separate FMID, called JDB7712 (for
DB2 Version 7). The SMP/E installation steps are described in Chapter 7 of Application
Programming Guide and Reference for Java, SG26-9932-03 ( http://www-306.ibm.com/software/data/db2/zos/v7books.html)
Talend is using the JDBC Type 4 driver
HTH,

BTW : Please post in English, this forum is meant to be international.

Re: Talend with DB2 MVS Connextion : Connection failure

Anonymous — Fri, 15 Feb 2008 17:02:31 GMT

Hello,
I think this is for working with à JVM on z/OS or OS/390.
But I am trying to connect directly from Talend Windows to DB2 z/OS without a JVM on z/OS using DRDA.
When I want to connect to a database who's name is too long I receive the message on MVS :
DSNL032I -DBDH DSNLZDJN DRDA EXCEPTION CONDITION IN REQUEST FROM REQUESTOR LOCATION=10.xxx.xxx.xx FOR THREAD WITH
LUWID=GA70F423.GC18.C1F465E19F7B=89342
REASON=00D35E00
ERROR ID=DSNLZSAS0118
where 00D35E00 means :
Explanation: DB2 has detected an error while parsing a DDM command or DDM
command data. An invalid RDBNAM length was sent on an ACCSEC command.

This reason code is issued by the following CSECT: DSNLZSAS

System Action: If the length of the RDBNAM is greater than 18, then A DDM
reply message (SYNTAXRM) is returned to the DRDA client. If the data in
characters 17-18 of the RDBNAME is non-blank, then a DDM reply message
(VALNSPRM) is returned to the DRDA client.
It seems I am not so far from working connexion

Re: Talend with DB2 MVS Connextion : Connection failure

Anonymous — Fri, 15 Feb 2008 19:09:40 GMT

Hi,
This is a solution to try to connect to DB2 MVS.
Use the tLibraryLoad components for b2jcc_license_cisuz.jar and db2jcc_license_cu.jar, then use the tJDBCInput to specify db2jcc.jar and the specific ClassName com.ibm.db2os390.sqlj.jdbc.DB2SQLJDriver for os390 connection.
See the following screenshot.
Regards

Re: Talend with DB2 MVS Connextion : Connection failure

Anonymous — Mon, 18 Feb 2008 11:00:20 GMT

Hi,
Where are the tLibraryLoad components, in a Folder of the Palette (TOS 2.3.0.M2_r7640) ?

Re: Talend with DB2 MVS Connextion : Connection failure

Anonymous — Mon, 18 Feb 2008 11:22:36 GMT

Hello,
This component is available since 2.3.0 stable version.
tLibraryLoad is available in the System family (See http://www.talendforge.org/components/index.php)
Regards,

Re: Talend with DB2 MVS Connextion : Connection failure

Anonymous — Mon, 18 Feb 2008 15:44:31 GMT

Hi,
Now, I've 2 problems :
1/ on tJDBCInput_1 : No Schema as been defined yet
2/ after running the Job :
Starting job Unload_DBDH at 16:31 18/02/2008.
Exception in component tJDBCInput_1
java.lang.ClassNotFoundException: com.ibm.db2os390.sqlj.jdbc.DB2SQLJDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at db2_download.unload_dbdh.Unload_DBDH.tJDBCInput_1Process(Unload_DBDH.java:182)
at db2_download.unload_dbdh.Unload_DBDH.tLibraryLoad_4Process(Unload_DBDH.java:322)
at db2_download.unload_dbdh.Unload_DBDH.tLibraryLoad_3Process(Unload_DBDH.java:366)
at db2_download.unload_dbdh.Unload_DBDH.runJobInTOS(Unload_DBDH.java:478)
at db2_download.unload_dbdh.Unload_DBDH.main(Unload_DBDH.java:394)
Job Unload_DBDH ended at 16:31 18/02/2008.
Do you know what it meens ?

Re: Talend with DB2 MVS Connextion : Connection failure

Anonymous — Mon, 18 Feb 2008 17:10:50 GMT

Hi,
I found for pb 2 :
it is not com.ibm.db2os390.sqlj.jdbc.DB2SQLJDriver
but COM.ibm.db2os390.sqlj.jdbc.DB2SQLJDriver !!!!!! (caps sensitive)
then when i run job, i get :
Starting job Unload_DBDH at 18:04 18/02/2008.
Exception in component tJDBCInput_1
com.ibm.db2.jcc.a.DisconnectException: The application server rejected establishment of the connection. An attempt was made to access a database, BHC00003, which was not found. DB2ConnectionCorrelator: null
at com.ibm.db2.jcc.b.hb.u(hb.java:1616)
at com.ibm.db2.jcc.b.hb.n(hb.java:525)
at com.ibm.db2.jcc.b.hb.a(hb.java:335)
at com.ibm.db2.jcc.b.hb.a(hb.java:115)
at com.ibm.db2.jcc.b.b.e(b.java:1385)
at com.ibm.db2.jcc.b.b.b(b.java:1259)
at com.ibm.db2.jcc.b.b.q(b.java:1031)
at com.ibm.db2.jcc.b.b.b(b.java:739)
at com.ibm.db2.jcc.b.b.a(b.java:725)
at com.ibm.db2.jcc.b.b.<init>(b.java:332)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:165)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at db2_download.unload_dbdh.Unload_DBDH.tJDBCInput_1Process(Unload_DBDH.java:185)
at db2_download.unload_dbdh.Unload_DBDH.tLibraryLoad_4Process(Unload_DBDH.java:322)
at db2_download.unload_dbdh.Unload_DBDH.tLibraryLoad_3Process(Unload_DBDH.java:366)
at db2_download.unload_dbdh.Unload_DBDH.runJobInTOS(Unload_DBDH.java:478)
at db2_download.unload_dbdh.Unload_DBDH.main(Unload_DBDH.java:394)
Job Unload_DBDH ended at 18:04 18/02/2008.
therefore, it the same pb as DRDA, the database BHC00003 is not found on MVS but it exists !!!!

Re: Talend with DB2 MVS Connextion : Connection failure

Anonymous — Tue, 19 Feb 2008 14:53:29 GMT

Hi,
1/ with DB2 Connect, I get the same message :
Connection failure. You must change the Database Settings.
The version of the IBM Universal JDBC driver in use is not licensed for connectivity to QDB2 databases. To connect to this DB2 server, please obtain a licensed copy of the IBM DB2 Universal Driver for JDBC and SQLJ. An appropriate license file db2jcc_license_*.jar for this target platform must be installed to the application classpath. Connectivity to QDB2 databases is enabled by any of the following license files: { db2jcc_license_cisuz.jar }
2/ with tJDBC_Input_1 :
I wrote the JDBC URL with IP Adress : "jdbc:db2://10.xx.xx.xxx:10xxx/DBDH"
3/ with tJDBC_Input_1 : I wrote in the name of the Database the name of DB2 (DBDH), I come more far but I get the message :
com.ibm.db2.jcc.a.SqlException: unsupported encoding Cp1147 for result set column

Re: Talend with DB2 MVS Connextion : Connection failure

Anonymous — Tue, 19 Feb 2008 15:13:13 GMT

3b/ There are provided in Advanced Settings pour tJDBC_Input_1 following encoding types : ISO-8859-15, UTF-8, CUSTOM. Which one is to use with encoding cp1147 MVS DB2 ?

Re: Talend with DB2 MVS Connextion : Connection failure

Anonymous — Tue, 19 Feb 2008 15:35:26 GMT

Hello,
You can specify "Cp1147" after having chose CUSTOM.
Regards,

Re: Talend with DB2 MVS Connextion : Connection failure

Anonymous — Tue, 19 Feb 2008 16:07:05 GMT

Thank you,
When I Specify "Cp1147" after having chose CUSTOM, I get the same message :
Starting job Unload_DBDH at 17:03 19/02/2008.
Exception in component tJDBCInput_1
com.ibm.db2.jcc.a.SqlException: unsupported encoding Cp1147 for result set column
Not easy

Re: Talend with DB2 MVS Connextion : Connection failure

Anonymous — Tue, 19 Feb 2008 16:59:47 GMT

May this link helps ?
http://www-1.ibm.com/support/docview.wss?uid=swg21221551

Re: Talend with DB2 MVS Connextion : Connection failure

Anonymous — Thu, 21 Feb 2008 10:55:26 GMT

Hi,
thank you,
to run Talend, we have installed the jre1.5.0_05 and it seems not using extended encoding set Cp1147,
we're looking for it.
Keep in touch

Re: Talend with DB2 MVS Connextion : Connection failure

Anonymous — Thu, 21 Feb 2008 13:14:34 GMT

Bingo !
we took charsets.jar from a jre 1.6 and stored it in C:\Program Files\Java\jre1.5.0_05\lib
=> Starting job Unload_DBDH at 12:45 21/02/2008.
connecting to socket on port yyyy
connected
connecting to socket on port xxxx
connected
1030860 milliseconds
disconnected
disconnected
Job Unload_DBDH ended at 13:02 21/02/2008.
Thank you every one