PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER-INCORROUT A RPG CHAIN MAY NOT FIND CORRECT VALU
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
PRE 5770999 V7R2M0 MF64908 00/00 0000
PRE 5770999 V7R2M0 MF64145 00/00 0000
PRE 5770999 V7R2M0 MF64091 00/00 0000
PRE 5770999 V7R2M0 MF64043 00/00 0000
PRE 5770999 V7R2M0 MF58842 00/00 0000
PRE 5770999 V7R2M0 MF58331 00/00 0000
CO 5770SS1 V7R2M0 SI67230 00/00 0000
CO 5770SS1 V7R2M0 SI66887 00/00 0000
CO 5770SS1 V7R2M0 SI66516 00/00 0000
CO 5770SS1 V7R2M0 SI66246 00/00 0000
CO 5770SS1 V7R2M0 SI65679 00/00 0000
CO 5770SS1 V7R2M0 SI61308 00/00 0000
CO 5770SS1 V7R2M0 SI52445 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
-----------------------------------------------
Using RPG with OPNQRYF and Field Procedure may not find a match
correctly.
CORRECTION FOR APAR SE69144 :
-----------------------------
The SQE support for native key positioning operations has been
changed to correctly Encode or Decode the user specified key
values to match the encoded/decoded values in the index used for
positioning.
CIRCUMVENTION FOR APAR SE69144 :
--------------------------------
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
-------------- ------------------------------------------------------------
SI66927 OSP-DB-OTHER Additional QAQQINI options to VisualExplan
SI66889 Internal Maintenance
SI66878 OSP-DB-OTHER-F/DBOPQUERY-T/QQQOOODBOP-MSGMCH3203 OPNQRYF THA
SI66873 OSP-DB-OTHER-MSGCPF4128 LOCKS NOT RELEASED WHEN SQL SELECT I
SI66872 OSP-S36E-OTHER-F/QDMCOPEN-T/QDMCOPEN-MSGMCH3601 ODP GETS NUL
SI66712 OSP-DB-OTHER Delete specific plan via QQQOOOCACH
SI66536 F/DBOPNODE-MSGMCH3203-PRCS/1720 F/DBOPNODE-MSGMCH3203-PRCS/1
SI66247 Internal Maintenance
SI66206 OSP-DB-OTHER-PERFM SQL STATEMENT CONTAINING COALESCE/IFNULL
SI66191 LIC-DB-OTHER Internal Database Maintenance.
SI66054 OSP-DB Internal Maintenance
SI66047 OSP-DB-OTHER-INCORROUT JSON_ARRAY with fullselect and orderi
SI65980 Fix for missing labels in Visual Explain for LIMIT/OFFSET.
SI65879 OSP-DB IBM i enhanced support for LIMIT and OFFSET.
SI65785 OSP-DB IBM i enhanced support for LIMIT and OFFSET.
SI65736 OSP-DB-OTHER ADD QRO Hash to iNav/ACS PlanCache view
SI65680 Internal Maintenance
SI65340 OSP-DB-MSGMCH3601 f/QQQQEXIT t/QQQQEXIT proc/CLOSE_USER_UFCB
SI65179 OSP-DB-OTHER Support to control data copy allowance for open
SI64972 OSP-DB-OTHER MSGMCH3203 F/DBPMTRAP T/QQQOOODBOP VL0600BADD V
SI64788 SQL-RUN B9003E10
SI64527 OSP-DB-PERFM Performance issue with SQL Expression Evaluator
SI64363 OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F
SI64021 OSP-DB System i XML publishing function special character es
SI63752 LIC-DB-UNPRED Failure tracing Query
SI63623 OSP-DB-MSGMCH3601 using inlined UDF with a parameter that ha
SI63522 OSP-DB-OTHER-F/QQQOOODBOP-T/QQQOOODBOP-MSGMCH3601 QQQDTQRO B
SI63495 OSP-DB Internal Database Maintenance
SI63465 OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH3601 MSGMCH3601 F/Q
SI63048 OSP-DB-PERFM PERFORMANCE ISSUES READING SQL VIEW THAT WAS OP
SI62987 OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH3601 MSGMCH3601 F/Q
SI62834 OSP-DB-f/QQQSRVV1-MSGCPD432D when inlining UDF with a select
SI62798 OSP-DB Internal Database Maintenance
SI62751 LIC-DB-PERFM Excessive optimization time when MQTs enabled
SI62555 F/OPTIMIZER-UDFWITHDETERMINISTICBEHAVIOUR OPTIMIZER-UDF WITH
SI62100 OSP-DB-Internal Database Maintenance
SI61561 OSP-DB INFRASTRUCTURE
SI61486 OSP-DB Internal Database Maintenance
SI61319 OSP-DB Internal Database Maintenance
SI61218 OSP-DB-OTHER-F/DBOPSTRATEGY-T/QQQOOODBOP-MSGMCH3203 F/DBOPST
SI61218 OSP-DB-MSGMCH3203 f/DbopAffinity t/QQQOOODBOP running GROUP
SI60937 OSP-DB-OTHER-MSGQRY2283 A MSGQRY2283 MAY OCCUR WITH A QUERY/
SI60389 OSP-DB Internal Database Maintenance
SI60010 OSP-DB Internal Database Maintenance
SI59734 OSP-LOOP CREATE FUNCTION WITH NESTED REPLACE LOOPS
SI59686 OSP-DB-UNPRED-MSGMCH3402 clear_plan_cache stored procedure
SI59272 OSP-DB Internal Database Maintenance
SI59090 OSP-DB Internal Database Maintenance
SI59060 OSP-DB-OTHER-F/ASSERT-T/QQQOOOINV-MSGMCH3203 SQL FAILING WIT
SI58154 OSP-DB-OTHER Query INI Option ALLOW_EVI_ONLY_ACCESS support
SI58094 OSP-DB-MSGSQL0443 MCH1210 When Visual Explaining a query wit
SI58069 OSP-DB-OTHER Query INI Option ALLOW_EVI_ONLY_ACCESS support
SI57944 OSP-DB-OTHER Query INI Option ALLOW_EVI_ONLY_ACCESS support
SI57926 OSP-DB-OTHER ALLOW TEMPORARY INDEXES BY DEFAULT FOR OPNQRYF
SI57913 OSP-OTHER-PERFM A QUERY WITH A RECURSIVE COMMON TABLE EXPRES
SI57337 OSP-DB-OTHER-INCORROUT TRIGGER BUFFER HAS INCONSISTENT ENCOD
SI57184 OSP PERFORMANCE DEGRADATION SENDING STATUS MESSAGES WHEN SCR
SI57121 OSP-DB-INCORROUT OPNQRYF OUTPUT MISSING RECORDS
SI56543 OSP-DB - SUPPORT SHARED AND PUBLIC MEMORY POOL NAMES IN QAQQ
SI56209 OSP-DB-OTHER Add Index Not Used list to VE
SI55636 OSP-DB-MSGMCH3601 F/QQQOOODBOP T/QQQOOODBOP OPNQRYF of Logic
SI55505 OSP-QQ-RUN Change to debug program
SI55415 OSP-DB Incremental Enhancement
SI55377 LIC-PERFM QUERIES AT R710 ARE RUNNING SLOWER UNLESS THE INLI
SI54733 OSP-DB database monitor fixes for the STRDBMON HOSTVAR parm.
SI54674 LIC-DB-PERFM Enable Pessimistic IO costing for Index Probe a
SI54594 OSP-DB-OTHER-F/MNRESOLVECONTEXT-T/QQQVWCMP-MSGMCH3401 CANNOT
SI54594 OSP-DB database monitor service option for the 3010 record
SI54318 OSP-DB-OTHER Add QRO Hash to Visual Explain.
SI54312 OSP-DB-INCORROUT Update or insert incorrectly allowed for op
SI54154 OSP-MSGCPF2189-D/TQQQOOOPLNC ATTEMPTING TO RUN VISUAL EXPLAI
SI54016 OSP-DB-MSGMCH3203 f/DbopQuery t/QQQOOODBOP for native open o
SI53924 OSP-DB-OTHER-F/QDBGETM-T/DBPMNATIVEACCESS-MSGMCH1825 ON A _R
SI53924 OSP-DB-MSGSQL0952 Process termination running SQL GROUP BY q
SI53245 OSP-DB SOME FUNCTIONS IN VISUAL EXPLAIN MAY FAIL IF AN INDEX
SI53139 OSP-DB-RUN Additional Plan Cache Properties
SI53132 OSP-DB Internal Database Maintenance
SI53059 OSP-DB-RUN Plan Cache Snapshot Does Not Default to QTEMP
SI53023 OSP-DB Internal Database Maintenance
SI52879 OSP-DB-OTHER-INCORROUT SUBSTITUTION CHARACTER X'00' USED INS
SI52817 OSP-DB Internal Database Maintenance
SI52727 OSP-DB Internal Database Maintenance
SI52584 OSP-DB Internal Database Maintenance
SI52442 OSP-DB Internal Database Maintenance
SI52288 OSP-DB SQL Internal support for RCAC, dump permissions and m
SI52236 OSP-DB Internal Database Maintenance
SI51862 OSP-DB Internal Database Maintenance
SI51696 OSP-DB Internal Database Maintenance
SI51665 OSP-DB Internal Database Maintenance
SI51630 OSP-DB Internal Database Maintenance
SI51475 OSP-DB Internal Database Maintenance
SI51411 OSP-DB Internal Database Maintenance
SI51243 OSP-DB Internal Database Maintenance
SI52911 OSP-DB-OTHER Change Plan Cache Snapshots creation to avoid j
SI51359 OSP-DB INTERNAL MAINTENANCE
SI52740 OSP-DB-OTHER-F/RMSLLOCKMIOBJECT-T/QDBOPEN-MSGMCH5802 QDBSRV
SI52740 OSP-DB-RUN Plan Cache Event Monitor Cannot be Ended
SI52740 OSP-DB Internal maintainence
SI52289 OSP-DB SQL Internal support for RCAC, dump permissions and m
Summary Information
System.............................. i
Models..............................
Release............................. V7R2M0
Licensed Program.................... 5770SS1
APAR Fixed.......................... View details for APAR SE69144
Superseded by:...................... View fix details for PTF SI85715
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