IBM Support

MF61476 - LIC-DB-OTHER-UNPRED Internal Database Maintenance

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

LIC-DB-OTHER-UNPRED Internal Database Maintenance


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770999  710  MF61477   00/00    0000
CO   5770999  710  MF61478   00/00    0000
CO   5770999  710  MF61349   00/00    0000
CO   5770999  710  MF60730   00/00    0000
CO   5770999  710  MF59878   00/00    0000
CO   5770999  710  MF59879   00/00    0000
CO   5770999  710  MF59274   00/00    0000
CO   5770999  710  MF58699   00/00    0000
CO   5770999  710  MF55214   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

-----------------------------------------------
Internal Database Maintenance

CORRECTION FOR APAR MA45343 :
-----------------------------
Internal Database Maintenance

CIRCUMVENTION FOR APAR MA45343 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF61350      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF61308      OSP-DB-OTHER-PERFM AFTER DELETION OF RECORDS A SELECT COUNT
   MF61112      LIC-DB-OTHER-LOOP a query accessing a table that is being re
   MF60731      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF60231      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF59997      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF59876      LIC-DB-OTHER-UNPRED Enable logging of page header mismatch f
   MF59472      LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
   MF59290      OSP-DB-OTHER-PERFM SCAN OF EVI OVERFLOW AREA CAUSES PERFORMA
   MF59087      LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
   MF58698      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF58348      LIC-DB-OTHER-INCORROUT Duplicate values incorrectly returned
   MF57347      OSP-DB-OTHER-THREADS-LOOP In a job with Maximum threads set
   MF57225      LIC-DB EVI processing fails on reuse due to original EVI ove
   MF57049      OSP-OTHER-PERFM redundant disk read attempts result in waste
   MF55556      LIC-DB-MSGMCH1807 during index maintenance - index cannot be
   MF55486      LIC-DB-INCORROUT Error not returned as expected from XMLTABL
   MF55216      LIC-DB Simple record deadlock detection improvement
   MF54985      LIC-DB-MSGCPF8111 DAMAGED TABLE ON UPDATE OF TENTATIVE INSER
   MF53304      LIC-DB-OTHER-UNPRED DAMAGE FILE. VL06001C85, VL06003585, VL0
   MF51774      LIC-DB-OTHER-INCORROUT ON SQE QUERY WITH ORDER BY CLAUSE
   MF51278      LIC-DB-PERFM Non-preload brings not targeting specific pool
   MF51269      LIC-DB CS and CURRENTLY COMMITTED row skipped when locked
   MF51214      LIC-DB-MSGMCH3203 IN JOB LOG / DBOP AND QEO DUMPS CREATED AN
   MF51011      LIC-DB-PERFM SQL Select with inner join on RRN performs poor
   MF50963      LIC-DB-INCORROUT EVI vector scan on right side of join retur
   MF50771      LIC-DB-MSGCPF5257 CPF5257 with MCH0001 and 0600 DEAD VLOG in
   MF50661      LIC-DB-OTHER Recursive Common Table Expression (RCTE) Enhanc
   MF50228      LIC-DB iDeliver application fails with partial damage after
   MF50183      LIC-DB-PERFM EVI with INCLUDE performance improvements
   MF50140      LIC-DB pseudo open of SQE query orphans record lock
   MF48796      LIC-DB-MSGMCH3601 F/DbpmPtbSad during access of SQE temp ind
   MF48527      LIC-DB-WAIT Dead lock possible when creating a large EVI wit
   MF49783      OSP-DB Performance enhancement for SQL MERGE statement
   MF50091      LIC-DB-OTHER-F/DBPMRRNBITMAPSCANNODE-T/QDBGETMQO-MSGMCH3402
   MF48009      LIC-DB SQE query tree validation failure due to bad position
   MF47883      LIC-DB-INCORROUT when using RCTE in combination with Random
   MF49102      LIC-DB-PERFM EVI with INCLUDE paging computations do not inc

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770999
APAR Fixed..........................View details for APAR MA45343
Superseded by:......................
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C6120710


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":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure 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:
09 March 2016