IBM Support

MF64286 - OSP-DB-OTHER-THREADS-SRCB6000302 SRCB6000302

PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-THREADS-SRCB6000302 SRCB6000302


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770999  V7R3M0    MF63858   00/00    0000
PRE  5770999  V7R3M0    MF62223   00/00    0000
PRE  5770999  V7R3M0    MF60955   00/00    0000
CO   5770999  V7R3M0    MF63731   00/00    0000
CO   5770999  V7R3M0    MF61542   00/00    0000
CO   5770999  V7R3M0    MF61286   00/00    0000
CO   5770999  V7R3M0    MF61258   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

-----------------------------------------------
srcB6000302 resulting from OPNQRYF with XOR

REG1=C000011E3616FD80 NIA=FFFFFFFFFF623860 module HvCallNuc+0xA0
..................... LR=FFFFFFFF820CD984 module
McTerminateImmediate+0x1264
ISF=C000011E3616FD80 NIA=FFFFFFFF820CD94C module
McTerminateImmediate+0x122C
ISF=C000011E3616FFC0 NIA=FFFFFFFFFF0883E8 module #qustack+0xA78
ISF=D64ADD6791FEEF60 NIA=FFFFFFFF820CDD2C module
McTerminateImmediate+0x160C
ISF=D64ADD6791FEF060 NIA=FFFFFFFFFF0D4CB0 module
ExTerminate+0x50
ISF=D64ADD6791FEF0E0 NIA=FFFFFFFFFF0D4F14 module
ExTerminate+0x2B4
ISF=D64ADD6791FEF1A0 NIA=FFFFFFFFFF0D45C8 module
ExExceptHighUse+0x2168
ISF=D64ADD6791FEF8A0 NIA=FFFFFFFFFF0D41F8 module
ExExceptHighUse+0x1D98
ISF=D64ADD6791FF0000 NIA=FFFFFFFFFFDC1A68 module
SmSegmentAddressRangeStatus+0x588
ISF=D64ADD6791FF0120 NIA=FFFFFFFFFFDC26A8 module
SmSegmentAddressRangeStatus+0x11C8
ISF=D64ADD6791FF0180 NIA=FFFFFFFFFFCC9734 module
SmGiantFaultHandler+0xDC4
ISF=D64ADD6791FF0220 NIA=FFFFFFFFFFCC99D4 module
SmGiantFaultHandler+0x1064
ISF=D64ADD6791FF0260 NIA=FFFFFFFF82648E30 module
ExIntHandlerHighUse+0x3A30
ISF=D64ADD6791FF02C0 NIA=FFFFFFFFF5305D58 module exmvsvst+0x298
ISF=D64ADD6791FF0D00 NIA=FFFFFFFFF5312D38 module
ExProcessCleanupHandlers+0xD8
ISF=D64ADD6791FF0F80 NIA=FFFFFFFFFF0D325C module
ExExceptHighUse+0xDFC
ISF=D64ADD6791FF1680 NIA=FFFFFFFFFF0D41F8 module
ExExceptHighUse+0x1D98
ISF=D64ADD6791FF1DE0 NIA=FFFFFFFFFFDC1A68 module
SmSegmentAddressRangeStatus+0x588
ISF=D64ADD6791FF1F00 NIA=FFFFFFFFFFDC26A8 module
SmSegmentAddressRangeStatus+0x11C8
ISF=D64ADD6791FF1F60 NIA=FFFFFFFFFFCC9734 module
SmGiantFaultHandler+0xDC4
ISF=D64ADD6791FF2000 NIA=FFFFFFFFFFCC99D4 module
SmGiantFaultHandler+0x1064
ISF=D64ADD6791FF2040 NIA=FFFFFFFF82648E30 module
ExIntHandlerHighUse+0x3A30
ISF=D64ADD6791FF20A0 NIA=FFFFFFFFF5305D58 module exmvsvst+0x298
----Interrupted instruction= FFFFFFFFFB0B24C4 module
DbstMdExprTreeAdmin+0xA604
ISF=D64ADD6791FF2AE0 NIA=FFFFFFFFFB0B24C8 module
DbstMdExprTreeAdmin+0xA608
ISF=D64ADD6791FF2D00 NIA=FFFFFFFFFB0B30D0 module
DbstMdExprTreeAdmin+0xB210
ISF=D64ADD6791FF2F00 NIA=FFFFFFFFFB067A70 module
DbstMdExprTree+0x1E70
ISF=D64ADD6791FF35E0 NIA=FFFFFFFFFB06A0C8 module
DbstMdExprTree+0x44C8
ISF=D64ADD6791FF3C00 NIA=FFFFFFFFFB17D510 module
DbstMdExpressionDNF+0x5D0
ISF=D64ADD6791FF3CC0 NIA=FFFFFFFFFB9DDE00 module
DbstMdExpressionIdConcrete+0x1820
ISF=D64ADD6791FF3D40 NIA=FFFFFFFFFB8160AC module
DbstMdExprPredicateConcrete+0x9DAC
ISF=D64ADD6791FF3EA0 NIA=FFFFFFFFFB8182E4 module
DbstMdExprPredicateConcrete+0xBFE4
ISF=D64ADD6791FF41C0 NIA=FFFFFFFFFC8D176C module
DbstMdProxyContext+0x236C
ISF=D64ADD6791FF4260 NIA=FFFFFFFFFB26AD14 module
DbopExprPredMisc+0x6EB4
ISF=D64ADD6791FF4460 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF4660 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF4860 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF4A60 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF4C60 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF4E60 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF5060 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF5260 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF5460 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF5660 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF5860 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF5A60 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF5C60 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF5E60 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF6060 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF6260 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF6460 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF6660 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF6860 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF6A60 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF6C60 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF6E60 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF7060 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF7260 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF7460 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF7660 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF7860 NIA=FFFFFFFFFB26ACA0 module
DbopExprPredMisc+0x6E40
ISF=D64ADD6791FF7A60 NIA=FFFFFFFFFB630A18 module
DbopExprPredList+0x4BB8
ISF=D64ADD6791FF7B20 NIA=FFFFFFFFFB99A06C module
DbopStatPredicate+0x3E0C
ISF=D64ADD6791FF7BA0 NIA=FFFFFFFFFB99A684 module
DbopStatPredicate+0x4424
ISF=D64ADD6791FF7D80 NIA=FFFFFFFFFB97E360 module
DbopPlanLog+0x6E20
ISF=D64ADD6791FF7E20 NIA=FFFFFFFFFB514894 module DbopNode+0xD354
ISF=D64ADD6791FF7EA0 NIA=FFFFFFFFFB515964 module DbopNode+0xE424
ISF=D64ADD6791FF7F60 NIA=FFFFFFFFFB515B3C module DbopNode+0xE5FC
ISF=D64ADD6791FF7FE0 NIA=FFFFFFFFFB4C2F94 module
DbopStratTopDog+0x7D4
ISF=D64ADD6791FFABA0 NIA=FFFFFFFFFBAB1478 module
DbopQuery+0x1F878
ISF=D64ADD6791FFB6C0 NIA=FFFFFFFFFB08076C module
DbopExecCommon+0xE54C
ISF=D64ADD6791FFC800 NIA=FFFFFFFFFB892284 module
DbopExecOptimizerRequest+0x29E4
ISF=D64ADD6791FFE940 NIA=FFFFFFFFFD089C00 module dbmaint+0x360
ISF=D64ADD6791FFEA60 NIA=FFFFFFFFFF0050E8 module #cfmir+0xE8
ISF=D64ADD6791FFEB20 NIA=FFFFFFFFFF094E58 module cfscv0a+0x158
ISF=E566A70C27FF8B60 NIA=3A5F00AC3716DA08 srvpgm QQQOOODBOP
offset 0x16DA08
ISF=E566A70C27FF8D60 NIA=3A5F00AC3716C670 srvpgm QQQOOODBOP
offset 0x16C670
ISF=E566A70C27FFB0E0 NIA=30F4A283FE046528 progrm QQQQUERY offset
0x44048
ISF=E566A70C27FFB300 NIA=30F4A283FE015004 progrm QQQQUERY offset
0x12B24
ISF=E566A70C27FFEC60 NIA=FFFFFFFFFFFF81D0 module #cfcblat+0x1D0
ISF=D64ADD6791FFEB80 NIA=FFFFFFFFFE0DE890 module
AiUpcallPortalUser+0xD0
ISF=E566A70C27FFECA0 NIA=1D4D2DF5780028AC progrm QQQOPNQF offset
0x11DC
ISF=E566A70C27FFF0C0 NIA=FFFFFFFFFE25F540 module #excctrp+0x0
ISF=D64ADD6791FFEDC0 NIA=FFFFFFFFFE0DE890 module
AiUpcallPortalUser+0xD0
ISF=E566A70C27FFF1E0 NIA=2A927D3ED30036F8 progrm QCMDEXC offset
0x2028

CORRECTION FOR APAR MA46549 :
-----------------------------
XOR operations are converted to AND/OR predicates when handled
by SQE optimizer.  If many XOR operations are included in an
OPNQRYF, the resulting predicate structure is too complicated to
correctly represent.  In this case, it was overwhelming the
statistics engine and leading to failures that ultimately caused
the crash.  PTF will prevent the failure.

CIRCUMVENTION FOR APAR MA46549 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF64166      LIC-DB Statistics engine gives a poor estimate for partition
   MF63932      OSP-DB-OTHER-F/QLIDLOBJ-MSGCPF2105 A TEMP FILE THAT IS CREAT
   MF64300      OSP-DB-OTHER-F/SKGUARD-T/QDBGETMQO-MSGMCH3601 WHEN EXECUTING
   MF63891      LIC-DB Internal Maintenance
   MF63797      LIC-DB-OTHER-PERFM Query runs slowly because it uses MTI ins
   MF63732      LIC-DB-OTHER-PERFM Improved optimization time for queries wi
   MF63729      OSP-DB-OTHER-PERFM INEFFICIENT MTI USED IN A PLAN
   MF62671      LIC-DB-OTHER-PERFM SQL STATEMENT CONTAINING A RCTE IS RE-OPT
   MF63726      LIC-DB-OTHER-PERFM Bad record count estimates for certain qu
   MF63589      OSP-DB-OTHER-PERFM DATA SKEW IN A JOIN CAUSED A SLOW PLAN TO
   MF63453      LIC-DB-PERFM FETCH FIRST ROW query over table runs slowly
   MF63409      LIC-DB-OTHER-PERFM IMPROVE DB ESTIMATE
   MF63404      OSP-PAR-940XMISC IMPROVE OPTIMIZER RECORD COUNT ESTIMATE OF
   MF62719      LIC-DB-OTHER-PERFM I/O statistics estimates cause poor query
   MF62598      LIC-DB-OTHER Improve statistic estimates for OLAP queries
   MF62036      LIC-DB-OTHER-UNPRED OLAP query with regression function fail
   MF62549      LIC-DB-OTHER-PERFM IMPROVE COSTING EVALUATION FOR AUX STORAG
   MF62444      OSP-PERFM ESTIMATES IN LARGE IN LIST CONVERSION TREES CAUSIN
   MF62437      LIC-DB Handle missing index during predicate checking on pla
   MF62235      LIC-DB Improvements to long EKR time tracking
   MF61819      LIC-DB Poor record count estimates in complex RRN AND/OR pla
   MF61785      LIC-DB-OTHER-PERFM Improved query optimizer costing for tabl
   MF61734      LIC-DB-OTHER Temporary storage may leak when running SQL que
   MF61663      LIC-DB-OTHER-PERFM SQE query may run slowly when OPTIMIZE FO
   MF61574      OSP-LOOP JOB LOOPING IN DBSTMDEXPRTREEADMIN
   MF61574      LIC-DB Add QRO hash in optimization trace for AQP/GCM estima
   MF61544      LIC-DB-OTHER Query with multiple OLAP functions fails with M
   MF61543      LIC-DB-OTHER Increase database random Input/Output initial b
   MF61427      LIC-DB-OTHER Failure when query predicate includes some OLAP
   MF61285      LIC-DB Offload long EKR estimates found during optimization
   MF61257      LIC-DB-OTHER-PERFM Stale column statistics not analyzed duri
   MF61257      LIC-DB-OTHER-PERFM Improved column statistics collection for
   MF61147      LIC-DB Improve optimizer estimate for partitioned tables wit
   MF61147      LIC-DB Estimate improvement for EOA plans with partitioned t

Summary Information

System.............................. i
Models..............................
Release............................. V7R3M0
Licensed Program............... 5770999
APAR Fixed.......................... View details for APAR MA46549
Superseded by:...................... View fix details for PTF MF65703
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C8242730


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, 2018, 2019 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.

Document information

More support for: i family

Software version: V7R3M0

Operating system(s): OS/400

Reference #: MF64286

Modified date: 07 February 2018