Ways to implement distributed data in programs

You can connect to a remote server in different ways. You can code an application that uses DRDA to access data at a remote location by using either CONNECT statements or three-part names and aliases.

Using either method, you must bind the DBRMs for the SQL statements that are to execute at the server to packages that reside at the server.

• At the local Db2 subsystem, use the BIND PLAN command to build an application plan.
• At the remote location, use the BIND PACKAGE command to build an application package that uses the local application plan.