IBM Support

SI66893 - OSP-DB Temp Storage growth with CLOBs in UDTF

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB Temp Storage growth with CLOBs in UDTF


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
CO   5770SS1  V7R3M0    SI66883   00/00    0000
CO   5770SS1  V7R3M0    SI65936   00/00    0000
CO   5770SS1  V7R3M0    SI65938   00/00    0000
CO   5770SS1  V7R3M0    SI65761   00/00    0000
CO   5770SS1  V7R3M0    SI65762   00/00    0000
CO   5770SS1  V7R3M0    SI65760   00/00    0000
CO   5770SS1  V7R3M0    SI60283   00/00    0000
DIST 5770SS1  V7R3M0    SI64149   00/00    0000
DIST 5770SS1  V7R3M0    SI63624   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

-----------------------------------------------
SQL UDTF with CLOB parameters and variables is repeatedly called
in the job. The temp storage in the job grows continually until
the job ends.

CORRECTION FOR APAR SE68827 :
-----------------------------
CLOBs in a SQL Procedure, Function and Triggers are internally
implemented as Locators. The storage associated with the
locators was not correctly freed after the execution of the
UDTF. This has been fixed.

CIRCUMVENTION FOR APAR SE68827 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI66580      OSP-DB Temp Storage growth with CLOBs in UDTF
   SI66457      OSP-DB-MSGMCH3203-RC1720 F/DBOPNODE-MSGMCH3203-RC1720
   SI66233      OSP-DB-QSQINS-MSGSQL0723 on trigger program using 3 part nam
   SI65937      OSP-DB-OTHER-UNPRED DUPLICATE STATEMENT NAMES IN SQLPKG
   SI65930      OSP-DB-OTHER-F/QSQSBAS-T/QSQSBAS-MSGMCH3601 SQL_GETQDT_FOR_U
   SI65763      OSP-DB INTERNAL MAINTENANCE
   SI65576      OSP-DB Internal Maintenance
   SI65361      OSP-DB Internal Maintenance
   SI65268      OSP-DB Internal Maintenance
   SI64611      OSP-DB-MSGMCH3601-T/QRWTQRY with 3 part name SQL
   SI64151      OSP-UNPRED ENDDBMON OF DBMON WITH PARM HOSTVAR(*CONDENSED) L
   SI64007      OSP-DB 3-part name replacement for heterogenous, use *SQL na
   SI63625      OSP-DB Improve Index Advisor storage management
   SI63437      OSP-DB INTERNAL MAINTENANCE
   SI63180      OSP-DB-MSGMCH3601 QZDASOINIT Job Termination Failing with MC
   SI63170      OSP-DB Internal Maintenance
   SI63062      OSP-DB-OTHER-T/QSQRUN3-MSGMCH3601 MODULE QSQOPEN PROCEDURE D
   SI62284      OSP-DB INTERNAL MAINTAINENCE
   SI62127      OSP ALTER TABLE STATEMENT NOT LOGGED BY DBMON
   SI62118      OSP-DB-OTHER-INCORROUT DBMON WORK WITH SQL STATEMENT AND VAR
   SI61620      OSP-DB-MSGMCH3402 f/QSQUDFPO t/QSQUDFPO running query with s
   SI60932      OSP-DB INTERNAL MAINTENANCE
   SI60902      OSP-DB INFRASTRUCTURE
   SI60480      OSP-DB-PERFM Slow performance when using SQL packages in mul
   SI60376      OSP - DB XML Decomp Attempt on Incomplete Schema Returns SQL
   SI60307      OSP-DB-MSGMCH3402-T/QSQCLSCR close remote cursor
   SI60284      OSP-DB Internal Maintenance
   SI59959      OSP-DB Internal Database Maintenance
   SI59825      OSP-DB-INCORROUT INLINED SQL FUNCTION
   SI59605      OSP-DB INTERNAL MAINTENANCE
   SI59558      OSP-DB Internal Maintenance
   SI59488      OSP-DB Internal Maintenance
   SI59488      OSP-DB-OTHER-MSGSQL0443 A MSGSQL0443 MAY OCCUR ON SERVER IBM
   SI59482      OSP-DB INFRASTRUCTURE
   SI59397      OSP-DB INTERNAL MAINTENANCE
   SI59394      OSP-DB REMOTE INSERT WITH AN ALIAS THAT HAS A 3 PART NAME FA
   SI59335      OSP-DB INTERNAL MAINTENANCE
   SI59220      OSP-DB Internal Maintenance
   SI59146      OSP-DB Create table LIKE with 3-part name issues misleading
   SI59072      OSP-DB INTERNAL MAINTENANCE
   SI59049      OSP-DB Internal Maintenance
   SI58994      OSP-DB-SQL Support optionally clearing SQLSTATE on truncatio
   SI58983      OSP-DB-OTHER-F/QSQRUN3-MSGSQL0517
   SI58954      OSP-DB INTERNAL MAINTENANCE
   SI58763      OSP-DB-MSGMCH3402 T/QSQPREP in QDBSxxxxxx system job
   SI58530      OSP-DB INTERNAL MAINTENANCE
   SI58530      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENTS

Summary Information

System..............................  i
Models..............................  
Release.............................  V7R3M0
Licensed Program....................  5770SS1
APAR Fixed..........................  View details for APAR SE68827
Superseded by:......................  View fix details for PTF SI85811
Recompile...........................  N
Library.............................  QSYS
MRI Feature ........................  NONE
Cum Level...........................  C8242730


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, 2023, 2024 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:
13 March 2024