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 V7R2M0 SI65955 00/00 0000
CO 5770SS1 V7R2M0 SI65934 00/00 0000
CO 5770SS1 V7R2M0 SI65933 00/00 0000
CO 5770SS1 V7R2M0 SI65781 00/00 0000
CO 5770SS1 V7R2M0 SI65780 00/00 0000
CO 5770SS1 V7R2M0 SI55801 00/00 0000
CO 5770SS1 V7R2M0 SI53866 00/00 0000
DIST 5770SS1 V7R2M0 SI66169 00/00 0000
DIST 5770SS1 V7R2M0 SI64148 00/00 0000
DIST 5770SS1 V7R2M0 SI60514 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
-------------- ------------------------------------------------------------
SI66613 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0509 WHEN STORED PROC
SI66581 OSP-DB-MSGMCH3603 with multiple nesting of triggers
SI66574 OSP-DB-OTHER INSERTS OF BLOB FIELDS TO IBM I DATABASE FROM A
SI66573 OSP SQL INSERT WRITING INTO THE WRONG MEMBER IN APPLICATION
SI66561 OSP-MSGSQL0138-D/TQSQRUN3-PAR WHEN CALLING A STORED PROCEDUR
SI66514 OSP-DB-OTHER-F/QSQRUN1X/19980-T/T/SAME-MSGMCH3601 BANKING AP
SI66507 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0519 PREPARE LOCK PAC
SI66501 OSP-MSGMCH3601-PAR-940XBASE RPG SQL APPLICATION RETURNS MCH3
SI66483 OSP-DB-MSGSQL0171 with insert statement
SI66382 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGMCH3601 SQL0901 MCH3601
SI66175 F/QSQRUN1-MSGSQL0904-RC160-MOD/QSQDESC F/QSQRUN1-MSGSQL0904-
SI66171 OSP-DB-OTHER-UNPRED MERGER STATEMENT WITH AN UPDATE OPERATIO
SI66134 OSP-DB-MSGMCH3601 and SQL0901 from Update Attempt of Not Yet
SI66066 F/#CFOCHKR-MSGMCH3603 MSGMCH3603 MCH3603 F/#CFOCHKR X/000C2C
SI66001 OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4301 CPD4301 SQL0901
SI65935 OSP-DB-OTHER-UNPRED DUPLICATE STATEMENT NAMES IN SQLPKG
SI65881 OSP-DB FETCH N ROWS clause with PREPARE ATTRIBUTE
SI65858 OSP-DB INTERNAL MAINTENANCE
SI65782 OSP-DB INTERNAL MAINTENANCE
SI65572 OSP-DB Internal Maintenance
SI65518 OSP-F/QSQROUTS-T/QSQROUTS-MSGSQL0518 REUSE OF SELECT FROM IN
SI65507 OSP-DB INTERNAL MAINTENANCE
SI65450 OSP-DB-OTHER-INCORROUT FRENCH CHARATER ' ' ('C0'X) IS DISPLA
SI65325 OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0913 SELECT FOR FET
SI65158 OSP-DB Performance improvement of Insert with remote subsele
SI65045 OSP-DB INTERNAL MAINTENANCE
SI65034 OSP-DB-PERFM Improve performance of OPEN statements in stati
SI64952 OSP-DB-OTHER-F/#COMOOBJ-T/QTNOPNCLS-MSGMCH6221 VLF000702
SI64910 OSP-DB-MSGSQL0206 with GVAR in remote drda job
SI64783 OSP-DB Internal Maintenance
SI64748 OSP-DB-OTHER-MSGMCH3601-T/QSQPREP PROCEDURE CLEANUP
SI64721 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0913 CODE ADDED TO AI
SI64524 OSP-OTHER-UNPRED CURSOR IS BEING HARD CLOSED DUE TO INTERNAL
SI64524 OSP SEVERAL QSQSVCDMP DUMPS FROM QZDASOINIT JOBS.
SI64524 OSP-MSGCPD4306-D/TQSQOPEN-PAR DECLARE CURSOR STATEMENT IN EM
SI64524 OSP-DB-OTHER-PERFM OSP-DB-OTHER-PERFM
SI64285 OSP-DB-OTHER-INCORROUT INTERMITTENT PROBLEM INCORROUT OUTPUT
SI64222 OSP-DB-MSGMCH0601-F/QSQSTATS CREATE TABLE AS statement WITH
SI64147 OSP-UNPRED ENDDBMON OF DBMON WITH PARM HOSTVAR(*CONDENSED) L
SI64137 OSP-DB-OTHER-INCORROUT STORED PROCEDURE WITH IDENTITY_VAL_LO
SI63973 OSP-DB-OTHER-T/QSQSBAS2-MSGMCH1210 MODULE QSQSFCRT
SI63864 OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-MSGSQL0904 SQL JOB FAILS WI
SI63789 OSP-DB Intermittent SQL failures with JDE workloads
SI63785 OSP-DB-OTHER-PERFM POOR ESTIMATE FOR UDTFS USED BY OBJECT_ST
SI63640 OSP-DB INTERNAL MAINTENANCE
SI63295 F/QSQRUN2-MSGSQL0326 SQL RPG PROGRAM FAILS WITH SQL0326. SEL
SI63435 OSP-DB-OTHER-F/QSQCONN-MSGSQL0751 USING 3 PART NAME FROM A T
SI63381 OSP-DB-OTHER-F/QSQLOPEN-MSGMCH3601 WHEN ANOTHER PROGRAM WAS
SI63381 OSP-DB-OTHER-UNPRED EMBEDDED SQL STATEMENTS IN RPGLE PROGRAM
SI63282 OSP-DB-OTHER-T/QSQRUN3-MSGMCH3601 MODULE QSQOPEN PROCEDURE D
SI63254 OSP-DB-OTHER MSGMCH0601 F/< INGHIGHUSE X/000118 T/QSQRUN3
SI63248 OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGMCH3601 MCH3601 MCH1210
SI63214 OSP-DB-OTHER-UNPRED INFORMATIONAL QSQSVCDMP SPOOL FILES ARE
SI63064 OSP-DB Internal Maintenance
SI62909 OSP-DB-MSGCPF3272 long running cli job
SI62772 OSP-DB-OTHER-T/QSQSBAS2-MSGMCH5804 SQL0901 LOCK SQL PACKAGE
SI62259 OSP-DB-OTHER-THREADS-PERFM SPACE LOCATION LOCKS ARE NOT BEIN
SI62163 F/QRWSQRY-MSGCPD3E06 F/QRWSQRY-MSGCPD3E06
SI62113 OSP-DB Incorrect diagnostics from stored procedure
SI61903 OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
SI61405 OSP-DB INFRASTRUCTURE
SI61068 OSP-DB-OTHER-F/EX3E06COMMITRESOURCELIMITEXCEEDED-T/QDBGETMQO
SI61056 OSP-DB reuse remote server job for 3 part SQL
SI60881 OSP-DB-QSQOPEN-MSGMCH3601 on EXECUTE IMMEDIATE with DRDA
SI60881 OSP-DB-OTHER-F/QSQRUN3/QSQINS-MSGSQL0913X/31981 UPDATE FAILS
SI60785 OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH1210 MCH1210 F/QQQS
SI60740 OSP-DB-MSGMCH0601 insert with remote subselect
SI60716 OPS - DB MCH3601 instead of SQL0503 when Attempting to Updat
SI60615 OSP GET DIAGNOSTICS SQL STATEMENT DOES NOT RETURN CORRECT SQ
SI60554 OSP-F/QSQRUN3-T/QSQRUN3-MSGSQL0180 SQL INSERT FAILS WITH MSG
SI60478 OSP-DB-PERFM Slow performance when using SQL packages in mul
SI59955 OSP-DB-OTHER-F/QSQPREP-MSGSQL0580 when 3rd argument of TIMES
SI59917 OSP-DB Return DB2_ROW_LENGTH on OPEN
SI59848 OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0518 SECOND STORED
SI59848 OSP-DB-OTHER-F/QSQSBAS2X/2815-T/SAME-MSGMCH1210 CPYF RSULTS
SI59848 OSP-DB-QQQOOOSETS-MSGMCH5003 using CURRENT DECFLOAT ROUNDING
SI59666 OSP-OTHER-PERFM SELECT FROM INSERT QUERY STARTED PERFORMING
SI59623 OSP-DB-OTHER ADD PACKAGE INFORMATION TO SYSLIMITS CATALOG
SI59593 OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
SI59526 OSP-DB-OTHER-F/QSQRUND-T/QSQRUN3-MSGSQL0901 A MSGSQL0901 F/Q
SI59499 OSP-HOSTSERVERS-OTHER-INCORROUT RANDOM DATA TYPRE MISMATCH
SI59124 OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-RC2-MSGSQL0101 SQL RPG OBJE
SI59093 OSP-DB-MSGMCH3601-F/QSQDESC SET STATEMENT FAILURE
SI59014 OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4301 ON RUNNING A PRO
SI58978 OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
SI58970 OSP-DB-OTHER-F/QSQRUN3-MSGSQL0517
SI58965 OSP-DB Wrong DB2_NUMBER_ROWS WITH OFFSET
SI58950 OSP-DB-SQL Support optionally setting indicator on truncatio
SI58929 OSP-DB-OTHER-RC8-MSGCPDB8E4 TRYING TO VARY OFF IASP
SI58647 OSP-DB-OTHER-MSGCPF3220 TRYING TO DELETE A TEMP TABLE AFTER
SI58366 OSP-DB-OTHER-THREADS-MSGMCH0601 MCH0601
SI58277 OSP-DB-OTHER-T/QQQIMPLEX/16106-MSGCPF4287 USING 3-PART NAMIN
SI58225 OSP-DB-OTHER-INCORROUT QSQSVCDMP DOESN'T GO TO THE QEZDEBUG
SI58190 OSP-DB-OTHER-F/QQQQUERY-T/QQQQUERY-MSGMCH3601 OCCURRING INTE
SI58172 OSP-DB insert with source table is in IASP
SI58078 OSP-DB Internal Maintenance
SI58075 OSP-DB-OTHER-SAP400-F/#CFOCHKR-T/QSQRUN1-MSGMCH3402 MSGMCH58
SI58002 OSP-DB-OTHER-MSGSQL0335 NOT ISSUED AS WARNING
SI57937 OSP-INCORROUT AFTER INSERT EXTERNAL TRIGGER FIRED BY AN INSE
SI57919 OSP-DB-OTHER-MSGSQL0335 NOT ISSUED AS WARNING
SI57836 OSP-DB-OTHER-F/QSQCONN-T/QSQCONN-MSGSQL0950 MSGSQL0950 AND M
SI57603 OSP-DB-OTHER-T/QSQRUN1-MSGMCH3601 ON SECOND PREPARE OF A MER
SI57490 OSP-MSGCPF4268 DIFFERENT BEHAVIORS FOR BATCH VS INTERACTIVE
SI57261 OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
SI57217 OSP-DB-OTHER-THREADS-F/QSQRUN1-T/QSQRUN1-MSGSQL0904 SQL0904
SI57217 OSP-DB-OTHER-INCORROUT HETEROGENEOUS DRDA CONNECTION NOT GET
SI57167 OSP-DB INSERT OF VARGRAPHIC DATA RESULT IN SQL0404
SI57108 F/QSQCONN-MSGSQL0950 SQL0950 ERROR HIT WHEN RPG WITH EMBEDDE
SI57099 OSP-DB-OTHER-T/QSQDDL1-MSGMCH1210 MODULE QSQACTNM ON AN INSE
SI57080 OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON
SI56949 OSP-DB-OTHER-F/QQQISVSU-T/QSQRUN3-MSGCPD4372 A MSGCPD4372 MA
SI56834 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
SI56548 OSP-OTHER-INCORROUT UNICODE TRANSLATION INTERMITTENTLY FAILS
SI56337 OSP-DB-OTHER-INCORROUT INCORRECT DATA IN CLOB FIELD.
SI56185 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0407 INSERT STATEMENT
SI56138 OSP-DB Extend QSQPRCED() to include some QAQQINI options
SI56010 OSP-DB-OTHER-UNPRED MSGSQL0104 FOR VALID SQL STATEMENT AFTER
SI55932 OSP-DB incorrect sqlcode returned on INSERT
SI55798 OSP-DB DRDA SERVER IMPLICIT COMMIT AFTER IMPLICIT QUERY CLOS
SI55651 OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4302 ON A QUERY FROM
SI55528 OSP-DB QSQPRCED() creates package using a larger capacity *S
SI55517 OSP-DB Internal Maintenance
SI55441 OSP-DB SQL Statement Operation blank in SQL Plan Cache
SI55420 OSP-DB-OTHER-T/QSQRUN3-MSGCPD4301 AFTER ALTER TABLE
SI55309 OSP-DB-OTHER-T/QSQSBAS2-MSGMCH3603 MODULE/QSQHDCLSm PROCEDUR
SI55284 OSP-DB Internal Maintenance
SI55271 OSP-DB-OTHER-T/QSQSBAS-MSGMCH1210 MODULE QSQVATTR PROCEDURE
SI55220 OSP-DB Internal Maintenance
SI55116 OSP-DB-OTHER-UNPRED QSQSVCDMP SPOOLED FILE CREATED
SI54941 OSP-DB-MSGSQL0502 after query with 3 part name
SI54869 OSP-DB-OTHER-UNPRED UPDATING A TABLE WITH BOTH A NULLABLE FI
SI54696 OSP-DB Internal Maintenance
SI54622 OSP-DB APPLICATIONS GETTING MSGMCH0601 T/QSQRUN2 MOD/QSQFETC
SI54585 OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3601
SI54310 OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3601
SI54090 OSP-DB-MSGSQL0407-F/QSQINS SQL INSERT OR UPDATE MISSING MSG
SI54068 OSP-DB DISPLAY LONG FIELD NAMES FOR SOME SQ MESSAGES
SI54061 OSP-DB DISPLAY LONG FIELD NAMES FOR SOME SQ MESSAGES
SI54038 OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
SI53987 OSP-DB-MSGSQ20478 after DEACTIVATE COLUMN ACCESS CONTROL
SI53865 OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QSQROUTX-MSGMCH0601 MCH3601
SI53849 OSP-DB-OTHER-UNPRED PROGRAM WITH EMBEDDED SQL CONTINUALLY GR
SI53593 OSP-DB-OTHER-UNPRED SERVICEABILITY CHANGE
SI53437 OSP-DB-OTHER-T/QSQALCDS-RC542-MSGSQL0904
SI53363 OSP-MSGSQL0312 STORED PROCEDURE RUNNING INSERT W/SUBSELECT W
SI53066 OSP-DB-OTHER-F/QSQSBAS2-T/QSQSBAS-MSGSQL0901 MSGSQL0901 F/QS
SI52868 OSP-DB-OTHER COMPRESS OF PACKAGE NOT OCCURRING
SI52848 OSP-DB-OTHER-INCORROUT SQL CALL LEVEL INTERFACE GRAPHIC PARA
SI52833 OSP-DB-F/QSQUPDAT-MSGMCH3601 processing SQ20478 error during
SI52833 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH0601 MSGMCH0601 F/QSQ
SI52833 OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QSQRUN2/QSQFETCH-MSGMCH0601
SI52791 SP/QSQRUN3-MSGSQL0511-MOD/QSQOPEN-OPCS/CLEANUP SQL SELECT UN
SI52537 OSP-DB Internal Maintenance
SI52340 OSP-DB INTERNAL MAINTENANCE
SI52340 OSP-DB DRDA AS detail in the SQL Plan Cache is incomplete
SI52251 OSP-DB-OTHER-F/QDBIOERRQO-T/QDBIOERRQO-MSGCPF503E UDF RUNNIN
SI52229 OSP-DB Internal Maintenance
SI51981 OSP-DB Internal Maintenance
SI51824 OSP-DB Internal Maintenance
SI51776 OSP-DB Internal Maintenance
SI51681 F/QSQROUTS-MSGSQL0404 MSGSQL0404 F/QSQROUTST/QSQROUTS
SI51578 OSP-DB Internal Maintenance
SI51560 OSP-DB INTERNAL MANTENANCE
SI51523 OSP-DB Internal Maintenance
SI51468 OSP-DB Internal Maintenance
SI51390 OSP-DB MCH1210 F/T: QSQSTATS/QSQSTATS
SI51367 OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-RC'0100E'-MSGSQL0464 SQL0
SI51284 OSP-DB Internal Maintenance
SI51238 OSP-DB Internal Maintenance
SI51238 OSP-DB-MSGMCH3601-F/QSQCONN MIXING DDM/DRDA CNN FIX
SI51238 OSP-DB INTERNAL MAINTENANCE
Summary Information
System.............................. i
Models..............................
Release............................. V7R2M0
Licensed Program.................... 5770SS1
APAR Fixed.......................... View details for APAR SE68689
Superseded by:...................... View fix details for PTF SI85788
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C8249720
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:
12 March 2024