PM77559: SQLCODE905 FROM DSNX9CAC FOR AN EXTERNAL STORED PROCEDURE ALSO REVIEW PI10085 ++HOLD ACTION ( ESCA SDSNLOAD MISMATCH )

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE905 from DSNX9CAC for an external stored procedure .
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 users of stored procedures or            *
  *                 User Defined Functions (UDFs) that           *
  *                 have ASUTIME specified.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When user specifies a very large        *
  *                      ASUTIME limit, the stored procedure     *
  *                      terminates with SQLCODE -905 while      *
  *                      the stored procedure works with a       *
  *                      smaller ASUTIME value.                  *
  *                      For example, when ASUTIME=999,999,999,  *
  *                      the stored procedure exceeds asutime    *
  *                      easily. When ASUTIME=99,999,999,        *
  *                      the same stored procedure works fine    *
  *                      without exceeding the asutime limit.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DB2 incorrectly stores the ASUTIME value into a
  signed local variable. When the value is big enough
  to have the sign bit on, the ASUTIME value is
  flipped over to become negative. Then DB2 resets the
  ASUTIME value to 1. Therefore, the stored procedure or
  UDF would be timed out easily.
  
  Additional Keywords:
  SQLUDF SQLSP SQLSTOREDPROC ASUTIMELIMIT
  

Problem conclusion

• DB2 code has been fixed to correctly store the ASUTIME
  value.
  

Temporary fix

Comments

• ž**** PE14/01/21 FIX IN ERROR. SEE APAR PI10085  FOR DESCRIPTION
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK93885 UK93886

Modules/Macros

• DSNWDFSP DSNX9CAC DSNX9EOT DSNX9I4R DSNX9REX
  DSNX9SPI DSNX9SPS DSNX9SP2 DSNX9ST2 DSNX9TIM DSNX9WLJ DSNX9WLS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK93885

     UP13/05/05 P F305

• R910 PSY UK93886

     UP13/05/05 P F305

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.