How QMF can access data in other databases

You can use QMF to connect to any of the DB2 UDB for OS/390, DB2 for VSE or VM, DB2 for iSeries, or DB2 Universal Database databases within a distributed network during QMF initialization or from within a QMF session. After successfully connecting to a location, you can access the data and QMF objects in that database in the same way you would access data and objects locally. For more information on the SQL CONNECT command, see the DB2 UDB for OS390 SQL Reference

QMF supports two methods of data access:

DRDA is IBM's approach to distributed technology. Within DRDA there are different types of support such as remote unit of work, distributed unit of work, and distributed request. In the DRDA environment, QMF supports only remote unit of work.

DB2 UDB for OS/390-to-DB2 UDB for OS/390 distributed unit of work allows you to access other DB2 UDB for OS/390 subsystems using a communications method specific to DB2 UDB for OS/390. DB2 UDB for OS/390 refers to this type of connection as system-directed access.

Both types of access are based on the definition of a unit of work, which is a single logical transaction. A logical transaction consists of a sequence of SQL statements in which either all of the operations are successfully performed or the sequence as a whole is considered unsuccessful.

[ Previous Page | Next Page | Contents | Index ]