IBM Support

SI49920 - OSP-DB MSGMCH1202 ERROR CAUSED BY A SQL CURSOR ISSUE

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB MSGMCH1202 ERROR CAUSED BY A SQL CURSOR ISSUE


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770SS1  710  SI48191   00/00    0000
CO   5770SS1  710  SI48194   00/00    0000
CO   5770SS1  710  SI48193   00/00    0000
CO   5770SS1  710  SI48195   00/00    0000
CO   5770SS1  710  SI48196   00/00    0000
CO   5770SS1  710  SI48197   00/00    0000
CO   5770SS1  710  SI48199   00/00    0000
CO   5770SS1  710  SI39899   00/00    0000
CO   5770SS1  710  SI39900   00/00    0000
CO   5770SS1  710  SI39903   00/00    0000
CO   5770SS1  710  SI39069   00/00    0000
DIST 5770SS1  710  SI49717   00/00    0000



NOTICE:
-------
Application of this PTF may disable or render ineffective programs that
use system memory addresses not generated by the IBM translator,
including programs that circumvent control technology designed to limit
interactive capacity to purchased levels.  This PTF may be a prerequisite
for future PTFs.  By applying this PTF you authorize and agree to the
foregoing.

This PTF is subject to the terms of the license agreement which
accompanied, or was contained in, the Program for which you are obtaining
the PTF.  You are not authorized to install or use the PTF except as part
of a Program for which you have a valid Proof of Entitlement.

SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY
AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT
AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED,
INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT,
REGARDING THE PTF.

The applicable license agreement may have been provided to you in printed
form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR)
CL command.





APAR Error Description / Circumvention

-----------------------------------------------
MCH1202 from / to a User Program happened because of a prior
error in a cursor.

CPD4374 / SQL0901 and SQL0302 may be found as well.

CORRECTION FOR APAR SE55465 :
-----------------------------
When a cursor is reused across different activation groups and
the most recent activation group is ended or reclaimed, the
cursor becomes orphaned.  If the Prepared Statement Area (PSA)
is compressed we will mistakenly be attached to a different SQL
statement that resides in the same array slot as the SQL stmt
that last used the cursor.
The activation group cleanup code has been fixed to not allow
the cursor to be orphaned.

CIRCUMVENTION FOR APAR SE55465 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


None.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI49718      OSP-DB-OTHER-T/QSQRUN1/11075-MSGSQL0101 SQL STMT FAILS WITH
   SI48508      OSP-DB INTERNAL MAINTENANCE
   SI48219      OSP-DB-OTHER-T/QSQSBAS2/3706-MSGMCH1210 SELECT STMT IN A QZD
   SI48198      OSP-DB-OTHER-RC480-MSGSQL0904
   SI47301      OSP-DB INTERNAL MAINTENANCE
   SI47132      OSP-DB INTERNAL MAINTENANCE
   SI46277      OSP-DB-OTHER-T/QSQJOBTM-MSGCPF5715
   SI45569      OSP-DB-QSQENDAG-MSGMCH6902 on activation group end
   SI45173      OSP-DB-LOOP QSQXIT PROCEDURE DUMPBADPSA
   SI44788      OSP-DB-OTHER-F/QRWTBAS-T/QRWTBAS-MSGMCH3601 SOME STORED PROC
   SI44466      OSP-DB-OTHER-T/QSQDSCPTX/6103-MSGSQL0904 FETCH NEXT FROM C1
   SI44097      OSP-DB-MSGMCH0601-T/QSQSBAS MODULE QSQCLSCR PROCEDURE SQCLOS
   SI43466      OSP-DB CANCEL QSQSRVR JOBS WHEN AN APPLICATION TERMINATES
   SI43353      OSP-DB-OTHER-T/QRWSQRY-MSGMCH3601
   SI43278      OSP-DB-OTHER-T/QSQROUTEX/27293-MSGMCH6903 COBOL PGM WITH EMB
   SI42879      OSP-DB-UNPRED Internal DRDA Maintenance
   SI42836      OSP-DB-QSQCMPDS High CPU during long running job
   SI42770      OSP-DB-OTHER-F/QSQXIT-MSGMCH3402
   SI42642      OSP-DB-MSGMCH3402 T/QSQXIT during vary on of independent ASP
   SI42274      OSP-DB-OTHER-INCORROUT DUMPS GENERATED FOR DDM CONNECTIONS
   SI42159      OSP-DB-OTHER-F/QSQCLI-T/QSQCLI-MSGMCH3601
   SI41871      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGMCH3601 STORED PROCEDU
   SI41442      OSP-DB-OTHER-T/QSQENDAG-MSGMCH3402
   SI41442      OSP-DB-OTHER-T/QSQROUTE-MSGMCH0601X/23395 AFTER UPGRADING TO
   SI41299      OSP-DB-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
   SI40943      OSP-DB-OTHER-MSGSQL0601 FOR GLOBAL TEMPORARY TABLE AFTER DIS
   SI40943      OSP-DB SQ EXIT PROGRAM FAILED AND ENDED QDBXRVXR2.
   SI40162      OSP-DB-MSGMCH5003 f/QQQVALID/33170 when using XML data in OP
   SI39989      OSP-DB-OTHER-UNPRED 1000 3000 Storage Managment VLOGs
   SI39902      OSP-DB-QSQASLOC-MSGSQL0204 when using specific name on ASSOC
   SI39880      OSP-DB-OTHER-LOOP IN QSQJOBTM
   SI39839      OSP-DB-OTHER-F/QSQROUTE-T/QSQROUTE-MSGMCH3601 SQL COBOL PROG
   SI39379      OSP-DB-OTHER-UNPRED VLOG 10003000 Generated for teraspace QS
   SI36585      OSP-DB-UNPRED Server mode error handling
   SI39064      OSP-DB Internal Maintenance
   SI38863      OSP-DB-OTHER-T/QSQCONN-MSGMCH6903
   SI38781      OSP-DB-OTHER-UNPRED HANDLING OF DEBUG DATA LEAVES JOBS OUTPU
   SI38662      OSP-DB Internal Maintenance
   SI38101      OSP-DB-MSGMCH6903-T/QSQCONN
   SI37160      OSP-DB-UNPRED DRDA packages not unlocked when connection end
   SI36726      OSP-DB-OTHER-T/QSQXIT-MSGMCH3402 WHEN QSQSRVR JOB RECYCLES
   SI38107      OSP-DB-OTHER XML PROCESSING
   SI37406      OSP-DB-MSGSQL7049 when running with result sets
   SI37064      OSP-DB-OTHER-PERFM when called program with activation group

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE55465
Superseded by:......................View fix details for PTF SI64267
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C3298710


System i Support

IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1 environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 May 2013