DB2 graphic  QMF Version 8

How QMF can access data in other databases

You can use QMF to connect to any of the DB2 UDB for z/OS, DB2 UDB for UNIX, Windows, and OS/2, DB2 Server for VSE or VM, DB2 UDB for iSeries, or DB2 UDB for Linux, UNIX, and Windows 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 DB2 UDB for z/OS 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 z/OS-to-DB2 UDB for z/OS distributed unit of work allows you to access other DB2 subsystems using a communications method specific to DB2 UDB for z/OS. DB2 UDB for z/OS 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.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004