Any pitfalls in using DDF?

[Yordaman]

My team is looking to use the DDF (Distributed Data Facility) of DB2 to run an application on one mainframe (OS/390) machine that can access the DB2 data on another (as opposed to copying this data between machines, an old solution).
This is new to the company, so wondered if anyone else out there has employed this facility and found it useful, troublesome, etc.
Thanks,

 

[dhecht]

If using cursors, use FETCH ONLY or READ ONLY to utilize BLOCK FETCH.

Do not use three part names (private protocol) to connect. This will not be supported in the future.

If you're remotely calling stored procedures, consider using WLM address spaces for performance and to avoid limits on the number of concurrently running stored procedures.

Check the ZPARM to see how many DDF threads can be open concurrently.

Check the ZPARM to see the DDF timeout value.