IBM Support

SI43259 - OSP-DB-MSGMCH1210 F/QQQVFILE during upgrade from V5R4M5 to V

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-MSGMCH1210 F/QQQVFILE during upgrade from V5R4M5 to V


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF51181   00/00    0000
PRE  5770999  710  MF49199   00/00    0000
CO   5770SS1  710  SI42965   00/00    0000
CO   5770SS1  710  SI42966   00/00    0000
CO   5770SS1  710  SI42967   00/00    0000
CO   5770SS1  710  SI42964   00/00    0000
CO   5770SS1  710  SI42541   00/00    0000
CO   5770SS1  710  SI40163   00/00    0000
CO   5770SS1  710  SI36909   00/00    0000
DIST 5770SS1  710  SI41934   00/00    0000
DIST 5770999  710  MF50983   00/00    0000
DIST 5770999  710  MF50492   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

-----------------------------------------------
When doing an ALTER TABLE of a table that is referenced by a
join logical file and the join logical file is referenced by an
SQL view, code was being executed that caused an incorrect array
reference to be made.

CORRECTION FOR APAR SE47564 :
-----------------------------
Code has been changed to avoid the array reference for this
scenario.

CIRCUMVENTION FOR APAR SE47564 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI43242      OSP-DB-OTHER-UNPRED LOCATE CODE USING MAX INSTEAD OF CASE
   SI43242      OSP-DB-OTHER-UNPRED MCH1210 F/QQQOOODBOP
   SI43226      OSP-DB-MSGMCH1210 from QQQOOOUPCL from omnifind query
   SI42963      OSP-DB Connect by support
   SI42884      OSP-DB-OTHER-F/QQQVALID-T/QQQVALID-MSGMCH0601 SQL SELECT FAI
   SI42824      OSP-DB-OTHER-T/QQQSRVE1-MSGMCH1210 Module/QQQGTSPC CREATESPA
   SI42799      OSP-DB Excessive optimization for nested UDFs that were inli
   SI42747      OSP-DB-OTHER-INCORROUT INCORROUT WHEN USING SO JOIN LOGICAL
   SI42635      OSP-DB-MSGCPD4307 from QQQVFMT when prepare with host variab
   SI42632      OSP-DB-OTHER-F/QQQQUERY-T/QQQQUERY-MSGMCH0601 RPG PROGRAM AC
   SI42632      OSP-DB-OTHER-F/QQQSRVE1-T/QSQSBAS2-MSGCPD4392 SQL PROCEDURE
   SI42632      OSP-DB INCORROUT OUTPUT FROM A SELECT OVER A SELECT/OMIT IND
   SI42632      OSP-DB-OTHER-F/QQQVALID-T/QQQVALID-MSGCPD4318 SQL UPDATE STA
   SI42467      OSP-DB Support of SQL Scalar UDF Inlining
   SI42549      OSP-DB-MSGMCH1211  from QQQVFMT while vary on IASP
   SI42442      OSP-DB Internal maintenance
   SI42442      OSP-DB-MSGSQL0901 SQL expression evaluator returned when cal
   SI42408      OSP-DB-MSGMCH3601 t/QQQQUERY proc/CHECK_LOB_LOCKING
   SI42325      OSP-MSGMCH4429-f/QQQVFMT when inlining a UDF that calls itse
   SI42325      OSP-DB Internal maintenance
   SI42246      OSP-DB Internal maintenance
   SI42246      OSP-DB-MSGMCH3203 from QQQOOODBOP when casting numeric to pu
   SI42246      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH1819 JAVA PROGRAM RECEIVES M
   SI42230      OSP-INCORROUT WRONG OUTPUT WITH JOIN SELECT/OMIT LOGICAL FIL
   SI42198      OSP-DB Internal maintenance
   SI42141      OSP-DB-MSGMCH3203 from QQQOOODBOP with CCSID translation
   SI41987      OSP-DB-MSGMCH3601-f/QQQVAP when inlining a sql scalar udf
   SI41987      OSP-DB SQE Support of Multi dataspace logical
   SI41978      OSP-DB SQE Support of Logical Files - one spec, no case
   SI41960      OSP-DB-MSGMCH5003 F/T QQQVFMT when using LAND/LOR/XOR with p
   SI41933      OSP-DB Internal maintenance
   SI41933      OSP-DB Remove substitution character msg on EBCDIC translate
   SI41915      OSP-DB Parameter marker enhancement in COALESCE/VALUE scalar
   SI41856      OSP-DB-MSGMCH3601 from QQQVAP - inline UDF fix
   SI41852      OSP-DB Parameter marker support in TRANSLATE scalar function
   SI41840      OSP-DB-OTHER-F/EXSNDPM-T/QQQQUERY-RC01-MSGMCH1819 SELECT QUE
   SI41840      OSP-DB-OTHER-T/QSQRUN3X/26628-MSGSQL0420 AFTER INSTALLING CU
   SI41840      OSP-DB Internal maintenance
   SI41767      F/QQQVAP-MSGMCH1201-MOD/QQQVAP F/QQQVAP-MSGMCH1201-MOD/QQQVA
   SI41767      OSP-DB-OTHER-F/QQQVAP-T/QQQVAP-MSGMCH1210 SQL CCSID CONVERSI
   SI41767      OSP-DB-MSGSQL0403 when using Date, Time, or Timestamp types
   SI41767      OSP-DB QQQQUERY: initialize QDT fields on ?CRTQAP
   SI41751      OSP-DB-MSGMCH3402  From DpbmTranslateOperation
   SI41750      OSP-DB-OTHER-F/QQQVFMTX/2880-MSGCPD4363RC17 SELECT STMT ERRO
   SI41750      OSP-DB-OTHER-F/QQQSRVI1-T/QQQSRVI1-MSGMCH1210 RUNNING APP FO
   SI41731      OSP-DB-OTHER-F/QDBSIGEX-T/QSQRUN3-RC20-MSGCPF5035 CPF5035 RC
   SI41674      OSP-DB Internal maintenance
   SI41639      OSP-DB-MSGCPF9898 f/QQQFNCHK NQE: ICU operand is not utf16/u
   SI41612      SMU-DB-OTHER-MSGSQL7054 MSGSQL7054 AND MSGCPF428E FOR QIBM_Q
   SI41602      OSP-DB Parameter marker support in TRANSLATE scalar function
   SI41588      OSP-DB Internal maintenance
   SI41553      OSP-DB Parameter marker extensions support - iteration 4
   SI41518      OSP-DB Internal maintenance
   SI41518      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F
   SI41499      OSP-DB-MSG-F/QQQVALID-T/QQQVALID QUERY LOGICAL FILE WITH FIE
   SI41490      OSP-DB Internal maintenance
   SI41445      OSP-DB Internal Maintenance
   SI41438      OSP-DB-OTHER-F/QQQIMPLE-T/QQQIMPLE-MSGMCH3601 MCH3601 DURING
   SI41438      OSP-DB-MSGSQL0243 on sensitive cursor
   SI41374      OSP-DB inlining udfs authority considerations
   SI41356      OSP-DB OVRDBF function to support buffer length for query
   SI41314      OSP-DB-MSGCPD4329 from QQQVSEL
   SI41286      OSP-DB-OTHER-INCORROUT OVRDBF OVERRIDES A SQL ALIAS
   SI41249      OSP-DB Incorrect length using a parameter markers and a dbcl
   SI41212      OSP-DB Parameter marker extensions support - iteration 3 (pa
   SI41212      OSP-DB Internal maintenance
   SI41190      OSP-DB Internal Maintenance
   SI41168      OSP-DB Internal maintenance
   SI41138      OSP-DB Parameter marker extensions support - iteration 3 (pa
   SI41066      OSP-DB Internal maintenance
   SI41042      OSP-DB-MSGMCH3601-f/QQQVFMT when running subquery
   SI41031      OSP-DB-OTHER-PERFM INSTEAD OF INSERT TRIGGER PERFORMANCE IN
   SI41019      OSP-DB-MSGMCH1210 from QQQITEMP
   SI40963      OSP-DB Parameter marker extensions support - iteration 3 (pa
   SI40963      OSP-DB inlining udfs with parameters
   SI40944      OSP-DB SQE Support of Multi dataspace logicals
   SI40888      OSP-DB-MSGMCH1819 F/T ExSndPm/QQQQUERY
   SI40860      OSP-DB-SQL  Timestamp_format use of Apostrophe fails
   SI40833      OSP-DB-MSGCPD4302 when trying to inline a udf
   SI40833      OSP-DB-MSGMCH3601 from QQQGET
   SI40833      OSP-DB-MSGCPD4002 Key mapping error in field *N member EVITB
   SI40809      OSP-DB-OTHER-INCORROUT FORMAT LEVEL ID DIFFERENCES BETWEEN T
   SI40799      OSP-DB-OTHER-F/QDBDLTFI-T/QSQBAS2-MSGCPF3220 MSGCPF3220 F/QD
   SI40747      OSP-DB-SQL Varchar_format & Timestamp_format additional Form
   SI40747      OSP-DB QAQQINI SQL_SCALAR_UDF_INLINE not valid
   SI40631      OSP-DB Send substitution character msg on EBCDIC translates
   SI40479      OSP-DB SQE Support of Multi dataspace logicals
   SI40450      OSP-DB compilation error from QQQVALID
   SI40447      OSP-DB-SQL Months_Between Consider time when parameters are
   SI40338      OSP-DB Parameter marker extensions support - iteration 2
   SI40312      OSP-DB SQL Scalar UDF Inlining - iteration 1
   SI40312      OSP-DB SQE Support of Multi dataspace logicals
   SI40214      OSP-DB-MSGMCH5003 f/#ccexcep t/QQQVFMT ASCII scalar function
   SI40214      OSP-DB-MSGMCH1819 IN predicate with date/time operand
   SI40214      OSP-DB-MSGMCH1819 T/QQQQUERY INAV SHOW TABLE INDEXES
   SI40124      OSP-DB-INCORROUT XMLrow with double-bytes characters in row-
   SI40097      OSP-DB Internal Maintenance QQQQUERY: initialize QDT fields
   SI40085      OSP-DB-MSGMCH1819 COALESCE function with UTF-8 and UCS-2 ope
   SI40073      OSP-DB QQQQUERY: initialize QDT fields on ?CRTQAP
   SI40050      OSP-DB-SQL BITAND, BITANDNOT,BITOR,BITXOR, and BITNOT functi
   SI40039      OSP-DB-SQL-MSGMCH3203  Queries with GROUP BY
   SI40029      OSP-DB-MSGCPD4301 from QQQVFMT on select from insert
   SI40015      OSP-DB bndpgm QQQQEXIT failed to create
   SI40015      OSP-DB-MSGCPD4318 Query with concatenation involving unicode
   SI39963      OSP-DB-SQL BITAND, BITANDNOT,BITOR,BITXOR, and BITNOT functi
   SI39921      OSP-DB-MSGCPF9812 OPNQRYF of DDM file
   SI39921      OSP-DB-MSGMCH3203 XML functions with double byte character n
   SI39921      OSP-DB-MSGMCH2603-f/QQQSRVE1 when using global variables and
   SI39835      OSP-DB-MSGCPF5032 f/QDBIOERRQO t/QSQFETCH MERGE using VALUES
   SI39835      OSP-DB-MSGCPD4349 order by fields are too long
   SI39800      OSP-DB-MSGCPF5035 Data mapping error on INSERT or UPDATE of
   SI39724      OSP-DB Parameter marker extensions support - iteration 1
   SI39585      OSP-DB incorrect refresh count for database monitor records
   SI39554      OSP-DB-MSGMCH3203 XMLAGG function with XMLAGG in order-by cl
   SI39547      OSP-DB-MSGCP9898 f/QQQSRVI1 t/QQQVSEL
   SI39547      OSP-DB-MSGCPD5036 Data mapping error when Logical file and f
   SI39509      OSP-DB-SQL   DEGREES and RADIAN functions internally restruc
   SI39472      OSP-DB-MSGCPD434C f/QQQQUERY t/QSQALTER altering SQL view
   SI39417      OSP-DB-MSGMCH0601 from qq module on Select from insert
   SI39380      OSP-DB-MSGMCH3601 from QQQDTQRO
   SI39380      OSP-DB-MSGMCH5003 From QQQSRVE1
   SI39353      OSP-DB-MSGCPD4318 from QQQVFMT for XMLFOREST when the job CC
   SI39353      OSP-DB-MSGCPD4301 Field not found on Select from insert
   SI39311      OSP-DB-MSGMCH3601-f/QQQVAP while validating index
   SI39311      OSP-DB-MSGMCH3203  Fix grouping sets problems
   SI39168      OSP-DB-OTHER-F/QQQQUERY-T/QQQQUERY-MSGMCH1210 CPYF FAILS WIT
   SI39168      OSP-DB-MSGMCH1820 in QQQQUERY for query with IN predicate
   SI39168      OSP-DB-MSGMCH3601 f/DbstMdDadDataSpaceConcrete t/QQQOOODBOP
   SI39168      OSP-DB-MSGCPF4268 f/QQQSRVV1 t/QSQRUN3 after refresh of MQT
   SI39168      OSP-DB-OTHER-F/QQQVSEL-T/QQQQRY-MSGCPF4278 WRKQRY CREATE FAI
   SI39168      OSP-DB EVI with include recovery
   SI39120      OSP-F/QQQVALID-T/QSQRUN3-MSGCPD4346 QUERY WITH SCALAR SUBSEL
   SI39120      OSP-DB-OTHER-F/QQQVFMT-MSGCPD4307 SELECT RRN IN UNIONS RESUL
   SI39029      OSP-DB Sequence objects used in a Merge query returns incorr
   SI39028      OSP-DB-OTHER-INCORROUT DRDA CLIENT CALLING FUNCTION THAT RET
   SI39028      OSP-DB-OTHER-F/QQQVFMT-T/QQQVFMT-MSGMCH1210 SQL UPDATE FAILS
   SI39019      OSP-DB-MSGMCH1819 CQE queries using fieldprocs
   SI38986      OSP-DB-SQL ORDER BY sort sequence and UTF-8 multiple levels
   SI38932      OSP-DB-MSGCPF7304 f/QDBINFLT t/QQQSRVV1
   SI38870      OSP-DB-MSGMCH1211 t/QQQVFMT/GETPARMCOMMOFFSET
   SI38854      OSP-DB-MSGMCH3601 creating procedure with array unnest funct
   SI38814      OSP-DB-SQL   DEGREES and RADIAN functions use DECFLOAT when
   SI38753      OSP-DB-INCORROUT CEILING and FLOOR scalar functions
   SI38707      OSP-DB-MSGMCH3601 in QQQVALID procedure TEMPSET
   SI38707      OSP-DB-MSGMCH1222 from QQQIOTMP
   SI38655      OSP-DB-SQL LOB column in query consumes temporary storage
   SI38655      OSP-DB-OTHER-INCORROUT DECIMAL SETTING DIFFERENCE CAUSES WRO
   SI38655      OSP-DB-OTHER-INCORROUT JT400 APPLICATION RETURNS INCORRECT R
   SI38612      OSP-DB-MSGMCH3601 Re-usable queryies using SQL Arrays
   SI38603      OSP-DB Internal Maintenance
   SI38535      OSP-DB USING A FUNCTION FAILS MSGCPD43AB F/QQQVSEL T/QSQRUN1
   SI38535      OSP-DB Incorrect output using a global variable path set to
   SI38535      OSP-DB-INCORROUT CEILING and FLOOR scalar functions
   SI38470      OSP-DB-MSGMCH3601 Query Logical File Field Procedure field
   SI38470      OSP-DB-SQL LOB column in query consume Temporay Space
   SI38414      OSP-DB-MSGCPF4268 Format not found for derived table query
   SI38414      OSP-DB-MSGMCH1210 length of order by fields is larger than 2
   SI38414      OSP-DB-MSGMCH3601 f/t cmpptra/QQQOOODBOP
   SI38338      OSP-DB-OTHER-F/QQQPDCMP-T/QQQPDCMP-MSGMCH1210 AN INTERNAL QU
   SI38338      OSP-DB-SQL- MSGMCH1210 DBCLOB parameter of ARRAY_AGG
   SI38338      OSP-SQL SQ20425 for CONTAINS and SCORE functions
   SI38338      OSP-DB-MSGCPD4363 Query with numeric compared to character s
   SI38338      OSP-DB-MSGCPD434A Cast of character string to BLOB
   SI38173      OSP-DB-MSGCPD4318 from QQQVFMT with binary data in XML funct
   SI38114      OSP-DB-SQL   Array_AGG fails when underlying table is change
   SI38105      OSP-DB-MSGMCH3601 From QQQOOODBOP select from insert
   SI38062      OSP-DB-MSGCPI4323 Excessive access plan rebuilds
   SI38062      OSP-DB-INCORROUT wrong CCSID for XML result from XMLAGG func
   SI38002      OSP-DB-SQL   Parameter Markers with types of Date,Time, and
   SI37940      OSP-DB-MSGCPF9898 function with XML CAST FROM
   SI37922      OSP-DB-MSGMCH3601 from QQQOOODBOP with CHAR function
   SI37879      OSP SQL IS FAILING WITH DATA MAPPING ERRORS.
   SI37834      OSP-DB-MSGMCH5003-f/QQQSRVE1 when using arrays
   SI37826      OSP-DB-OTHER-T/QDBOPEN-MSGMCH3601 INTERMITTENTLY ON OPNDBF
   SI37806      OSP-DB Database monitor internal maintenance
   SI37806      OSP-DB-MSGCPD439C  during create EVI index
   SI37806      OSP-DB Internal Maintenance
   SI37737      OSP-DB-MSGMCH1210 f/t QQQSVRTN/QQINVUDF/IMPLEMENTUDTFINSQE
   SI37721      OSP-DB-MSGSQL0901 Select from insert statement with user def
   SI37702      OSP-DB-SQl  IS NULL Predicates with Host Variable Array as t
   SI37633      OSP-DB-OTHER OLAP functions not working properly.
   SI37615      OSP-DB-OTHER-F/#DBCOMMIT-T/QTNOPNCLS-RC1716-MSGMCH3203 QUERY
   SI37615      OSP-DB-MSGMCH1819 CQE Grouping query with fieldprocs
   SI37544      OSP-DB-MSGMCH3601-F/QDMGETOV during restore of files
   SI37523      OSP-DB-MSGMCH3601-f/QQQSRVE1 when using database monitor and
   SI37479      OSP-DB CRTDUPOBJ of aggregate EVI is incorrect
   SI37464      OSP-DB-MSGCPD4392 using a date global variable
   SI37460      OSP-DB- INCORROUT result CCSID of SOUNDEX function
   SI37424      OSP-DB-MSGMCH1210 Using database monitor and Expression eval
   SI37398      OSP-DB-OTHER-PERFM NEW QAQQINI OPTION, DETERMINISTIC_UDF_SCO
   SI37398      OSP-DB-MSGCPD434A CAST of CURRENT SERVER to unicode CCSID
   SI37361      OSP-DB-MSGMCH0601 F/T QQQSVIMP/QQQSVIMP when CQE and fieldpr
   SI37353      OSP-DB-MSGMCH5003-f/QQQSRVE1 when using lobs
   SI37334      OSP-DB-F/QQQSRVE1-MSG1210 5 or more Array_agg function in a
   SI37328      OSP-DB Internal Maintenance
   SI37261      OSP-DB-MSGMCH3601-f/QQQOOODBOP when using a UDTF and right o
   SI37240      OSP-DB Database monitor maintenance
   SI37195      OSP-DB-F/QQQSRVE1-MSG1210 Date/Time/Timestamp with UNNEST Fu
   SI37151      OSP-DB Longer Schema Support
   SI37151      OSP-DB-MSGMCH3203 query with values clause
   SI36867      OSP-DB-OTHER-F/QQQOOOUPCL-T/QQQOOOUPCL-MSGMCH0601 AFTER SOME
   SI37007      OSP-DB-MSGSQL0443 XSLTRANSFORM scalar function
   SI36934      OSP-DB-PERFM Slow performance for query with SQL view or tab
   SI36906      OSP-DB-INCORROUT XSLTRANSFORM returns incorrect results
   SI36871      OSP-DB-MSGMCH3401 f/qqqvfmt on QSQPTABL during RSTLIB
   SI36839      OSP-DB-INCORROUT XML publishing funtion
   SI36736      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0443 ENCOUNTED USING
   SI36695      OSP-DB-INCORROUT UDF XML output parameter
   SI36505      OSP-DB-MSGMCH3601 with XML publishing functions
   SI36467      OSP-DB-MSGCPF4268 format not found
   SI36462      OSP-DB-t/QQQSRVV1-MSGMCH3402 when using the contains functio

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE47564
Superseded by:......................View fix details for PTF SI75298
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C1270710


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.1","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.1","Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1"},"Component":"5770SS1","Edition":""}]

Document Information

Modified date:
16 April 2021