PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER-THREADS-F/QSQEVENT-T/QQQOOOUPCL-RC1-MSGSQL0952
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
CO 5770999 V7R2M0 MF65178 00/00 0000
CO 5770999 V7R2M0 MF64628 00/00 0000
CO 5770999 V7R2M0 MF64629 00/00 0000
CO 5770999 V7R2M0 MF64630 00/00 0000
CO 5770999 V7R2M0 MF64073 00/00 0000
CO 5770999 V7R2M0 MF64074 00/00 0000
CO 5770999 V7R2M0 MF64075 00/00 0000
CO 5770999 V7R2M0 MF63215 00/00 0000
CO 5770999 V7R2M0 MF63413 00/00 0000
CO 5770999 V7R2M0 MF62011 00/00 0000
CO 5770999 V7R2M0 MF60732 00/00 0000
CO 5770999 V7R2M0 MF59838 00/00 0000
CO 5770999 V7R2M0 MF59839 00/00 0000
CO 5770999 V7R2M0 MF57842 00/00 0000
CO 5770999 V7R2M0 MF57843 00/00 0000
CO 5770999 V7R2M0 MF59855 00/00 0000
CO 5770999 V7R2M0 MF59857 00/00 0000
CO 5770999 V7R2M0 MF59858 00/00 0000
CO 5770999 V7R2M0 MF58822 00/00 0000
DIST 5770SS1 V7R2M0 SI56209 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
-----------------------------------------------
SQLCancel appears to have kicked in right during the up-call to
XPF for child thread creation.
A method is being called in SLIC that went for thread
serialization mutex (DbpmMutex) that had already been made
eligible for transfer to child threads.
In that state, the DbpmMutex appears held, but not by the
requesting thread, so it blocked as opposed to being rejected.
CORRECTION FOR APAR MA47403 :
-----------------------------
Events and signals are now masked to avoid a cancellation from
being processed when threads are being created to avoid the
potential hang condition. After thread creation, events and
signals will be processed normally.
CIRCUMVENTION FOR APAR MA47403 :
--------------------------------
None.
Activation Instructions
None.
Special Instructions
********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************
SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF MF65166 :
=================================================
This PTF may not resolve issues with indexes or maintained temporary
indexes (MTI) that existed prior to application. An IPL is required to
ensure complete resolution.
Default Instructions
THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.
Supersedes
PTF/FIX NO(S). APAR TITLE LINE
-------------- ------------------------------------------------------------
MF65411 LIC-DB-OTHER-PERFM Reduce system overhead when rapidly creat
MF65383 SQL-RUN-THREADS-WAIT JOB WAS IN A STACK WAITING FOR A FIELD
MF65179 OSP-DB-OTHER-MSGCPF32F9 WHEN VARYING ON IASP
MF65166 OSP-DB VL0A004FFF VL0600DEAD VL0600BADD VL02001720 WHEN OPTI
MF64902 LIC-DB-OTHER-PERFM Attempt to reduce segment extensions and
MF64639 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF64627 OSP-DB-OTHER-UNPRED SQE CHANGED TO HOLD JOBS WHEN QUERY RELA
MF64409 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF64274 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF64241 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF64072 LIC-DB-PERFM Database Monitor 3010 record
MF63126 OSP-UNPRED VL0600BADA VL0600BADD VLOGS CAUSING CORRUPTION
MF58424 LIC-DB-PERFM not using ICU index
MF64022 LIC-DB-OTHER-PERFM Attempt to reduce segment extensions and
MF63214 LIC-DB-OTHER-PERFM Attempt to reduce segment extensions and
MF59853 LIC-DB-UNPRED Ensure order of partitions in partitioned tabl
MF58821 LIC-DB-OTHER-PERFM SLOW PARTITION DUE TO CONCURRENT IDENTICA
MF58821 LIC-DB-OTHER-PERFM SLOW PARTITION DUE TO CONCURRENT IDENTICA
MF58520 OSP-DB SOME FUNCTIONS IN VISUAL EXPLAIN MAY FAIL IF AN INDEX
MF58483 OSP-DB-Other Enable additional Plan Cache Properties and opt
MF63705 LIC-DB-OTHER-F/DBPMTRAP-T/QDBPUT-RC0-MSGMCH3203 Insert/Write
MF63508 LIC-DB-OTHER-PERFM Estimated I/O cost may be computed as 0 r
MF63415 OSP-DB-OTHER-MSGCPI0999 XMLAGG QUERIES MAY RESULT IN LARGE A
MF62333 OSP-UNPRED THIS IS TO GET THE WORKLOAD THE DBPMSERVER TASKS
MF61909 OSP-UNPRED THIS IS TO GET THE WORKLOAD THE DBPMSERVER TASKS
MF62133 LIC-DB-OTHER-PERFM Normal vary on of independant ASP may tak
MF62002 OSP-DB-OTHER-UNPRED TEMPORARY STORAGE MAY OCCASIONALLY BE OR
MF59320 LIC-DB-OTHER-WAIT An insert or update to a table with a comp
MF59107 LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
MF61705 LIC-DB-OTHER-PERFM DBPMSERVER TASK CAUSING CONTENTION DUE TO
MF61648 IPL-SRCC9002A85-WAIT SYSTEM ASP WAS AT 99.6%. SYSTEM IPL POS
MF60773 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF60729 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF60001 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF59835 LIC-DB-OTHER-UNPRED Enable logging of page header mismatch f
MF59626 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF59293 LIC-DB-OTHER-PERFM Existing EVI index may not be used by the
MF58666 LIC-DB-OTHER-UNPRED 0600 DEAD LIC logs
MF58641 LIC-DB-OTHER-PERFM Query performing a large sort in overcomm
MF58340 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF58305 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF58111 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF58021 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF57897 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF57841 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF57658 LIC-DB-OTHER-UNPRED Internal Database Maintenance
MF59491 LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
Summary Information
System.............................. i
Models..............................
Release............................. V7R2M0
Licensed Program.................... 5770999
APAR Fixed.......................... View details for APAR MA47403
Superseded by:...................... View fix details for PTF MF70016
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C9123720
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, 2022 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:
17 June 2022