PM67288: CUSTOMER IS GETTING SQL ERROR CODE -518 ON SQL ROLLBACK STATEMENT.

Obtain the fix for this APAR.

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 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.