I need to create a connection to mainframe db2.
In the Metadata , I tried to create a db connection.
DB Type: IBM DB2 ZOS
I left blank in Schema filed. Then click check. I got connection successful.
But if I entered schema name, I got "Connection failure. You must change the Database Settings.
com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: SYSIBM.SYSSCHEMATA"
So there is no table schema or view schema can be generated.
Do you have any idea on what is wrong ?
Thanks.
Hi jijli,
Thanks for your feedback, what's more, talend open studio production of version 5.2.2 will be released in two days. Perhaps this issue has been fixed on the newest version. Let's wait for that.
Best regards
Sabrina