PM26077: INCORRECT AUTHID OR OWNER USED FOR ALIAS RESOLUTION DURING A REMOTE PACKAGE BIND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2DDF DB2DRDA defect pm26077 dpm26077
  Incorrect authid or owner used for alias resolution during a
  remote package bind.
  ********************************************************
  Additional symptoms and keyword:
   SQLCODE204N SQLCODE204 SQL204N SQL204 SRCN204 SRC204
   DSN6SPRM DRDA_RESOLVE_ALIAS
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users    *
  *                 running a remote package bind request and    *
  *                 DRDA_RESOLVE_ALIAS subsystem parameter is    *
  *                 set to YES on the requester subsystem.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE +204 or -204 returned from      *
  *                      remote system during remote package     *
  *                      bind for a reference to an object       *
  *                      that should have been found on the      *
  *                      requester system.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Remote BIND PACKAGE requests from a DB2 requester system
  (SITE1) to a remote server (SITE2) may fail with unpredictable
  errors on the server SITE2 because of faulty DRDA ALIAS
  RESOLUTION processing at the requester SITE1.  DRDA ALIAS
  RESOLUTION is a capability provided by APAR PK64045 (see NOTE
  below) for V8 and V9, and is enabled when the subsystem
  parameter DRDA_RESOLVE_ALIAS is set to YES.  DRDA ALIAS
  RESOLUTION always occurs on V10 subsystems.
  
  With DRDA ALIAS RESOLUTION enabled, when any statement being
  bound references an object using a 3-part name ALIAS, DB2 at
  SITE1 searches its catalog to resolve the 3-part name ALIAS
  into the qualified name of the object at SITE2.  DB2 then
  creates a modified statement with the resolved object
  references and sends that modified statement to SITE2 to be
  bound.
  
  If the Communication Database (CDB) on SITE1 has outbound
  userid translation definitions which are to be used when
  accessing SITE2, then DRDA ALIAS RESOLUTION for unqualified
  object references in the statement may incorrectly use the
  CDB definition to search the SITE1 catalog when resolving
  3-part name ALIASes instead of using the value of the OWNER
  bind option, if it is provided.
  
  As a result, DB2 at SITE1 generates a modified statement with
  incorrectly qualified object references and sends the incorrect
  statement to the remote server SITE2.  The results of the bind
  of the statement at SITE2 are unpredictable, but include the
  possibility of various SQL errors, such as SQLCODE +204 and
  -204, as described above.
  
  NOTE: APAR PK64045 provides tools and capabilities to aid
  customers in migrating their plans and packages from using
  private protocol to using DRDA protocol. One of the
  capabilities is DRDA ALIAS RESOLUTION.
  

Problem conclusion

• DB2 DRDA alias resolution processing has been changed to
  to ensure that the provided value of the OWNER bind option
  or the job authid is used to qualify unqualified object
  references in SQL statements when accessing the requester
  catalog during a remote package bind.
  

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:

  UK64183 UK64184 UK64185

Modules/Macros

• DSNLXRCM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK64183

     UP11/02/09 P F102

• R810 PSY UK64184

     UP11/02/09 P F102

• R910 PSY UK64185

     UP11/02/09 P F102

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.