IBM Support

MF53752 - LIC-DB-WAIT XPF DB Server job (QDBSRVnn) hangs in TIMW after

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

LIC-DB-WAIT XPF DB Server job (QDBSRVnn) hangs in TIMW after


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF49920   00/00    0000
CO   5770999  710  MF53753   00/00    0000
CO   5770999  710  MF52109   00/00    0000
CO   5770999  710  MF51592   00/00    0000
CO   5770999  710  MF51275   00/00    0000
CO   5770999  710  MF51011   00/00    0000
CO   5770999  710  MF50659   00/00    0000
CO   5770999  710  MF50660   00/00    0000
CO   5770999  710  MF50190   00/00    0000
CO   5770999  710  MF50191   00/00    0000
CO   5770999  710  MF49911   00/00    0000
CO   5770999  710  MF48430   00/00    0000
CO   5770999  710  MF47886   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

-----------------------------------------------
Cancellation of certain complex queries executing with SMP may
result in an XPF DB Server job (QDBSRVnn) hanging in TIMW.

The stack will be similar to this:

Task: TDE=B004D0000A7A1000 TaskName=MITHREAD QDBSRV39  QSYS
654722     TimeSinceRun=65:27:09.024 TotalRunTime=0:00:56.038
WaitObj=E716FEA2B50FA528 QTB-QuSingleTaskBlocker
WaitObjCaller=FFFFFFFFFF357378 module SkRefCount+0xB78
ISF=CAB72F1AF5FFB060 NIA=FFFFFFFFFD013C08 module
RmprLongWaitRcvBlocker+0x288
ISF=CAB72F1AF5FFB120 NIA=FFFFFFFFFF357378 module
SkRefCount+0xB78
ISF=CAB72F1AF5FFB240 NIA=FFFFFFFFFF3570F8 module
SkRefCount+0x8F8
ISF=CAB72F1AF5FFB2C0 NIA=FFFFFFFFFC438B18 module DbpmQds+0x90B8
ISF=CAB72F1AF5FFB380 NIA=FFFFFFFFC8504DB0 module
DbpmDataSource+0xB7B0
ISF=CAB72F1AF5FFB420 NIA=FFFFFFFFC84FCBD4 module
DbpmDataSource+0x35D4
ISF=CAB72F1AF5FFB4A0 NIA=FFFFFFFFFC1C04CC module
DbpmReadOnlyQuery+0x10CCC
ISF=CAB72F1AF5FFB5C0 NIA=FFFFFFFFC785FF94 module
DbopRunTimeInfo+0x534
ISF=CAB72F1AF5FFB680 NIA=FFFFFFFFC78602F4 module
DbopRunTimeInfo+0x894
ISF=CAB72F1AF5FFB700 NIA=FFFFFFFFC7861A04 module
DbopRunTimeInfo+0x1FA4
ISF=CAB72F1AF5FFB780 NIA=FFFFFFFFC6889B60 module
DbopPlanCacheControls+0x14C60
ISF=CAB72F1AF5FFF180 NIA=FFFFFFFFFD099378 module dbmaint+0x608
ISF=CAB72F1AF5FFF240 NIA=FFFFFFFFFF0050E8 module #cfmir+0xE8
ISF=CAB72F1AF5FFF300 NIA=FFFFFFFFFF07DBAC module cfscv0a+0x12C
ISF=D9D2F8BF8BFFEDC0 NIA=3548A540A60063B4 progrm
QSYS/QQQOOOPLAN-QQQOOOPLAN:+0x64 Stmt# 6230
ISF=D9D2F8BF8BFFEEE0 NIA=3548A540A6003124 progrm
QSYS/QQQOOOPLAN-QQQOOOPLAN:QQQOOOPLAN+0x1624 Stmt# 5461
ISF=D9D2F8BF8BFFF980 NIA=FFFFFFFFFFFF81D0 module #cfcblat+0x1D0
ISF=CAB72F1AF5FFF360 NIA=FFFFFFFFFE0D7CD4 module
AiUpcallPortalUser+0xC4
ISF=D9D2F8BF8BFFF9C0 NIA=3ED9617B3B001C5C progrm
QSYS/QQQOOOHNDL-QQQOOOHNDL:QQQOOOHNDL+0x45C Stmt# 2943
ISF=D9D2F8BF8BFFFBC0 NIA=FFFFFFFFFFFF81D0 module #cfcblat+0x1D0
ISF=CAB72F1AF5FFF5A0 NIA=FFFFFFFFFE0D7CD4 module
AiUpcallPortalUser+0xC4
ISF=D9D2F8BF8BFFFC00 NIA=1AE049473D0020D0 progrm
QSYS/QDBSERVE+0xA00 Inst# 0x74
ISF=D9D2F8BF8BFFFEC0 NIA=FFFFFFFFFE2F26D0 module #excctrp+0x0
This frame is trapped for Callee Cleanup......
Its true NIA=FFFFFFFFFFFF81D0 module #cfcblat+0x1D0
ISF=CAB72F1AF5FFF7E0 NIA=FFFFFFFFFE253CCC module
AiUpcallPortalMach+0x5C
ISF=CAB72F1AF5FFFA20 NIA=FFFFFFFFC3886980 module
pminitiateprocess+0x2D40
ISF=CAB72F1AF5FFFF20 NIA=0000000000000000 Not valid instruction
address
Stack unwind complete

CORRECTION FOR APAR MA41219 :
-----------------------------
SQE cancel processing during parallel query temporary object
population has a problem where it goes for resource it already
holds.  This problem causes cancel processing to fail and leaves
process in TIMW status.   A fix has been made to cancel
processing to avoid this problem.

CIRCUMVENTION FOR APAR MA41219 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF53483      LIC-DB-PERFM Make MTIs immediate maintenance capable for bet
   MF52773      LIC-DB-OTHER-THREADS-F/DBPMTRAP-T/QQQOOOUPCL-RC1720-MSGMCH32
   MF52279      LIC-OTHER RE-COMPILE TO INCLUDE ADDITIONAL LIC SEGMENTS
   MF52108      LIC-DB-OTHER-PERFM Threads executing certain parallel querie
   MF52040      OSP-DB-OTHER-UNPRED JOBS USING RUNNING A FENCED USER-DEFINED
   MF51593      LIC-DB-OTHER-PERFM Performance enhancements for Keep in memo
   MF51280      LIC-DB-PERFM Non-preload brings not targeting specific pool
   MF51012      LIC-DB-PERFM SQL Select with inner join on RRN performs poor
   MF50658      LIC-DB-OTHER Recursive Common Table Expression (RCTE) Enhanc
   MF50581      LIC-DB-MSGMCH3402 encountered during SQE query temporary ind
   MF50188      LIC-DB-MSGMCH1807 Insert into a table with an EVI with INCLU
   MF50142      LIC-DB pseudo open of SQE query orphans record lock
   MF49909      LIC-DB-INCORROUT Correctly transfer translate table storage
   MF49867      LIC-DB-PERFM EVI with INCLUDE performance improvements
   MF49663      LIC-DB-WAIT Plan cache task is trying to get infomation from
   MF49551      LIC-DB-PERFM EVI with INCLUDE performance improvements
   MF49515      LIC-DB-WAIT QZDASOINIT jobs would not end after varying off
   MF49441      LIC-DB-WAIT QDBSRV job hung on QuSingleTaskBlocker
   MF49344      LIC-DB-WAIT QZDASOINIT jobs would not end after varying off
   MF49203      LIC-DB-WAIT Cancellation of an EVI with INCLUDE build may re
   MF49070      LIC-DB-OTHER 0600 BAD3 vlog produced after delete of EVI wit
   MF48991      LIC-DB-WAIT Hang on single task blocker in SkRefCount after
   MF48918      LIC-DB-INCORROUT Fix problem in restore of aggregate EVI.
   MF48853      LIC-DB-PERFM Excessive number of single page segment extensi
   MF48691      LIC-DB-MSGMCH3601  Creation of EVI with INCLUDE fails with M
   MF48529      LIC-DB-WAIT Dead lock possible when creating a large EVI wit
   MF48429      LIC-DB EVI with INCLUDE build status function not working as
   MF47880      LIC-DB Aggregate EVI build error data is not being retrieved

Summary Information

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


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:
12 September 2011