Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 ?
Labels (2)
14 Replies
Anonymous
Not applicable
Author

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.
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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

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,
Anonymous
Not applicable
Author

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 ?
Anonymous
Not applicable
Author

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 !!!!
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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 ?