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 REL NUMBER MIN/MAX OPTION
---- -------- --- ------- ------- ------
CO 5770999 710 MF61476 00/00 0000
CO 5770999 710 MF61478 00/00 0000
CO 5770999 710 MF61114 00/00 0000
CO 5770999 710 MF59874 00/00 0000
CO 5770999 710 MF59878 00/00 0000
CO 5770999 710 MF59879 00/00 0000
CO 5770999 710 MF59274 00/00 0000
CO 5770999 710 MF58699 00/00 0000
CO 5770999 710 MF55214 00/00 0000
CO 5770999 710 MF52432 00/00 0000
CO 5770999 710 MF49865 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
-------------- ------------------------------------------------------------
MF63511 LIC-DB-OTHER-WAIT Job hung in TIMW with DbpmMutex in stack a
MF62688 LIC-OTHER-WAIT PROCESS CAN BE BLOCKED FROM DISPATCHING UNDER
MF61477 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF61113 LIC-DB-OTHER-LOOP a query accessing a table that is being re
MF60613 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF60505 OSP-DB scaling changes
MF59875 LIC-DB-OTHER-UNPRED Enable logging of page header mismatch f
MF59278 OSP-DB-OTHER-PERFM SCAN OF EVI OVERFLOW AREA CAUSES PERFORMA
MF59251 OSP-DB-OTHER-F/SMSEGMENTADDRESSRANGESTATUS-T/QDBGETMQO- MSGM
MF59086 LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
MF58703 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF58583 LIC-DB-OTHER-PERFM An SQL CANCEL of an SMP query may take an
MF57779 OSP-DB-OTHER-PERFM LONG SEIZE WAITS OCCUR WITH SQE QUERIES D
MF57559 OSP-DB-OTHER-INCORROUT An MTI initially created over an empt
MF56776 OSP-DB-OTHER-F/QDBIOERRQO-MSGCPF5257 INSTEAD OF A SELECTION
MF56620 LIC-DB-OTHER-THREADS-RCTYPE13RC423-MSGSQL0904 SQL0904 TYPE 1
MF56502 LIC-DB RANDOM READ COUNT IN QSYS2.SYSPARTITIONSTAT IS NOT AC
MF55535 LIC-DB-LOOP UDTF keeps getting called over and over again
MF55215 LIC-DB Simple record deadlock detection improvement
MF55206 LIC-DB-PERFM Allow cancel during SQE sorted temporary list s
MF54778 LIC-DB-INCORROUT with ICU sort and subqueries through SQE
MF52539 OSP-DB-OTHER-UNPRED ORPHANED XA TRANSACTION LOCKS FOR DELETE
MF52468 LIC-DB-PERFM Need EVI stat to detect skewed values on a tabl
MF52433 LIC-DB-PERFM Need EVI stat to detect skewed values on a tabl
MF51886 LIC-DB-PERFM Need EVI stat to detect skewed values on a tabl
MF51838 OSP-DB-OTHER-MSGMCH1668 File damaged by active query during
MF51331 OSP- VL02001720 Fuction Check assert+4 from DbpmCommit+1BC0
MF51316 OSP-DB-OTHER-INCORROUT QUERY RETURNS INCORRECT NUMBER OF ROW
MF51275 LIC-DB-PERFM Non-preload brings not targeting specific pool
MF51110 LIC-DB-MSG3402 Intermittent MCH3402 from #dbixsiz
MF50590 LIC-DB-PERFM Enable chgpf/chglf Keep in memory (KEEPINMEM) k
MF50225 LIC-DB iDeliver application fails with partial damage after
MF50182 LIC-DB-PERFM EVI with INCLUDE performance improvements
MF50139 LIC-DB pseudo open of SQE query orphans record lock
MF48837 LIC-DB-MSGMCH3601 F/DbpmPtbSad during access of SQE temp ind
MF50090 LIC-DB-OTHER-F/DBPMRRNBITMAPSCANNODE-T/QDBGETMQO-MSGMCH3402
MF49866 LIC-DB-PERFM EVI with INCLUDE performance improvements
MF49548 LIC-DB-PERFM EVI with INCLUDE performance improvements
MF49514 LIC-DB-WAIT QZDASOINIT jobs would not end after varying off
MF49343 LIC-DB-WAIT QZDASOINIT jobs would not end after varying off
MF49201 LIC-DB-WAIT Cancellation of an EVI with INCLUDE build may re
MF48690 LIC-DB-MSGMCH3601 Creation of EVI with INCLUDE fails with M
MF47949 LIC-DB SQE query has hash table size computation problem
MF47882 LIC-DB Aggregate EVI build error data is not being retrieved
MF49472 LIC-DB SQL MERGE probe cursor
Summary Information
System.............................. | i |
Models.............................. | |
Release............................. | V7R1M0 |
Licensed Program............... | 5770999 |
APAR Fixed.......................... | View details for APAR MA46436 |
Superseded by:...................... | |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | NONE |
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 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:
24 July 2017