IBM Support

SI66643 - OSP-DB-PERFM-Improvement in extended dynamic prepares with l

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

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 i Support

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.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.3.0","Product":{"code":"SWG60","label":"IBM i"},"Component":"5770SS1","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
13 March 2024