PM87227: DSNLCITR SQLCODE -904 REASON 00D3102E RESOURCE TYPE RESOURCE WHEN QUERY RUNS ON ACCLERATOR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2DDF defect pm87227 dpm87227
  DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED
  BY AN UNAVAILABLE RESOURCE.
  REASON 00D3102E, TYPE OF RESOURCE 00001004,
  AND RESOURCE NAME (accelerator location name)
  incorrectly issued when a query attempts to run on
  the accelerator and has an ASUTIME condition exceeded.
  ***************************************************************
  Additional Symptoms and Keywords:
   SQLCODE -904 SQLCODE904 SRCN904 SQL904N SQL00904N
    DSNLCITR 00D3102E RC00D3102E
  

Local fix

• disable RLF to prevent Asutime limit exceeded
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE -904 is correctly returned      *
  *                      when a Communications DataBase (CDB)    *
  *                      unavailable condition occurs, however   *
  *                      the reason code returned does not       *
  *                      reflect the actual error condition.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When attempting to access a remote server using a trusted
  connection, DB2 searches the CDB for the system authid to be
  used in connecting to the remote location.  If an error occurs,
  such as an ASUTIME limit exceeded condition, DB2 reports the
  error with SQLCODE -904 but with an incorrect reason code,
  00D3102E (trusted context system authid row not found),
  instead of a reason code that reflects the actual error.
  

Problem conclusion

• DB2 has been changed to report the reason code associated
  with the actual error.
  

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:

  UK94915 UK94922

Modules/Macros

• DSNLVINF
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK94915

     UP13/06/28 P F306

• R910 PSY UK94922

     UP13/06/28 P F306

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.