IBM Support

MF56378 - LIC-DB-OTHER-LOOP Database jobs not ending

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

LIC-DB-OTHER-LOOP Database jobs not ending


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF55844   00/00    0000
PRE  5770999  710  MF51012   00/00    0000
PRE  5770999  710  MF49782   00/00    0000
CO   5770999  710  MF56253   00/00    0000
CO   5770999  710  MF56162   00/00    0000
CO   5770999  710  MF56160   00/00    0000
CO   5770999  710  MF56161   00/00    0000
CO   5770999  710  MF56035   00/00    0000
CO   5770999  710  MF55950   00/00    0000
CO   5770999  710  MF55769   00/00    0000
CO   5770999  710  MF55437   00/00    0000
CO   5770999  710  MF55258   00/00    0000
CO   5770999  710  MF55249   00/00    0000
CO   5770999  710  MF53805   00/00    0000
CO   5770999  710  MF53696   00/00    0000
CO   5770999  710  MF53695   00/00    0000
CO   5770999  710  MF52508   00/00    0000
DIST 5770SS1  710  SI43994   00/00    0000
DIST 5770SS1  710  SI37397   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

-----------------------------------------------
One or more database jobs may fail to end in a timely manner due
to infinite looping. Process information will show the looping
module is DbListHome.

CORRECTION FOR APAR MA42477 :
-----------------------------
Jobs generate index advice for queries that used Maintained
Temporary Indexes (MTIs) as a source of statistics. When
multiple jobs simultaneously generate advice for the same MTI,
internal data structures may become corrupted, leading to the
looping behavior. This fix disables index advice under these
conditions. Index advice for MTIs used to implement a query
remains enabled.

CIRCUMVENTION FOR APAR MA42477 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF56360      LIC-DB-OTHER-F/QQQSRVI1-T/QQQVFMT-MSGCPF9898 SQE STATEMENT F
   MF56348      LIC-DB-OTHER-PERFM QUERY IS REOPTIMIZED MORE OFTEN AFTER A R
   MF56339      LIC-DB-OTHER SQE TRACING IMPROVEMENTS
   MF56255      OSP-DB SQL Plan Cache - filter by index advise key columns
   MF56207      LIC-DB-PERFM-OTHER ADDITIONAL TRACING FUNCTIONALITY TO DEBUG
   MF56188      OSP-DB SQL Plan Cache - filter by index advise key columns
   MF56143      OSP-PERFM LONG RUNNING SQL DUE TO BAD ESTIMATE WITH FETCH N
   MF56036      OSP-INCORROUT OSP INCORROUT PLANCACHE POOLID
   MF55987      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 A MSGMCH3203 F
   MF55952      LIC-DB-MSGMCH3601 relating to partitioned tables and EVIs
   MF55948      DB Issue#48254-BADA - DbopParmContainer Ptr not set
   MF55943      LIC-DB-PERFM Performance Problems when DBMON active
   MF55879      LIC-DB-MSGMSG3203 0600 BADA from DbopHandlerAQP
   MF55867      LIC-DB-PERFM Overflow condition on EVI with INCLUDE over tab
   MF55837      OSP-DB-OTHER-PERFM OPTIMIZATION ENHANCMENT
   MF55806      OSP-DB-OTHER-SRCB6005121-UNPRED WORD 1: SRCB6005121 WORD 3:
   MF55767      OSP-DB Visual Explain, Not able to explain a query access pl
   MF55651      LIC-DB-OTHER Internal maintenance
   MF55516      LIC-DB-OTHER-PERFM INCONSISTENT PERFORMANCE FOR A JOIN QUERY
   MF55443      LIC-DB-PERFM-OTHER AQP LOGIC CHANGES
   MF55434      LIC-DB-OTHER-PERFM SUPPORT PLAN CACHE AUTOSIZING
   MF55328      OSP-DB-OTHER Avoid indexes when creating EVI INCLUDE index
   MF55301      LIC-DB-OTHER Add targeted tracing support for CHECK_PSEUDO_H
   MF55266      LIC-DB-OTHER not revalidating on Workload Group changes
   MF55257      LIC-DB-PERFM Optimization of partitioned table query with de
   MF55250      LIC-DB Index advice missing or incorrect
   MF55125      OSP-OTHER-UNPRED VL0600BADD GENERATED WHEN SYSTEM CREATES AN
   MF55120      LIC-DB-OTHER TARGETED TRACE FIX FOR AQP IN THE SQL ENGINE
   MF55019      LIC-DB-MSGMCH3402 SQE Optimizer is not handling numeric(32)
   MF54954      LIC-DB-OTHER IMPROVE SQE TRACING
   MF54815      LIC-DB-UNPRED referencing deleted storage when PSEUDO_OPEN_C
   MF54815      OSP-OTHER-F/#DBCINDS-T/QQQOOODBOP-MSGMCH2804 QUERY FAILS WIT
   MF54458      OSP-DB Database Monitor host variable value = 222.2
   MF54264      LIC-DB-OTHER-LOOP Job loops on list spinlock
   MF54051      LIC-DB Actively maintain MTIs
   MF54023      LIC-DB-PERFM-OTHER Problems with costing Select/Omit indexes
   MF53920      OSP-DB Database Monitor host variable value = Infinity
   MF53849      LIC-DB Internal maintenance
   MF53757      OSP-DB-OTHER-INCORROUT UDF USING THE CURRENT_TIME SQL PREDIC
   MF53622      OSP-DB-OTHER-UNPRED SQL INSERT WITH SUM HANGS WHEN RAN WITH
   MF53588      OSP-DB Internal Maintenance for Database Monitor
   MF53588      LIC-DB-PERFM BAD STAT IN THE GLOBAL CONTEXT.
   MF53556      LIC-DB-OTHER SQL OPTIMIZER TRACE IMPROVEMENTS
   MF53476      LIC-DB-PERFM Add PSEUDO_OPEN_CHECK_HOST_VARS QAQQINI option
   MF53357      LIC-DB-OTHER-PERFM TOO MANY PLANS IN THE PLAN CACHE FOR A GI
   MF53023      OSP-DB-OTHER-INCORROUT A FIELDPROC MAY SHOW CACHED RESULTS I
   MF53023      OSP-DB-OTHER-SAP400-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 SAP C
   MF53023      LIC-DB-OTHER-PERFM COMPLEX QUERY PLAN IS TOO LARGE TO BE SAV
   MF53023      LIC-DB-INCORROUT S/O INDEX INCORRECTLY USED IS CAUSING INCOR
   MF52863      OSP-DB-OTHER-INCORROUT SPARSE PREDICATE VALIDATION NOT HANDL
   MF52506      OSP-DB-OTHER-UNPRED SQL ROQ SIZES TOO LARGE AND BEING CACHED
   MF52489      LIC-DB-OTHER-UNPRED 0600 BADA VLOG may be produced after can
   MF52458      LIC-DB Connect By infrastructure
   MF52419      LIC-DB-PERFM Performance on query of MULTI-DS LFs
   MF52251      LIC-PERFM DBOPAQCM/findLowerLeftNode looping starting the CP
   MF52183      LIC-DB-OTHER Internal Maintenance
   MF51929      LIC DB - 0600 BADD LIC logs from removeIter
   MF51380      LIC-DB-PERFM SQE optimization performance
   MF50491      OSP-DB-PERFM Not using MQT when MQT matches query selection
   MF51322      LIC-DB-OTHER-PERFM SQE performance improvements
   MF51189      OSP-DB Creation of SQL deflated table
   MF49927      LIC-DB-PERFM Improve EVI with INCLUDE costing in low memory
   MF48571      OSP-OTHER-PERFM DUPLICATE TRANSLATE TABLES
   MF50862      LIC-DB-OTHER Internal maintenance
   MF50650      OSP-DB Visual Explain showing incorrect host variable values
   MF50649      OSP-DB Visual Explain showing incorrect host variable values
   MF50462      LIC-DB-OTHER Plan Cache Dump not showing the correct pool in
   MF49991      LIC-DB Generating DbopTrace on MSGMCH6260
   MF49959      LIC-DB-OTHER LPG HIGHLIGHTING IS NOT WORKING CORRECTLY IN TH
   MF49911      LIC-DB-INCORROUT Correctly transfer translate table storage
   MF49798      OSP-DB Performance enhancement for SQL MERGE statement
   MF49766      LIC-DB Array fixes
   MF49636      LIC-DB-INCORROUT Graphic values in the DBMON 3010 record
   MF48338      LIC-DB Not deallocating storage
   MF49611      DB-LIC-PERFM Enable CREATE EVI with INCLUDE  with SMP settin
   MF49529      LIC-DB-PERFM STRDBMON missing QQQ3010 record and BADD vlog
   MF49417      LIC-DB-OTHER Update Detailed Plan Cache Dump
   MF49397      DB-LIC-INCORROUT Wrong results possible with Encoded Vector
   MF49346      LIC-DB-PERFM REDUCE PAGE FAULTING DURING SQL PLAN VALIDATION
   MF49346      LIC-DB-OTHER INDEX ADVISE INFRASTRUCTURE CHANGE
   MF49346      LIC-DB-OTHER SQL OPTIMIZER TRACING IMPROVEMENTS
   MF49341      LIC-DB 0600 BADA VLOGs generated while running SQL queries
   MF49158      OSP-DB Array fixes
   MF49112      LIC-DB-INCORROUT Missing decFloat values in DBMON 3010 recor
   MF49037      LIC-DB SQL query performs poorly
   MF48981      OSP-DB-OTHER-PERFM SQL STATEMENTS PERFORM WORSE AT R610 OVER
   MF48970      LIC-DB-SQL query runs very poorly after AQP plan replacement
   MF47999      LIC DB DBST Static Variable Cleanup
   MF48909      LIC DB PERFM Allow MQTs and EVIs with INCLUDE to coexist.
   MF48793      OSP-DB-OTHER-F/ASSERT-T/QQQOOODBOP-RC1720-MSGMCH3203 COMPLEX
   MF48753      LIC-DB Visual Explain of plan contains value of 'UNKNOWN' fo
   MF48753      LIC-DB Beam fix for NULL class pointer
   MF48622      OSP DB OTHER EVI Include and aggregation rounding mode
   MF48567      LIC-DB SQL query does not complete.
   MF48567      OSP-DB-OTHER-PERFM NEW QAQQINI OPTION, DETERMINISTIC_UDF_SCO
   MF48424      LIC-DB VLOG contains many VLOGs with major code 0600, minor
   MF48354      LIC-DB Numerous Database VLOGs, major code 0600, minor code
   MF48030      LIC-DB-MSG3203 SQL query with grouping sets clause fails
   MF48125      LIC-DB-OTHER-F/ASSERT-T/QQQOOODBOP-MSGMCH3203 AND TEMP STORA
   MF47919      LIC-DB Too many DataBase Monitor Records

Summary Information

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


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:
30 November 2012