Distributed Relational Database Architecture
Distributed Relational Database Architecture™ (DRDA®)
is a set of protocols that permits multiple database systems, which
includes both IBM and
not IBM systems,
as well as application programs, to work together.
Updating database directories
You can define where database connection information
is stored by updating the database directory.
DB2 Connect and SQL statements DB2 Connect™ forwards
SQL statements submitted by application programs to IBM mainframe database servers.
Multisite Updates
Multisite update, also known as distributed unit of work
(DUOW) and two-phase commit, is a function that enables your applications
to update data in multiple remote database servers with guaranteed
integrity. DB2® database products
provide comprehensive support for multisite updates.
SQLCODE mapping
Different IBM relational
database products do not always produce the same SQLCODEs for similar
errors. Even when the SQLCODE is the same, it might be accompanied
by tokens that are specified differently. The token list is passed
in the SQLERRMC field of the SQLCA. By default, DB2 Connect maps
SQLCODEs and tokens from each IBM mainframe database server to the appropriate DB2 SQLCODEs.