IBM Support

MF59671 - LIC-DB EVI on IASP not refreshing when overflow reaches thre

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

LIC-DB EVI on IASP not refreshing when overflow reaches thre


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  MF54245   00/00    0000
PRE  5761999  610  MF55887   00/00    0000
PRE  5761999  610  MF47879   00/00    0000
PRE  5761999  610  MF45494   00/00    0000
CO   5761999  610  MF58290   00/00    0000
CO   5761999  610  MF58292   00/00    0000
CO   5761999  610  MF54856   00/00    0000
CO   5761999  610  MF52530   00/00    0000
CO   5761999  610  MF53933   00/00    0000
CO   5761999  610  MF53885   00/00    0000
CO   5761999  610  MF49876   00/00    0000
CO   5761999  610  MF43626   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

-------------------------------------------------
When a database index, which is an EVI, exists on an IASP, it
may not automatically 'refresh' when an internal threshold is
reached.  This can reduce the performance of read operations
that utilize the EVI.

CORRECTION FOR APAR 'MA44336' :
-------------------------------
This PTF corrects the refresh event processing specific to a
database index EVI on an IASP.

CIRCUMVENTION FOR APAR 'MA44336' :
----------------------------------
None.


Activation Instructions


None.




Special Instructions

None.


Default Instructions

THIS IS A DELAYED PTF TO BE APPLIED AT IPL TIME.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   MF59600      LIC-DB-OTHER-F/#DBXSIZE-T/QDBMAINT-MSGMCH2804 INDEX ACCESS P
   MF59596      MSGMSGCPDB8E4RC6-DISK-HLIC VARY ON OF IASP FAILS WITH MSGCPD
   MF59580      OSP-SRCB6001215-UNPRED DURING NORMAL OPERATIONS, SYSTEM FAIL
   MF59498      OSP-DB-OTHER-UNPRED VL06001389 INDEX INVALIDATED. FILES SHOW
   MF59452      LIC-DB-JRN EVI refresh inhibits force, impacts journal sync
   MF59228      LIC-DB Index mismatch and records not appearing in file
   MF59211      OSP-DB Internal tuning - Delayed Maintenance Indexes/Access
   MF58814      OSP-DB internal threshold tuning for database delayed mainte
   MF58321      OSP-DB-OTHER-UNPRED NEED A WAY TO IDENTIFY A ACCESS PATH REB
   MF58251      OSP-DB Data Space Index Catch-up Enhancements
   MF57997      OSP-DB Large Data Space Index Enablement
   MF57994      OSP-DB Large Data Space Index Restore processing
   MF57460      LIC-DB iASP varyon hang at Commit Recovery
   MF57395      LIC-DB-OTHER-UNPRED INDEX BEING REBUILT AFTER SYSTEM CRASH
   MF57379      LIC-DB-SRCB6000308 #DBPARIX
   MF57196      LIC-DB Function Check during index build
   MF57167      OSP-DB-OTHER-F/#DBIXSIZ-T/QDBEXDME-MSGMCH3403 MCH3203 AND CP
   MF57061      IPL-SRCB6000103 SYSTEM AUTO IPLED.
   MF56975      LIC-DB Improve temp storage usage parallel index build
   MF56722      LIC-DB Improve temp storage usage parallel index build
   MF56480      OSP-DB-OTHER-SRCB6001215 SYSTEM CRASHED DOUBLE SRCB6001215.
   MF56228      OSP-DB-OTHER-LOOP SOME CONDITIONS WHERE PAGES GET ZEROED OUT
   MF55881      LIC-DB PERFORMANCE MCLI - QUBaseGate_UnLocks #dbixchn
   MF55372      OSP-DB-OTHER-PERFM INDEXES OVER A TABLE MAY BE REBUILT WHEN
   MF54606      LIC-DB-MSGCPF4126 End of Chain exception ouf of #dbixchn
   MF54491      OSP-F/IXMACHINEINDEXEXTEND-T/QDBCRTME-MSGMCH2804 MSGMCH2804
   MF53543      LIC-DB-OTHER-LOOP LIC-DB-OTHER-LOOP - RGZPFM HANGS
   MF53882      LIC-DB DB Index Seize contention
   MF53579      LIC-DB Long IPL after Flashcopy with CHGASPACT ASPDEV(*SYSBA
   MF53535      Async Move to SSD
   MF53534      Async Move to SSD
   MF53069      LIC-DB CPI70B8 IN DSPLOG
   MF52931      LIC-DB Potential damage to index after attempting to end job
   MF52430      LIC-DB-OTHER-PERFM HIGH MACHINE GATING ON INDEX.
   MF52273      LIC-DB Deleted entry count discovery and correction during R
   MF51787      OSP-UNPRED EVI BUILD IS USING UP TEMP STORAGE
   MF51424      LIC-DB-PERFM AN TABLE SCAN IS BEING CHOSEN OVER A INDEX.
   MF51406      OSP-DB ALL SAP JOBS TRYING TO ACCESS THE TABLE USRSTAMP GETT
   MF51003      LIC-DB Additional materialization data
   MF50118      LIC-DB-SMAPP-UNPRED
   MF49875      LIC-DB-OTHER-UNPRED RUN-TIME DEFERRED UNIQUE KEY ENFORCEMENT
   MF49669      LIC-DB-JRN-PERFM SMAPP IS OVER-PROTECTING SMALL ACCESS PATHS
   MF49632      LIC-DB-SRCB6001215 #dbcdsrt referencing too far into a DSR s
   MF49603      LIC-DB-MSGMCH3601-F/#DBMATIX
   MF48382      LIC-DB-OTHER-F/#DBXBINX-T/QDMCOPEN-MSGMCH3203
   MF47892      OSP-Database synchronously move access path to new unit
   MF47789      LIC-DB-MSGMCH3203 from SQE query with key fields of type dec
   MF47594      LIC-DB-UNPRED Index rebuild after canceled delayed maintenan
   MF44708      LIC-DB MCH3203 f/#dbxbinx x/00163C t/QDBOPEN    Function err
   MF44471      OSP FIXING ISSUES WITH PTF MF43226
   MF43929      OSP-DB-JRN-F/SMSEGMENTADDRESSRANGE-T/QDBOPEN-MSGMCH3203 ERRO
   MF46587      DB Member Level Create/Modify Enhancements
   MF44178      LIC-DB-INCORROUT RSTOBJ DOESN'T APPEAR TO INCREMENT THE CHEC
   MF43625      LIC-DB-MSGMCH1716 Restore of SQL Derived Index fails with MC
   MF45956      LIC-DB-INCORROUT IMPLEMENTING A QUERY WITH A SELECT/OMIT LF
   MF45740      LIC-DB-UNPRED #dbmatix generates 0600 8341 vlog
   MF45264      LIC-DB-UNPRED #dbmatix generates 0600 8341 vlog
   MF45074      LIC-DB-MSGMCH3203-RC1716-F/#DBMATIX assume from #dbmatix
   MF44924      OSP-DB Seize level on DSI in Materialize Data Space Index
   MF43792      LIC-DB-MSGMCH3601-F/#DBBUILD  Create EVI fails
   MF43485      LIC-DB-MSGMCH1716 Restore of SQL Derived Index fails with MC
   MF43596      LIC-DB-MSGMCH0601-F/#DBMATIX  MATDSIAT fails with an 80
   MF43132      LIC-DB-UNPRED System crash due to problem in materialize ind
   MF46349      LIC-DB-SRCB6005121
   MF45512      LIC-DB MSGMCH6220 F/#CODCMIT T/QTNROLLB
   MF45298      LIC-DB VLOG04030040 tolerated exception VLOG while accessing
   MF44884      LIC-DB MSGMCH6220 F/#CODCMIT T/QTNROLLB
   MF44664      LIC-DB-UNPRED  Tolerate VLOG from #dbixchn
   MF44309      LIC-DB DUPLICATE KEYS ALLOWED IN UNIQUE INDEX
   MF43774      LIC-DB RGZPFM ALWCANCEL(*YES) DUPLICATE KEY EXCEPTION
   MF43576      LIC-DB-OTHER-F/#DBIXCHN-T/QDBUDR-MSGMCH1807 INDEX MAINTENANC
   MF43331      LIC-DB MSGMCH3203 F/#DBENFCN
   MF43058      LIC-DB MSGMCH3203 VL060040DB VL030003EA VL02001209
   MF43915      OSP-DB TEMP STORAGE/PERFORMANCE/ PROBLEM WHEN BUILDING INDEX
   MF47790      LIC-DB-MSGMCH3203 from SQE query with key fields of type dec
   MF54857      LIC-DB-PERFM FILE CONTENTION WHEN AN EXTENT TABLE NEEDS TO B
   MF46609      LIC-DB-MSGMCH3601-F/#DBPARIX while attempting to restore lib
   MF43950      LIC-DB-UNPRED Parallel index build fails
   MF54247      LIC-DB Query for file SSD info sees stale data location info
   MF46518      LIC-DB-MSGMCH3601-F/#DBPARIX  Building Index  on SSDs
   MF55863      OSP-DB-OTHER-F/#DBPARIX-T/QDBOPEN-MSGMCH3203 MSGMCH3203 F/#D
   MF50541      OSP-F/#DBPARIX-T/QDBCRTME-MSGMCH3203 CRTLF FAILS WITH MSGMCH
   MF58291      OSP-DB-OTHER-T/QTNDTCOBX/01E8-MSGMCH6204 RPGSQL PGM FAILS WI
   MF58291      OSP- CPF5079 Number of locks under commit in job exceeds lim
   MF58147      OSP-DB-OTHER-UNPRED RGZPFM ALWCANCEL(*NO) DOES NOT RETURN AU
   MF57868      LIC-DB MSGMCH3601 exception when closing damaged files
   MF57501      OSP-DB RGZPFM INCREASES THE SIZE OF A PF WITH LOB COLUMNS
   MF57481      OSP-DB DBMN TR enhancements
   MF57000      UNPRED-HLIC-94XXMISC CPYF SKIPS THE DENT BYTE VALIDATION.
   MF54859      LIC-DB-PERFM FILE CONTENTION WHEN AN EXTENT TABLE NEEDS TO B
   MF54461      OSP-DB-OTHER-INCORROUT INCORRECT OUTPUT RETURNED ON A FETCH
   MF53930      OSP-DB-OTHER ADD ABILITY TO END A JOB READING FROM AN INDEX
   MF52533      OSP-DB-OTHER-UNPRED ORPHANED XA TRANSACTION LOCKS FOR DELETE
   MF48920      LIC-DB record validity check in Retrieve Sequential
   MF47611      OSP-DB-OTHER-MSGSQL0913 MSGSQL0913 IS ISSUED BEFORE WAITRCD
   MF46694      LIC-DB-MSGMCH3601-F/#DBPARL while doing a RETSDSE
   MF44761      OSP-DB Database performance enhancements for native read pro
   MF43470      LIC-DB COMPARE KEY FEEDBACK INCORRECT
   MF43151      LIC-DB INCORRECT STRING TRUNCATION WARNING FROM CQE
   MF43101      LIC-DB MSGMCH3405 F/#DBCLLFN
   MF42708      LIC-DB MSGMCH3601 F/#DBGRSDS X/3F94
   MF43473      LIC-DB-UNPRED CQE not returning sqlcode 364 when in warning
   MF52639      OSP-F/#DBENTAD-T/QDBGETM-RC1716-MSGMCH3203 QUERY FAILS WITH
   MF45272      OSP-MSGMCH3203 f/stringHighUse t/QDBGETM #dbjposn+1504 in vl
   MF57447      OSP-DB RGZPFM INCREASES THE SIZE OF A PF WITH LOB COLUMNS
   MF57251      OSP Database RGZPFM enhancements
   MF57165      OSP-DB-OTHER-PERFM A RGZPFM THAT HAS BEEN RESTARTED MY CAUSE
   MF56664      LIC-DB Additional support for DBStats during RGZPFM
   MF56052      LIC-DB-SRCB6001215 System terminated out of DbReuse.
   MF54858      LIC-DB-PERFM FILE CONTENTION WHEN AN EXTENT TABLE NEEDS TO B
   MF54677      F/#DBHCEOD-MSGMCH3203 RGZPFM MCH3203 F/#DBHCEOD T/QDBRGZPF F
   MF52926      LIC-DB Slow RGZPFM on extremely large file
   MF52272      LIC-DB Deleted entry count discovery and correction during R
   MF51982      LIC-DB-JRN-PERFM REPLAY OF RGZPFM ENTRIES CONSUMES SYSTEM RE
   MF50471      SRCB6005121-HLIC-94XXDOC 1 SRCB6005121 3 SRC0002000A 4 SRC00
   MF49941      LIC-DB Jobs take longer during RGZPFM KEYFILE(*RPLDLTRCD) AL
   MF48773      OSP RGZPFM RUNS LONGER AT R610 WHEN READING THROUGH THE DELE
   MF46067      LIC-DB-OTHER-INCORROUT RPGPFM OVER A HUGE FILE LEFT NO RECOR

Summary Information

System..............................i
Models..............................
Release.............................V6R1M0
Licensed Program...............5761999
APAR Fixed..........................View details for APAR MA44336
Superseded by:......................View fix details for PTF MF63416
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:
28 January 2015