IBM Support

SI60250 - OSP-DB Internal Database Maintenance

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB Internal Database Maintenance


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770999  V7R2M0    MF60681   00/00    0000
PRE  5770999  V7R2M0    MF60719   00/00    0000
PRE  5770999  V7R2M0    MF57974   00/00    0000
PRE  5770999  V7R2M0    MF57614   00/00    0000
CO   5770SS1  V7R2M0    SI60251   00/00    0000
CO   5770SS1  V7R2M0    SI60252   00/00    0000
CO   5770SS1  V7R2M0    SI60010   00/00    0000
CO   5770SS1  V7R2M0    SI59597   00/00    0000
CO   5770SS1  V7R2M0    SI59357   00/00    0000
CO   5770SS1  V7R2M0    SI52481   00/00    0000
DIST 5770SS1  V7R2M0    SI59351   00/00    0000
DIST 5770SS1  V7R2M0    SI59348   00/00    0000
DIST 5770SS1  V7R2M0    SI57838   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

-----------------------------------------------
PTF for internal database maintenance.

CORRECTION FOR APAR SE64494 :
-----------------------------
PTF for internal database maintenance.

CIRCUMVENTION FOR APAR SE64494 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI60238      OSP-DB-OTHER-UNPRED UNABLE TO CREATE VIEWS THAT CONTAIN CTES
   SI60011      OSP-DB Internal Database Maintenance
   SI60011      OSP-DB Internal Database Maintenance
   SI59921      OSP-DB Internal Database Maintenance
   SI59956      OSP-DB Internal Database Maintenance
   SI59941      OSP-DB Internal Database Maintenance
   SI59916      OSP-DB Internal Database Maintenance
   SI59709      OSP-DB Internal Database Maintenance
   SI59704      OSP-DB Internal Database Maintenance
   SI59704      OSP-DB Internal Database Maintenance
   SI59669      OSP-DB Internal Database Maintenance
   SI59631      OSP-DB Internal Database Maintenance
   SI59631      OSP-DB-MSGCPD434C f/QQQQUERY t/QDBRSPRE on restore of SQL vi
   SI59595      OSP-DB-MSGMCH1210 f/QQQQUERY t/QQQQUERY proc/CRTNEWQDT
   SI59556      OSP-DB INCORRECT INFORMATION IN THE DESCRIPTORS PARAMTERS RE
   SI59540      OSP-DB Internal Database Maintenance
   SI59535      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F
   SI59459      OSP QIBM_QQQ_QUERY_GOVR EXIT PROGRAM PASSED INCORRECT SQL ST
   SI59425      OSP-DB Internal Database Maintenance
   SI59355      OSP-DB Internal Database Maintenance
   SI59299      OSP-DB-OTHER-INCORROUT INCORRECT OUTPUT DEPENDING ON THE SPA
   SI59278      OSP-DB Internal Database Maintenance
   SI59252      OSP-DB Internal Database Maintenance
   SI59225      OSP-DB-OTHER-F/AIEAGERACTIVATOR-T/QQQUDFAC-MSGMCH4430 FTP OR
   SI59089      OSP-DB Internal Database Maintenance
   SI59002      OSP-DB Internal Database Maintenance
   SI59002      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOOUPCL-RCX'1720'-MSGMCH3203 CR
   SI58903      OSP-DB-OTHER-INCORROUT OPNQRYF ON DDM FILE REFERENCING V6R1
   SI58749      OSP-DB-OTHER-F/#MNRNRL-T/QQQVWCMP-MSGMCH3401 WITH SELECT FAI
   SI58666      OSP-DB-OTHER MSGMCH6903 T/QC2UTIL1 CAN BE SEEN WHEN THE REGE
   SI58652      OSP-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203 RUNNING
   SI58419      OSP-DB-OTHER-F/QQOOOINV-T/QQQOOODBOP-MSGMCH3202 Function Err
   SI58282      OSP-DB-OTHER Encoded Vector Index Include Case with Aggregat
   SI58226      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-RC1720-MSGMCH3203 STATE
   SI58226      OSP-F/QQQOOODBOP-T/QQQOOODBOP-MSGMCH1210 SQL SELECT FAILS WI
   SI58173      OSP-DB-OTHER-INCORROUT INCORRECT CCSID IS USED WHEN CAST A G
   SI58153      OSP-DB-OTHER Query INI Option ALLOW_EVI_ONLY_ACCESS support
   SI58096      OSP-DB-OTHER Internal Maintenance
   SI58070      OSP-DB-OTHER Query INI Option ALLOW_EVI_ONLY_ACCESS support
   SI58035      OSP-DB-OTHER-INCORROUT SPECIAL REGISTER VALUE INCORRECTLY RE
   SI57943      OSP-DB-OTHER Query INI Option ALLOW_EVI_ONLY_ACCESS support
   SI57839      OSP-DB-INCORROUT OPNQRYF OUTPUT MISSING RECORDS
   SI57833      OSP-DB-MSGMCH3601 in QQQVALID /proc BUILDIELIST using SQL LA
   SI57833      OSP-DB-INCORROUT Compare of DBCS Unicode data to SBCS data
   SI57664      OSP-DB-OTHER-INCORROUT WHEN USING THE GROUPING FUNCTION FIEL
   SI57602      OSP-DB-INCORROUT OPNQRYF OUTPUT MISSING RECORDS
   SI57370      F/QQQQUERY-MSGCPD438C CPD438C REASON CODE 18 IS RECEIVED WHE
   SI57265      OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
   SI57120      OSP-DB-INCORROUT OPNQRYF OUTPUT MISSING RECORDS
   SI57012      OSP-OTHER-PERFM COGNOS QUERY IS TAKING TOO LONG TO COMPLETE
   SI56923      OSP-DB-OTHER Scalar Function Support
   SI56909      OSP-DB-OTHER-INCORROUT RCAC - EMBEDDED SQL NOT RETRIEVING EX
   SI56811      OSP-DB-OTHER-INCORROUT OPNQRYF - RECORD SELECTION IS NOT WOR
   SI56781      OSP-DB-OTHER-RC2-MSGCPF426A AFTER DELETE OF A FUNCTION
   SI56737      OSP-DB QQQQUERY receives MCH3402 Object Destroyed during obj
   SI56661      OSP-DB-OTHER Scalar Function Support
   SI56596      OSP-DB-INCORROUT GRAPHIC and VARGRAPHIC scalar functions wit
   SI56596      OSP-DB-INCORROUT QUERY OF JOIN LOGICAL FILE WITH SELECT/OMIT
   SI56542      OSP-DB - SUPPORT SHARED AND PUBLIC MEMORY POOL NAMES IN QAQQ
   SI56412      OSP-DB Select from view fails when view uses function in QSY
   SI56302      OSP-DB-OTHER Scalar Function Support
   SI56269      OSP-DB-MSGMCH3601 in QQQSETUP for query of laterally correla
   SI56189      OSP-DB-INCORROUT Native Open of View With Column Access Cont
   SI56091      OSP-DB-OTHER Scalar Function Support
   SI56047      OSP-DB-OTHER Scalar Function Support
   SI55948      OSP-DB-OTHER Database Internal Maintenance
   SI55800      OSP-DB-MSGMCH1865 f/#dbvsisv t/QDBGETSQ for update using tim
   SI55648      OSP-DB-OTHER-F/QQQVALID-T/QSQRUN3-RC7-MSGCPD4383 ON QUERY WI
   SI55648      OSP-MSGCPF4204-D/TQQQQUERY STORED PROCEDURE DECLARE GLOBAL T
   SI55555      OSP-DB-MSGMCH0601 f/stringHighUse4K t/QQQVFMT for query with
   SI55513      OSP-DB-OTHER-F/QQQVWCMP-MSGMCH3601 WHEN CREATING A VIEW WITH
   SI55378      LIC-PERFM QUERIES AT R710 ARE RUNNING SLOWER UNLESS THE INLI
   SI55344      OSP-DB MSGCPD4318 when using Verify_Group_For_User with CCSI
   SI55326      OSP-DB-MSGMCH3601 f/QQQVFMT when using UDFs as parameters to
   SI55297      OSP-DB Internal Maintenance
   SI55219      OSP-DB Internal Maintenance
   SI55074      OSP-DB-OTHER-F/MNRESOLVECONTEXT-T/QQQUDFAC-MSGMCH3401 A VARY
   SI55001      OSP-DB-OTHER-PERFM QUERY CONTAINING MULTIPLE COMMON TABLE EX
   SI54983      OSP-OTHER-F/LOCKMIOBJECT-T/QQQSRVI1-MSGMCH5802 SQL0443 CPF43
   SI54979      OSP-DB-OTHER-F/QQQQUERY/BUILDAP-T/QQQQUERY/BUILDAP-MSGMCH360
   SI54961      OSP-DB REGEXP Scalar Function Support
   SI54747      OSP-DB-INCORROUT Query of SQL view with lateral correlation
   SI54687      OSP-DB-OTHER-F/QQQVFMT-T/SAME-MSGMCH3601 CREATE TABLE AS SEL
   SI54596      OSP-DB-OTHER-F/QQQVWCMP-T/QQQVWCMP-MSGMCH1210 SQL CREATE VIE
   SI54562      OSP-DB STRDPRAPY FAILS MSGMCH3203 X/1720
   SI54562      SQL-RUN-MSGCPI433ACPI433A EXPERIENCE LONG RUNNING PROCESSES.
   SI54562      OSP-DB-OTHER-T/QQQQUERYX/16860-MSGMCH3402 RUNNING A INSERT I
   SI54539      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-RC11-MSGCPD4318 A MSGCPD431
   SI54528      OSP-DB-OTHER QAQQINI file options not being honored
   SI54472      OSP-DB Internal Database Maintenance
   SI54298      OSP HOST VARIABLE WITH TRAILING BLANKS USED IN LIKE CLAUSE C
   SI54166      OSP-DB-OTHER-F/QQQQUERY-T/QQQQUERY-MSGCPF4204 SQL UPDATE STA
   SI54082      OSP-DB Internal Database Maintenance
   SI54082      OSP-DB-INCORROUT INSTEAD OF trigger not fired when open of S
   SI54069      OSP-DB-MSGMCH1819 When passing a null value to a UDF with a
   SI54021      OSP-DB-MSGSQL0332 not returned when using CCSID 937/935/1208
   SI54015      OSP-DB-MSGMCH3203 f/DbopQuery t/QQQOOODBOP for native open o
   SI53973      OSP-DB-MSGMCH3203 When using a default parameter in a UDF
   SI53931      OSP-DB-OTHER-F/QQQVSEL-T/QSQRUN3-MSGCPI431B A MSGCPI431B MAY
   SI53923      OSP-DB-MSGSQL0191 using LOB in SQL Stored Procedure
   SI53923      OSP-DB-OTHER-F/QDBGETM-T/DBPMNATIVEACCESS-MSGMCH1825 ON A _R
   SI53787      OSP-DB LPAD and RPAD Scalar Function Support
   SI53678      OSP-DB Internal Database Maintenance
   SI53644      OSP-DB Internal Database Maintenance
   SI53605      OSP-DB-OTHER-F/DBPMTRAP-MSGMCH3203 TRIGGER PROGRAM FAILS WIT
   SI53600      OSP-DB-MSGMCH3203 f/DbpmTrap t/QQQOOODBOP using NULLIF SQL s
   SI53600      OSP-DB-MSGCPD4305 in QQQVFMT UPDATE involving OLAP function
   SI53600      OSP-DB-OTHER-MSGSQL0443 MSGCPF503E DOUPLE QUOTE '"' BECOME '
   SI53364      OSP-DB Internal Database Maintenance
   SI53131      OSP-DB Internal Database Maintenance
   SI52994      OSP-DB Internal Database Maintenance
   SI52878      OSP-DB EVI WITH INCLUDE CAUSES JOBS TO HANG AFTER IPL
   SI52878      OSP-DB Internal Database Maintenance
   SI52839      OSP-DB Internal Database Maintenance
   SI52816      OSP-DB Internal Database Maintenance
   SI52704      OSP-DB Internal Database Maintenance
   SI52564      OSP-DB Internal Database Maintenance
   SI52487      OSP-DB Internal Database Maintenance
   SI52441      OSP-DB Internal Database Maintenance
   SI52441      OSP-DB-OTHER-INCORROUT WHEN OVERRIDING A TABLE TO ANOTHER TA
   SI52441      OSP-DB-OTHER  Keep Temp writer job (QQQTEMP1) from starting
   SI52283      OSP-DB InCorrOut Sequence object doens't return expected res
   SI52283      OSP-DB-OTHER-INCORROUT INCORROUT IN QUERY WITH LOB DATA AND
   SI52283      OSP-DB Incorrout with S/O logical file and NULL capable fiel
   SI52283      OSP ORDERING NOT CORRECT WHEN USING OLAP FUNCTION ROW_NUMBER
   SI52283      OSP-DB-OTHER-MSGCPD432B -  global variable object not found
   SI52283      OSP-DB-msgSQL0204 or msgSQL0440 UDF not resolved properly
   SI52235      OSP-DB Internal Database Maintenance
   SI52367      OSP-DB Internal Database Maintenance
   SI52172      OSP-DB Internal Database Maintenance
   SI52032      OSP-DB Internal Database Maintenance
   SI51985      OSP-DB Internal Database Maintenance
   SI51935      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4308 ON A SELECT FROM
   SI51882      OSP-DB Internal Database Maintenance
   SI51863      OSP-DB Internal Database Maintenance
   SI51717      OSP-DB Internal Database Maintenance
   SI51694      OSP-DB Internal Database Maintenance
   SI51663      OSP-DB Internal Database Maintenance
   SI51644      OSP-DB Internal Database Maintenance
   SI51629      OSP-DB Internal Database Maintenance
   SI51499      OSP-DB Internal Database Maintenance
   SI51465      OSP-DB INTERNAL MAINTENANCE
   SI51457      OSP-DB Internal Database Maintenance
   SI51408      OSP-DB Internal Database Maintenance
   SI51242      OSP-DB Internal Database Maintenance

Summary Information

System..............................i
Models..............................
Release.............................V7R2M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE64494
Superseded by:......................View fix details for PTF SI75095
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C6306720


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 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":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2","Product":{"code":"SG15V","label":"PTF Cover Letters - IBM i General"},"Component":"5770SS1","Edition":""},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2","Product":{"code":"SG16F","label":"PTF Cover Letters - IBM i 7.2"},"Component":"5770SS1","Edition":""}]

Document Information

Modified date:
05 February 2021