PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER-T/QSQISE-MSGMCH3402
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
CO 5770SS1 V7R2M0 SI68098 00/00 0000
CO 5770SS1 V7R2M0 SI68102 00/00 0000
CO 5770SS1 V7R2M0 SI67788 00/00 0000
CO 5770SS1 V7R2M0 SI66887 00/00 0000
CO 5770SS1 V7R2M0 SI63434 00/00 0000
CO 5770SS1 V7R2M0 SI63436 00/00 0000
CO 5770SS1 V7R2M0 SI57930 00/00 0000
CO 5770SS1 V7R2M0 SI55644 00/00 0000
CO 5770SS1 V7R2M0 SI55643 00/00 0000
CO 5770SS1 V7R2M0 SI56023 00/00 0000
CO 5770SS1 V7R2M0 SI53866 00/00 0000
DIST 5770SS1 V7R2M0 SI64147 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
-----------------------------------------------
In some cases QSQOPEN can call its self recursively. Not all
values from
first call are being restored correctly when control returns to
that
level of code.
CORRECTION FOR APAR SE70288 :
-----------------------------
The environment for QSQOPEN is being correctly saved and
restored when
QSQOPEN is called recursively.
CIRCUMVENTION FOR APAR SE70288 :
--------------------------------
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
-------------- ------------------------------------------------------------
SI68681 OSP-DB-QSQVALUE-INCORROUT Dynamic Values Into with indicator
SI68529 OSP-DB-OTHER-RC4-MSGSQL0452 WHEN SQLTYPE CLOB_FILE OR XML_CL
SI68118 OSP-DB-OTHER-INCORROUT INCORROUT FOR FUNCTIONS USING: IN_DAT
SI68101 OSP-DB-MSGSQL0423 FETCHING CLOB DATA
SI68101 OSP-DB Internal Maintenance
SI68068 OSP-DB-OTHER-F/QSQXCUTEX/32508-T/SAME-MSGSQL0904 INSERT RECO
SI67787 OSP-DB-OTHER-RC1-MSGCPF503E GET_BLOB_FROM_FILE FAILS WHEN FI
SI67787 OSP-DB-OTHER-INCORROUT LOB FILE REFERENCE VARIABLE SQLTYPE(B
SI67386 OSP-DB-MSGCPF3E33-F/QRWSARDB SQL RELEASE ALL
SI67106 OSP-DB-OTHER-MSGSQL0443 INCORROUT-MESSAGE TEXT CORRUPTED
SI66888 OSP-DB Temp Storage growth with CLOBs in UDTF
SI66560 OSP-DB Internal Maintenance
SI66534 OSP-MSGSQL0076 OSP-MSGSQL0076 - CSSID GRAPHIC CONVERSION ISS
SI66157 OSP-DB-OTHER-F/QDBSIGEX-T/QC2IO-RC17-MSGCPF5035 STRQMPRC FAI
SI66135 OSP-DB GRANT STATEMENT WILL FAIL WITH THE SQL0570 WHEN RUN U
SI65947 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0514 A MSGSQL0514 MAY
SI65698 OSP-DB-MSGSQL0303 Blanks are not truncated on a RETURN state
SI65628 OSP-DB-OTHER-RC6-MSGSQL0752 SET TRANSACTION LEVEL NO COMMIT
SI65506 OSP-DB INTERNAL MAINTENANCE
SI65468 OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGMCH3601 FETCH FROM RESUL
SI65449 OSP-F/QSQROUTE-T/QSQROUTE-MSGMCH3601 MSGMCH3601 T/QSQROUTE P
SI65449 OSP-DB-PERFM Improve performance of OPEN statements in stati
SI65273 OSP-DB-OTHER-F/QCNSMCTL-T/QRWSQRY-MSGCPF916A CPF916A EXTRACT
SI64954 OSP-DB-OTHER-F/QSQDSCPT-RC14-MSGSQL0904 OCCURS AT DEALLOCATE
SI64525 OSP-DB-OTHER-PERFM OSP-DB-OTHER-PERFM
SI64148 OSP-UNPRED ENDDBMON OF DBMON WITH PARM HOSTVAR(*CONDENSED) L
SI63897 OSP-UNPRED SAVEPOINTS FOR INSERT STATEMENT NOT SET VIA DRDA
SI63676 OSP-DB-OTHER-F/QQQVSEL-MSGCPD4324
SI63641 OSP-DB INTERNAL MAINTENANCE
SI63296 F/QSQRUN2-MSGSQL0326 SQL RPG PROGRAM FAILS WITH SQL0326. SEL
SI63433 OSP-DB-OTHER-F/QSQCONN-MSGSQL0751 USING 3 PART NAME FROM A T
SI63375 OSP-DB SQLSTATE 01004 not returned from table function when
SI63310 OSP-DB-OTHER-F/QDBIOERRQO-T/QSQRUN2-MSGCPF5173 CPF5173 F/QDB
SI63247 OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGMCH3601 MCH3601 MCH1210
SI63136 OSP-DB-OTHER-MSGSQL0204 USING UNQUALIFIED TABLE REFERENCE
SI63098 OSP-DB-OTHER-T/QSQRUN3-MSGSQL0901 AFTER 0200 1720 VLOG
SI62940 OSP-DB-OTHER-MSGSQL0326 SQL0326 GENERATING SQLSTATE 01557
SI62230 OSP-DB-MSGSQL0900 with embedded SQL after SETASPGRP
SI62108 OSP ALTER TABLE STATEMENT NOT LOGGED BY DBMON
SI61411 OSP-DB INFRASTRUCTURE
SI61303 OSP-DB-MSGSQL0331 Assignment to input parameter on routine w
SI61162 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH3601 JOB THAT USE TO
SI60968 OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGMCH1210 ERROR MESSAGE
SI60956 OSP-DB-MSGCPF5173 QUERY WITH OFFSET AND LIMIT CLAUSES
SI60870 OSP-DB-QSQCALLSP-MSGMCH3601 when using SQL descriptor with S
SI60596 OSP - DB SQFCRT and SQFOVR with XML CLOB File Result in Impr
SI60555 OSP-F/QSQRUN3-T/QSQRUN3-MSGSQL0180 SQL INSERT FAILS WITH MSG
SI60380 SP/QSQDSCPT-MSGSQL0076-RC9332-MOD/QSQGETDS MSGSQL0076
SI60313 OSP-DB FETCH FIRST with OFFSET returns next row
SI60208 OSP-DB-OTHER-F/QSQRUN2-MSGSQL0303 Assigning from CHAR to DAT
SI60153 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0910 FAST DELETE COMM
SI59892 OSP-DB-MSGSQL0900 IMPLICITLY CONNECT RESET FOR SQL DRDA CNN
SI59849 OSP-DB-OTHER-F/QSQSBAS2X/2815-T/SAME-MSGMCH1210 CPYF RSULTS
SI59849 OSP-DB-QQQOOOSETS-MSGMCH5003 using CURRENT DECFLOAT ROUNDING
SI59805 OSP-DB OFFSET > 4GIG Return SQ20539
SI59525 OSP-DB-OTHER-MSGSQL0843 TRYING TO RELEASE A CONNECTION USING
SI59206 OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
SI59113 OSP-DB-OTHER CREATE COLLECTION DOESN'T SHOW UP ANYMORE IN TH
SI58947 OSP-DB-SQL Support optionally setting indicator on truncatio
SI58673 OSP-DB Error using SQL file reference variable
SI58335 SP/QSQDSCPT-MSGSQL0076-RC9332-MOD/QSQGETDS MSGSQL0076
SI58079 OSP-DB Internal Maintenance
SI57931 OSP-DB-OTHER-SAP400-THREADS-RC1-MSGCPF503E SQL SELECT ON UDF
SI57906 OSP-DB-OTHER-MSGSQL0501 IN QRWTSRVR JOB
SI57508 OSP-DB-OTHER-LOOP QSQROUTE PROCEDURE SETRES
SI57498 OSP-DB-OTHER-F/QSQVALUE-T/QSQVALUE-MSGMCH3601 JOB GETS MCH36
SI57114 OSP-DB-OTHER-F/QDBIOERRQO-T/QDBIOERRQO-RC1-MSGCPF503E ON INS
SI57079 OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON
SI56981 OSP-DB Remove DRDA result set open capture in database monit
SI56836 OSP-DB-OTHER-T/QSQRUN2-MSGCPF5257 SERVICEABILITY CHANGE
SI56832 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
SI56392 OSP-DB-OTHER-T/QSQRUN2-MSGSQL0501 MODULE QSQFETCH
SI56252 OSP-DB INTERNAL MAINTENANCE
SI56219 OSP-DB-OTHER-LOOP JOB LOOPS AND CONSUMES HIGH CPU ON SET RES
SI56217 OSP-DB-MSGMCH3601-F/QSQVALUE SQL SET OF LARGE GV TO STRING C
SI56188 OSP-DB-OTHER-INCORROUT RETURNGLOBALVARIABLE VALUES ARE DIFFE
SI56072 OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QSQRUN2-MSGMCH0601 A QUERY
SI55884 OSP-DB-OTHER-WAIT SQL QUERY OVER A VIEW HANGS
SI55799 OSP-DB DRDA SERVER IMPLICIT COMMIT AFTER IMPLICIT QUERY CLOS
SI55641 OSP-DB DNS LOOKUP DELAY FOR SQL CONNECT
SI55608 OSP-MSGSQL0303 SQL FUNCTION W/SUBSELECT ASSIGNS BLANKS VIA C
SI55421 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH1210 A MSGMCH1210 MAY
SI55318 OSP-DB INTERNAL MAINTENANCE
SI55272 OSP-DB-OTHER-T/QSQSBAS-MSGMCH1210 MODULE QSQVATTR PROCEDURE
SI55254 OSP-DB-OTHER-INCORROUT DESCRIBE USING DESCRIPTOR STATEMENT -
SI55168 OSP-DB-OTHER-RC2-MSGSQL7049
SI55114 OSP-DB-OTHER-UNPRED QSQSVCDMP SPOOLED FILE CREATED
SI54785 OSP-DB-MSGSQL0901 OPEN USING passing a lob global variable
SI54695 OSP-DB Internal Maintenance
SI54584 OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3601
SI54498 OSP-DB-OTHER-T/QSQSBAS2-MSGMCH1210 MODULE QSQEXPEVAL
SI54463 OSP-DB Internal Maintenance
SI54405 OSP-DB Internal Maintenance
SI54309 OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3601
SI54273 OSP-DB-OTHER-INCORROUT STRDBMON QQI6 VALUE IS TOO LARGE
SI54124 OSP-DB DISPLAY LONG FIELD NAMES FOR SOME SQ MESSAGES
SI54040 OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
SI53993 OSP-DB-OTHER-RC540-MSGSQL0904 A MSGSQL0904 RESOURCE LIMIT TY
SI53864 OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QSQROUTX-MSGMCH0601 MCH3601
SI53659 OSP-DB-OTHER-F/QSQRUND-T/QSQRUN2-MSGSQL0901 MCH1210 F/QSQRUN
SI53527 OSP-DB-OTHER-UNPRED SERVICEABILITY CHANGE
SI53346 OSP-DB-OTHER-UNPRED SERVICEABILITY CHANGE
SI53269 OSP-DB-MSGCPF2471-F/QSQROUTE-MSGMCH1210-F/QSQFETCH UNINIT CU
SI53224 OSP-DB-OTHER-F/QSQROUTQ-T/QSQROUTQ-MSGMCH1210 A MSGMCH1210 M
SI53224 OSP-DB-OTHER-UNPRED SERVICEABILITY CHANGE TO DIAGNOSE MSGMCH
SI53069 OSP-DB-OTHER-UNPRED SERVICEABILITY CHANGE
SI52975 OSP-DB-MSGSQL0517-F/QSQRUN3 PREPARE/EXEC STMT FAILURE USING
SI52747 OSP-MSGSQL0904 JDBC APPLICATION USING BATCH UPDATES IS LEAKI
SI52616 OSP-DB-MSGSQL7971-F/QSQCONN CLT SPC REG INIT WSQG_DB2_MODULE
SI52542 OSP-PERFM 1GB TERASPACE FILE EXTENDS CAUSING DRIVES TO BE BU
SI52517 OSP-DB Internal Maintenance
SI52460 OSP-DB INTERNAL MAINTENANCE
SI52338 OSP-DB-OTHER-MSGSQL0443 SERVICEABILITY ENHANCEMENT
SI52338 OSP-DB-OTHER-T/QSQROUTX-MSGMCH0602
SI52273 OSP-DB INTERNAL MAINTENANCE
SI52011 OSP-DB Internal Maintenance
SI52011 OSP-DB-OTHER-T/QQQQEXIT-MSGMCH0601
SI51926 OSP-DB INTERNAL MAINTENANCE
SI51821 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
SI51686 OSP-DB Internal Maintenance
SI51686 OSP-DB-OTHER-T/QSQMSGAR-MSGCPF2499
SI51624 OSP-DB-MSGSQL0901-F/QSQGTSPC using LOBs in sql procedure
SI51580 OSP-DB Internal Maintenance
SI51464 OSP-DB Internal Maintenance
SI51448 OSP-DB-MSGSQL0901-F/QSQGTSPC using LOBs in sql procedure
SI51394 OSP-DB MCH1210 F/T: QSQSTATS/QSQSTATS
SI51363 OSP-DB-OTHER-F/QSQRUN2-MSGSQL0332 when numeric column follow
SI51363 OSP-DB-OTHER-INCORROUT SET TRANSACTION ISOLATION from Run SQ
SI51286 OSP-DB Internal Maintenance
SI51286 OSP-DB-OTHER-INCORROUT Routine parameter default truncates w
SI51286 OSP-DB-OTHER-F/QSQCONN-T/QSQCONN-MSGSQL7022 MSGSQL7022 F/QSQ
SI51239 OSP-DB multiple errors
SI51239 OSP-DB INTERNAL MAINTENANCE
SI51239 OSP-DB Independent ASP and SRCPF support for selected SQL bu
SI51239 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0301 INSERT FAILS WIT
Summary Information
System.............................. i
Models..............................
Release............................. V7R2M0
Licensed Program.................... 5770SS1
APAR Fixed.......................... View details for APAR SE70288
Superseded by:...................... View fix details for PTF SI85797
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C9297720
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