PH66427: SQLCODE905 WITH ASUTIME=0 FOR SQL STATEMENT WITH UDF IN PACKAGE BOUND WITH APPLCOMPAT V10R1 AND RELEASE COMMIT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE905 with ASUTIME=0 can occur for an SQL statement with a
  UDF in it for a package that is bound with APPLCOMPAT V10R1 and
  RELEASE COMMIT.
  

Local fix

• BIND the package with a higher APPLCOMPAT if possible.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 12 and 13 for z/OS users who use     *
  *                 the resource limit facility (RLF) for        *
  *                 packages bound with APPLCOMPAT(V10R1).       *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE -905 was unexpectedly issued    *
  *                      with ASUTIME LIMIT = 000000000000 for   *
  *                      a statement that invoked a user         *
  *                      defined function. The ASUTIME LIMIT     *
  *                      tokens in this SQL condition were       *
  *                      unexpected for this statement.          *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  A package bound with APPLCOMPAT(V10R1) being governed by RLF
  with a row in the table with a specific ASUTIME column value.
  This package had a statement that invoked a UDF. After
  returning from the UDF, the ASULIMIT is restored from the
  caller's package information. However, due to an earlier
  COMMIT, the caller's package was released and
  the RLF  table was not looked up again. This left the limit
  values as zero in the caller's pacakge.
  
  Additional Keywords:
  SQLCODE905 SQLUDF SQLFUNCTION DB2RLF
  

Problem conclusion

• Db2 code has been changed to save and restore the caller's RLF
  information from stacked storage.
  

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:

  UO03873

Modules/Macros

• DSNIWKFL DSNIWRCC DSNIWTTA DSNIWTTC DSNIWTTD DSNLZDTA DSNLZOGV
  DSNTXSTB DSNX9CAC DSNX9WCA DSNXDMPS DSNXEAU2 DSNXEBR  DSNXECL
  DSNXECLF DSNXECLN DSNXECW  DSNXECWA DSNXECWU DSNXEDP  DSNXEDS1
  DSNXEDSC DSNXEEZ  DSNXEEZT DSNXEPM  DSNXEPP  DSNXERT  DSNXERT2
  DSNXESPL DSNXESTA DSNXESTR DSNXESTS DSNXETCH DSNXEXAT DSNXEXBT
  DSNXIANR DSNXOPTH DSNXOSTP DSNXRASM DSNXRBND DSNXRCTC DSNXRCUF
  DSNXRGPL DSNXRITV DSNXRLOB DSNXROH1 DSNXROH2 DSNXROHB DSNXROHL
  DSNXROHR DSNXROHS DSNXRORR DSNXROVR DSNXRRTN DSNXRSPL DSNXRUFS
  DSNXZEU2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UO03873

     UP25/07/08 P F507

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.