One Star

Talend with DB2 MVS Connextion : Connection failure

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 ?
14 REPLIES
Employee

Re: Talend with DB2 MVS Connextion : Connection failure

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.
One Star

Re: Talend with DB2 MVS Connextion : Connection failure

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
Employee

Re: Talend with DB2 MVS Connextion : Connection failure

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
One Star

Re: Talend with DB2 MVS Connextion : Connection failure

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

Re: Talend with DB2 MVS Connextion : Connection failure

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,
One Star

Re: Talend with DB2 MVS Connextion : Connection failure

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 ?
One Star

Re: Talend with DB2 MVS Connextion : Connection failure

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 !!!!
One Star

Re: Talend with DB2 MVS Connextion : Connection failure

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
One Star

Re: Talend with DB2 MVS Connextion : Connection failure

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 ?
Employee

Re: Talend with DB2 MVS Connextion : Connection failure

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

Re: Talend with DB2 MVS Connextion : Connection failure

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
Employee

Re: Talend with DB2 MVS Connextion : Connection failure

One Star

Re: Talend with DB2 MVS Connextion : Connection failure

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
One Star

Re: Talend with DB2 MVS Connextion : Connection failure

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