DRDA stands for “Distributed Relational Database Architecture.” It is a standard for the communication between a relational database management system (RDBMS) and a remote client application. DRDA provides a common communication protocol that allows a client application to access and manipulate data stored in a remote RDBMS, regardless of the specific RDBMS or operating system being used.
DRDA is based on the client-server model, where the RDBMS acts as the server and the client application acts as the client. The client application sends requests to the server and the server responds with the requested data or information. The requests and responses are sent using the DRDA protocol, which defines the format and syntax of the requests and responses.
DRDA is designed to work with both synchronous and asynchronous communication between the client and the server. It also supports both connection-oriented and connectionless communication.
DRDA supports a variety of data access and manipulation operations, such as query, update, insert, and delete. It also supports distributed transactions, which allow multiple operations to be performed as a single atomic transaction. This ensures that the data remains in a consistent state even if an error occurs during the transaction.
DRDA is widely supported by many relational databases such as IBM’s DB2, Informix, and Microsoft SQL Server. This allows for easy integration of different databases and allows for the creation of distributed systems that can access and manipulate data stored in multiple databases.
In summary, DRDA stands for Distributed Relational Database Architecture, it is a standard for the communication between a relational database management system (RDBMS) and a remote client application. It provides a common communication protocol that allows a client application to access and manipulate data stored in a remote RDBMS, regardless of the specific RDBMS or operating system being used. It is based on the client-server model and it supports a variety of data access and manipulation operations, such as query, update, insert, and delete. It also supports distributed transactions, which allow multiple operations to be performed as a single atomic transaction. It is widely supported by many relational databases such as IBM’s DB2, Informix, and Microsoft SQL Server.