A fix is available
APAR status
Closed as program error.
Error description
Per PMR 58833,200,838 ================================================================ Customer is getting SQL error code -518 on SQL ROLLBACK statement. The following information is seen: FSYSQLIO: FAILED REQUEST -> ROLLBACK DSNT408I SQLCODE = -518, ERROR: THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED STATEMENT DSNT418I SQLSTATE = 07003 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXERT2 SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -280 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFEE8' X'00000000' X'00000000' X'FFFFFFFF' X'0000 INFORMATION FAILED REQUEST FROM APPLICATION PROGRAM --------------------------------------- SQL/DB2 FUNCTION: --> ROLLBACK CALL IDENTIFIERᆬ: --> Q1003 USER CURSOR NAME: --> DYNAMSQL-NCRS1 DYNAM I/O CURSOR: --> <NONE> REQUESTOR'S STRING IN ERROR -------------------------------- ROLLBACK ================================================================ ================================================================ ROLLBACK PREPARE fix for recursive use. Date reported: 06/19/2012 Prerequisite: V3R2M0 PTF UK77803 Severity: High Users Affected: All IMU users of MU V3.2 Problem Description: Customer is getting SQL error code -518 on SQL ROLLBACK statement. Problem Summation Code -518 indicates that PREPARE string is not available. IMU builds a PREPARE for each ROLLBACK one time only. However, PREPARE is released by DB2 whenever SQL CLOSE is processed. Any ROLLBACK issued after the SQL CLOSE no longer has access to the original PREPARE because it is released by the SQL CLOSE. Problem Conclusion: The PREPARE routine for the ROLLBACK was changed to build PREPARE before every ROLLBACK. =============================================================
Local fix
none available
Problem summary
**************************************************************** * USERS AFFECTED: All IMU V3.2 Users * **************************************************************** * PROBLEM DESCRIPTION: Getting SQL error code -518 on * * SQL ROLLBACK statement. * **************************************************************** * RECOMMENDATION: Apply PTF. * **************************************************************** Code -518 indicates that PREPARE string is not available. IMU builds a PREPARE for each ROLLBACK one time only. However, PREPARE is released by DB2 whenever SQL CLOSE is processed. Any ROLLBACK issued after the SQL CLOSE no longer has access to the original PREPARE because it is released by the SQL CLOSE.
Problem conclusion
The PREPARE routine for the ROLLBACK was changed to build PREPARE before every ROLLBACK.
Temporary fix
Comments
APAR Information
APAR number
PM67288
Reported component name
MIGRATION UTILI
Reported component ID
5697N4400
Reported release
320
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-06-20
Closed date
2012-08-14
Last modified date
2012-09-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK81073
Modules/Macros
FSYDMSQL
Fix information
Fixed component name
MIGRATION UTILI
Fixed component ID
5697N4400
Applicable component levels
R320 PSY UK81073
UP12/08/16 P F208
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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSY4B9","label":"IBM Migration Utility for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"320","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
27 October 2020