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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM77559

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-21

  • Closed date

    2013-04-26

  • Last modified date

    2014-05-14

  • 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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PM77559

Modified date:

2014-05-14

Translate my page

Machine Translation

Content navigation