PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-PERFM-Improvement in extended dynamic prepares with l
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
PRE 5770SS1 V7R3M0 SI65954 00/00 0000
PRE 5770SS1 V7R3M0 SI62828 00/00 0000
CO 5770SS1 V7R3M0 SI65937 00/00 0000
CO 5770SS1 V7R3M0 SI65936 00/00 0000
CO 5770SS1 V7R3M0 SI65762 00/00 0000
CO 5770SS1 V7R3M0 SI65760 00/00 0000
CO 5770SS1 V7R3M0 SI60067 00/00 0000
CO 5770SS1 V7R3M0 SI60069 00/00 0000
CO 5770SS1 V7R3M0 SI60071 00/00 0000
CO 5770SS1 V7R3M0 SI60070 00/00 0000
DIST 5770SS1 V7R3M0 SI66170 00/00 0000
DIST 5770SS1 V7R3M0 SI65455 00/00 0000
DIST 5770SS1 V7R3M0 SI60515 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
-----------------------------------------------
As extended dynamic packages get larger, PREPARE statements take
longer to complete.
CORRECTION FOR APAR SE68689 :
-----------------------------
Extended dynamic PREPARE statements will be faster with this
PTF. The larger the package, the more noticeable the difference
will be.
CIRCUMVENTION FOR APAR SE68689 :
--------------------------------
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
-------------- ------------------------------------------------------------
SI66614 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0509 WHEN STORED PROC
SI66582 OSP-DB-MSGMCH3603 with multiple nesting of triggers
SI66575 OSP-DB-OTHER INSERTS OF BLOB FIELDS TO IBM I DATABASE FROM A
SI66567 OSP SQL INSERT WRITING INTO THE WRONG MEMBER IN APPLICATION
SI66563 OSP-MSGSQL0138-D/TQSQRUN3-PAR WHEN CALLING A STORED PROCEDUR
SI66535 OSP-DB FETCH N ROWS clause with PREPARE ATTRIBUTE
SI66515 OSP-DB-OTHER-F/QSQRUN1X/19980-T/T/SAME-MSGMCH3601 BANKING AP
SI66508 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0519 PREPARE LOCK PAC
SI66508 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGMCH3601 SQL0901 MCH3601
SI66482 OSP-DB-MSGSQL0171 with insert statement
SI66388 OSP-MSGMCH3601-PAR-940XBASE RPG SQL APPLICATION RETURNS MCH3
SI66176 F/QSQRUN1-MSGSQL0904-RC160-MOD/QSQDESC F/QSQRUN1-MSGSQL0904-
SI66172 OSP-DB-OTHER-UNPRED MERGER STATEMENT WITH AN UPDATE OPERATIO
SI66156 OSP-F/QSQRUN3-T/QSQRUN3-MSGMCH3601 MSGMCH3601 F/T/QSQRUN3
SI66067 F/#CFOCHKR-MSGMCH3603 MSGMCH3603 MCH3603 F/#CFOCHKR X/000C2C
SI66002 OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4301 CPD4301 SQL0901
SI65995 OSP-DB-OTHER-T/QQQSRVE1-MSGMSGMCH3601 STORED PROCEDURE CALLS
SI65938 OSP-DB-OTHER-UNPRED DUPLICATE STATEMENT NAMES IN SQLPKG
SI65932 OSP-F/QSQRUN1-T/QSQRUN1-RC167-MSGSQL0904 SQL0904 WITH TYPE 7
SI65873 OSP-DB FETCH N ROWS clause with PREPARE ATTRIBUTE
SI65856 OSP-DB INTERNAL MAINTENANCE
SI65765 OSP-DB INTERNAL MAINTENANCE
SI65577 OSP-DB Internal Maintenance
SI65517 OSP-F/QSQROUTS-T/QSQROUTS-MSGSQL0518 REUSE OF SELECT FROM IN
SI65456 F/QSQRUN2-MSGSQL0326 SQL RPG PROGRAM FAILS WITH SQL0326. SEL
SI65406 OSP-DB INTERNAL MAINTENANCE
SI65397 OSP SEVERAL QSQSVCDMP DUMPS FROM QZDASOINIT JOBS.
SI65397 OSP-OTHER-UNPRED CURSOR IS BEING HARD CLOSED DUE TO INTERNAL
SI65326 OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0913 SELECT FOR FET
SI65120 F/QQQSRVE1-MSGMCH1210-MOD/QQQOOOSETS F/QQQSRVE1-MSGMCH1210-M
SI64993 OSP-DB-OTHER-F/QDBDLTFI-MSGMCH3406 for *SQDT00002
SI64993 OSP-DB-OTHER-INCORROUT STORED PROCEDURE WITH IDENTITY_VAL_LO
SI64953 OSP-DB-OTHER-F/#COMOOBJ-T/QTNOPNCLS-MSGMCH6221 VLF000702
SI64912 OSP-DB-MSGSQL0206 with GVAR in remote drda job
SI64749 OSP-DB-OTHER-MSGMCH3601-T/QSQPREP PROCEDURE CLEANUP
SI64734 OSP-DB-PERFM Improve performance of OPEN statements in stati
SI64722 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0913 CODE ADDED TO AI
SI64510 OSP-MSGCPD4306-D/TQSQOPEN-PAR DECLARE CURSOR STATEMENT IN EM
SI64510 OSP-DB-OTHER-INCORROUT INTERMITTENT PROBLEM INCORROUT OUTPUT
SI64223 OSP-DB-MSGMCH0601-F/QSQSTATS CREATE TABLE AS statement WITH
SI64196 OSP-DB INTERNAL MAINTENANCE
SI64150 OSP-UNPRED ENDDBMON OF DBMON WITH PARM HOSTVAR(*CONDENSED) L
SI63992 OSP-DB-OTHER-PERFM OSP-DB-OTHER-PERFM
SI63972 OSP-DB-OTHER-T/QSQSBAS2-MSGMCH1210 MODULE QSQSFCRT
SI63863 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0904 SQL JOB FAILS WI
SI63786 OSP-DB-OTHER-PERFM POOR ESTIMATE FOR UDTFS USED BY OBJECT_ST
SI63509 OSP-DB INTERNAL MAINTENANCE
SI63487 OSP-DB-OTHER-F/QSQCONN-MSGSQL0751 USING 3 PART NAME FROM A T
SI63382 OSP-DB-OTHER-UNPRED EMBEDDED SQL STATEMENTS IN RPGLE PROGRAM
SI63382 OSP-DB-OTHER-F/QSQLOPEN-MSGMCH3601 WHEN ANOTHER PROGRAM WAS
SI63288 OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGMCH3601 MCH3601 MCH1210
SI63253 OSP-DB-OTHER MSGMCH0601 F/< INGHIGHUSE X/000118 T/QSQRUN3
SI63215 OSP-DB-OTHER-UNPRED INFORMATIONAL QSQSVCDMP SPOOL FILES ARE
SI63093 OSP-DB restore special registers after triggers
SI63067 OSP-DB Internal Maintenance
SI63059 OSP-DB-OTHER-T/QSQRUN3-MSGMCH3601 MODULE QSQOPEN PROCEDURE D
SI62896 OSP-DB-MSGCPF3272 long running cli job
SI62771 OSP-DB-OTHER-T/QSQSBAS2-MSGMCH5804 SQL0901 LOCK SQL PACKAGE
SI62261 OSP-DB-OTHER-THREADS-PERFM SPACE LOCATION LOCKS ARE NOT BEIN
SI62133 OSP-DB Internal Maintenance
SI62128 OSP-DB-OTHER-INCORROUT FRENCH CHARATER ' ' ('C0'X) IS DISPLA
SI62117 OSP-DB-OTHER-INCORROUT DBMON WORK WITH SQL STATEMENT AND VAR
SI62115 F/QRWSQRY-MSGCPD3E06 F/QRWSQRY-MSGCPD3E06
SI62114 OSP-DB Incorrect diagnostics from stored procedure
SI61904 OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
SI61629 OSP-DB INFRASTRUCTURE
SI61414 OSP-DB INFRASTRUCTURE
SI61305 OSP-F/QSQRUN3-T/QSQRUN3-MSGSQL0180 SQL INSERT FAILS WITH MSG
SI61071 OSP-DB INFRASTRUCTURE
SI61069 OSP-DB-OTHER-F/EX3E06COMMITRESOURCELIMITEXCEEDED-T/QDBGETMQO
SI61050 OSP-DB-OTHER-INCORROUT QSYS2/SYSLIMITS SQLPKG SIZING_NAME CU
SI60927 OSP - DB SQL0301 Assigning a Date, Time, or Timestamp to col
SI60882 OSP-DB-OTHER-F/QSQRUN3/QSQINS-MSGSQL0913X/31981 UPDATE FAILS
SI60882 OSP-DB-QSQOPEN-MSGMCH3601 on EXECUTE IMMEDIATE with DRDA
SI60715 OPS - DB MCH3601 instead of SQL0503 when Attempting to Updat
SI60616 OSP GET DIAGNOSTICS SQL STATEMENT DOES NOT RETURN CORRECT SQ
SI60479 OSP-DB-PERFM Slow performance when using SQL packages in mul
SI60196 OSP-DB-OTHER-PERFM Allow Psuedo close opens for special regi
SI60196 OSP-DB-OTHER CREATE TABLE AS WITH DATA does not ignore an OV
SI60112 OSP-DB-OTHER-PERFM Allow Psuedo close opens for special regi
SI60068 OSP-DB-OTHER-INCORROUT QQC21 = 'CA' RECORDS MISSING FROM STR
SI60048 OSP-DB REMOTE INSERT WITH AN ALIAS THAT HAS A 3 PART NAME FA
SI59993 OSP-DB-OTHER-F/QSQPREP-MSGSQL0580 when 3rd argument of TIMES
SI59922 OSP-DB-MSGMCH3601-QSQROUTQ
SI59857 OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH1210 MCH1210 F/QQQS
SI59857 OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0518 SECOND STORED
SI59827 OSP-OTHER-PERFM SELECT FROM INSERT QUERY STARTED PERFORMING
SI59827 OSP-DB Return DB2_ROW_LENGTH on OPEN
SI59698 OSP-DB INFRASTRUCTURE
SI59625 OSP-DB-OTHER ADD PACKAGE INFORMATION TO SYSLIMITS CATALOG
SI59594 OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
SI59539 OSP-DB Internal Maintenance
SI59491 OSP-DB-OTHER-UNPRED UPDATING A TABLE WITH BOTH A NULLABLE FI
SI59491 OSP-MSGCPF4268 DIFFERENT BEHAVIORS FOR BATCH VS INTERACTIVE
SI59491 OSP-DB-OTHER-F/QSQRUND-T/QSQRUN3-MSGSQL0901 A MSGSQL0901 F/Q
SI59491 OSP-HOSTSERVERS-OTHER-INCORROUT RANDOM DATA TYPRE MISMATCH
SI59491 OSP-DB-OTHER-T/QQQIMPLEX/16106-MSGCPF4287 USING 3-PART NAMIN
SI59455 OSP-DB INFRASTRUCTURE
SI59266 OSP-DB Internal Maintenance
SI59155 OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
SI59145 OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-RC2-MSGSQL0101 SQL RPG OBJE
SI59108 OSP-DB-MSGMCH3601-F/QSQDESC SET STATEMENT FAILURE
SI59075 OSP-DB INTERNAL MAINTENANCE
SI59061 OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
SI59013 OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4301 ON RUNNING A PRO
SI58979 OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
SI58979 OSP-DB-OTHER-RC8-MSGCPDB8E4 TRYING TO VARY OFF IASP
SI58979 OSP-DB-OTHER-F/QSQRUN3-MSGSQL0517
SI58979 F/QSQCONN-MSGSQL0950 SQL0950 ERROR HIT WHEN RPG WITH EMBEDDE
SI58979 OSP-DB-OTHER-F/QSQSBAS2X/2815-T/SAME-MSGMCH1210 CPYF RSULTS
SI58979 OSP-DB-SQL Support optionally setting indicator on truncatio
SI58926 OSP-DB Internal Maintenance
SI58791 OSP-DB Internal Maintenance
SI58670 OSP-DB Internal Database Maintenance
SI58541 OSP-DB Support OFFSET clause in PREPARE attribute string
SI58541 OSP-DB-OTHER-THREADS-MSGMCH0601 MCH0601
SI58541 OSP-DB-OTHER-SAP400-F/#CFOCHKR-T/QSQRUN1-MSGMCH3402 MSGMCH58
SI58541 OSP-DB-OTHER-F/QQQQUERY-T/QQQQUERY-MSGMCH3601 OCCURRING INTE
SI58541 OSP-DB-OTHER-INCORROUT QSQSVCDMP DOESN'T GO TO THE QEZDEBUG
SI58541 OSP-DB-OTHER-MSGCPF3220 TRYING TO DELETE A TEMP TABLE AFTER
SI58541 OSP-DB-QQQOOOSETS-MSGMCH5003 using CURRENT DECFLOAT ROUNDING
Summary Information
System.............................. i
Models..............................
Release............................. V7R3M0
Licensed Program.................... 5770SS1
APAR Fixed.......................... View details for APAR SE68689
Superseded by:...................... View fix details for PTF SI85789
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C8242730
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