IBM Support

SI67440 - OSP-DB-OTHER-INCORROUT A RPG CHAIN MAY NOT FIND CORRECT VALU

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

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 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.2.0","Product":{"code":"SWG60","label":"IBM i"},"Component":"5770SS1","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
12 March 2024