PM10679: INCORRECT SQLCODE501 AFTER AN SQLCODE805. THE IMPACTED THREAD IS RUNNING PACKAGES AT BOTH LOCAL AND REMOTE SERVERS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2DDF DDFL09 defect pm10679 dpm10679
  An SQL -501 can be issued after a previous SQL request get a
  -805. The thread may have issued SQL requests at both a local
  and a remote server. The SQLCODE501 is incorrectly issued from
  DSNLXRSQ.
  **************************************
  Additional keywords and symptoms:
   SQLCODE501n SQL501n SQL0501n SRCN501
   SQLCODE516n SQL516n SQL0516n SRCN516
   SQLCODE518n SQL518n SQL0518n SRCN518
   PACKAGE PATH
   CURRENT PACKAGE PATH
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When multiple collection IDs are        *
  *                      used in the PACKAGE PATH clause of      *
  *                      a CREATE PROCEDURE statement, or        *
  *                      via SET CURRENT PACKAGE PATH, the       *
  *                      following negative SQLCODEs are         *
  *                      possible when performing remote         *
  *                      SQL requests:                           *
  *                      1. SQLCODE -501 incorrectly issued      *
  *                         on FETCH or CLOSE.                   *
  *                      2. SQLCODE -516 incorrectly issued      *
  *                         on DESCRIBE.                         *
  *                      3. SQLCODE -518 incorrectly issued      *
  *                         on EXECUTE.                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When multiple collection ids are specified either via the
  PACKAGE PATH clause at CREATE PROCEDURE time, or via the SET
  CURRENT PACKAGE PATH statement, the list of collection ids
  is used to resolve references to packages that are used to
  execute remote SQL statements. The negative SQLCODEs listed
  above may be incorrectly issued because not all the COLLIDs
  specified via PACKAGE PATH were used to resolve package
  references.
  

Problem conclusion

• DB2 for z/OS requester has been changed to resolve package
  references for remote statements when PACKAGE PATH with more
  than one entry is used.
  

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:

  UK57520 UK57521

Modules/Macros

• DSNDARPB DSNDRSTB DSNLRRDS DSNLXROP DSNLXRSQ
  DSNXEPM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK57520

     UP10/06/16 P F006

• R910 PSY UK57521

     UP10/06/16 P F006

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.