iSeries to iSeries data connection

[craig_welton]

Hi all,

This may be obvious, but I don't have a way to technically test it.

Can a UBE running on iSeries A read data from a datasource mapped to iSeries B?

thanks
Craig

 

[jdelisths]

Yes, it can.

 

[craig_welton]

Thanks Hari,

Is it as simple as it would appear? Meaning create the data source and OCM and ensure security is setup?

thanks
Craig

 

[jdelisths]

It should be. Most iSeries shops have two boxes, one for prod (A) and one for non-prod (B). When UBEs are run on B, it connects to the common data sources on A, so set up the data source just like how the System DS is set up on the server map of the B. Does that make sense?

 

[craig_welton]

Perfect sense, that's what I was hoping. Thanks again.

Craig

 

[ice_cube210]

HI Craig , yes this will work. QXDAEDRSQL needs to be running on both iSeries servers

 

[craig_welton]

Thanks for the detail! I was wondering if a "service" was needed to broker the SQL requests.