IBM Support

MF63507 - SQL-RUN-WAIT SQL SELECT QUERIES HANG. THE JOBS REMAINED IN E

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

SQL-RUN-WAIT SQL SELECT QUERIES HANG. THE JOBS REMAINED IN E


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  MF61350   00/00    0000
CO   5770999  710  MF61351   00/00    0000
CO   5770999  710  MF61113   00/00    0000
CO   5770999  710  MF59874   00/00    0000
CO   5770999  710  MF59878   00/00    0000
CO   5770999  710  MF59879   00/00    0000
CO   5770999  710  MF52109   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

-----------------------------------------------
SELECT Queries hang, the jobs remained in END status. No joblog,
no call stack available.

TASKINFO showed
Last dispatch timebase: 0009BAF64330594A (negative 'SinceRun'
means task ran after this)
***Dumping task (at breakpoint) on current logical processor
TDE=B00150000FA70000 Name=MSTHREAD:QDBSRV12 QSYS 341851
SinceRun=000:00:07.811351 CPU=000:00:00.057580 Pri=C0 tdescr=004
WaitObject=C0DC5FE265000900 QQu-QuQueue
WaitCaller=FFFFFFFFF76A8E8C module rirsServiceBreakpoint+0x46C
InitialTDE=B00140000EBBB000
REG1=C84FAF3EB2FFEEC0 NIA=FFFFFFFFFF6C0B24 module
SkRefCount+0xC84
..................... LR=FFFFFFFFFF6C0AE8 module
SkRefCount+0xC48
ISF=C84FAF3EB2FFEEC0 NIA=FFFFFFFFFF6C0B28 module
SkRefCount+0xC88
ISF=C84FAF3EB2FFF000 NIA=FFFFFFFFFCCC39CC module DbpmQds+0xCF8C
ISF=C84FAF3EB2FFF0C0 NIA=FFFFFFFFC9E39BDC module
DbpmDataSource+0xCC1C
ISF=C84FAF3EB2FFF120 NIA=FFFFFFFFC9E30D94 module
DbpmDataSource+0x3DD4
ISF=C84FAF3EB2FFF1A0 NIA=FFFFFFFFFCC5BDF8 module
DbpmReadOnlyQuery+0x12D98
ISF=C84FAF3EB2FFF300 NIA=FFFFFFFFFBCDFEB4 module
DbopRunTimeInfo+0x574
ISF=C84FAF3EB2FFF3E0 NIA=FFFFFFFFFBCE03AC module
DbopRunTimeInfo+0xA6C
ISF=C84FAF3EB2FFF460 NIA=FFFFFFFFCD818EB0 module
DbServerBase+0xA30
ISF=C84FAF3EB2FFF520 NIA=FFFFFFFFCD8192EC module
DbServerBase+0xE6C
ISF=C84FAF3EB2FFF680 NIA=FFFFFFFFCD7D8F10 module
DbAsyncCall+0x1790
ISF=C84FAF3EB2FFF840 NIA=FFFFFFFFFD21AD28 module dbmaint+0x1938
ISF=C84FAF3EB2FFF960 NIA=FFFFFFFFFF0050E8 module #cfmir+0xE8
ISF=C84FAF3EB2FFFA20 NIA=FFFFFFFFFF0D1658 module cfscv0a+0x148
ISF=EFDD9410FDFFFC60 NIA=02F4192AD500387C srvpgm
QSYS/QQQOOOUPCL-QQQOOOUPCL:DbopThreadMain__FP14DbopThreadParm+0x
FC Stmt#=3
ISF=EFDD9410FDFFFDA0 NIA=1C66B184B400B36C srvpgm
QSYS/QLESPI-QLECRTTH:LE_Create_Thread2__FP12crtth_parm_t+0x21C
Stmt#=20
ISF=EFDD9410FDFFFEE0 NIA=FFFFFFFFFFFF81D0 module #cfcblat+0x1D0
ISF=C84FAF3EB2FFFA80 NIA=FFFFFFFFFE1A12B8 module
AiUpcallPortalMach+0xC8
ISF=C84FAF3EB2FFFCC0 NIA=FFFFFFFFC227D934 module
pminitiatethread+0x2C24
ISF=C84FAF3EB2FFFF20 NIA=0000000000000000 Not valid instruction
address
Stack unwind complete

CORRECTION FOR APAR MA46307 :
-----------------------------
During the processing of the cancellation of an SMP query a
cancellable wait may be entered briefly.  If the executing job
is ended, then a resource in the query execution object (QEO)
may remain held.  When that QEO is destroyed in a QDBSRVnn
thread, it may result in that thread hanging on the stacks
posted below.  If this happens enough times, all of the server
threads may become hung in different objects in this state.  At
that point, without any server threads to perform normal SQE
work, new queries may begin to hang.

The fix associated with this defect is to ensure that the
resource is released in this situation.

CIRCUMVENTION FOR APAR MA46307 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF61761      LIC-OTHER-LOOP JOB RUNNING DB QUERY WON'T END EVEN AFTER END
   MF61349      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF61114      LIC-DB-OTHER-LOOP a query accessing a table that is being re
   MF59996      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF59877      LIC-DB-OTHER-UNPRED Enable logging of page header mismatch f
   MF59088      LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
   MF58582      LIC-DB-OTHER-PERFM An SQL CANCEL of an SMP query may take an
   MF58202      LIC-DB-UNPRED Index build status file 16 byte alignment
   MF57164      OSP THREAD HANG WHEN SMP QUERY PROCESSING IS CANCELLED. DEFA
   MF56710      LIC-DB-OTHER-PERFM Cancel of a temporary index build (MTI) m
   MF56016      LIC-DB-PERFM Parallel SQE query not finishing as expected
   MF53752      LIC-DB-WAIT XPF DB Server job (QDBSRVnn) hangs in TIMW after
   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 MA46307
Superseded by:......................View fix details for PTF MF64223
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C7192710


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.

[{"Type":"MASTER","Line of Business":{"code":"LOB08","label":"Cognitive Systems"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"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":""}}]

Document Information

Modified date:
24 April 2017