MF63407 - OSP-DB-OTHER-MSGCPI0999 XMLAGG QUERIES MAY RESULT IN LARGE A

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF59933   00/00    0000
PRE  5770999  710  MF49099   00/00    0000
CO   5770999  710  MF63405   00/00    0000
CO   5770999  710  MF63406   00/00    0000
CO   5770999  710  MF55774   00/00    0000
CO   5770999  710  MF55718   00/00    0000
CO   5770999  710  MF53588   00/00    0000
CO   5770999  710  MF51266   00/00    0000
CO   5770999  710  MF51267   00/00    0000
CO   5770999  710  MF50188   00/00    0000
CO   5770999  710  MF49866   00/00    0000
CO   5770999  710  MF48982   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

-----------------------------------------------
xmlagg queries may result in large amounts of temporary storage
being consumed which may result in a CPI0999 threshold warning
message.

CORRECTION FOR APAR MA46286 :
-----------------------------
Changes were made to return storage early for subsequent reuse
on the next aggregation, reducing overall storage usage.

CIRCUMVENTION FOR APAR MA46286 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF61649      IPL-SRCC9002A85-WAIT SYSTEM ASP WAS AT 99.6%. SYSTEM IPL POS
   MF59998      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF59938      LIC-DB SLIC DB Parallel Index Build Priority
   MF59473      LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
   MF59089      LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
   MF58834      LIC-OTHER-THREADS-INCORROUT IMPROVE TIMING WINDOW SO THAT QW
   MF58326      OSP-DB-OTHER-F/ASSERT-T/QQQOOOUPCL-MSGMCH3203 JOB RUNS BUT M
   MF57317      OSP-DB-OTHER-LOOP AFTER A SQL UPDATE COMPLETES, THE JOB HANG
   MF57053      OSP-THREADS-F/QDBSIGEX-MSGCPF523F MSGCPF523F ISSUED FOR A SI
   MF56283      OSP-DB-OTHER-F/SMASMSIGNALEXCEPTION-MSGMCH3203 0 byte extens
   MF55846      LIC-DB-MSGMCH3203 VL0600DEAD clearing beyond storage allocat
   MF55773      LIC-DB SYSTEM CRASH MAY OCCUR WITH SRCB6000334 IF 2 JOBS USE
   MF55717      LIC-DB-PERFM SQE queries with LOBs taking excessive page fau
   MF54489      LIC-DB-PERFM SQE pooled threads are reused even if client ta
   MF53695      LIC-DB-PERFM BAD STAT IN THE GLOBAL CONTEXT.
   MF52278      LIC-OTHER RE-COMPILE TO INCLUDE ADDITIONAL LIC SEGMENTS
   MF52151      LIC-DB XPF debugger goes into inhibited state on customer co
   MF51265      LIC-DB-OTHER-PERFM SQE performance improvements
   MF50224      LIC-DB-INCORROUT SQE not returning underflow error properly
   MF50190      LIC-DB-MSGMCH1807 Insert into a table with an EVI with INCLU
   MF49865      LIC-DB-PERFM EVI with INCLUDE performance improvements
   MF49546      LIC-DB-PERFM EVI with INCLUDE performance improvements
   MF49291      LIC-DB-INCORROUT Decimal float ops involving SNAN returning
   MF49200      LIC-DB-WAIT Cancellation of an EVI with INCLUDE build may re
   MF49101      LIC-DB-PERFM Excessive faulting on heap pages during EVI wit
   MF48977      LIC-DB-PERFM High faulting during EVI with INCLUDE creation
   MF48855      LIC-DB-PERFM Excessive number of single page segment extensi
   MF48377      DataBase fixes for SQL Arrays
   MF48061      LIC-DB-INCORROUT Intermittent incorrect output from XML aggr
   MF47881      LIC-DB Aggregate EVI build error data is not being retrieved
   MF48563      LIC-DB-PERFM Degradation of parallel queries in storage pool

Summary Information

System i Support