PH58448: ABEND04E RC00E70005 AT DSNXISB2 P942 DURING INTERNAL BIND FOR ALTER PROCEDURE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 at DSNXISB2 P942 during ALTER PROCEDURE
  processing. ALTER PROCEDURE was doing an internal BIND of the
  stored procedure package and experienced a deadlock. The
  deadlock should be reported with SQLCODE904 (resource
  unavailable) instead of abending.
  

Local fix

• Retry to avoid the deadlock with the other transaction accessing
  the same resource at the same time.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 and 13 for z/OS users that                        *
  * issue CREATE or ALTER of native SQL                          *
  * routines through the use of                                  *
  * EXECUTE IMMEDIATE.                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND04E RC00E70005 in DSNISB2                               *
  * at location P942 occurs on                                   *
  * ALTER or CREATE of native SQL                                *
  * routines that use EXECUTE IMMEDIATE.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  ABEND04E RC00E70005 occurred when altering or creating
  a native SQL routine because internal return code
  and SQLCODE checking didn't handle positive SQLCODEs correctly.
  In this case, SQLCODE 385 was issued during the parsing phase.
  The use of EXECUTE IMMEDIATE prevented SQLCODE 385 from being
  set back to zero before the bind phase. The bind phase did not
  handle the SQLCODE properly which lead to an ABEND.
  

Problem conclusion

• SQLCODE checking during the ALTER/CREATE
  native SQL routines are adjusted to handle
  positive SQLCODEs correctly. SQLCODE -904 will now be
  correctly issued instead of an ABEND.
  Additional Keywords:
  SQLCREATE SQLALTER SQLSTOREDPROC SQLCODE904 SQLCODE385
  SQLNATIVESQLPL SQLFUNCTION SQLTRIGGER
  

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:

  UI95951 UI95952

Modules/Macros

• DSNTBSPL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI95951

     UP24/03/13 P F403

• RD10 PSY UI95952

     UP24/03/13 P F403

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.