PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-PERFM QDBFSTCCOL GENERATING HIGH I/O TO DBPMSERVER TASKS
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
CO 5770999 V7R2M0 MF63666 00/00 0000
CO 5770999 V7R2M0 MF63667 00/00 0000
CO 5770999 V7R2M0 MF63669 00/00 0000
CO 5770999 V7R2M0 MF62002 00/00 0000
CO 5770999 V7R2M0 MF61762 00/00 0000
CO 5770999 V7R2M0 MF61479 00/00 0000
CO 5770999 V7R2M0 MF59839 00/00 0000
CO 5770999 V7R2M0 MF59840 00/00 0000
CO 5770999 V7R2M0 MF59275 00/00 0000
CO 5770999 V7R2M0 MF59291 00/00 0000
CO 5770999 V7R2M0 MF58279 00/00 0000
CO 5770999 V7R2M0 MF57843 00/00 0000
CO 5770999 V7R2M0 MF57746 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
-----------------------------------------------
QDBFSTCCOL generating high I/O to DbpmServer Tasks producing a
system slowdown.
CORRECTION FOR APAR MA46436 :
-----------------------------
Code is being added to change the behavior of the QDBFSTCCOL
job, along with corresponding DbpmServer tasks, in regards to
how they handle statistic collections over column with AUX data.
These changes specifically target the number of threads / tasks
to be used and the IO page size being used for scanning the
table.
CIRCUMVENTION FOR APAR MA46436 :
--------------------------------
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
-------------- ------------------------------------------------------------
MF63668 LIC-DB-OTHER-PERFM SQL Limit/Offset support
MF63510 LIC-DB-OTHER-WAIT Job hung in TIMW with DbpmMutex in stack a
MF63288 LIC-DB-OTHER-WAIT Job hung in TIMW with DbpmMutex in stack a
MF62687 LIC-OTHER-WAIT PROCESS CAN BE BLOCKED FROM DISPATCHING UNDER
MF62360 OSP-DB-OTHER-F/DBPMDSPACCESS-T/QDBGETMQO-MSGMCH3402 MCH3402
MF62229 LIC-DB-OTHER-PERFM Internal Database Maintenance
MF62011 OSP-DB-OTHER-UNPRED TEMPORARY STORAGE MAY OCCASIONALLY BE OR
MF61763 LIC-OTHER-LOOP JOB RUNNING DB QUERY WON'T END EVEN AFTER END
MF61706 LIC-DB-OTHER-PERFM DBPMSERVER TASK CAUSING CONTENTION DUE TO
MF61480 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF61222 LIC-DB-OTHER-LOOP a query accessing a table that is being re
MF60614 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF60506 OSP-DB scaling changes
MF60002 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF59836 LIC-DB-OTHER-UNPRED Enable logging of page header mismatch f
MF59713 LIC-DB-OTHER-INCORROUT SQE native key next or previous equal
MF59586 LIC-DB-OTHER-INCORROUT Positioning using a partial key in so
MF59253 OSP-DB-OTHER-F/SMSEGMENTADDRESSRANGESTATUS-T/QDBGETMQO- MSGM
MF59083 LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
MF58640 LIC-DB-OTHER-PERFM Query performing a large sort in overcomm
MF58281 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF58049 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF57725 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF57745 LIC-DB Prevent masked constraint Enablement
MF57653 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF57616 OSP-DB-OTHER-INCORROUT An MTI initially created over an empt
MF57844 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF57652 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF59279 OSP-DB-OTHER-PERFM SCAN OF EVI OVERFLOW AREA CAUSES PERFORMA
Summary Information
System.............................. | i |
Models.............................. | |
Release............................. | V7R2M0 |
Licensed Program............... | 5770999 |
APAR Fixed.......................... | View details for APAR MA46436 |
Superseded by:...................... | View fix details for PTF MF68691 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | C7290720 |
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, 2020, 2021 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:
07 June 2021