IBM Support

MF63722 - OSP-PERFM QDBFSTCCOL GENERATING HIGH I/O TO DBPMSERVER TASKS

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

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


System i Support

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.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
24 July 2017