PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
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 |
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.
Was this topic helpful?
Document Information
Modified date:
01 May 2013