IBM Support

SI68617 - OSP-DB-OTHER-UNPRED QDBTREXT BEING CALLED TWICE PER INVOCATI

PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-UNPRED QDBTREXT BEING CALLED TWICE PER INVOCATI


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770SS1  V7R2M0    SI59900   00/00    0000
PRE  5770SS1  V7R2M0    SI51352   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

-----------------------------------------------
QDBTREXT is allocating 4GB or more of temporary teraspace
storage for a job.

CORRECTION FOR APAR SE70034 :
-----------------------------
Invocation end processing for database i/o modules that process
put, update and delete requests are being called twice.  This
can lead to incorrectly allocating temporary teraspace for a
job.  Invocation end processing is corrected.

CIRCUMVENTION FOR APAR SE70034 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI67742      OSP-DB-OTHER-F/QDBPUT-MSGMCH1873 A MSGMCH1873 F/QDBPUT MAY O
   SI67535      OSP-F/QDBUDR-T/QDBUDR-MSGMCH1210 MCH1210 F/T/QDBUDR
   SI67127      OSP-DB Internal maintenance
   SI66924      OSP-DB-OTHER-T/QDBXREF-MSGMCH6903 QDBSRVXR JOB REACHES HEAP
   SI65377      SQL-RUN-F/CBLABRANCH-MSGMCH1210 MSGMCH1809 FOLLOWED BY MSGMC
   SI64323      OSP-DB-OTHER-F/QDBUDR-T/QDBUDR-MSGMCH0601 WHEN TRIGGER FIRES
   SI61484      OSP-DB-OTHER-F/#DBCPYFL-T/QDBUDR-MSGMCH5003 UPDATE FAILS WIT
   SI61297      Improper handling of MSGMCH1873 f/QDBUDR results in MSGMCH36
   SI61263      OSP-DB-OTHER-F/#DBENFCN-T/QDBPUTDR-MSGMCH1880 WHILE APPLYING
   SI60131      OSP-DB Internal Maintenance
   SI59902      OSP-DB Internal Maintenance
   SI59008      OSP-DB-OTHER-F/QDBPUTMX-T/QDBPUTMX-MSGMCH3402 MCH3402 SQL090
   SI58613      OSP-F/QDBUDR-T/QDBUDR-MSGMCH1873 MSGMCH1873 F/QDBUDR T/QDBUD
   SI57303      OSP-DB-OTHER-INCORROUT IN TRIGGER BUFFER WHEN INSERT OF UTF-
   SI57117      OSP-DB-OTHER-UNPRED LOWER CASE SQL STATEMENTS ARE NOT RECOGN
   SI53005      OSP-DB-MSGMCH1210 unable to delete a large number of records
   SI52699      OSP-JRN-INCORROUT Internal maintenance
   SI52645      OSP-DB-INCORROUT Internal maintenance
   SI52550      OSP-DB-INCORROUT Internal maintenance
   SI52501      OSP-DB-INCORROUT internal maintenance
   SI52485      OSP-DB-INCORROUT Internal maintenance
   SI52370      OSP-DB-INCORROUT Internal maintenance
   SI52292      OSP-DB-INCORROUT Internal maintenance
   SI52174      OSP-DB-INCORROUT Failing trigger programs cause job terminat
   SI51659      OSP-DB-INCORROUT QDBPUTMX PLX port fixes
   SI51504      OSP-DB-INCORROUT QDBPUT QDBPUTDR QDBPUTM QDBPUTMX QDBUDR fix
   SI51470      OSP-DB-INCORROUT QDBPUT QDBPUTDR QDBPUTM QDBPUTMX QDBUDR fix
   SI51351      OSP-DB Internal updates
   SI51351      OSP-DB-INCORROUT Errors in QDBPUT, QDBPUTDR, QDBPUTM, QDBPUT

Summary Information

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


System 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 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.

Document information

More support for: i family

Software version: V7R2M0

Operating system(s): OS/400

Reference #: SI68617

Modified date: 26 November 2018