IBM Support

SI72600 - OSP-DB-OTHER-INCORROUT Complex SQL security fix

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-INCORROUT Complex SQL security fix


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770999  V7R2M0    MF64158   00/00    0000
PRE  5770999  V7R2M0    MF62454   00/00    0000
PRE  5770SS1  V7R2M0    SI61104   00/00    0000
PRE  5770999  V7R2M0    MF60180   00/00    0000
PRE  5770999  V7R2M0    MF62422   00/00    0000
PRE  5770999  V7R2M0    MF60719   00/00    0000
PRE  5770999  V7R2M0    MF57614   00/00    0000
CO   5770SS1  V7R2M0    SI71244   00/00    0000
CO   5770SS1  V7R2M0    SI71239   00/00    0000
CO   5770SS1  V7R2M0    SI68101   00/00    0000
CO   5770SS1  V7R2M0    SI67985   00/00    0000
CO   5770SS1  V7R2M0    SI67529   00/00    0000
CO   5770SS1  V7R2M0    SI65881   00/00    0000
CO   5770SS1  V7R2M0    SI65783   00/00    0000
CO   5770SS1  V7R2M0    SI63696   00/00    0000
CO   5770SS1  V7R2M0    SI63695   00/00    0000
CO   5770SS1  V7R2M0    SI63263   00/00    0000
CO   5770SS1  V7R2M0    SI61559   00/00    0000
CO   5770SS1  V7R2M0    SI52481   00/00    0000
DIST 5770SS1  V7R2M0    SI55398   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

-------------------------------------------------
Complex SQL security fix

CORRECTION FOR APAR 'SE73081' :
-------------------------------
Complex SQL security fix.  CVE-2020-4345

CIRCUMVENTION FOR APAR 'SE73081' :
----------------------------------
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
--------------  ------------------------------------------------------------
   SI72351      OSP MULTIPLE INSERTS CAUSING MATRMD CONTENTION.
   SI72154      OSP-DB-OTHER-F/QQQVAP-T/QQQVAP-MSGMCH3601 MCH3402 MCH3601 CE
   SI72074      OSP-DB-OTHER-INCORROUT ACCESSING DDS LF WITH S/O LOGIC USING
   SI71825      OSP-DB-OTHER-F/QQQVAP-T/QQQVAP-MSGMCH3601 MCH3402 MCH3601 CE
   SI71563      OSP-F/QQQSVRTN-T/QQQSVRTN-MSGCPF426C-F/QQQSVRTN-T/QQQSVRTN-
   SI71552      OSP LONG OPTIMIZATION
   SI71243      OSP-DB-MSGSQL0443 f/QSQFETCH t/QSQRUN2 when select from view
   SI71242      OSP-DB Incremental Enhancement
   SI71067      OSP-DB Invalid JSON_OBJECTAGG query not resulting in an erro
   SI71067      OSP-DB-OTHER ATTEMPT TO CREATE A VIEW ON A JSON_TABLE RETURN
   SI70315      OSP-DB-MSGSQL0332 on binary character input to JSON_TABLE fu
   SI69991      OSP SQL FUNCTION FAILS WITH SQL0551
   SI69531      OSP-DB-OTHER USING A FUNCTION MAY FAIL WITH CPD432C
   SI69229      OSP-DB-MSGCPD432D When inlining a complex UDTF.
   SI69181      OSP-DB-OTHER-F/QQQVFMT-T/QQQVFMT-MSGMCH1210 MSGMCH1210 F/QQQ
   SI69159      OSP-MSGCPF426A USER DEFINED FUNCTION USING A VIEW THAT WAS R
   SI68766      OSP-DB-OTHER-F/STRINGHIGHUSE4K-T/QQQVWCMP-MSGMCH0601 CPF4204
   SI68766      OSP-DB-MSGMCH3203 f/DbpmTrap t/QQQOOODBOP proc/CALLDBMAINTFO
   SI69007      OSP-DB-OTHER-MSGSQL0204 A MSGSQL0204 MAY OCCUR WHEN QUERYING
   SI68744      OSP-DB-OTHER-F/QQURA-T/QQURA-MSGCPD4318 WHEN FORCING SQE_NAT
   SI68696      OSP-DB-OTHER-F/QQQSRVI1-T/QQQVFMT-MSGCPF9898 UPDATE_SS_UDF_E
   SI68678      OSP-MSGCPI4323 ACCESS PATHS REBUILT WHEN THEY MAY NOT NEED T
   SI68611      OSP-DB-OTHER-F/QQQVWCMP-T/QQQVWCMP-MSGMCH3601 QUERY FAILING
   SI68598      OSP-DB-MSGMCH3203 f/DbpmTrap t/QQQOOODBOP proc/CALLDBMAINTFO
   SI68598      OSP-DB-MSGMCH3203 f/DbpmTrap t/QQQOOODBOP proc/CALLDBMAINTFO
   SI68559      OSP-DB-OTHER-F/QQQQUERY-T/QQQQUERY-MSGCPD4388 SQL0901 CPD438
   SI68465      OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGSQL0129 SQL FAILING WI
   SI68462      OSP-DB INCORROUT SQL LATERAL JOIN
   SI68449      OSP-DB-OTHER-INCORROUT CREATE TABLE AS - IDENTITY COLUMN ATT
   SI68320      OSP-PAR-940XBASE INCREASE IN CPYTOIMPF RUN TIME AFTER UPGRAD
   SI68214      OSP-DB MSGSQL0901 when operand of JSON_OBJECT contains a fun
   SI68198      OSP-F/QQQOOODBOP-T/QQQOOODBOP-MSGMCH3601 MCH3601 F/QQQOOODBO
   SI68185      OSP-DB Reduce query space usage
   SI68185      OSP-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203 OPEN OF
   SI68165      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F
   SI68098      Internal Maintenance
   SI67989      OSP-DB-PERFM INLINED SQL TABLE FUNCTION
   SI67950      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0334 SETTING PARAMETE
   SI67877      Internal Maintenance
   SI67865      OSP-DB-OTHER-F/QQQSRVI1-T/*SAME-MSGMCH3601 QQALLOC_HEAP_SPAC
   SI67740      OSP-F/MNRESOLVECONTEXT-T/QQQVWCMP-MSGMCH3401 MSGMCH3401 F/MN
   SI67626      OSP-DB-OTHER-F/QQQOVALID-MSGCPF4131 MSGCPF4131 F/QQQVALID EV
   SI67527      OSP-DB Database Monitor Internal Maintenance
   SI67422      OSP-DB-OTHER-INCORROUT UDTF - 'NO EXTERNAL ACTION'
   SI67306      Internal Maintenance
   SI67188      Internal Maintenance
   SI67125      OSP-DB Database Monitor Internal Maintenance
   SI67099      OSP-F/QQQDBLOG-T/QQQDBLOG-MSGCPD4382 CPD4382 RECEIVED FOR GU
   SI66895      OSP-DB-OTHER-F/QQQSRVI1X/1357-T/QQQVALIDX/49320 WITH RCAC ON
   SI66884      OSP-DB-MSGCPF9898 f/QQQSRVI1 using large LOB global variable
   SI66874      OPS-DB Change result data type of TO_TIMESTAMP to TIMESTAMP(
   SI66874      OSP-DB-MSGCPF9898 F/QQQSRVI1 T/QQQOOODBOP (QQQDTQRO) using A
   SI66548      OSP-DB Database Monitor Internal Maintenance
   SI66493      F/QDMSIGNL-MSGCPF413 F/QDMSIGNL-MSGCPF4131 LVLCHK IS NOT ISS
   SI66449      OSP-DB-MSGMCH3203-RC1720 F/DBOPNODE-MSGMCH3203-RC1720
   SI66246      Internal Maintenance
   SI66114      OSP-F/QDBRCACX/1603-T/QQQVALID/X48481-MSGCPF3202 JOBS WORKIN
   SI66053      OSP-DB Internal Maintenance
   SI66049      OSP-DB-OTHER-F/QQQVFMT-T/QSQRUN3-MSGCPD4311 STATEMENT TOO LO
   SI66031      OSP-DB IBM i enhanced support for LIMIT and OFFSET.
   SI65968      OSP-DB-OTHER-F/EXSNDPM-T/QQQQUERY-MSGMCH1819 OPNQRYF APPLICA
   SI65961      Db2 for IBM i Internal Maintenance
   SI65955      OSP-DB IBM i enhanced support for LIMIT and OFFSET.
   SI65927      OSP-DB IBM i enhanced support for LIMIT and OFFSET.
   SI65921      OSP-DB IBM i enhanced support for LIMIT and OFFSET.
   SI65880      OSP-DB IBM i enhanced support for LIMIT and OFFSET.
   SI65880      OSP-DB IBM i enhanced support for LIMIT and OFFSET.
   SI65836      Internal Maintenance
   SI65784      OSP-DB IBM i enhanced support for LIMIT and OFFSET.
   SI65748      Internal Maintenance
   SI65714      OSP-DB-DB-OTHER-F/DBOPNODE-T/QQQOOODBOP-MSGMCH3203 MSGMCH320
   SI65682      Internal Maintenance
   SI65559      OSP-DB-OTHER-INCORROUT CPYTOIMPF THE WRONG DECIMAL POINT CHA
   SI65559      OSP-DB-OTHER-INCORROUT CPYTOIMPF THE WRONG DECIMAL POINT CHA
   SI65400      OSP-DB-OTHER-RC6-MSGCPD43A4 USING A FILE WITH RCAC IN AN SQL
   SI65376      F/QQQSRVI1-MSGCPF9898 VWCMP - DID NOT FIND POINTER MSGCPF989
   SI65366      OSP-DB Internal Maintenance
   SI65342      OSP-DB System i enhanced support for LIMIT and OFFSET.
   SI65178      OSP-DB-OTHER Support to control data copy allowance for open
   SI65149      OSP-DB-OTHER-F/QQQVALID-T/QSQCRTV-MSGCPD437F WITH COMPLEX JO
   SI65092      OSP-DB-OTHER-WAIT DELETE QUERY OVER SQL TABLE DELAYED 2 SECO
   SI65014      OSP-DB System i LISTAGG SQL Function Multiple Fixes
   SI64996      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0408 RUNNING AN UPDAT
   SI64996      OSP-DB-MSGMCH3203 f/DbstMdContextBase t/QQQOOODBOP mod/QQQOO
   SI64989      OSP-DB-OTHER MSGCPD4328 F/QQQVFMT T/QDBRSPRE MSGCPF4278 F/QQ
   SI64973      OSP-DB MSGMCH3402 F/QQQSRVE1 T/QQQSRVE1 AFTER DB GROUP 4 AND
   SI64796      F/ASSERT-MSGMCH3203-RC1720-MOD/ASSERT SP UPDATE SQL SENTENCE
   SI64768      Internal Maintenance
   SI64640      OSP-DB Internal Maintenance
   SI64508      F/QSQROUTS-MSGSQL0313 RANDOM SQL0313 ON TOOLBOX CONNECTION S
   SI64475      OSP-DB-OTHER-F/QQQSRVE1-MSGMCH3601 A MSGMCH3601 F/QQQSRVE1 F
   SI64475      OSP-DB-OTHER-F/QQQSRVE1-MSGMCH3601 A MSGMCH3601 F/QQQSRVE1 F
   SI64456      OSP-DB-OTHER-INCORROUT DSPFFD SHOWS INCORRECT BUFFER INFORMA
   SI64427      OSP-DB-OTHER-INCORROUT BIDI ISSUE.
   SI64319      OSP-DB-OTHER-F/DBSTMDDADDATASPACECONCRETE-T/QQQOOODBOP- MSGM
   SI64257      Internal Maintenance
   SI64022      OSP-DB System i XML publishing function special character es
   SI64014      Internal Maintenance
   SI63984      OSP-DB-OTHER Rebuild Access Plan too often for partition tab
   SI63899      OSP-DB-OTHER-F/QDBIOERRQO-T/QSQRUN2-MSGCPF5023 MERGE STATEME
   SI63818      QRY-OTHER-THREADS-UNPRED TRUNCATES OUT OF QQQSRVI1 CAUSE FRA
   SI63776      LIC-DB-PERFM improved expression evaluator performance
   SI63734      OSP-DB WHEN CALLING A UDF *LIBL IS NOT BEING USED TO LOCATE
   SI63693      Internal Maintenance
   SI63693      OSP-DB-OTHER Allow more then 8192 literals values in a query
   SI63622      OSP-DB-MSGMCH3601 using inlined UDF with a parameter that ha
   SI63530      OSP-DB-MSGMCH4429 using nested subqueries or nested UDTFs th
   SI63494      OSP-DB Internal Database Maintenance
   SI63283      OSP-DB-OTHER-INCORROUT INCORRECT FIELD CCSID AFTER REPLICATI
   SI63220      OSP-DB-OTHER-INCORROUT QSQPRCED DROP CREATE FUNCTION UDTF
   SI62988      OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH3601 MSGMCH3601 F/Q
   SI62900      OSP-DB-MSGMCH3203 F/DbpmTrap T/QQQOOODBOP for invalid GROUP
   SI62900      OSP-DB-OTHER-INCORROUT ATTRIBUTE OF ID COL IN CREATE TABLE A
   SI62885      OSP-DB-MSGMCH5601 f/t RmslUnlockMiObject/QQQQEXIT executing
   SI62851      OSP-DB-OTHER-F/QQQQUERY-T/QQQQUERY-MSGMCH3601 ON QUERY USED
   SI62835      OSP-DB-MSGCPD432B Query of UTF-16 global variable based on u
   SI62835      OSP-DB-MSGMCH3203 f/DbpmTrap t/QQQOOODBOP using NULLIF scala
   SI62835      OSP-DB-MSGMCH3203 f/DbpmTrap t/QQQOOODBOP using recursive co
   SI62835      OSP-DB-f/QQQSRVV1-MSGCPD432D when inlining UDF with a select
   SI62799      OSP-DB System i XML publishing function special character es
   SI62561      OSP-DB-OTHER-F/QSQCRTV-T/QQQVSEL-MSGCPD4329 MSGCPD4329 F/QSQ
   SI62602      Internal Maintenance
   SI62542      Internal Maintenance
   SI62532      OSP-DB Internal Database Maintenance
   SI62487      OSP-DB Internal Database Maintenance
   SI62461      Internal Maintenance
   SI62458      F/QQQVALID-MSGCPD433F CPD433F F/QQQVALID T/QSQPREP
   SI62247      OSP-SRCB6000317-UNPRED SYSTEM CRASH
   SI62156      OSP-DB-MSGSQL0332 CHARACTER CONVERSION BETWEEN CCSID 273 AND
   SI62039      OSP-DB Internal Database Maintenance
   SI61563      OSP-DB-OTHER Allow more then 8192 literals values in a query
   SI61560      OSP-DB INFRASTRUCTURE
   SI61488      OSP-DB Internal Database Maintenance
   SI61320      OSP-DB Internal Database Maintenance
   SI61106      OSP-DB Internal Database Maintenance
   SI61066      OSP-PAR PRESTART JOBS ARE NOT CLEANING UP MUTEXES WHEN ENDIN
   SI60494      OSP-DB-OTHER-THREADS-F/QQQSRVE1-T/QQQSRVE1-MSGMCH3601 MCH360
   SI60486      OSP-INCORROUT SQL GET DESCRIPTOR RETURNS ERRONEOUS VALUES FO
   SI60388      OSP-DB Internal Database Maintenance
   SI60543      OSP-DB-OTHER Internal maintenance.
   SI60333      OSP-DB Internal Database Maintenance
   SI60308      OSP-DB-OTHER-INCORROUT SQL INSERT WITH OVRDBF NOT
   SI60250      OSP-DB Internal Database Maintenance
   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
   SI60304      OSP LIBRARIES NOT CORRECTLY CHECKED WHEN RESTORING A VIEW TH
   SI60214      OSP-DB-OTHER-F/QQQOOODBOP-T/QQQOOOXTOC-MSGMCH3601 MCH3601 F/
   SI59597      OSP-DB-MSGMCH1210 f/QQQQUERY t/QQQQUERY proc/CRTNEWQDT
   SI59582      OSP-DB-OTHER-LOOP QSYS/QQQSVIMP-QQQINMAP:BLDINPUTMAPPING+0X2
   SI59346      OSP-DB-OTHER-T/QDZXDBX/02F3-MSGCPF5109 UPDATING FIELD PROC A
   SI58364      OSP-DB-OTHER-F/QQQOPTIM-T/QQQOPTIM-MSGMCH3601 MSGMCH3601 F/Q
   SI58065      OSP-DB-OTHER-F/QQQOPTIM-T/QQQOPTIM-MSGMCH1210 HA SOFTWARE IS
   SI57222      OSP-DB-OTHER Extended Unicode Support for UPPER and LOWER Sc
   SI57122      OSP-DB-INCORROUT OPNQRYF OUTPUT MISSING RECORDS
   SI57072      OSP-INCORROUT RESTORE OF LIBRARY TO DIFFERENT LIBRARY - VIEW
   SI56150      OSP-DB-OTHER-INCORROUT ON V7R2 QU1 QUERIES WILL NOW MAKE USE
   SI55980      OSP-DB-OTHER-F/QQQPDCMP-T/QQQPDCMP-MSGMCH3601 MSGMCH3601 F/Q
   SI55556      OSP-DB-MSGMCH0601 f/stringHighUse4K t/QQQVFMT for query with
   SI55414      OSP-DB Incremental Enhancement
   SI54749      OSP-LOOP JOB IS LOOPING ON QQQTSORT
   SI54333      OSP-DB-OTHER-INCORROUT A SELECT QUERY WITH A SUBSELECT MAY C
   SI54985      OSP-DB-Other Internal Database Maintenance
   SI54748      OSP-DB-MSGMCH3203 f/dbpmtrap t/QQQOOODBOP MIN or MAX with ro
   SI54563      OSP-DB-OTHER-T/QDBCRTMEX/-MSGMCH5601X/1368 CREATE INDEX OVER
   SI53133      OSP-DB Internal Database Maintenance
   SI52996      OSP-DB Internal Database Maintenance
   SI52881      OSP-DB-MSGCPD4301 f/QQQVFMT t/QSQRUN3 running query with lat
   SI52566      OSP-DB-OTHER-INCORROUT WHEN OVERRIDING A TABLE TO ANOTHER TA
   SI52703      OSP-DB-MSGMCH5601 F/#DBCINX T/QDBCRTME when restoring an SQL
   SI52444      OSP-DB Internal Database Maintenance
   SI51987      OSP-DB Internal Database Maintenance
   SI51664      OSP-DB Internal Database Maintenance
   SI51245      OSP-DB Internal Database Maintenance

Summary Information

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


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