MF52041 - OSP-DB-OTHER-UNPRED JOBS USING RUNNING A FENCED USER-DEFINED

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770999  710  MF52040   00/00    0000
CO   5770999  710  MF51732   00/00    0000
CO   5770999  710  MF51592   00/00    0000
CO   5770999  710  MF51275   00/00    0000
CO   5770999  710  MF50925   00/00    0000
CO   5770999  710  MF50188   00/00    0000
CO   5770999  710  MF50066   00/00    0000
CO   5770999  710  MF49865   00/00    0000
CO   5770999  710  MF48482   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 'IBM License Agreement for Machine
Code', the terms of which were provided in a printed document that was
delivered with the machine.

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.





APAR Error Description / Circumvention

-----------------------------------------------
Jobs running SQL statments with a fenced user-defined function
may hang following an endjob *immed.

CORRECTION FOR APAR MA40384 :
-----------------------------
The problem was fixed.

CIRCUMVENTION FOR APAR MA40384 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


None.


Default Instructions

THIS IS A DELAYED PTF TO BE APPLIED AT IPL TIME.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   MF51733      LIC-DB-OTHER-SRCB6005121 SRCB6005121 00040000 00000007
   MF51594      LIC-DB-OTHER-PERFM Performance enhancements for Keep in memo
   MF51281      LIC-DB-PERFM Non-preload brings not targeting specific pool
   MF51033      LIC-DB-PERFM  Improve performance of KEEPINMEM=*YES queries
   MF50957      LIC-DB-OTHER-SRCB6005121-UNPRED SYSTEM CRASH - SRCB6005121.
   MF50189      LIC-DB-MSGMCH1807 Insert into a table with an EVI with INCLU
   MF50161      LIC-DB pseudo open of SQE query orphans record lock
   MF49868      LIC-DB-PERFM EVI with INCLUDE performance improvements
   MF49547      LIC-DB-PERFM EVI with INCLUDE performance improvements
   MF49202      LIC-DB-WAIT Cancellation of an EVI with INCLUDE build may re
   MF49129      LIC-DB-PERFM Performances changes for P7 hardware.
   MF48978      LIC-DB-PERFM High faulting during EVI with INCLUDE creation
   MF48854      LIC-DB-PERFM Excessive number of single page segment extensi
   MF48530      LIC-DB-WAIT Dead lock possible when creating a large EVI wit
   MF48484      LIC-DB Aggregate EVI recovery fixes
   MF48435      LIC-DB EVI with INCLUDE build status function not working as
   MF47890      QAQQINI option SQL_DECFLOAT_WARNINGS *YES not always honored

Summary Information

System i Support