IBM Support

MF59217 - LIC-DB Prevent rebuild of internal recycle index

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

LIC-DB Prevent rebuild of internal recycle index


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5761999  611  MF57383   00/00    0000
PRE  5761999  611  MF50428   00/00    0000
CO   5761999  611  MF59219   00/00    0000
CO   5761999  611  MF58285   00/00    0000
CO   5761999  611  MF58287   00/00    0000
CO   5761999  611  MF58288   00/00    0000
CO   5761999  611  MF54425   00/00    0000
CO   5761999  611  MF51418   00/00    0000
CO   5761999  611  MF48611   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

-----------------------------------------------
Customer sees a file get locked for up to two hours.  In this
case, it is part of a commit transaction, and so this holds up
other transactions.  However, it is not limited to transaction
processing.

CORRECTION FOR APAR MA44034 :
-----------------------------
The hang is caused because an exclusive lock is required to
rebuild an internal structure.  We will delay the rebuild of the
internal structure until the next IPL, if possible.

CIRCUMVENTION FOR APAR MA44034 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF58579      OSP-DB-OTHER-INCORROUT ROW CHANGE TIMESTAMP NOT SET BY AFTER
   MF58532      LIC-DB LOG 06005D60 vlogs
   MF58286      OSP- CPF5079 Number of locks under commit in job exceeds lim
   MF57985      OSP-DB-OTHER-UNPRED SELECT FROM INSERT STATEMENT CAUSES INDE
   MF57736      LIC-DB proactively improve robustness of internal DB XREF st
   MF57479      OSP-DB DBRT TR enhancements
   MF57028      LIC-DB Performance degredation in DBGETAX/SMISSAME 540 to 61
   MF56501      LIC-DB-OTHER-PERFM PERFORMANCE DEGRADATION FOR LARGE DELETE
   MF56146      LIC-DB-OTHER-LOOP DBIOXX CONSUMING CPU #DBRECYC, EOJ STUCK,
   MF51373      OSP-DB #dbrecyc diagnostics improved and recix max limit inc
   MF49872      OSP- MSGMCH1210-F/CBLABRANCH-T/QDBEXDME DSPFD GETS MCH1210
   MF57109      OSP DAMAGED FILE OCCURS DURING TOLERATED EXCEPTION
   MF57069      OSP-DB A STORED PROCEDURE FAILS MSGCPF5035 RC16 F/QDBSIGEX T
   MF56640      OSP- Internal maintenance
   MF56341      LIC-DB-JRN-MSGMCH4801 #DBUPDIM CHECKSUM FAILURE
   MF56264      LIC-DB-OTHER-SRCB6000103-UNPRED SRCB6000103 DURING NORMAL OP
   MF56135      OSP-MSGMCH3402 f/t stringHighUse/QDBPUT lob insert
   MF56130      MCH3203 F/T QDBPUT "Function error X'0322' in machine instru
   MF55066      OSP-DB-OTHER-INCORROUT INSERTING BLOCKED RECORDS INTO A PART
   MF54426      LIC-DB Large IO buffer efficiency
   MF54426      LIC-DB INZPFM and Alter Table performance ennhancement
   MF53901      OSP-WAIT INSERT TO JOURNALED FILE HANGS
   MF53877      LIC-DB Check stats for staleness on insert/update/delete ops
   MF53487      OSP-MSGMCH3203 f/SmAsmSignalException t/QDBPUT on insert of
   MF53378      LIC-DB-PERFM Performances changes for P7 hardware.
   MF53345      LIC-DB F IZ journal enties out of sequence
   MF52973      LIC-DB-MSGCPF5027 at times incorrectly displays *TNSOBJ
   MF52652      OSP-DB-OTHER-RC2-MSGCPF7091 FILE SHOWING AS DAMAGED WITH MSG
   MF52241      LIC-DB A DELETED RECORD HAS BEEN FOUND AS NOT REPORTED IN TH
   MF51996      OSP-WAIT SEVERE GATE CONTENTION REQUIRING IPL TO RESOLVE
   MF51440      OSP-DB-OTHER-PERFM PERFORMANCE ENHANCEMENTS FOR TRIGGER OPER
   MF51414      OSP-OTHER-PERFM SQL DELETE STATEMENT TAKES A LOT LONGER WHEN
   MF51246      LIC-DB-WAIT Data Base seize deadlock
   MF51150      OSP-DB-OTHER-INCORROUT ROW CHANGE TIMESTAMP DESTROYED BY BEF
   MF50429      LIC-DB ROW CHANGE TIMESTAMP INCORROUT
   MF49779      LIC-DB JOBS HUNG ON THEIR PROD BOX, IPL WAS NEEDED.
   MF49615      OSP-DB-OTHER-INCORROUT TABLE WITH DBCLOB FIELD (UNICODE 1348
   MF48616      LIC-DB-PERFM Performances changes for P7 hardware.
   MF47331      OSP-DB-OTHER-UNPRED FILE SIZE GROWTH DIFFERENT BETWEEN JOURN

Summary Information

System..............................i
Models..............................
Release.............................V6R1M1
Licensed Program...............5761999
APAR Fixed..........................View details for APAR MA44034
Superseded by:......................View fix details for PTF MF60259
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C5063610


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.

[{"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":"V6R1M1","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG16A","label":"PTF Cover Letters - i5\/OS V6R1 environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V6R1M1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 November 2014