DRDA

With Distributed Relational Database Architecture (DRDA ), both the IBM architecture for distributed databases is referred to, which are located on different heterogeneous platforms, as well as the protocol developed by IBM for the distribution of data.

DRDA allows distributed access to the different versions of IBM DB2 and Informix database systems.

There are different levels of implementation of the DRDA:

  • Support of a single SQL requests on a remote system
  • It can only be taken to a location reference.
  • It does not support transaction processing.
  • Each statement is handled separately and applied immediately
  • The server executes after each statement with a COMMIT.
  • Support for multiple SQL requests within a UOW ( Unit of Work )
  • Within a unit of work, only one server is addressed
  • The one- phase commit is still sufficient
  • Within a unit of work, multiple servers can be addressed
  • A single request speaks to only one server
  • Use of the Two -phase commit is required
  • In a query ( an SQL statement ) Multiple servers can be addressed

Within the DB2 world is mostly Professional Studies and even DR possible.

If you want to access other database server manufacturers or ODBC data sources, only the levels 1 or 2 are partially possible.

IBM Informix
291260
de