IBM Support

SI78389 - OSP-MSGMCH3402-D/TQQQSVRTN USING IFS_OBJECT_STATISTICS OVER

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-MSGMCH3402-D/TQQQSVRTN USING IFS_OBJECT_STATISTICS OVER


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
CO   5770SS1  V7R3M0    SI78672   00/00    0000
CO   5770SS1  V7R3M0    SI78671   00/00    0000
CO   5770SS1  V7R3M0    SI70856   00/00    0000
CO   5770SS1  V7R3M0    SI68083   00/00    0000
CO   5770SS1  V7R3M0    SI66885   00/00    0000
DIST 5770SS1  V7R3M0    SI75033   00/00    0000
DIST 5770SS1  V7R3M0    SI75034   00/00    0000
DIST 5770SS1  V7R3M0    SI74526   00/00    0000
DIST 5770SS1  V7R3M0    SI74321   00/00    0000
DIST 5770SS1  V7R3M0    SI69769   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 processing query using IFS_OBJECT_STATISTICS, the SQE
optimizer calls up to the OS with LOB storage that has been
destroyed, resulting in MCH3402 in the called code. The
optimizer needs to ensure that this storage does not get cleared
when performing the call to the OS.

CORRECTION FOR APAR SE76972 :
-----------------------------
The SQE optimizer will inform XPF that, for this query, the XPF
created LOB buffer should not be reset until query close.

CIRCUMVENTION FOR APAR SE76972 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI77325      OSP-DB-OTHER-T/QDBSRVPGM1-MSGMCH3402 MODULE QDBRSYNU
   SI77171      OSP-DB Internal Maintenance
   SI76992      OSP-INCORROUT-RWS-D/T5250 UPDATE FAILS IN RUNSQLSTM WITH 3 P
   SI76378      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0811 A MSGMCH1202 M
   SI76315      OSP-DB-QSQFETCH-Internal Maintenance
   SI76311      OSP-DB Internal Maintenance
   SI76214      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0501 SELECT USING THR
   SI75947      OSP-DB-MSGMCH6904-F/QSQVALUE F_GETBLK SQL ARRAY SQL SET STAT
   SI75815      OSP-DB-OTHER-F/QSQSBASMOD/QSQVATTRPROC/BUILDVALSENTRY- MSGMC
   SI75798      OSP-DB INTERNAL MAINTENANCE
   SI75796      OSP-DB-MSGSQL0900-F/QSQCLNUP SQL EXIT PROGRAM FIRES AT CONNE
   SI75530      OSP-DB SQL OPTION MONITOR=*SYSTEM NOT HONORED
   SI75446      OSP-DB-QSQFETCH MSGSQL0666 returned for Query Supervisor
   SI75429      OSP-DB Internal Maintenance
   SI75219      OSP-F/QSQRUN3-T/QSQRUN3-MSGSQL0423 MSGSQL0423 F/QSQRUN3 T/QS
   SI75032      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGSQL0501 AFTER PTF INSTAL
   SI74525      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-RC480-MSGSQL0904 MSGSQL09
   SI74441      OSP-DB-OTHER-F/#DBCPYFL-T/QSQRUN2-MSGMCH0601 IN QRWTSRVR JOB
   SI74319      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0507 MSGSQL0507 F/QSQ
   SI74150      OSP-DB-QSQFETCH-Incorrect message text for MSGSQL0802
   SI74148      OSP-DB-OTHER-F/#DBCPYFL-T/QSQRUN2-MSGMCH0601 IN QRWTSRVR JOB
   SI73932      OSP-DB-MSGSQL0423 with pipelined functions
   SI73301      OSP-DB-QSQINS-MSGSQL0462 warning on INSERT with 3 part name
   SI72873      OSP-DB-INTERNAL MAINTENANCE
   SI72355      OSP-Internal Maintenance
   SI72325      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2 RUNNING NODEJS ON IBM I AND
   SI72297      OSP-DB-OTHER-F/QSQADITM-RC8488-MSGSQL0901
   SI72022      OSP-DB DRDA QUERY TO A HOMOGENEOUS SERVER FAILS.
   SI71951      OSP-DB-QSQALCS-MSGSQL0904 Information for MSGSQL0904 reason
   SI71846      OSP-DB UDF not getting called in AR job with JDBC interface
   SI71819      OSP-DB-OTHER-UNPRED TEMPSTG ISSUE WHERE JOBS ARE ALLOCATING
   SI71816      OSP-DB-OTHER-INCORROUT INCORROUT FOR FUNCTIONS USING: IN_DAT
   SI71548      OSP-DB Fetch Relative with large RRN value fails
   SI70855      OSP-DB-MSGMCH3402 fetching LOB data from remote server
   SI70537      OSP-DB-OTHER-THREADS-F/QSQROUTX-T/QSQROUTX-MSGSQL0501 QUERY
   SI70379      internal maintenance
   SI70063      OSP-OTHER-F/QRWXFDOCA-T/QRWXFDOCA-MSGMSGMCH1210 MESSAGE MCH1
   SI69864      OSP-DB-OTHER-F/QQQQUERY-T/QSQRUN3-MSGCPD4388 SQL0901 SAP DEL
   SI69858      OSP-DB-OTHER-F/QRWSQRY-T/QRWSQRY-RCX'01'-MSGCPF3E33 QUERY OV
   SI69771      OSP-DB-OTHER IBM DB2 DRIVER FOR JDBC AND SQLJ INCORRECT SPAN
   SI69557      OSP-DB-OTHER-F/STRINGHIGHUSEX/0118-T/QSQRUN2/52748-MSGMCH360
   SI69151      OSP-DB-INTERNAL MAINTENANCE
   SI68922      OSP-DB-MSGMCH1202 fetching data in a CLI program with differ
   SI68750      OSP-DB-OTHER-T/QSQISE-MSGMCH3402
   SI68693      OSP-F/STRINGHIGHUSE-T/QSQROUTE-MSGMCH0601 SQL PROGRAM FAILS
   SI68441      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGMCH3601 FETCH FROM RESUL
   SI68441      OSP-DB-QSQVALUE-INCORROUT Dynamic Values Into with indicator
   SI68109      OSP-DB-OTHER-PERFM HIGH TEMPORARY STORAGE FROM BUCKET 12 (DS
   SI68086      OSP-DB-MSGSQL0423 FETCHING CLOB DATA
   SI68086      OSP-DB Internal Maintenance
   SI68069      OSP-DB-OTHER-F/QSQXCUTEX/32508-T/SAME-MSGSQL0904 INSERT RECO
   SI67948      OSP-DB-OTHER-F/STRINGHIGHUSE-T/QSQRUN4-MSGMCH3601 MSGMCH3601
   SI67784      OSP-DB-OTHER-F/QSQBAS-T/QSQBAS-MSGMCH3601 WHEN SWITCHING USE
   SI67452      OSP-DB-MSGCPF3E33-F/QRWSARDB SQL RELEASE ALL
   SI67400      OSP-DB-OTHER-F/QSQROUTE-MSGMCH0601 A MSGMCH0601 F/QSQROUTE F
   SI67307      OSP-DB-OTHER-F/QSQRUN3X/33441-MSGSQ30020 INSERT...SELECT FRO
   SI67107      OSP-DB-OTHER-MSGSQL0443 INCORROUT-MESSAGE TEXT CORRUPTED
   SI66883      OSP-DB Temp Storage growth with CLOBs in UDTF
   SI66559      OSP-DB Internal Maintenance
   SI66251      OSP-DB-OTHER-F/QZDASRV-T/QZDASRV-MSGMCH1210 EXTRANEOUS COMMO
   SI66533      OSP-MSGSQL0076 OSP-MSGSQL0076 - CSSID GRAPHIC CONVERSION ISS
   SI66196      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0514 A MSGSQL0514 MAY
   SI66158      OSP-DB-OTHER-F/QDBSIGEX-T/QC2IO-RC17-MSGCPF5035 STRQMPRC FAI
   SI65630      OSP-DB-OTHER-RC6-MSGSQL0752 SET TRANSACTION LEVEL NO COMMIT
   SI65455      F/QSQRUN2-MSGSQL0326 SQL RPG PROGRAM FAILS WITH SQL0326. SEL
   SI65403      OSP-DB INTERNAL MAINTENANCE
   SI65274      OSP-DB-OTHER-F/QCNSMCTL-T/QRWSQRY-MSGCPF916A CPF916A EXTRACT
   SI65043      OSP-DB-MSGSQL0303 assigning NULL to varbinary
   SI64994      OSP-DB-OTHER-F/QDBDLTFI-MSGMCH3406 for *SQDT00002
   SI64955      OSP-DB-OTHER-F/QSQDSCPT-RC14-MSGSQL0904 OCCURS AT DEALLOCATE
   SI64735      OSP-DB-PERFM Improve performance of OPEN statements in stati
   SI64637      OSP-DB GRANT STATEMENT WILL FAIL WITH THE SQL0570 WHEN RUN U
   SI64149      OSP-UNPRED ENDDBMON OF DBMON WITH PARM HOSTVAR(*CONDENSED) L
   SI63993      OSP-DB-OTHER-PERFM OSP-DB-OTHER-PERFM
   SI63867      SP/QSQDSCPT-MSGSQL0076-RC9332-MOD/QSQGETDS MSGSQL0076
   SI63678      OSP-DB-OTHER-F/QQQVSEL-MSGCPD4324
   SI63486      OSP-DB-OTHER-F/QSQCONN-MSGSQL0751 USING 3 PART NAME FROM A T
   SI59829      OSP-DB-MSGSQL0900 IMPLICITLY CONNECT RESET FOR SQL DRDA CNN
   SI63438      OSP-DB INTERNAL MAINTENANCE
   SI63311      OSP-DB-OTHER-F/QDBIOERRQO-T/QSQRUN2-MSGCPF5173 CPF5173 F/QDB
   SI63285      OSP-DB-OTHER-F/QSQRUN2-T/QSQRUN2-MSGMCH3601 MCH3601 MCH1210
   SI63135      OSP-DB-OTHER-MSGSQL0204 USING UNQUALIFIED TABLE REFERENCE
   SI63094      OSP-DB-OTHER-T/QSQRUN3-MSGSQL0901 AFTER 0200 1720 VLOG
   SI62938      OSP-DB-OTHER-MSGSQL0326 SQL0326 GENERATING SQLSTATE 01557
   SI62824      OSP-DB SQLSTATE 01004 not returned from table function when
   SI62229      OSP-DB-MSGSQL0900  with embedded SQL after SETASPGRP
   SI62126      OSP ALTER TABLE STATEMENT NOT LOGGED BY DBMON
   SI61416      OSP-DB INFRASTRUCTURE
   SI61304      OSP-DB-MSGSQL0331 Assignment to input parameter on routine w
   SI61276      OSP-F/QSQROUTE-T/QSQROUTE-MSGMCH3601 MSGMCH3601 T/QSQROUTE P
   SI61211      OSP-DB statement aborted due to SQL warning
   SI61161      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH3601 JOB THAT USE TO
   SI60969      OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGMCH1210 ERROR MESSAGE
   SI60963      OSP-DB incorrect output with offset clause
   SI60904      OSP-DB-MSGCPF5173 QUERY WITH OFFSET AND LIMIT CLAUSES
   SI60597      OSP - DB SQFCRT and SQFOVR with XML CLOB File Result in Impr
   SI60312      OSP-DB FETCH FIRST with OFFSET returns next row
   SI60289      OSP-DB-QSQCALLSP-MSGMCH3601 when using SQL descriptor with S
   SI60209      OSP-DB-OTHER-F/QSQRUN2-MSGSQL0303 Assigning from CHAR to DAT
   SI60152      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0910 FAST DELETE COMM
   SI59856      OSP-DB Return subsystem name instead of server name for CURR
   SI59856      OSP-DB Internal Maintenance
   SI59804      OSP-DB OFFSET > 4GIG Return SQ20539
   SI59701      OSP-DB INFRASTRUCTURE
   SI59486      OSP-DB-OTHER-INCORROUT RETURNGLOBALVARIABLE VALUES ARE DIFFE
   SI59486      OSP-UNPRED SAVEPOINTS FOR INSERT STATEMENT NOT SET VIA DRDA
   SI59486      SP/QSQDSCPT-MSGSQL0076-RC9332-MOD/QSQGETDS MSGSQL0076
   SI59265      OSP-DB Internal Maintenance
   SI59265      OSP-DB Internal Maintenance
   SI59219      OSP-DB Internal Maintenance
   SI59207      OSP-DB-OTHER-MSGSQL0913 SERVICABILITY ENHANCEMENT
   SI59110      OSP-DB-OTHER CREATE COLLECTION DOESN'T SHOW UP ANYMORE IN TH
   SI59107      OSP-DB Internal Maintenance
   SI59050      OSP-DB Internal Maintenance
   SI59048      OSP-DB Internal Maintenance
   SI59047      OSP-DB Internal Maintenance
   SI58984      OSP-DB-OTHER-F/QSQSBAS2X/2815-T/SAME-MSGMCH1210 CPYF RSULTS
   SI58984      OSP-DB-SQL Support optionally setting indicator on truncatio
   SI58943      OSP-DB Internal Maintenance
   SI58943      OSP-DB INTERNAL MAINTENANCE
   SI58900      OSP-DB Internal Maintenance
   SI58759      OSP-DB Internal Maintenance
   SI58672      OSP-DB Internal Database Maintenance
   SI58551      OSP-DB-QQQOOOSETS-MSGMCH5003 using CURRENT DECFLOAT ROUNDING
   SI58542      OSP-DB Internal Maintenance
   SI58542      OSP-DB Error using SQL file reference variable
   SI58868      OSP-DB Internal Maintenance

Summary Information

System..............................  i
Models..............................  
Release.............................  V7R3M0
Licensed Program....................  5770SS1
APAR Fixed..........................  View details for APAR SE76972
Superseded by:......................  View fix details for PTF SI79427
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, 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:
25 May 2022