Effects of distributed data on planning

When you work in a distributed environment, you need to consider how authorization works and the cost of running SQL statements.

The appropriate authorization ID must have authorization at a remote server to connect to and to use resources at that server.

You can use the resource limit facility at the server to set resource limits for distributed SQL statements. Using this facility, a server can govern how much of its resources a given package can consume by using DRDA access.