topic Re: DB2connection schema name in Talend Studio

DB2connection schema name

Anonymous — Fri, 07 Sep 2018 10:00:13 GMT

Hi,

I am using DB2connection. Below properties need to be specified :

Password: PSwd

Server: hostname

Port:50000

Database: database to which i want to connect

schema ne table/many table

While executing the job it is not connecting to the database which i specified.Rather it is connecting to the userid database. So throwing error. Can any one suggest what is the way to deal with.

userid db2admin

so it is accessing db2admin database rather than the database name which i specified in the database option.

Thanks,

Rajul

Re: DB2connection schema name

iamabhishek — Fri, 07 Sep 2018 10:08:39 GMT

Could you provide the screenshot of the db2 component settings configuration. Also, please double-check the Hostname, Database, UserName properties.

Re: DB2connection schema name

Anonymous — Fri, 07 Sep 2018 10:30:14 GMT

pls find attached the screenshot

Re: DB2connection schema name

Anonymous — Fri, 07 Sep 2018 10:30:55 GMT

pls find attached the configuration of db2 connection

db2_configuration.JPG

Re: DB2connection schema name

Anonymous — Mon, 10 Sep 2018 08:13:14 GMT

Hello,

Have you tried to specify IP address for DB2 connection to see if it works?

What's the error message you are getting?

Best regards

Sabrina