PK29868: QMF INSTALLATION - THREE PART NAME INSTALL

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• QMF V9.1 will provide a new installation path to allow three
  part name queries to run at remote DB2 servers that do not have
  QMF fully installed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS users using three part  *
  *                 names referencing remote locations where QMF *
  *                 is not installed.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users running QMF commands referencing  *
  *                      three part names can receive            *
  *                      MSGDSQ16805 'Your command invoked a     *
  *                      program not found in the current plan.' *
  *                      This will happen if the remote location *
  *                      specified in the three part name does   *
  *                      not have QMF installed.                 *
  ****************************************************************
  * RECOMMENDATION: Users using three part names from QMF        *
  *                 may either fully install QMF at the          *
  *                 remote location or run the new               *
  *                 three part name only install path            *
  *                 to the remote location.  Either way,         *
  *                 the proper release QMF packages must         *
  *                 be bound at the remote location for          *
  *                 three part name usage to work from           *
  *                 QMF 8.1 and higher.                          *
  ****************************************************************
  QMF commands RUN QUERY, DRAW, DISPLAY TABLE, EXPORT TABLE,
  IMPORT TABLE and EDIT TABLE support referencing three part table
  names (location.schema.tablename).  Starting with QMF 8.1, usage
  of these commands to a location that does not contain QMF
  results in the above mentioned MSGDSQ16805.  This is because
  starting with QMF 8.1, QMF began binding all QMF packages with
  DBPROTOCOL(DRDA) which makes QMF a DRDA application.  DRDA
  protocol requires the presence of an application package at both
  the requestor and the location referenced in the three part
  name. Prior to QMF 8.1, QMF bound all packages with the
  DBPROTOCOL(PRIVATE) option, which does not require the presence
  of a package at the location specified in the three part name.
  This allowed the QMF commands referencing three part names to
  work at locations that did not contain QMF.
  *
  This APAR will add a new install path to QMF V8.1 and V9.1.
  The following installation path would be used to install
  QMF into a remote location where QMF accesses tables via
  three part names only. Run the following three jobs to
  complete the QMF Three Part Name usage only installation:
  -Run QMF.SDSQSAPE(DSQ1BSQL) at the remote location
  -Modify QMF.SDSQEXCE(DSQ1DEFS) to set T3PARTNM="YES"
   (T3PARTNM is a new DSQ1DEFS parameter added by this
   fix)
  -Run QMF.SDSQSAPE(DSQ1BPKG) at the remote location
   (Make sure to have the DSQDEFS ddcard in DSQ1BPKG
    point to the DSQ1DEFS that you modified in the step
    above)
  *
  Example situation for use:
  QMF is installed and run from local location DB2PROD.
  Users invoke QMF in location DB2PROD and run the query:
  SELECT * FROM DB2PAY.EMP.ADDRESS
  (Location DB2PAY does not have QMF installed and users never
  CONNECT TO DB2PAY from QMF on DB2PROD).
  To run the above query in QMF 8.1 and higher, either QMF would
  need to be installed at location DB2PAY, or, the new QMF Three
  Part Name usage only installation could be run.  In QMF 7.2 and
  below, the query would have successfully run with no QMF
  installed in DB2PAY.
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK17316 UK17317

Modules/Macros

• DSQ0BPKL DSQ1BPKB DSQ1DEFS
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• R810 PSY UK17316

     UP06/08/19 P F608

• R910 PSY UK17317

     UP06/08/23 P F608

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.