A fix is available
APAR status
Closed as program error.
Error description
ABEND04E RC00C90101 at DSNGEPDL ERQUAL50FF occurred during REBIND or automatic REBIND of a Native SQL PL package on the fallback release. The abend is the result of an inconsistency between the SYSPACKAGE catalog table and the directory.
Local fix
Drop and recreate the Native SQL PL stored procedure
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 for z/OS users who run an * * application program that calls a native * * stored procedure created on a higher release * * of DB2 for z/OS, which causes the implicit * * regeneration of the native stored procedure. * **************************************************************** * PROBLEM DESCRIPTION: ABEND04E RC00C90101 at DSNGEPDL * * ERQUAL50FF occurred during REBIND or * * automatic REBIND of a native SQL PL * * package on the fallback release. This * * native stored procedure was created on * * a higher release of DB2 and was called * * on the fallback release, which caused * * the implicit regeneration of the native * * stored procedure. The implicit * * regeneration of the procedure failed * * due to some error and the application * * returned SQLCODE904. The subsequent * * REBIND or automatic REBIND of this * * package ABENDed. * * * * This could happen on a data sharing * * system with V10 and V11 coexistence or * * V11 and V12 coexistence. * **************************************************************** * RECOMMENDATION: * **************************************************************** ABEND04E RC00C90101 at DSNGEPDL ERQUAL50FF occurred during REBIND or automatic REBIND of a native SQL PL package on the fallback release. This native stored procedure was created on a higher release of DB2 and was called on the fallback release, which caused the implicit regeneration of the native stored procedure. The implicit regeneration of the procedure failed due to some error and the application returned SQLCODE904. The subsequent REBIND or automatic REBIND of this package ABENDed. This could happen on a data sharing system with V10 and V11 coexistence or V11 and V12 coexistence. The root cause of the problem is the error handling during implicit regeneration of a native stored procedure is incorrect. It deleted the directory record of the package. Additional keywords: ABEND04E RC00C90101 ERQUAL50FF DB2COEXIST/K SQLNATIVESQLPL DB2MIGV11/K DB2MIGV12/K SQLCODE904
Problem conclusion
DB2 has been changed to handle the error of implicit regeneration of native stored procedures correctly.
Temporary fix
Comments
APAR Information
APAR number
PI72712
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-11-22
Closed date
2016-12-16
Last modified date
2017-01-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI43430 UI43431
Modules/Macros
DSNTBSPL
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:
03 January 2017