IBM Support

MF63979 - 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  V7R2M0    MF60049   00/00    0000
CO   5770999  V7R2M0    MF62065   00/00    0000
CO   5770999  V7R2M0    MF60904   00/00    0000
CO   5770999  V7R2M0    MF59448   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
--------------  ------------------------------------------------------------
   MF63961      OSP-OTHER-PERFM QUERY, OVER PARTITIONED TABLES, IS PERFORMIN
   MF63821      OSP-PAR-940XBASE STATS ARE NOT UPDATED ON A PARTITIONED TABL
   MF63796      LIC-DB-OTHER-PERFM Query runs slowly because it uses MTI ins
   MF63728      OSP-DB-OTHER-F/QLIDLOBJ-MSGCPF2105 A TEMP FILE THAT IS CREAT
   MF63643      OSP-OTHER-PERFM QUERY PERFORMANCE
   MF63454      OSP-DB-OTHER-PERFM INEFFICIENT MTI USED IN A PLAN
   MF63379      LIC-DB-OTHER-PERFM IMPROVE DB ESTIMATE
   MF63246      LIC-DB-PERFM FETCH FIRST ROW query over table runs slowly
   MF63010      LIC-DB Internal Maintenance
   MF62501      LIC-DB-OTHER-PERFM SQL STATEMENT CONTAINING A RCTE IS RE-OPT
   MF62436      LIC-DB Handle missing index during predicate checking on pla
   MF62220      LIC-DB-OTHER-PERFM IMPROVE COSTING EVALUATION FOR AUX STORAG
   MF62171      OSP-PERFM ESTIMATES IN LARGE IN LIST CONVERSION TREES CAUSIN
   MF62066      LIC-DB Poor record count estimates in complex RRN AND/OR pla
   MF62064      LIC-DB-OTHER Increase database random Input/Output initial b
   MF61898      LIC-DB-OTHER-PERFM Improved query optimizer costing for tabl
   MF61753      LIC-DB Keep track of longest estimate key range during optim
   MF61735      LIC-DB-OTHER Temporary storage may leak when running SQL que
   MF61631      LIC-DB-OTHER-LOOP A query predicate with multiple large NOT
   MF61458      OSP-LOOP JOB LOOPING IN DBSTMDEXPRTREEADMIN
   MF61402      LIC-DB-OTHER-PERFM SQE query may run slowly when OPTIMIZE FO
   MF61370      LIC-DB Add QRO hash in optimization trace for AQP/GCM estima
   MF61115      LIC-DB Estimate improvement for EOA plans with partitioned t
   MF61098      LIC-DB-OTHER-PERFM Stale column statistics not analyzed duri
   MF61081      LIC-DB-OTHER-PERFM STATEMENT WITH LEFT OUTER JOIN AND COALES
   MF60905      LIC-DB-OTHER-PERFM Improved column statistics collection for
   MF60841      OSP-DB-OTHER-PERFM BAD DBST ESTIMATE WHEN GETTING INVALID CA
   MF60813      LIC-DB Improve optimizer estimate for partitioned tables wit
   MF60686      OSP-OTHER-PERFM QUERY WITH RECURSIVE COMMON TABLE EXPRESSION
   MF60675      LIC-DB Estimate Improvement for complex bitmap AND/OR tree s
   MF60631      OSP-PAR-940XMISC BETTER STATS USAGE FOR PARTITONED TABLES
   MF60513      OSP-PAR-940XMISC PARTITION TABLE ESTIMATE IMPROVEMENT
   MF60485      OSP-OTHER-PERFM AFTER LOADING GROUP PTFS AND IPLING, QUERY C
   MF60301      LIC-DB-OTHER-PERFM Improved record counts for certain join q
   MF60278      OSP-LOOP JOB LOOPING ON DBSTPOINTERMAPHOMEMACH+0X98A8
   MF60274      OSP-DB-OTHER-PERFM SELECT/OMIT INDEX IN FROM CLAUSE NOT USED
   MF60260      LIC-DB-OTHER-PERFM TABLE SCAN FOR AGGREGATION QUERY RESULTS
   MF60164      OSP-DB-OTHER-LOOP SQE LOOP
   MF60050      LIC-DB-OTHER-PERFM TABLE SCAN FOR AGGREGATION QUERY RESULTS
   MF59986      OSP-OTHER-PERFM LONG CURSOR OPEN TIME WITH INCREASED CPU CON
   MF59986      LIC-DB Prevent 0600/BADA VLOG during AQP analysis
   MF59870      LIC-DB Improved record counts for left outer join queries wi
   MF59827      LIC-DB-OTHER-PERFM INTERMITTENT POOR SQL PERFORMANCE
   MF59827      OSP-PAR THE STATISTICS ENGINE IS INCORRECTLY UPDATING HOST V
   MF59729      OSP-PAR-940XMISC MTI BEING BUILT WITH A BUFFER SCAN OVER AN
   MF59729      OSP-DB-OTHER-PERFM SQL SELECT INTERMITTENT RUNS VERY MUCH LO
   MF59700      LIC-DB Improve cardinality, selectivity estimates with compl
   MF59449      OSP-PERFM QUERIES AT R710 ARE RUNNING SLOWER UNLESS THE INLI
   MF59417      OSP-PERFM SQL OVER A VIEW CAUSES LONG OPTIMIZATION TIMES
   MF59417      LIC-DB-OTHER-PERFM LONG EKR (ESTIMATE KEY RANGE) DURING QUER
   MF59351      OSP-DBSMP-PERFM Query runs slowly after a bad AQP estimate r
   MF59351      LIC-DB Improved cardinality estimate over multiple PT column
   MF59000      OSP-DB-OTHER-PERFM LARGE SYSTEMS CAN EXPERIENCE MACHINE GATI
   MF59000      OSP-DB-OTHER-PERFM QUERY SLOW, USES MORE CPU, GETKEYRANGEEST
   MF58904      LIC-DB-Other Internal Maintenance
   MF58904      LIC-DB Internal changes to improve statistical estimates
   MF58860      LIC-DB-OTHER-PERFM QUERY OPTIMIZER DOES NOT IMPLEMENT VIA AN
   MF58793      OSP-LOOP DBSTMDEXPRESSIONVALUEBASE
   MF58438      LIC-DB-OTHER-PERFM Incorrect disk response time estimates fo
   MF58402      LIC-DB-OTHER-PERFM DISTINCT QUERY PERFORMS POORLY FOLLOWING
   MF58283      LIC-DB Internal Maintenance
   MF58176      LIC-DB-OTHER-PERFM SQL OVER PARTITION TABLE HIGH CPU.
   MF58176      LIC-DB Incorrectly using EVI for cardinality estimate
   MF58001      LIC-DB Internal Maintenance
   MF57875      LIC-DB Internal Maintenance
   MF57627      LIC-DB Internal Maintenance

Summary Information

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


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: V7R2M0

Operating system(s): OS/400

Reference #: MF63979

Modified date: 25 October 2017