IBM Support

MF59216 - 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  610  MF57384   00/00    0000
PRE  5761999  610  MF46262   00/00    0000
CO   5761999  610  MF59218   00/00    0000
CO   5761999  610  MF58291   00/00    0000
CO   5761999  610  MF58292   00/00    0000
CO   5761999  610  MF54422   00/00    0000
CO   5761999  610  MF51419   00/00    0000
CO   5761999  610  MF45192   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
--------------  ------------------------------------------------------------
   MF58670      OSP-DB-OTHER-INCORROUT SETLL ON A JLF WITH ONE UNICODE KEYFI
   MF58578      OSP-DB-OTHER-INCORROUT ROW CHANGE TIMESTAMP NOT SET BY AFTER
   MF58533      LIC-DB LOG 06005D60 vlogs
   MF58290      OSP- CPF5079 Number of locks under commit in job exceeds lim
   MF57984      OSP-DB-OTHER-UNPRED SELECT FROM INSERT STATEMENT CAUSES INDE
   MF57737      LIC-DB proactively improve robustness of internal DB XREF st
   MF57478      OSP-DB DBRT TR enhancements
   MF57027      LIC-DB Performance degredation in DBGETAX/SMISSAME 540 to 61
   MF56500      LIC-DB-OTHER-PERFM PERFORMANCE DEGRADATION FOR LARGE DELETE
   MF56145      LIC-DB-OTHER-LOOP DBIOXX CONSUMING CPU #DBRECYC, EOJ STUCK,
   MF54094      OSP Enhance data in VL06001710 vlog
   MF53792      OSP-MSGCPF3793-MSGMCH2803-MSGCPF5272 RC1 Database File proce
   MF52764      LIC-OTHER-INCORROUT RESTORING A LARGE PHYSICAL FILE CRASHES
   MF51371      OSP-DB #dbrecyc diagnostics improved and recix max limit inc
   MF49871      OSP- MSGMCH1210-F/CBLABRANCH-T/QDBEXDME DSPFD GETS MCH1210
   MF46714
   MF46589      DB Member Level Create/Modify Enhancements
   MF57108      OSP DAMAGED FILE OCCURS DURING TOLERATED EXCEPTION
   MF57068      OSP-DB A STORED PROCEDURE FAILS MSGCPF5035 RC16 F/QDBSIGEX T
   MF56641      OSP- Internal maintenance
   MF56340      LIC-DB-JRN-MSGMCH4801 #DBUPDIM CHECKSUM FAILURE
   MF56263      LIC-DB-OTHER-SRCB6000103-UNPRED SRCB6000103 DURING NORMAL OP
   MF56134      OSP-MSGMCH3402 f/t stringHighUse/QDBPUT lob insert
   MF56129      MCH3203 F/T QDBPUT "Function error X'0322' in machine instru
   MF55063      OSP-DB-OTHER-INCORROUT INSERTING BLOCKED RECORDS INTO A PART
   MF54423      LIC-DB Large IO buffer efficiency
   MF54423      LIC-DB INZPFM and Alter Table performance ennhancement
   MF53898      OSP-WAIT INSERT TO JOURNALED FILE HANGS
   MF53876      LIC-DB Check stats for staleness on insert/update/delete ops
   MF53486      OSP-MSGMCH3203 f/SmAsmSignalException t/QDBPUT on insert of
   MF53380      LIC-DB-PERFM Performances changes for P7 hardware.
   MF53344      LIC-DB F IZ journal enties out of sequence
   MF52972      LIC-DB-MSGCPF5027 at times incorrectly displays *TNSOBJ
   MF52921      OSP-DB-OTHER-F/#CFDAMSTX/04B7-MSGMCH1604 FILE GETS DAMAGED R
   MF52651      OSP-DB-OTHER-RC2-MSGCPF7091 FILE SHOWING AS DAMAGED WITH MSG
   MF52240      LIC-DB A DELETED RECORD HAS BEEN FOUND AS NOT REPORTED IN TH
   MF51995      OSP-WAIT SEVERE GATE CONTENTION REQUIRING IPL TO RESOLVE
   MF51488      OSP-OSP MSGMCH3601 F/#DBBLDCR T/QDBCRTME
   MF51438      OSP-DB-OTHER-PERFM PERFORMANCE ENHANCEMENTS FOR TRIGGER OPER
   MF51415      OSP-OTHER-PERFM SQL DELETE STATEMENT TAKES A LOT LONGER WHEN
   MF51245      LIC-DB-WAIT Data Base seize deadlock
   MF51125      OSP-DB-OTHER-INCORROUT ROW CHANGE TIMESTAMP DESTROYED BY BEF
   MF50217      LIC-DB-WAIT Data Base seize deadlock
   MF50208      LIC-DB ROW CHANGE TIMESTAMP INCORROUT
   MF49778      LIC-DB JOBS HUNG ON THEIR PROD BOX, IPL WAS NEEDED.
   MF49614      OSP-DB-OTHER-INCORROUT TABLE WITH DBCLOB FIELD (UNICODE 1348
   MF45193      OSP-DB-OTHER-T/QSQRUN3-RCX/24216-MSGSQL0407 THE COLUMN INDEN
   MF43720      OSP-DB-OTHER-INCORROUT DSPFD SHOWS THE INCORRECT NUMBER OF D
   MF47330      OSP-DB-OTHER-UNPRED FILE SIZE GROWTH DIFFERENT BETWEEN JOURN
   MF47311      LIC-DB-JRN-SRCB6000317-UNPRED SYSTEM CRASHED DURING APYJRNCH
   MF46608      LIC-DB-JRN-SAP400-INCORROUT DB FILE ECORD INCORRECTLY RECOVE
   MF46263      LIC-OTHER-WAIT HIGH AVAILABILITY JOBS HANG
   MF44445      LIC-DB DUPLICATE KEYS ALLOWED IN UNIQUE INDEX
   MF43843      OSP-DB-OTHER-INCORROUT REFERENTIAL INTEGRITY NOT ENFORCED WH
   MF46390      OSP-DB Support Long VL Footprint in Perm Cursors
   MF44659      SRCB6000317-HLIC-94XXBASE SYSTEM TERMINATES WITH B6000317
   MF43854      LIC-DB MSGCPF502F F/QDBSIGEX T/QDBSIGEX RC=3
   MF43799      LIC-DB MSGMCH3601 F/#DBBLDCR T/QQQIMPLE

Summary Information

System..............................i
Models..............................
Release.............................V6R1M0
Licensed Program...............5761999
APAR Fixed..........................View details for APAR MA44034
Superseded by:......................View fix details for PTF MF60258
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":"V6R1M0","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":"V6R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 November 2014