PM90484: ABND=0C6-00000006,-DSNILREP CAN OCCUR ON SQL PROCEDURE/FUNCTION IF IT IS INVOKED THEN ALTERED IN THE SAME COMMIT SCOPE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND0C6 RC06 DSNILREP can occur on a SQL procedure/function
    if it is invoked then altered in the same commit scope.  The
    dump title looks similar to the following:
    DB2A,ABND=0C6-00000006,U=USRT002 ,M=N  ,C=111.DMC
    -DSNILREP,M=DSNTFRCV,PSW=077C2001FE08CF80,A=002D
    Altering of a SQL procedure/function in the same commit scope
    where it has been invoked is not allowed. This APAR will
    block such an ALTER.                                  (d158790)
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 10 for z/OS users who try to alter       *
    *                 a procedure/function between two invocations *
    *                 of the procedure/function.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND0C6 RC06 DSNILREP can occur on an  *
    *                      SQL procedure/function if it is invoked *
    *                      then altered and invoked again in the   *
    *                      same commit scope.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    ABEND0C6 RC06 DSNILREP can occur on an SQL procedure/function if
    it is invoked then altered and invoked again in the same commit
    scope. The reason is the cached code for the procedure/function
    is not purged after the ALTER PROCEDURE/FUNCTION.
    
    Additional Keywords:
    ABEND0C6 RC00000006 SQLUDF SQLSTOREDPROC SQLSP SQLALTER
    SQLCODE615
    

Problem conclusion

  • Code has been changed so the ALTER PROCEDURE/FUNCTION is blocked
    if it follows the invocation of the procedure/function in the
    same commit scope.  SQLCODE -615 is issued in this case.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM90484

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-06-05

  • Closed date

    2013-07-23

  • Last modified date

    2013-09-03

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

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

    UK96072

Modules/Macros

  •    DSNTBRB2
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK96072

       UP13/08/07 P F308

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

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM90484

Modified date:

2013-09-03

Translate my page

Machine Translation

Content navigation