PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
LIC-DB Potential temp storage corruption when statistics eng
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM REL NUMBER MIN/MAX OPTION
---- -------- --- ------- ------- ------
PRE 5770999 710 MF52580 00/00 0000
PRE 5770999 710 MF52468 00/00 0000
PRE 5770999 710 MF49604 00/00 0000
CO 5770999 710 MF56158 00/00 0000
CO 5770999 710 MF56178 00/00 0000
CO 5770999 710 MF55248 00/00 0000
CO 5770999 710 MF55250 00/00 0000
CO 5770999 710 MF54579 00/00 0000
CO 5770999 710 MF49556 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
-----------------------------------------------
When inserting LIKE predicates into the global statistics cache,
the statistics engine accesses a segment storage management
object to set up the predicate. It's possible that multiple
jobs attempt to use the same object at the same time, but if the
timing is right, this can cause the jobs to interfere with other
and potentially corrupt storage.
CORRECTION FOR APAR MA42394 :
-----------------------------
When inserting LIKE predicates into the global statistics cache,
the statistics engine accesses a segment storage management
object to set up the predicate. It's possible that multiple
jobs attempt to use the same object at the same time, but if the
timing is right, this can cause the jobs to interfere with other
and potentially corrupt storage.
CIRCUMVENTION FOR APAR MA42394 :
--------------------------------
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
-------------- ------------------------------------------------------------
MF56249 LIC-DB-OTHER-PERFM AFTER R710 UPGRADE, QUERY TAKES LONGER TO
MF56234 LIC-DB Confidence of Cardinality Estimate based on defaults
MF56198 OSP-OTHER-PERFM ESTIMATES FOR AN LPG PLAN CAUSES AN INEFFICI
MF56174 LIC-DB-OTHER-PERFM QUERY OPTIMIZER CHOOSES A TABLE SCAN IMPL
MF56157 LIC-DB Detect skew in partitioned tables
MF56116 LIC-DB Statistics Engine using incorrect index for cardinali
MF55985 OSP-SRCB6005121-LOOP A QUERY USING RECURSIVE COMMON TABLE EX
MF55973 LIC-DB Change confidence of cardinality estimate for complex
MF55914 LIC-DB-OTHER-SRCB6005121-UNPRED SYSTEM CRASHED WITH MSD
MF55884 OSP-DB-OTHER-F/ASSERT-T/QQQOOOINV-MSGMCH3203 FOR QUERY THAT
MF55813 LIC-DB-OTHER-SAP400-PERFM SAP INFOCUBE COMPRESSION PERFORMS
MF55734 LIC-DB Potential re-use of destroyed segment on statistics e
MF55716 OSP-PERFM JOB CONSUME HIGH CPU WHEN RUNNING A SELECTION STAT
MF55692 OSP-PERFM COMPLEX JOIN QUERY TAKES HOURS TO OPTIMIZE AFTER R
MF55643 OSP-OTHER-PERFM QUERY PERFORMANCE. LONG OPTIMIZATION TIME. P
MF55568 LIC-DB-OTHER-PERFM SQL Query with RCTE takes a long time to
MF55410 LIC-DB Ignore index in optimization when it has been invalid
MF55368 LIC-DB Query with Row_Number() olap runs long after bad esti
MF55300 LIC-DB-OTHER-PERFM AN SQL STATEMENT CONTAINING A RECURSIVE C
MF55261 OSP-PERFM PT FVL TECHNIQUE IS NOT USED ON PARTITIONED TABLES
MF55249 LIC-DB Use MTIs as a source of statistics
MF54992 OSP-DB-OTHER-UNPRED ENDJOBABN IS NOT HONORED DURING OPTIMIZA
MF54992 LIC-DB-OTHER-PERFM SQL STATEMENT WITH COMPLEX JOIN PREDICATE
MF54903 LIC-DB-OTHER Temp storage leak
MF54812 OSP-PERFM JOIN QUERY TAKING MUCH LONGER TO COMPLETE AFTER UP
MF54785 OSP-PERFM NOT USING COLUMN STATS FOR PARTITIONED TABLE ESTIM
MF54785 OSP-PERFM JOIN QUERY USED TO TAKE 1 SECOND, NOW TAKES 30 SEC
MF54776 OSP-DB-OTHER-WAIT MACHINE GATE WAIT ON THE GLOBAL CONTEXT WI
MF54691 LIC-DB VLOG 0600A1B8 DBST VLOGs while giving index estimate
MF54603 SP/QQQOOOINV-MSGMCH3203 MSGMCH3203 T/QQQOOODBOP, ASSERT 0000
MF54580 LIC-DB MCH3601 After Removing PTF
MF54589 LIC-DB Disable MTIs as a source of statistics
MF54403 LIC-DB Cardinality estimate too low for column in UNIQUE ind
MF54360 OSP-OTHER-PERFM INSERT QUERY WITH A SUBSELECT STARTED PERFOR
MF54189 OSP-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 STATISTICS FOR AN SQE Q
MF54050 LIC-DB Use MTIs as a source of statistics
MF53989 OSP-DB-OTHER-LOOP JOBS CAN GET INTO A LOOP IN DBST AQP CODE
MF53947 LIC-DB Improvements for Global Context Manager portion of AQ
MF53947 PERFM-HLIC MACHINE GATE WAITS FOR GLOBAL CONTEXT MANAGER.
MF53939 LIC-DB-PERFM Incorrect Sparse Index Cost Estimate
MF53891 MSG0600BADA VLOG 0600 BADA RELATED TO AQP - ADAPTIVE QUERY P
MF53806 LIC-DB Internal maintenance
MF53768 OSP-OTHER-PERFM QUERY RUNS POORLY WHEN USING A LIKE PREDICAT
MF53736 LIC-DB-PERFM Sparse Index Not Included in Query Optimization
MF53727 LIC-DB Statistical engine uses default estimate for select/o
MF53688 OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 OSP-DB-OTHER
MF53641 LIC-PERFM SAP TYPE BTC JOB EXECUTING A JOIN QUERY, WHERE ONE
MF53608 LIC-DB-PERFM Heap Leak in DBST Algorithm
MF53585 LIC-DB Bad estimate for partitioned table spanning index
MF53585 LIC-DB-OTHER Query doesn't re-optimize when related foreign
MF53584 LIC-DB-PERFM DBST not using column stat for costing estimate
MF52453 LIC-DB Fix statistical estimates for IN list with character
MF53527 LIC-DB-UNPRED Prevent hanging jobs due to internal lock corr
MF53526 LIC-DB-PERFM Query Not Using Global Statistic
MF53504 OSP-OTHER-PERFM SPARSE INDEX IS BEING USED TO PROVIDE A STAT
MF53473 LIC-DB DBST Changes to enable pseudo-open host variable chec
MF53473 LIC-DB Improved temp storage re-use is pseudo-open mode vari
MF53430 LIC-DB-OTHER MCH3203 on selective index over date field
MF53288 OSP-DB-OTHER-SRC0600A1B8 LOTS OF VL0600A1B8S AND 0A004FFF AR
MF53044 OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 INDEX CAUSING
MF52613 LIC-DB-MSGMCH3601 during VRYCFG ON operation of flash copy i
MF52498 LIC-DB Implement join skew testing via EVI counts
MF52283 LIC-DB-OTHER-PERFM QUERY WENT FROM RUNNING IN MINUTES TO HOU
MF52245 LIC-DB-OTHER-PERFM Not-Partitioned Derived Index Not Used fo
MF52150 OSP-PERFM NEVER ENDING JOIN QUERY USING LPG
MF52150 LIC-DB-OTHER-PERFM COMPLEX QUERY REFERENCING A VIEW PERFORMS
MF50513 IPL-SRCB6005121-UNPRED SRCB6005121 STACK OVERFLOW
MF52131 LIC-DB-OTHER-PERFM Frequent Reoptimizations during COPR work
MF52100 OSP-LOOP JOB LOOPING IN OPTIMIZATION WHILE LOOKING IN THE GL
MF52027 LIC-DB Temporarily disable stats in GCM to avoid potential l
MF51930 LIC DB - 0600 BADD LIC logs from removeIter
MF51685 OSP-OTHER-PERFM INSERT QUERY IS SLOW
MF51557 LIC-DB-OTHER-PERFM Column Stats not Auto Collected over Shar
MF51478 LIC-DB-OTHER-SRCB6000302-UNPRED
MF51437 LIC-DB MCH3203 RC1720 F/DBPMTRAP X/0003F8 T/QQQOOODBOP MODUL
MF51378 LIC-DB-PERFM SQE optimization performance
MF51143 LIC-DB-OTHER System counters for global stats not being upda
MF51133 LIC-DB-OTHER-PERFM Keepinmem attribute changes not triggerin
MF51097 LIC-DB-OTHER Internal Database Maintenance
MF51096 LIC-DB-OTHER-PERFM Sparse Index with RRN predicate not found
MF51066 LIC-DB-OTHER-PERFM
MF51059 LIC-DB-OTHER SQE Deflated Table Support
MF51013 OSP-DB-OTHER-PERFM LONG OPTIMIZATION TIMES
MF50725 LIC-DB-OTHER Internal maintenance
MF50608 LIC-DB-LOOP Job Won't End with Call Stack in DBST
MF50570 LIC-DB Recognize and optimize for SSD objects
MF50510 LIC-DB-OTHER-PERFM SQE QUERY PERFORMS POORLY
MF49932 LIC-DB-OTHER Internal Database Maintenance
MF49606 LIC-DB-LOOP DbopTrace Appears to be Looping in DBST
MF49605 LIC-DB Expose New DataSpace / Index Attribute
MF49599 LIC-DB Improve handling of very low record count estimates t
MF49599 LIC-DB Change in-line stats collections to ignore QDBFSTCCOL
MF48893 LIC-DB Avoid VLOG due to negative record count estimate with
MF48893 OSP-DB-OTHER-THREADS-PERFM REAL TIME SQL STATS BEING COLLECT
MF49576 LIC-DB MQT Not used when MQT is thought to be bad/invalid
MF49542 LIC-DB 0600/DEAD Vlog From Query Over Select/Omit Index
MF49545 LIC SMP CAN CHOOSE A VERY HIGH SMP NUMBER WHEN USING EVI'S
MF49534 LIC-DB-PERFM Expression with Matrix not added to Global Stat
MF49526 LIC-DB-PERFM Unable To End Long Running Dbop Trace
MF49507 LIC-DB-LOOP DbopTrace Appears to be Looping in DBST
MF49466 LIC-DB-OTHER Internal Database Maintenance
MF49432 LIC-DB-OTHER Internal Database Maintenance
MF49416 LIC-DB-PERFM Global Stat Not Triggering Re-optimize
MF49409 LIC-DB-OTHER-THREADS-LOOP Global Stats Access Concurrency Pr
MF48630 LIC-DB Improve handling of invalid MQTs, including better VL
MF48604 LIC-DB-OTHER-PERFM AQP Beharior incorrectly tied to test sta
MF48570 OSP-OTHER-PERFM DUPLICATE TRANSLATE TABLES
MF48534 LIC-DB-OTHER-PERFM Global Statistic Not Used During Optimiza
MF48318 OSP-DB-OTHER-F/DBSTMDEXTENTLAYOUT-T/QQQOOOINV-MSGMCH3402 QMQ
MF48310 OSP-DB-OTHER-PERFM LONG RUNNING SQL QUERY IS LOSING TRACK OF
MF48310 OSP-DB-OTHER-PERFM JOIN QUERY CAUSES A LARGE INCREASE IN TEM
MF48120 OSP-DB-OTHER-F/DBSTPRECISION-T/QQQOOODBOP-MSGMCH3203 OSP-DB-
MF48120 OSP-DB-OTHER-PERFM STATS ARE CONSIDERED, EVEN IF STALED, WHI
MF48068 LIC-DB-OTHER-UNPRED 1000/2207 Vlogs from DBST AQP
MF47998 LIC DB DBST Static Variable Cleanup
MF47933 LIC-DB-OTHER SQL901 MCH3601 From DbstMdExtentLayout + 00001C
MF50027 OSP-OTHER-PERFM QUERY PERFORMS POORLY WHEN WE USE AN INDEX T
MF50027 LIC-DB-OTHER-PERFM QUERY WHICH USUALLY RUNS IN SECONDS NOW T
MF50027 OSP-DB-OTHER-PERFM SQE QUERY HANGS FOR SEVERAL HOURS IN NEWF
MF49130 LIC-DB Statistics engine gives low estimate on join with ske
MF48891 OSP-DB-OTHER-PERFM SQE WITH MANY ORDER BY FIELDS PERFORMS PO
MF48515 LIC-DB DBST not finding skew in column because of bad cardin
MF48515 LIC-DB-OTHER-PERFM COMPLEX QUERY PERFORMS POORLY AT V6R1.
Summary Information
System.............................. | i |
Models.............................. | |
Release............................. | V7R1M0 |
Licensed Program............... | 5770999 |
APAR Fixed.......................... | View details for APAR MA42394 |
Superseded by:...................... | View fix details for PTF MF63216 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | C3037710 |
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:
08 November 2012