PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER-T/QDBOPENX/18021-MSGMCH5804 MASSIVE QSQSVCDMPS
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM REL NUMBER MIN/MAX OPTION
---- -------- --- ------- ------- ------
PRE 5770999 710 MF55300 00/00 0000
PRE 5770SS1 710 SI47619 00/00 0000
PRE 5770SS1 710 SI45886 00/00 0000
PRE 5770999 710 MF54634 00/00 0000
CO 5770SS1 710 SI59909 00/00 0000
CO 5770SS1 710 SI50439 00/00 0000
CO 5770SS1 710 SI45894 00/00 0000
CO 5770SS1 710 SI45897 00/00 0000
CO 5770SS1 710 SI46011 00/00 0000
DIST 5770SS1 710 SI60502 00/00 0000
DIST 5770SS1 710 SI48817 00/00 0000
DIST 5770SS1 710 SI43719 00/00 0000
DIST 5770SS1 710 SI43721 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 connecting to iSeries from WAS, lots of QSQSVCDMPs were
generated. The connection job fails with MCH5804
F/RmslLockSpaceLoc
T/QDBOPEN-MODULE/QDBOPEN-PROCEDURE/ACTIVATE-STMT/18021. The
trigger program can potentially be deleted while the file is
open.
CORRECTION FOR APAR SE66786 :
-----------------------------
This fix prevents anything from being modified while the file in
use is open. This will prevent taking a MCH5804 and the open of
the file works as expected.
CIRCUMVENTION FOR APAR SE66786 :
--------------------------------
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
-------------- ------------------------------------------------------------
SI62210 OSP-DB ALLOW_DDL_CHANGES_WHILE_OPEN CPF4326 Commit definitio
SI60899 OSP-DB-OTHER-F/QDBSIGEX-T/QDBSIGEX-RC3-MSGCPF502F ON WRITE I
SI60498 OSP-DB-OTHER-F/QSQRUN3/QSQINS-MSGSQL0913X/31981 UPDATE FAILS
SI59901 OSP-DB Internal Maintenance
SI58637 OSP-DB-MSGCPF4326 Open of file without commitment control fa
SI52642 OSP-DB Incremental Enhancement
SI50438 OSP-DB MCH3601 F/QSQGDIOT T/QSQGDIOT USING GUARDIUM PRODUCT
SI49886 OSP-DB-OTHER-F/QDBSIGEX-T/QSQTRGIO-MSGMCH3601 WHEN USING _RU
SI49342 OSP-DB-UNPRED Internal maintenance
SI49298 OSP-DB-OTHER SUPPORT QPTFOBJ1 and QPTFOBJ2
SI48569 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
SI48377 OSP-DB Incremental Enhancement
SI48081 OSP-DB-OTHER Changes to Parallel_Degree *OPTIMIZE percentage
SI47621 OSP-DB-OTHER-INCORROUT MIMIX OBJECT REPLICATION OF FILE WITH
SI46653 OSP-DB-OTHER-T/TNOPNCLSX/3024-MSGMCH360 USER APP RECEIVES MS
SI45895 OSP-DB Incremental enhancement for field procs
SI45895 OSP-DB-UNPRED Simultaneous recreation of trigger programs
SI45895 F/QDBSIGEX-MSGCPF4102-RC04-OPCS/DSPPFM DSPPFM FAILS IF FILE
SI45050 OSP-DB Incremental Enhancement
SI44831 OSP-DB Open exit QIBM_DB_OPEN enhancement
SI44409 OSP-DB-OTHER-T/QDBOPENX/12633-MSGMCH3402 RCLSTG *DBXREF FAIL
SI44183 OSP-DB ADD TOTAL DB OPENS TO COLLECTION SERVICES
SI44163 OSP-DB-OTHER-T/QDBUDRX/207A-MSGMCH3601 UPDATE STMT FAILS WIT
SI44163 OSP-DB-MSGMCH0601 failure opening DB file when user exit pro
SI44098 OSP-DB-MSGMCH0601-T/QSQSBAS MODULE QSQCLSCR PROCEDURE SQCLOS
SI43960 OSP-DB-OTHER VARIOUS FIXES FOR SELECT FROM INSERT
SI43806 OSP-DB-OTHER VARIOUS FIXES FOR SELECT FROM INSERT
SI43720 OSP-MSGSQL0913 MERGE INTO STATEMENT FAILS WITH SQL0913
SI43412 OSP-DB-OTHER-T/QDMCOPENX/04B7-MSGMCH1604 FILE GETS DAMAGED W
SI43199 OSP-DB Incremental Enhancement
SI43199 OSP-DB-UNPRED Reduce temporary address usage when user exit
SI43199 OSP-DB Incremental Maintenance
SI42745 OSP-DB-OTHER-RC8-MSGSQL0904 MSGSQL0904 RESOURCE LIMIT TYPE 8
SI39951 OSP-DB-QDBCLOSE-MSGMCH2605 from RmslUnlockSpaceLoc
SI39455 OSP-OTHER-UNPRED
SI42656 OSP-DB UPDATE TO A VIEW CREATED BY DDS WITH CCSID 277 RESULT
SI42493 OSP-DB CPF4328 / SQL7008 RC3 FOR AN INSERT INTO A VIEW UNDER
SI41713 OSP-DB-OTHER-UNPRED VARIOUS MESSAGES DUE TO IN-USE TABLE FUL
SI41567 OSP-OTHER-QDBOPEN MCH1210 T/F QDBOPEN
SI40730 OSP-DB-OTHER-F/QDBOPENX/19108-T/QDMCOPENX/0852-MSGMCH3402 RP
SI40353 OSP-DB Limit The Number Of Records To 1 For SEQONLY(*YES) Wh
SI39613 OSP-DB-OTHER-F/QDBSIGEX-T/QSQTRGIO-RC20-MSGCPF5035 WHEN USIN
SI39397 OSP-DB-MSGCPF5032 F/QDBIOERRQO-T/QDBIOERRQO WHEN USING THE S
SI39385 OSP-DB Temporay LOB Data Spaces Are Not Being Destroyed For
SI38694 OSP-DB-OTHER-QDBOPEN MCH5003 in QDBPUTM Partitioning Table
SI38394 OSP-DB-OTHER-QDBOPEN Changes
Summary Information
System.............................. | i |
Models.............................. | |
Release............................. | V7R1M0 |
Licensed Program............... | 5770SS1 |
APAR Fixed.......................... | View details for APAR SE66786 |
Superseded by:...................... | View fix details for PTF SI67333 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | C7192710 |
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 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.
Was this topic helpful?
Document Information
Modified date:
26 May 2017