PL40968: SQLCODE905 - UNSUCCESSFUL EXECUTION DUE TO RESOURCE LIMIT BEING EXCEEDED - MESSAGE LIMIT VALUE IS ALWAYS ZERO.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• -905 SQLCODE905 - UNSUCCESSFUL EXECUTION DUE TO RESOURCE LIMIT
  BEING EXCEEDED - WAS ISSUED.  PART OF THE MESSAGE TEXT IS A
  FIELD CALLED LIMIT WHICH IS SUPPOSED TO BE EQUAL TO THE LIMIT
  AMOUNT ASUTIME THAT WAS EXCEEDED.  THAT LIMIT VALUE ALWAYS
  SEEMS TO BE ZERO EVEN THOUGH THE USER PUT THE VALUE 100 INTO
  THE RLIMIT TABLE DSNRLST01 FOR THE SPUFI PLANS, DSNESPCS AND
  DSNESPRR.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS OF THE DB2 RESOURCE LIMIT          *
  *                 FACILITY (RLF RLIMIT).                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: A RESOURCE LIMIT IS ESTABLISHED WITH    *
  *                      AN ASUTIME OF 100.  WHEN AN SQL         *
  *                      USER EXCEEDS THIS LIMIT, MSGDSNT408I    *
  *                      IS ISSUED WITH AN SQLCODE905 (-905)     *
  *                      BUT THE LIMIT VALUE IN THE MESSAGE      *
  *                      IS ZERO.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  WHEN A RESOUCE LIMIT IS ESTABLISHED (BY ADDING A ROW TO
  THE ACTIVE RESOURCE LIMIT SPECIFICATION TABLE), THE TIME
  LIMIT IS ENTERED IN CPU SERVICE UNITS.  WHEN SQLCODE905
  IS ISSUED FOR EXCEEDING THIS LIMIT, THE LIMIT IS DISPLAYED
  IN SECONDS (CONVERTED FROM CPU SERVICE UNITS).  100 CPU
  SERVICE UNITS IS LESS THAN 1 SECOND OF CPU TIME ON ANY
  MODEL D/T3090 PROCESSOR, SO MSGDSNT408I DISPLAYS A
  LIMIT TIME OF 0 SECONDS.
  

Problem conclusion

• MSGDSNT408I HAS BEEN CHANGED WHEN ISSUED FOR AN SQLCODE905.
  THE RESOURCE LIMIT TIME WILL BE DISPLAYED IN CPU SERVICE UNITS
  (AS DEFINED IN THE RESOURCE LIMIT SPECIFICATION TABLE) AS
  WELL AS IN CPU SECONDS.  A 'REQUEST FOR PUBLICATION CHANGE'
  HAS BEEN SUBMITTED TO UPDATE THE DB2 MESSAGES AND CODES
  MANUAL FOR THE CHANGE TO THE SQLCODE905 MESSAGE.
  

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:

  UL49267

Modules/Macros

•    DSNTIAM  DSNTRLMT DSNXECK  DSNXEDP  DSNXERT
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R210 PSY UL49267

     UP89/04/11 P F904

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.