APAR status
Closed as fixed if next.
Error description
There is no serialization mechanism between Alter Procedure REGENERATE (DDL) and CALL stored procedure and that results in SQLCODE805 This ApAR is opened to document problem, which development is going to fix in future release.
Local fix
-STOP PROCEDURE xxx ACTION (REJECT) ..... ALTER PROCEDURE xxx REGENERATE ... -START PROCEDURE xxx ......
Problem summary
**************************************************************** * USERS AFFECTED: DB2 users of native SQL procedures and * * ALTER PROCEDURE REGENERATE. * **************************************************************** * PROBLEM DESCRIPTION: SQLCODE -805 may be returned for * * the CALL :HV statement for native * * SQL procedures if ALTER * * PROCEDURE REGENERATE is executed * * at the same time. * **************************************************************** * RECOMMENDATION: * **************************************************************** This is a timing issue. When DB2 processes the CALL statement, it retrieves the routine info from either the catalog table or a cache table. In the meantime, ALTER PROCEDURE REGENERATE executes and changes the routine info in the catalog table. So the routine info DB2 just retrieved and saved is out-of-date. When the stored procedure package is executing, the contoken DB2 saved for the routine doesn't match the one in the catalog and DB2 issues SQLCODE -805. A serialization machanism is needed between ALTER PROCEDURE REGENERATE and CALL stored procedure to eliminate the timing window.
Problem conclusion
Temporary fix
Comments
The fix for this problem is too risky to deliver in an APAR. It will be fixed in a future release. Additional Keywords: SQLNATIVESQLPL, SQLALTER, SQLCODE805
APAR Information
APAR number
PI15274
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-04-04
Closed date
2014-04-29
Last modified date
2014-04-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
RA10 PSN
UP
[{"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:
29 April 2014