SI64252 - OSP-DB-OTHER-T/QDBOPENX/18021-MSGMCH5804 MASSIVE QSQSVCDMPS

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 Support