To execute query on a Table on a different server

nagesh54 · New User Joined: 20 Jun 2008 Posts: 30 Location: Hyderabad

Hi,

I want to execute a query on a table which is located on a different subsystem. I have two TSO regions for example t1 and t2. Db2 subsystems db1 and db2. I want to execute a query which is on db2 fromn t1. Please guide me..

I tried to save the query as a proc in QMF and tried to run it from t1 but it is not succesful.. Please help me if there is any other procedure to do it..

Thanks,
Nagesh.

nagesh54 · New User Joined: 20 Jun 2008 Posts: 30 Location: Hyderabad

Hi,

In the above question I want to execute the query as a batch job from t1 on the table which is on other host t2 and the db system is db2.

Thanks,
Nagesh.

Srihari Gonugunta · Posted: Tue Jun 02, 2009 3:03 pm

Hi Nagesh,
Please find out if the DDF connections are setup between the two subsystems. If they are setup already, you can use Locationid.qualifier.tablename for getting data from the table of other system.

nagesh54 · New User Joined: 20 Jun 2008 Posts: 30 Location: Hyderabad

Hi,

Thanks alot for the help.. One more thing, if the DDF connections are available then do we need to give any connect statements while executing through a batch job? or directly can we use that db2 subsystem name.

Thanks,
Nagesh.

Srihari Gonugunta · Posted: Tue Jun 02, 2009 9:13 pm

You don't need to use the other subsystem name also. You can simply use the proper qualified table name in your programs.