PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-MSGMCH3402 SET RESULT SETS WITH RETURN TO CLIENT
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
CO 5770SS1 V7R3M0 SI67304 00/00 0000
CO 5770SS1 V7R3M0 SI67231 00/00 0000
CO 5770SS1 V7R3M0 SI61632 00/00 0000
DIST 5770SS1 V7R3M0 SI68297 00/00 0000
DIST 5770SS1 V7R3M0 SI68298 00/00 0000
DIST 5770SS1 V7R3M0 SI67948 00/00 0000
DIST 5770SS1 V7R3M0 SI63625 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
-----------------------------------------------
Following error is seen intermittently..
MCH3402 Escape 40 01/06/19 10:41:04.523189 QSQRUN4 QSYS *STMT
QSQRUN4 QSYS *STMT
From user . . . . . . . . . : SESSWEB
From module . . . . . . . . : QSQCALLSP
From procedure . . . . . . : CLEANUP
Statement . . . . . . . . . : 43386
To module . . . . . . . . . : QSQCALLSP
To procedure . . . . . . . : CLEANUP
Statement . . . . . . . . . : 43386
Thread . . . . : 00000015
Message . . . . : Tried to refer to all or part of an object
that no longer
exists.
Cause . . . . . : The most common cause is that a stored address
to an
object is no longer correct because that object was deleted or
part of the
object was deleted.
CORRECTION FOR APAR SE70501 :
-----------------------------
In some rare scenario, an internal pointer was stale which
caused the MSGMCH3402 exception. This problem has been fixed.
CIRCUMVENTION FOR APAR SE70501 :
--------------------------------
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
-------------- ------------------------------------------------------------
SI68946 OSP-F/QDBSIGEX-T/QSQPROCR-RC14-MSGCPF5035 MSGCPF5035 F/QDBSI
SI68935 OSP-DB-OTHER-F/QSQPROCR-T/QSQPROCR-MSGMCH1210 07931,821,821
SI68687 OSP-DB-OTHER-INCORROUT VALUE OF DETERMINISTIC IN QSYS2/SYSRO
SI68680 F/QSQTRG-MSGSQL0104 F/QSQTRG-MSGSQL0104
SI68680 OSP-DB-QSQCALLSP-MSGSQL7049 - produce QSQSVCDMP
SI68586 OSP-DB-OTHER-INCORROUT INCORROUT ON GUI RETRIEVE SQL SOURCE
SI68517 OSP-DB-OTHER-INCORROUT WRONG RUSSIAN CHARACTERS AFTER AN SQL
SI68296 OSP-DB-OTHER-THREADS-F/QSQRUN1-T/QSQRUN1-MSGSQL0204 MSGSQL02
SI68149 OSP-DB-MSGMCH5003-T/QSQCALLEXP calling procedure
SI68108 OSP-INCORROUT STORED PROCEDURE NAME IS APPENDED WITH X'10' W
SI68070 OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGMCH1210 MSGMCH1210 F/QSQ
SI68054 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0104 MSGSQL0104 F/QSQ
SI67949 OSP-DB-OTHER-F/STRINGHIGHUSE-T/QSQRUN4-MSGMCH3601 MSGMCH3601
SI67920 OSP-DB-OTHER-INCORROUT GENERATE_SQL MAY NOT RETURN SYSTEM NA
SI67849 OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGSQL0204 A MSGSQL0204 MAY
SI67796 OSP-DB INFRASTRUCTURE
SI67738 OSP-DB CATALOG SYSROUTINES/SYSPARMS/SYSROUTDEP FIX
SI67614 OSP QSQGNDDL GENERATES UNQUALIFIED FUNCTION WITHOUT QUOTES
SI67581 OSP-DB SYSROUTINEDEP schema name for unqualified function is
SI67447 OSP-DB-OTHER SYSIBM/USERS WAS LOCKED BY QDBSRVXR2 AFTER PTF
SI67439 OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGSQL0443 ATTEMPTING TO GE
SI67374 OSP-DB-OTHER-INCORROUT GENERATE SQL FROM EXISTING PROCEDURE
SI67350 OSP-DB-OTHER-F/QSQPMAIN-T/QSQPMAIN-MSGCPF3BCC IS RECEIVED WH
SI67305 OSP-DB INFRASTRUCTURE
SI67283 OSP-MSGCPD4311 SOME SYSTEM STORED PROCEDURES WILL FAIL IN ST
SI67233 OSP-DB INFRASTRUCTURE
SI67111 OSP-DB GENERATE SQL IS GENERATING INCORRECT SQL FOR STORED P
SI67008 SQL-CMPL-CURR-UNPRED WHEN OLD VERSION TRIGGER PROGRAMS HAVE
SI66953 OSP-DB-QSQPREP-MSGSQL0303 when using timestamp global variab
SI66948 OSP-DB GENERATE_SQL and SET OPTION DFTRDBCOL = *NONE
SI66518 OSP-DB Internal Maintenance
SI66170 OSP-DB-OTHER-UNPRED MERGER STATEMENT WITH AN UPDATE OPERATIO
SI66155 OSP-DB-OTHER-F/#CCCLAP-T/QSQRUN4-MSGMCH0601 JOB USING CCSID
SI65911 OSP-DB Generate SQL for default permissions not correct
SI65850 OSP-DB-OTHER-F/QZDGDBGS-T/QSQRUN4-MSGSQL0204 INAV GENERATE S
SI65791 OSP-DB INTERNAL MAINTENANCE
SI65669 OSP-DB-OTHER-F/QZDGDBGS-T/QSQRUN4-MSGMCH0601 GENERATE SQL FA
SI65454 OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGMCH1210 MSGMCH1210 F/QSQ
SI65436 OSP-DB-OTHER-INCORROUT ACS GENERATE SQL GENERATES INCORRECT
SI65346 OSP-DB-Internal Maintenance
SI65223 OSP-DB-OTHER-INCORROUT TRUNCATE STATEMENT NOT CLEARING RECOR
SI60162 OSP-DB-OTHER-INCORROUT MERGE SHOULD INSERT 2 RECORDS, ONLY 1
SI60162 OSP-DB-OTHER-UNPRED EXTERNAL PROCEDURE CANNOT BE RESTORED
SI65141 OSP-DB-OTHER-F/QSYRVAUT-T/QSQPROC-MSGCPF2236 WHEN JAVA UDF S
SI65044 OSP-DB DATETIME PRECISION SET TO MAX INSTEAD OF ACTUAL AFTER
SI64639 OSP-DB Generate_SQL does not generate KEEP IN MEMORY YES
SI63809 OSP-DB INTERNAL MAINTENANCE
SI63648 OSP-DB INTERNAL MAINTENANCE
SI63624 OSP-DB Improve Index Advisor storage management
SI63488 OSP-DB-OTHER-F/QSQCONN-MSGSQL0751 USING 3 PART NAME FROM A T
SI63439 OSP-DB INTERNAL MAINTENANCE
SI62937 OSP-DB-INCORROUT RUNSQLSTM TARGET RELEASE INCORRECT
SI62725 OSP-DB INTERNAL MAINTENANCE
SI62504 OSP-F/QQQSRVI1-T/QQQSVRTN-MSGCPF9898 SAVE AND RESTORE OF RPG
SI59987 OSP-DB Add PROCESS_ID and THREAD_ID global variables
SI62624 OSP-DB-QSQCALLSP-MSGSQ20440 using SQL arrays
SI62283 OSP-DB INTERNAL MAINTENANCE
SI62226 OSP-DB-MSGSQL0206 Setting Global Variable to Default Value A
SI62129 OSP-DB-OTHER-F/QSQRUN4MOD/QSQCALLEXPPROC/SQL_EXPINCALL- MSGM
SI62104 OSP-DB Associate locator statement fails with variable
SI61969 OSP-DB RESTORE CURRENT TEMPORAL REGISTER AFTER PROC CALL
SI61634 OSP-DB INTERNAL MAINTENANCE
SI61417 OSP-DB INFRASTRUCTURE
SI61281 OSP-DB-OTHER-INCORROUT WRONG RUSSIAN CHARACTERS AFTER AN SQL
SI61186 OSP-DB-F/QSQPROC-MSGSQL0901 Running ALTER ROUTINE from RUNSQ
SI61107 OSP-DB Internal Maintenance
SI60535 OSP-DB-OTHER-UNPRED EXTERNAL PROCEDURE CANNOT BE RESTORED
SI60467 OSP-DB-MSGMCH3601 External Procedure Call with Basic Default
SI60357 OSP-DB-F/QSQROUTS-MSGSQ20226 Looping on SQ20226 when running
SI60287 OSP-DB-QSQCALLSP-MSGMCH3601 when using SQL descriptor with S
SI60318 OSP-DB THREAD_ID same for entire job
SI60143 OSP-DB-OTHER-PERFM QDBSRVxx JOBS SLOWED BY NATIVE OPENS
SI60063 OSP-DB-OTHER-MSGSQL0723 TRIGGER FIRE SQL0723 THE VALUE OF PA
SI60049 OSP-DB Embedded Create trigger uses program target release
SI60026 OSP-DB-OTHER-PERFM QDBSRVxx JOBS SLOWED BY NATIVE OPENS
SI59503 OSP-DB INFRASTRUCTURE
SI59487 OSP-DB incorrect output with truncate table
SI59396 OSP-DB Add PROCESS_ID and THREAD_ID global variables
SI59396 OSP-DB Internal Maintenance
SI59338 OSP-DB Describe Parameter Marker incorrect for CALL with nam
SI59338 OSP-MSGSQL0204 ASSOCIATE LOCATOR STATEMENT FAILS WITH MSGSQL
SI59109 OSP-DB Internal Maintenance
SI59068 OSP-DB INTERNAL MAINTENANCE
SI59029 OSP-DB-QSQCALLSP-MSGMCH3601 Calling stored procedure using d
SI58993 OSP-DB-SQL Support optionally clearing SQLSTATE on truncatio
SI58946 OSP-DB Internal Maintenance
SI58899 OSP-DB Internal Maintenance
SI58869 OSP-DB INFRASTRUCTURE
SI58869 OSP-DB Internal Maintenance
SI58507 OSP-DB INTERNAL MAINTENANCE
SI58507 OSP-DB Embedded Create trigger uses program target release
SI58507 OSP-DB Internal Maintenance
SI58507 OSP-DB-MSGSQL0482 not returned on remote procedure
Summary Information
System.............................. i
Models..............................
Release............................. V7R3M0
Licensed Program.................... 5770SS1
APAR Fixed.......................... View details for APAR SE70501
Superseded by:...................... View fix details for PTF SI85800
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C9311730
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, 2018, 2019, 2020, 2021, 2022, 2023, 2024 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:
13 March 2024