A fix is available
APAR status
Closed as program error.
Error description
Resource not available during CREATE FUNCTION may cause ABEND 04E-00E70005 DSNXIVRO:P138
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: DB2 10 and 11 for z/OS users * * of CREATE FUNCTION * **************************************************************** * PROBLEM DESCRIPTION: User receives ABEND04E RC00E70005 at * * DSNXIDDL.DSNXIVRO P138 when executing * * CREATE FUNCTION * **************************************************************** * RECOMMENDATION: * **************************************************************** Users may receive ABEND04E RC00E70005 at DSNXIDDL.DSNXIVRO P138 when executing a CREATE FUNCTION statement. The problem occurs because DB2 internally encounters a resource-not-available (or similar) condition, but continues processing instead of exiting immediately with an appropriate SQLCODE. Other unexpected symptoms may occur as the result of DB2 internally encountering a resource-not-available (or similar) condition and continuing processing. The following statements are also affected by this problem: - ALTER PROCEDURE - ALTER FUNCTION - ALTER TABLE - COMMENT ON - CREATE PROCEDURE - CREATE TABLE - DROP ALIAS - DROP SYNONYM - DROP PROCEDURE - DROP FUNCTION - DROP TABLE - DROP VIEW - RENAME TABLE Note: the listed statements that do not directly reference FUNCTION or PROCEDURE are only affected by the problem if functions or procedures are involved in statement processing.
Problem conclusion
DB2 has been modified to exit immediately with an appropriate SQLCODE if a resource-not-available (or similar) condition is encountered during CREATE FUNCTION processing. Additional Keywords: SQLCREATE SQLFUNCTION SQLTABLEUDF SQLUDF SQLTUDF SQLALIAS SQLALTER SQLCOMMENTON SQLDROP SQLMQT SQLPROCEDURE SQLSP SQLSTOREDPROC SQLSYNONYM SQLVIEW
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PI72719
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-11-22
Closed date
2016-12-19
Last modified date
2017-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI43469 UI43470
Modules/Macros
DSNXISB2
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 February 2017