IBM Support

SI74325 - OSP-OSP-DB-DB-OTHER-F/QSQVTCHG-T/QSQVTCHG-MSGMCH1210 WHEN CR

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix
 
Abstract

OSP-OSP-DB-DB-OTHER-F/QSQVTCHG-T/QSQVTCHG-MSGMCH1210 WHEN CR


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770SS1  V7R2M0    SI61159   00/00    0000
PRE  5770SS1  V7R2M0    SI59618   00/00    0000
CO   5770SS1  V7R2M0    SI69070   00/00    0000
CO   5770SS1  V7R2M0    SI67303   00/00    0000
CO   5770SS1  V7R2M0    SI67245   00/00    0000
CO   5770SS1  V7R2M0    SI64209   00/00    0000
CO   5770SS1  V7R2M0    SI63611   00/00    0000
CO   5770SS1  V7R2M0    SI61172   00/00    0000
CO   5770SS1  V7R2M0    SI57932   00/00    0000
CO   5770SS1  V7R2M0    SI57941   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 CREATING A VIEW WITH A VERY LARGE NUMBER OF CTE'S AN
INTERNAL VARIABLE MAY OVERFLOW CAUSING THE MCH1210 AND
PREVENTING THE VIEW FROM BEING CREATED.

CORRECTION FOR APAR SE74401 :
-----------------------------
The problem is fixed with this PTF.

CIRCUMVENTION FOR APAR SE74401 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI69071      OSP-DB INTERNAL MAINTENANCE
   SI68916      OSP-DB-OTHER-UNPRED AN EXISTING PARTITIONED TABLE MAY NOT AL
   SI68452      OSP-DB-OTHER-MSGSQL0204 FOR SCHEMA ON SECONDARY IASP
   SI67616      OSP-MSGCPD5D02 CRTDUPOBJ CAN FAIL WITH CPD5D02 IF THE FILE H
   SI67302      OSP-DB-LOOP SQL GLOBAL VARIABLE CAUSES LOOPING OR MSGSQL7009
   SI67246      OSP-DB INFRASTRUCTURE
   SI66179      OSP-DB-OTHER-F/QSQDDL1-T/QSQDDL1-MSGMCH0601
   SI65304      SQL-RUN-UNPRED SYSTEM RUNS OUT OF TERASPACE STORAGE. SQL0901
   SI64964      OSP-DB-MSGSQL0204 ALTER TRIGGER using delimited trigger name
   SI64605      OSP-DB INTERNAL MAINTENANCE
   SI64532      OSP-DB Looping in QSQRCHK procedure NODETYP when processing
   SI64447      OSP-DB Internal Maintenance
   SI64431      OSP-DB Internal Maintenance
   SI64256      OSP-DB EXCESSIVE NATIVE OPENS OF QADBXRMTNM/QADBXRDBD FILES
   SI63859      OSP-DB-MSGSQL0901 ALTER TABLE adding a range partition using
   SI63617      OSP-DB MSGSQL0104 ALTER TABLE ADD PARTITION when using multi
   SI63610      OSP-DB-OTHER-SAP400-MSGSQL0636 ALTER TABLE ADD PARTITION RAN
   SI63158      OSP-DB-OTHER-LOOP QSQRUND MODULE QSQSWDS PROCEDURE SQSwitchD
   SI62985      OSP-DB-OTHER-F/QBNCRTBP-T/QBNCRTPG-MSGCPF5D02 IS RECEIVED WH
   SI62505      OSP-DB INTERNAL MAINTENANCE
   SI62290      OSP-DB INTERNAL MAINTENANCE
   SI61306      OSP-DB INTERNAL MAINTENANCE
   SI61174      OSP-DB Add prestart job detail to QSYS2.GET_JOB_INFO()
   SI60036      OSP-DB INTERNAL MAINTENANCE
   SI59989      OSP-DB Add PROCESS_ID and THREAD_ID global variables
   SI59616      OSP-DB Internal Maintenance
   SI59135      OSP-DB-MSGCPF8364-F/QDBGENSP-T/QDBGENSP SQL VARIABLE IO FAIL
   SI58796      OSP-DB Extended indicator setting not saved for SQL procedur
   SI58185      OSP-DB Allow extended indicators in dynamic sq in sql routin
   SI58166      OSP-DB INTERNAL MAINTENANCE
   SI58023      OSP-DB INTERNAL MAINTENANCE
   SI57933      OSP-DB-MSGSQL0206 when column not defined at precompile time
   SI57396      OSP-DB-OTHER-THREADS-UNPRED RDB() SHOWS BLANK FOR AN RPG PGM
   SI57134      OSP-DB Internal Maintenance
   SI57087      OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON
   SI56768      OSP-DB REMOVE FIELD PROC FROM TRANSITION TABLES
   SI56413      OSP-DB-MSGCPF5035-T/QSQTRGIO INSTEAD OF TRIGGER DELETE TRANS
   SI56366      OSP-DB-PERFM Improve performance of the QSYS2/RETURN_SQLPATH
   SI56289      OSP-DB ENHANCE QSYS2/GET_JOB_INFO
   SI56230      OSP-DB INTERNAL MAINTENANCE
   SI56224      OSP-DB-OTHER-UNPRED XSR OBJECTS FOUND MISSING AFTER IPL
   SI55795      OSP-DB INTERNAL MAINTENANCE
   SI55403      OSP-DB Improve LOB locator performance during commit or roll
   SI54801      OSP-DB-OTHER-F/QSQDDL1-T/QSQDDL1-MSGMCH1210 SQL CREATE TABLE
   SI54762      OSP-DB CREATE TRIGGER FAILS W/ TRANSITION TABLES OVER TABLE
   SI54041      OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
   SI53977      OSP-DB GET_JOB_INFO() output sometimes contains extraneous c
   SI53918      OSP-DB QSYS2.OVERRIDE_QAQQINI() do not take effect
   SI53778      OSP-DB Internal Maintenance
   SI53374      OSP-DB Internal Maintenance
   SI53256      OSP-DB-OTHER-LOOP QSQRUND PROCEDURE SQSWITCHDIAGSPACE
   SI52977      OSP-DB Internal Maintenance
   SI51382      OSP-DB Internal Maintenance
   SI52906      OSP-DB-MSGCPF8364-F/QDBGENSP-T/QDBGENSP SQL VARIABLE IO FAIL
   SI52902      OSP-DB ENHANCE QSYS2/GET_JOB_INFO
   SI52834      OSP-DB Internal maintenance
   SI52819      OSP-DB Internal Maintenance
   SI52750      OSP-DB-MSGSQL0604 CREATE TABLE with PARTITION BY RANGE using
   SI52686      OSP-DB UNABLE TO USE GENERATE SQL WITH PARTITIONED TABLE IF
   SI52686      OSP-DB UNABLE TO USE GENERATE SQL WITH PARTITIONED TABLE IF
   SI52686      OSP-DB-MSGSQL0423 running a SQL routine that has LOBs
   SI52455      OSP-DB INTERNAL MAINTENANCE
   SI52272      OSP-DB INTERNAL MAINTENANCE
   SI52014      OSP-DB INTERNAL MAINTENANCE
   SI51890      OSP-DB INTERNAL MAINTENANCE
   SI51757      OSP-DB Internal Maintenance
   SI51757      OSP-DB-OTHER-INCORROUT NO ROW RETURNED WHEN USING MQREQDALL
   SI51594      OSP-DB Internal Maintenance
   SI51467      OSP-MSGSQL0204 ALTER TABLE FAILS WHEN ADDING A CONSTRAINT. D
   SI51687      OSP-DB F/QSQSEQCDA-MSGSQL0601 Sequence operations with quali

Summary Information

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

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:
16 April 2021