Connectivity in distributed environments

Connectivity in the client/server environment enables communication between applications and database systems on disparate operating systems.

Connectivity in the client/server environment requires an architecture that can handle the stringent performance requirements of a transaction-based system and the flexibility of a decision-support system by using ODBC or JDBC.

Using standard communication protocols, Db2 can bind and rebind packages at other servers and run the statements in those packages. Communication protocols are rules for managing the flow of data across a computer network just as traffic lights and traffic rules manage the flow of car traffic. These protocols are invisible to Db2 applications.

In a distributed environment, applications can connect to multiple databases on different servers and can complete transactions, including commit and rollback operations, at the same time. This type of connectivity is known as a distributed unit of work.