Installation path G: Preparing a remote server to be accessed by QMF commands that include three-part names

Use this procedure to prepare a remote server to be accessed by QMF commands that include three-part names.

The following rules apply to QMF commands that include three-part table and view names:

They can be initiated from Db2® for z/OS® databases only.
They can be directed to all types of servers except DB2® for VSE and VM.
They cannot be used when QMF for TSO has been started as a Db2 for z/OS stored procedure.
The stored procedure interface to QMF for TSO is an optional interface that allows any product that can run a Db2 for z/OS stored procedure to start QMF for TSO.
They will produce errors if multirow fetch is active and the command is directed to a server other than Db2 for z/OS.
Start QMF in the Db2 for z/OS requester with multirow fetch turned off if users will be issuing QMF commands with three-part names to servers other than Db2 for z/OS.

By default, QMF commands that include three-part names cannot be used to access remote tables that contain large object (LOB) data. To enable access of LOB data in remote tables with three-part names, the DSQEC_LOB_RETRV global variable must be set to 3. The DSQEC_LOB_RETRV can also be set to 2 to enable the retrieval of LOB metadata only.

For more information about three-part table and view names, see .

Before you begin

The instructions in this topic assume that you have already determined that this is the correct installation path by using the roadmap for server databases that are accessed by three-part names.

Before you begin the installation process, complete the following steps:

If you have not done so already, install, prepare, and test QMF Version 13 Release 1 in at least one Db2 for z/OS requester database that will access this server. Only Db2 for z/OS databases can function as requesters. See Roadmap 1: Installing QMF in stand-alone or requester databases (Db2 for z/OS only) for installation paths for requesters.
Ensure that you have the proper authority for the database into which you will be installing the product. For more information, see Required authorities for installing QMF.

Procedure

To prepare a remote server to be accessed by QMF commands that include three-part names, complete the following steps:

Define and test DRDA communications between the server into which you are installing QMF Version 13 Release 1 and the requester into which you already installed QMF Version 13 Release 1.

DRDA communications between the server and the requester are used to complete the QMF Version 13.1 installation in the server.
Start both the requester and server databases.
You must start the Db2 for z/OS subsystem in the requester database with distributed data facility (DDF) started.
Run the jobs in Running installation jobs that prepare servers to be accessed by QMF commands that include three-part names. You must run these jobs from the local database.