Remote access and distributed data
Db2 supports remote access between requester and server relational database management systems (DBMS)
Introductory concepts
Db2 uses DRDA access for remote connections.
Characteristics of DRDA
With DRDA, the application can remotely
bind packages and can execute packages of static or dynamic SQL that
have previously been bound at that location. DRDA has the following characteristics and benefits:
- With DRDA access, an application can access data at any server that supports DRDA, not just a Db2 server on a z/OS® operating system.
- DRDA supports all SQL features, including user-defined functions, LOBs, stored procedures, and XML data.
- DRDA can avoid multiple binds and minimize the number of binds that are required.
- DRDA supports multiple-row FETCH.