IBM Support

SI66051 - OSP-DB Internal Maintenance

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB Internal Maintenance


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770999  V7R3M0    MF64146   00/00    0000
PRE  5770999  V7R3M0    MF64141   00/00    0000
PRE  5770999  V7R3M0    MF64068   00/00    0000
PRE  5770999  V7R3M0    MF63297   00/00    0000
PRE  5770SS1  V7R3M0    SI62847   00/00    0000
CO   5770SS1  V7R3M0    SI66050   00/00    0000
CO   5770SS1  V7R3M0    SI66052   00/00    0000
CO   5770SS1  V7R3M0    SI65875   00/00    0000
CO   5770SS1  V7R3M0    SI65876   00/00    0000
DIST 5770999  V7R3M0    MF62261   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

-----------------------------------------------
OSP-DB Internal Maintenance

CORRECTION FOR APAR SE68253 :
-----------------------------
OSP-DB Internal Maintenance

CIRCUMVENTION FOR APAR SE68253 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI66048      OSP-DB-OTHER-INCORROUT JSON_ARRAY with fullselect and orderi
   SI65981      Fix for missing labels in Visual Explain for LIMIT/OFFSET.
   SI65874      OSP-DB IBM i enhanced support for LIMIT and OFFSET.
   SI65764      OSP-DB IBM i enhanced support for LIMIT and OFFSET.
   SI65670      OSP-DB-MSGCPF4268 f/QQQSRVV1 fmod/QQQVFILE t/QQQOOOUPCL tmod
   SI65500      OSP-MSGCPF426A USER DEFINED FUNCTION USING A VIEW THAT WAS R
   SI65412      Internal Maintenance
   SI65380      OSP-DB Internal Maintenance
   SI65275      OSP-DB-MSGMCH3601 f/QQQQEXIT t/QQQQEXIT proc/CLOSE_USER_UFCB
   SI65269      OSP-DB-OTHER Support to control data copy allowance for open
   SI65242      OSP-DB-OTHER  Internal system maintenance.
   SI64971      OSP-DB-OTHER MSGMCH3203 F/DBPMTRAP T/QQQOOODBOP VL0600BADD V
   SI64504      OSP-DB-PERFM Performance issue with SQL Expression Evaluator
   SI64364      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F
   SI64278      OSP-DB-PERFM PERFORMANCE ISSUES READING SQL VIEW THAT WAS OP
   SI64085      OSP-DB System i XML publishing function special character es
   SI63629      OSP-DB-MSGMCH3601 using inlined UDF with a parameter that ha
   SI63524      OSP-DB-OTHER-F/QQQOOODBOP-T/QQQOOODBOP-MSGMCH3601 QQQDTQRO B
   SI63464      OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH3601 MSGMCH3601 F/Q
   SI63006      OSP-DB Internal Database Maintenance
   SI62960      OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH3601 MSGMCH3601 F/Q
   SI62933      LIC-DB-PERFM Excessive optimization time when MQTs enabled
   SI62846      OSP-DB-OTHER-F/DBOPSTRATEGY-T/QQQOOODBOP-MSGMCH3203 F/DBOPST
   SI62846      OSP-DB-MSGMCH3203 f/DbopAffinity t/QQQOOODBOP running GROUP
   SI62846      OSP-DB-f/QQQSRVV1-MSGCPD432D when inlining UDF with a select
   SI62741      OSP-DB Internal Database Maintenance
   SI62726      LIC-DB-UNPRED Failure tracing Query
   SI62564      OSP-DB Internal Database Maintenance
   SI62131      OSP-DB Internal Database Maintenance
   SI62106      OSP-DB-Internal Database Maintenance
   SI61566      OSP-DB INFRASTRUCTURE
   SI61314      OSP-DB Internal Database Maintenance
   SI61222      OSP-DB Internal Database Maintenance
   SI60982      OSP-DB SQL Percentile Functions
   SI60938      OSP-DB-OTHER-MSGQRY2283 A MSGQRY2283 MAY OCCUR WITH A QUERY/
   SI60890      OSP-DB Internal Database Maintenance
   SI60529      OSP-DB Internal Database Maintenance
   SI60395      OSP-DB Internal Database Maintenance
   SI60065      OSP-DB Internal Database Maintenance
   SI59735      OSP-LOOP CREATE FUNCTION WITH NESTED REPLACE LOOPS
   SI59685      OSP-DB-UNPRED-MSGMCH3402 clear_plan_cache stored procedure
   SI59580      OSP-DB Internal Database Maintenance
   SI59495      OSP-DB Internal Database Maintenance
   SI59091      OSP-DB Internal Database Maintenance
   SI58590      OSP-DB-MSGSQL0443 MCH1210 When Visual Explaining a query wit
   SI58535      OSP-DB-MSGSQL0443 MCH1210 When Visual Explaining a query wit
   SI58535      OSP-DB-MSGSQL0443 MCH1210 When Visual Explaining a query wit
   SI58535      OSP-DB-OTHER-F/ASSERT-T/QQQOOOINV-MSGMCH3203 SQL FAILING WIT

Summary Information

System..............................  i
Models..............................  
Release.............................  V7R3M0
Licensed Program....................  5770SS1
APAR Fixed..........................  View details for APAR SE68253
Superseded by:......................  View fix details for PTF SI79945
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 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:
07 July 2022