IBM Support

MF58681 - LIC-DB-OTHER-INCORROUT SYSTEM CRASH DURING NORMAL OPERATIONS

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

LIC-DB-OTHER-INCORROUT SYSTEM CRASH DURING NORMAL OPERATIONS


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF57390   00/00    0000
PRE  5770999  710  MF55844   00/00    0000
PRE  5770999  710  MF55643   00/00    0000
CO   5770999  710  MF57809   00/00    0000
CO   5770999  710  MF57003   00/00    0000
CO   5770999  710  MF56590   00/00    0000
CO   5770999  710  MF56581   00/00    0000
CO   5770999  710  MF56066   00/00    0000
CO   5770999  710  MF56037   00/00    0000
CO   5770999  710  MF55856   00/00    0000
CO   5770999  710  MF51399   00/00    0000
CO   5770999  710  MF48118   00/00    0000
DIST 5770SS1  710  SI45826   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

-----------------------------------------------
Client system crashed twice during normal operations both were
word 1 B6005121 additional words were different. The two crashes
were both related to heap allocation. After investigation it was
found to be related to the combination of a query with UNNEST
and DBMON is active. Odds of having a problem get higher when
the array name is longer then 16 bytes.

CORRECTION FOR APAR MA43824 :
-----------------------------
PTF will ensure that heap allocations associated with UNNEST are
managed properly, especially while DBMON is active.

CIRCUMVENTION FOR APAR MA43824 :
--------------------------------
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 MF57002 :
=================================================

The customer should clear out the system wide index advice table so as
not to be confused by the duplicate key advice that was incorrectly
generated per this problem.  After clearing out the bad advice, new
index advice will automatically be generated through the ongoing use of
SQL.

SQL:  delete from qsys2.sysixadv


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   MF58575      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 SQL SELECT STA
   MF58026      LIC-DB-OTHER-PERFM DELETE STATEMENT WITH NOT IN PREDICATE IS
   MF57876      OSP-DB-OTHER-F/QQQOOODBOP-T/QQQOOOINV-MSGMCH3203 QUERIES FAI
   MF57808      LIC-DB-PERFM Excessive optimization time when MQTs enabled
   MF57576      LIC-DB-MSGMCH3603 MSGMCH3603
   MF57391      OSP-DB-OTHER-UNPRED LOB USED IN SQL CAUSES HUGE TEMPORARY ST
   MF57359      OSP-DB-OTHER-INCORROUT A QUERY INCORRECTLY SELECT NO ROW WIT
   MF57283      OSP-DB-OTHER-LOOP A QUERY WITH NESTED NULLIF, AND MULITPLE O
   MF57203      LIC-DB Optimizer not always observing INI option OPTIMIZE_ST
   MF57002      OSP-DB-OTHER-INCORROUT SYSIXADV RECOMMENDS FIELDS MORE THAN
   MF56937      OSP-PERFM QUERY OPTIMIZATION TAKES TOO LONG WHEN MANY INDEXE
   MF56804      OSP-DB-OTHER-T/QQQOOODBOPX/4655-MSGMCH3203 SELECT STMT FAILS
   MF56593      SQL-DB-PERFM Index advice for ORed predicates
   MF56580      OSP-DB-PERFM Visual Explain while running fails for short ru
   MF56485      LIC-DB-UNPRED Update of self-referencing view
   MF56352      LIC-DB-OTHER-PERFM COMPLEX QUERY REOPTIMIZES TOO OFTEN
   MF56254      OSP-DB SQL Plan Cache - filter by index advise key columns
   MF56175      OSP-PERFM OPTIMIZER RECOMMENDS EVI OVER A PRIMARY KEY
   MF56067      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 QUERY DBOP ISS
   MF56035      OSP-INCORROUT OSP INCORROUT PLANCACHE POOLID
   MF56023      LIC-DB Fix optimizer code to be compatible with xpf compile
   MF56015      LIC-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 USING EMPTY
   MF55986      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 A MSGMCH3203 F
   MF55979      OSP-DB-OTHER QQQOOODBOP MSGMCH3402 Assert XMLTABLE
   MF55944      LIC-DB-PERFM Performance Problems when DBMON active
   MF55868      LIC-DB-PERFM Overflow condition on EVI with INCLUDE over tab
   MF55854      LIC-DB-OTHER-INCORROUT Grouping set queries with concatenati
   MF55836      OSP-DB-OTHER-PERFM OPTIMIZATION ENHANCMENT
   MF55768      OSP-DB Visual Explain, Not able to explain a query access pl
   MF55720      LIC-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 COMPLEX SQL QU
   MF55669      OSP-DB-OTHER-INCORROUT INCORRECT OUTPUT ON QUERY WITH COMMON
   MF55652      OSP-OTHER-PERFM QUERY PERFORMANCE. LONG OPTIMIZATION TIME. P
   MF55498      LIC-DB-UNPRED Using LOBs as input to UDTF
   MF55413      LIC-DB-PERFM LONG OPTIMIZATION TIMES WITH HIGH NUMBER OF SEL
   MF55265      LIC-DB-OTHER not revalidating on Workload Group changes
   MF55248      LIC-DB Internal maintenance
   MF55142      LIC-DB-PERFM Table Probe IO Costing when secondary in a join
   MF54942      LIC-DB-OTHER Wrong host variables in VE diagram when PSEUDO_
   MF54892      LIC-DB-OTHER SQE Optimizer support for Workload Group
   MF54722      LIC-DB-OTHER Internal Maintenance
   MF54687      OSP-DBPARL-UNPRED QSQSRVR QSQDBXXXXXX SPACE OBJECTS USING TE
   MF54675      OSP-DB Incorrout with Col1 Is Null OR Col1 Is Not Null
   MF54667      OSP-DB-OTHER-F/ASSERTX/004-T/QQQOOODBOPX/4474-RCX1720- MSGMC
   MF54609      OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3203 SQL UPDATE of MULTI-DS
   MF54387      OSP-DB Perform key selection for LIKE predicate with leading
   MF54330      PERFM-LIC FILTERING BY STATEMENT TEXT ON INAV 'SHOW STATEMEN
   MF54298      LIC-DB-PERFM Remove unnecessary Preload of QDS objects
   MF54293      LIC-DB-INCORROUT XML NULL on NULL
   MF54293      LIC-DB-MSGMCH3203 Common Table expression reference in subqu
   MF54009      LIC-DB-PERFM Change Optimizer Average Active jobs calculatio
   MF53809      LIC-DB Internal maintenance
   MF53742      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 QUERY OVER A F
   MF53718      LIC-DB-PERFM Change Optimizer Average Active jobs calculatio
   MF53591      OSP-DB Internal Maintenance for Database Monitor
   MF53479      LIC-DB-PERFM Add PSEUDO_OPEN_CHECK_HOST_VARS QAQQINI option
   MF53479      LIC-DB-OTHER Translated Keys not showing up as translated on
   MF53479      LIC-DB-MSGSQL0901 Fetching numeric with precision 63
   MF53445      OSP-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F/ASSE
   MF53227      OSP-DB-OTHER-LOOP AFTER UPGRADING TO R710, A QUERY WITH NEST
   MF53338      OSP-OTHER-PERFM QUERY PERFORMANCE WITH PARTITIONED TABLES
   MF53338      LIC-PERFM CAST(CHAR as TIMESTAMP) index not being used
   MF53163      LIC-DB-OTHER-MSGCPF5035 UPDATE WITH WHERE CLAUSE FAILS WITH
   MF53099      OSP-DB-OTHER-INCORROUT A FIELDPROC MAY SHOW CACHED RESULTS I
   MF53060      OSP-OTHER-PERFM PERFORMANCE DIFFERENCE BETWEEN LEFT AND SUBS
   MF52507      OSP-DB-OTHER-UNPRED SQL ROQ SIZES TOO LARGE AND BEING CACHED
   MF52507      LIC-DB-OTHER-PERFM SQE NOT MATCHING CONCAT DERIVED KEY INDEX
   MF52459      LIC-DB Connect By infrastructure
   MF52414      LIC-DB-PERFM Performance on query of MULTI-DS LFs
   MF52121      LIC-DB INDEX ADVISOR SUGGESTS AN INDEX OVER A 'NOTUSED' COLU
   MF51928      OSP-DB Select/Omit logical files with NULL capable fields
   MF51928      LIC DB - 0600 BADD LIC logs from removeIter
   MF51767      OSP-DB Select/Omit logical files with NULL capable fields
   MF51620      LIC-DB Database optimizer heap leak fix
   MF51436      OSP-DB-OTHER Enable in memory files for indexes
   MF51402      LIC-DB-PERFM SQL queries not honoring pre-load plans
   MF51402      LIC-DB-PERFM SQE optimization performance
   MF51402      OSP-DB-OTHER-LOOP CREATE FUNCTION LOOPS
   MF51402      LIC-DB-PERFM MQT not matching when DECFLOAT
   MF51402      OSP-DB-OTHER-PERFM SQE ONR COSTING TO LOW
   MF51183      OSP-DB Creation of SQL deflated table
   MF51089      LIC-DB-OTHER Internal Maintenance
   MF51043      LIC-DB-INCORROUT Updatable ORDER BY columns
   MF50983      LIC-DB-Other Add support for validating LF mappings
   MF50865      LIC-DB-OTHER Internal maintenance
   MF50596      LIC-DB-OTHER Internal Maintenance
   MF50493      OSP-DB-PERFM Not using MQT when MQT matches query selection
   MF50493      LIC-DB-MSG3203 Assert from generateOperations__25DbopAccessP
   MF50464      LIC-DB-OTHER Plan Cache Dump not showing the correct pool in
   MF50311      LIC-DB-PERFM SQL Field Procedure Index only access
   MF50070      LIC-DB-MSGMCH3402 BADD Vlog DbVisualExplainStream + 000A34
   MF49962      OSP-DB SQL0802 F/QSQRUN2 T/QSQRUN2 HEX of Left Outer Join co
   MF49962      LIC-DB SQL Support Select/Omit indexes with FieldProcs
   MF49925      LIC-DB-PERFM Improve EVI with INCLUDE costing in low memory
   MF49799      OSP-DB Performance enhancement for SQL MERGE statement
   MF49638      LIC-DB-INCORROUT SQL field procedure with cached DecFloat pa
   MF49553      LIC-DB-OTHER-PERFM QUERY WITH MANY VALUES IN AN IN PREDICATE
   MF49553      OSP-DB-OTHER-UNPRED MCH3203 FROM ASSERT TO QQQOOODBOP
   MF49553      LIC-DB-Other Improved Heap usage
   MF49402      OSP-DB-MSGMCH3601 F/T:DbopOperationMisc/QQQOOODBOP
   MF49392      LIC-DB-MSGMCH3203 SQL Array and XML Agg
   MF49216      INCORROUT XML encoding option wrong results
   MF49157      LIC-DB Array fixes
   MF48987      OSP-DB-OTHER-PERFM SQL STATEMENTS PERFORM WORSE AT R610 OVER
   MF48987      LIC-DB-MSGMCH3203 0200/1722 MODULE HmDerivedHeap when LOBs
   MF48911      LIC-DB-PERFM Allow MQTs and EVIs with INCLUDE to coexist
   MF48904      LIC-PERFM SQL Field Procedures
   MF48792      LIC-DB DBMonitor 3012 record Global Variable
   MF48792      LIC-DB-MSGMCH3203 SQL Arrays
   MF48493      LIC-DB-MSGMCH3203 SQL Arrays
   MF48493      lic-db-unpred System crash
   MF48458      LIC-DB MSGMCH3203 X/1720 F/ASSERT X/000004 T/QQQOOODBOP MODU
   MF48423      LIC-DB VLOG contains many VLOGs with major code 0600, minor
   MF48356      LIC-DB MSGMCH3203 Queries with Arrays fail
   MF48165      LIC-DB-MSGMCH3203 Function check when running Grouping set q
   MF48117      OSP DB OTHER Incorrect output multiple XMLAgg order bys
   MF48029      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-RC1720-MSGMCH3203 SQL UPD
   MF47921      LIC-DB-MSGMCH3203 VLOG occurs when running a Grouping Sets q

Summary Information

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


IBM 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, 2018, 2019, 2020 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"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG15V","label":"PTF Cover Letters - IBM i General"},"Component":"5770999","Edition":""},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1"},"Component":"5770999","Edition":""}]

Document Information

Modified date:
10 December 2020