MQSeries.net :: View topic

Qadeer_824

Hi,
I am using a database node to connect to a DB2 on a remote system. The remote system is a Mainframe server that hosts a DB2 instace.

The remote database has two database schemas, called as TEST1 and TEST2 each holding tables T_TEST1 and T_TEST2 respective.

To connect to these database tables i have two user-ids, usrtest1 and usrtest2. usrtest1 has authority on TEST1 schema and usrtest2 has authority on TEST2 schema.

I have alredy created odbc configuration for the remote database instance in .odbc.ini on the Message Broker server. I also created a DSN service using mqsisetdbparms command using the user-id usrtest1 for database. I have also catalogued the remote database usint db2 catalog database command. I can run queries on the T_TABLE1 successfully from compute node.

If i want to run queries from Database node on the table T_TEST2, using the user-id usrtest2, then is it sufficient if i only create another dsn service using mqsisetdbparms or do i need to catalog the database using a different alias name?

I hope i have not made it very complex to understand, but i really need to understand this. Please provide your inputs on this and your help is highly appreciated.

Thanks,
Qadeer