Tailoring QMF for DB2 Universal Database for iSeries^(R) Servers

Beginning with Version 7 Release 1, QMF supports connectivity from a QMF application requester to a DB2 UDB for iSeries Version 4 Release 4 (or higher) server. This support is optional. You need to perform the steps in this chapter only if you intend to connect QMF to a DB2 UDB for iSeries Version 4 Release 4 (or later) server. Before you install QMF on a DB2 UDB for iSeries server, you need to make the following preparations:

• From the DB2 UDB for iSeries Query Manager, execute the following SQL on the server: CREATE COLLECTION Q using a user ID that has administrative authority. This must be the security officer or a user ID that has *ALLOBJ authority.
• Ensure that users of QMF have *USE authority for Q *LIB.

The following steps apply to a first time QMF installation. You can rerun these steps again as necessary to correct errors.