PH45636: RESOURCE UNAVAILABLE ERROR (SQLCODE-904) WITH REASON 00000000

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Message "DSNT408I SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION
  CAUSED BY AN UNAVAILABLE RESOURCE"  is received with REASON =
  00000000.
  The reason should be 00C90081 because the object is STOPPED.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS and Db2 13 for z/OS                      *
  * users.                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * SQLCODE -904 issued with an incorrect                        *
  * zero reason code.                                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  When a thread was getting a claim, the claim attempt needed
  to be retried because the object was in the STOP state.
  Eventually, the claim was successful after the object was
  no longer in the STOP state.
  Although the claim was successful, an error reason code
  for the STOP state error was not reset before the retry.
  This caused the SQLCODE904 to be returned with a zero
  reason code for the RESOURCE NOT AVAILABLE error.
  

Problem conclusion

• To fix the inadvertent SQLCODE904, the claim logic in Db2
  was fixed to reset the error reason code before retrying
  the claim.
  

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:

  UI81401 UI81402

Modules/Macros

• DSNB1LCM DSNB1CLM DSNB1POC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI81401

     UP22/07/19 P F207

• RD10 PSY UI81402

     UP22/07/19 P F207

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.