IBM Support

MF59924 - LIC-OTHER-SRCB6000103-INCORROUT CRASH WHEN TRYING TO DUMP QU

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

LIC-OTHER-SRCB6000103-INCORROUT CRASH WHEN TRYING TO DUMP QU


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF59089   00/00    0000
CO   5770999  710  MF59786   00/00    0000
CO   5770999  710  MF59472   00/00    0000
CO   5770999  710  MF59086   00/00    0000
CO   5770999  710  MF59088   00/00    0000
CO   5770999  710  MF58962   00/00    0000
CO   5770999  710  MF57780   00/00    0000
CO   5770999  710  MF57781   00/00    0000
CO   5770999  710  MF57290   00/00    0000
CO   5770999  710  MF55214   00/00    0000
CO   5770999  710  MF52540   00/00    0000
CO   5770999  710  MF52541   00/00    0000
CO   5770999  710  MF49949   00/00    0000
CO   5770999  710  MF49473   00/00    0000
CO   5770999  710  MF49474   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

-----------------------------------------------
Invalid data in a QEO (Query Execution Object) led to DBPM
(Database Primitives) attempting to dump the QEO query tree. An
incorrect branch occurred in LIC when trying to parse the
invalid data.

Service Keywords:
srcB6000103 B6000103 - reuse of real heap
dumpTI
srcB6000317 B6000317
DbpmQueryTree DbpmQds DbpmDataSource

CORRECTION FOR APAR MA44491 :
-----------------------------
Should an attempt be made to construct an invalid QEO, a
function check will be generated.  This will prevent the system
crash and should generated enough information to determine the
problem source.

CIRCUMVENTION FOR APAR MA44491 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF59785      LIC-DB-OTHER Internal maintenance

   MF59471      LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
   MF59301      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF59082      LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
   MF58961      OSP-DB-OTHER-INCORROUT A QUERY WITH A -CAST(-2147483648 AS I
   MF58883      LIC-DB-OTHER-INCORROUT SQE query referencing column with fie
   MF58696      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF58581      LIC-DB-OTHER-PERFM An SQL CANCEL of an SMP query may take an
   MF58349      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF57796      LIC-DB-OTHER-F/IXRADIX4COMMONFUNCTIONS-T/QDBGETMQO-MSGMCH340
   MF57778      OSP-DB-OTHER-PERFM LONG SEIZE WAITS OCCUR WITH SQE QUERIES D
   MF57560      OSP-DB-OTHER-INCORROUT An MTI initially created over an empt
   MF57454      OSP-DB-OTHER-INCORROUT ABS(CAST(-2147483648) AS INTEGER
   MF57348      OSP-DB-OTHER-THREADS-LOOP In a job with Maximum threads set
   MF57291      OSP-DB-OTHER-F/DBPMCHARACTERSTRIPOPERATION-T/QDBGETMQO- MSGM
   MF57226      LIC-DB EVI processing fails on reuse due to original EVI ove
   MF57052      OSP-THREADS-F/QDBSIGEX-MSGCPF523F MSGCPF523F ISSUED FOR A SI
   MF57048      OSP-OTHER-PERFM redundant disk read attempts result in waste
   MF56777      OSP-DB-OTHER-F/QDBIOERRQO-MSGCPF5257 INSTEAD OF A SELECTION
   MF56621      LIC-DB-OTHER-THREADS-RCTYPE13RC423-MSGSQL0904 SQL0904 TYPE 1
   MF56536      LIC-DB-OTHER-UNPRED Actual record counts displayed by iNav V
   MF56469      OSP-DB-OTHER-THREADS UPDATE OR DELETE QUERIES EXECUTED CONCU
   MF56418      LIC-DB-MSGMCH3402 Failure in SQE query after file has been r
   MF55890      LIC-DB-OTHER-F/DBPMQIL-T/QQQOOODBOP-MSGMCH3203 SQL QUERY FAI
   MF55704      LIC-DB Improve dianostics in SQE on DB page header mismatch
   MF55557      LIC-DB-MSGMCH1807 during index maintenance - index cannot be
   MF55536      LIC-DB-LOOP UDTF keeps getting called over and over again
   MF55489      LIC-DB-INCORROUT Error not returned as expected from XMLTABL
   MF55217      LIC-DB Simple record deadlock detection improvement
   MF54986      LIC-DB-MSGCPF8111 DAMAGED TABLE ON UPDATE OF TENTATIVE INSER
   MF54692      LIC-DB-OTHER-WAIT SAP-#DBDELEN-LEQ GATE-HYBRID CURSOR
   MF54355      LIC-DB-INCORROUT Incorrect status returned when getting obje
   MF54316      LIC-DB-MSGMCH3203 Field procedute error on open when error s
   MF54226      LIC-DB-PERFM Reuse CLOB allocations when possible during SQE
   MF54134      LIC-DB-PERFM Reuse CLOB allocations when possible during SQE
   MF53308      LIC-DB-OTHER-UNPRED DAMAGE FILE. VL06001C85, VL06003585, VL0
   MF52538      OSP-DB-OTHER-UNPRED ORPHANED XA TRANSACTION LOCKS FOR DELETE
   MF52158      LIC-DB XPF debugger goes into inhibited state on customer co
   MF51775      LIC-DB-OTHER-INCORROUT ON SQE QUERY WITH ORDER BY CLAUSE
   MF51346      LIC-DB-OTHER Recursive Common Table Expression (RCTE) Enhanc
   MF51279      LIC-DB-PERFM Non-preload brings not targeting specific pool
   MF51268      LIC-DB CS and CURRENTLY COMMITTED row skipped when locked
   MF51219      LIC-DB-MSGMCH3203 IN JOB LOG / DBOP AND QEO DUMPS CREATED AN
   MF51032      LIC-DB-PERFM  Improve performance of KEEPINMEM=*YES queries
   MF50980      LIC-DB-MSGSQL0901 Floating point conversion error during SQE
   MF50964      LIC-DB-INCORROUT EVI vector scan on right side of join retur
   MF50659      LIC-DB-OTHER Recursive Common Table Expression (RCTE) Enhanc
   MF50589      LIC-DB-PERFM Enable chgpf/chglf Keep in memory (KEEPINMEM) k
   MF50551      LIC-DB-INCORROUT Module failed to compile.
   MF50227      LIC-DB iDeliver application fails with partial damage after
   MF50066      LIC-DB pseudo open of SQE query orphans record lock
   MF49366      LIC-DB pseudo open of SQE query orphans record lock
   MF49910      LIC-DB-INCORROUT Correctly transfer translate table storage
   MF49782      OSP-DB Performance enhancement for SQL MERGE statement
   MF49550      LIC-DB-PERFM EVI with INCLUDE performance improvements
   MF48990      LIC-DB-WAIT Hang on single task blocker in SkRefCount after
   MF48551      LIC-DB-UNPRED Index rebuild after canceled delayed maintenan
   MF49471      LIC-DB SQL MERGE probe cursor
   MF48608      LIC-DB Support SKIP LOCKED DATA with NC and UR
   MF49133      LIC-DB-MSGMCH3203 SQE costing method fails with floating poi
   MF48852      LIC-DB-PERFM Excessive number of single page segment extensi
   MF48433      LIC-DB EVI with INCLUDE build status function not working as
   MF48010      LIC-DB SQE query tree validation failure due to bad position
   MF47994      LIC-DB sInvalidAdMaxSizeChangeRefreshed__8DbpmTrapFUlN31 + 0
   MF47885      LIC-DB Aggregate EVI build error data is not being retrieved
   MF50026      OSP-DB-OTHER-WAIT WHEN THE NUMBER OF LOCKS IS LIMITED VIA QA
   MF49948      OSP-DB Performance enhancement for SQL MERGE statement

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770999
APAR Fixed..........................View details for APAR MA44491
Superseded by:......................View fix details for PTF MF64005
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C5142710


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.

[{"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":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1 environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
10 April 2015