IBM Support

MF66764 - OSP-DB-OTHER-UNPRED UNEXPECTED ACCESS PATH REBUILD VL06002E1

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-UNPRED UNEXPECTED ACCESS PATH REBUILD VL06002E1


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770999  V7R3M0    MF66557   00/00    0000
PRE  5770999  V7R3M0    MF65941   00/00    0000
PRE  5770999  V7R3M0    MF65555   00/00    0000
PRE  5770999  V7R3M0    MF63654   00/00    0000
CO   5770999  V7R3M0    MF66576   00/00    0000
CO   5770999  V7R3M0    MF66117   00/00    0000
CO   5770999  V7R3M0    MF66119   00/00    0000
CO   5770999  V7R3M0    MF66121   00/00    0000
CO   5770999  V7R3M0    MF66122   00/00    0000
CO   5770999  V7R3M0    MF66123   00/00    0000
CO   5770999  V7R3M0    MF66125   00/00    0000
CO   5770999  V7R3M0    MF66126   00/00    0000
CO   5770999  V7R3M0    MF64487   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

-----------------------------------------------
While an archive job that deletes a lot of records is running,
it
suddenly halts while access paths are being rebuilt.
MSGCPF5257 Failure for device or member MCH0160 file ... in
library ...
and VL06002E1C may be seen after a lot of constraint errors like
MSGSQL0532

CORRECTION FOR APAR MA47956 :
-----------------------------
A path in Index maintenance was not properly handling records
that cross a SID boundary. This caused the record to be
processed past the end of the SID...which resulted in the errors
seen by the customer.

This path now copies the SID crossing record into a contiguous
buffer before proceeding...which eliminates the problem.

CIRCUMVENTION FOR APAR MA47956 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF MF60986 :
=================================================

If one or both of the PTFs for MA45275 or MA45104 have been installed
on a system when a table or physical file is saved, then BOTH of those
PTFs must also be installed on the system where the file is restored to
prevent the possibility of a restore failure.  Specifically, some files
with variable length or LOB fields may be damaged during the restore if
the PTFs are not present.  Because this may occur when restoring across
releases, PTFs for all releases are listed.

NOTE:  One or both of the PTFs for MA45275 and MA45104 may be installed
on the restore system when a table or physical file is restored even if
the PTFs were not installed on the save system at the time of the save.
This includes saving a file from a system at one release and restoring
it to a system at a different release.

The PTFs for MA45275 are:
V7R1:   MF62518
V7R2:   MF62519
V7R3:   MF61374

The PTFs for MA45104 are:
V7R1:   MF61046
V7R2:   MF61047
V7R3:   MF60986


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   MF66656      OSP-DB SLIC DB support to return additional internal data sp
   MF66574      OSP-DB *file restore internal validation enhancements
   MF66124      OSP-DB-OTHER-PERFM TLBIE RESPONSE TIMES SPIKES AND CACHE LIN
   MF65197      OSP-RC3-MSGCPF523B RESTORE OF A PARTITIONED TABLE RESULTS IN
   MF61945      OSP-DB SLIC DB Maintenance
   MF60986      LIC-DB Correct Save/Restore inconsistancy in Recycle index
   MF66263      OSP SLIC DB increase threshold of diagnostic vl060018BF
   MF66118      OSP-DB-OTHER-PERFM TLBIE RESPONSE TIMES SPIKES AND CACHE LIN
   MF66060      OSP-DB New options on internal OS function
   MF65990      OSP SEIZE CONTENTION IN #DBATRCF
   MF65909      OSP-DB increased temp index validation in SLIC DB data space
   MF65561      OSP-Database base support for enhanced database limits proce
   MF64575      OSP-DB-OTHER-F/#DBIXCHN-T/QDBPUT-MSGMCH1807 A MSGMCH1807 MAY
   MF64485      OSP-DB Internal query optimization enhancements: materialize
   MF61806      LIC-DB Future release compatibility changes
   MF63657      OSP DATABASE next IDENTITY COLUMN VALUES NOT CORRECT AFTER F
   MF62657      OSP-DB Internal Maintenance for SLIC DB - Implicitly turn on
   MF61966      OSP-F/#DBCINDS-T/QQQOOODBOP-MSGMCH2804 MCH2804 RECEIVED ON A
   MF61808      LIC-DB Future release compatibility changes
   MF61807      LIC-DB Future release compatibility changes
   MF61558      OSP-DB Database IPL/Vary on Database Recovery & Initializati
   MF61534      OSP-DB Database IPL/Vary on Database Recovery Processing Imp
   MF61474      OSP-DB Internal DBDSIPL diagnostic tuning
   MF61473      OSP-DB Database IPL/Vary on Database Recovery Processing Imp
   MF61163      OSP-DB-OTHER-THREADS-PERFM RESTORE FAILS WITH MCH1604
   MF60996      LIC-DB 060056B9 vlogs on first touch after IPL, IASP vary on
   MF61394      OSP-DB Database IPL/Vary on Database Recovery Statistics
   MF60947      LIC-DB-OTHER-PERFM IASP VARY ON SPENDING MORE TIME THEN EXPE
   MF60947      OSP-DB Internal Maintenance for DB IPL/Vary-on
   MF63337      0600 76C4 vlogs generated by seemingly normal processing
   MF62526      OSP-DB-OTHER-F/QDBCLRPF-MSGCPF3130 A MSGCPF3130 MAY OCCUR ON
   MF61423      OSP-DB Database LOB query performance
   MF65872      OSP-DB insert fixes
   MF65708      LIC-DB-OTHER-PERFM Reduce contention on cacheline modified d
   MF65509      IPL-SRCD90027C0-WAIT ECHO PROCESSING BETWEEN THE SYSBAS AND
   MF64484      LIC-DB-OTHER-UNPRED TMPSTG TEMPORARY STORAGE INCREASING
   MF64312      LIC-DB Duplicate entries in table with primary key constrain
   MF63734      OSP-DB QDBSRV01 JOB IS NO LONGER PROCESSING REQUESTS.
   MF61291      OSP-DB DataBase Vary-On processing to avoid tolerated except
   MF61171      OSP-DB DataBase Vary-On processing to avoid tolerated except
   MF65332      OSP - SLIC DB maintenance for HASH_VALUES and UPDATE with "o
   MF65233      OSP-DB-OTHER-SRCB6000308-INCORROUT SRCB6000308
   MF64309      LIC-DB Duplicate entries in table with primary key constrain
   MF64090      OSP-DB-OTHER-F/RMSLRELEASESEIZENOTOKEN-T/QDBPUTM-MSGMCH3203
   MF64048      OS-DB Database update and delete purge/write optimization im
   MF63832      OSP-DB-OTHER FILE WITH AUX SPACE BECOMES DAMAGED.
   MF62921      OSP-F/#DBUPDIM-T/QDBUDR-MSGMCH4801 APPLY JOB FAILS WITH MCH4
   MF62339      OSP-DB Job locks on ENDDBMON, can't endjob or endjobabn, mus
   MF62202      OSP-DB Internal performance improvements for cpyf, alter tab
   MF61944      OSP-DB SLIC DB Maintenance
   MF61166      LIC-DB-MSGMCH3203 f/#dbinsim
   MF61802      LIC-DB Future release compatibility changes
   MF61364      OSP-DB Database Insert Processing Improvements
   MF61326      OSP-DB-MSGMCH3402 F/T stringHighUse/QDBFEOD is returned when
   MF61057      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF60988      OSP-F/#DBDELIM-T/QDBUDR-RC1716-MSGMCH3203 RGZPFM WITH ALWCAN
   MF61044      OSP-DB-OTHER-F/#DBXPUSH-T/QDBPUT-MSGMCH3203 CPF5257 F/QDBSIG

Summary Information

System..............................  i
Models..............................  
Release.............................  V7R3M0
Licensed Program....................  5770999
APAR Fixed..........................  View details for APAR MA47956
Superseded by:......................  View fix details for PTF MF71142
Recompile...........................  N
Library.............................  QSYS
MRI Feature ........................  NONE
Cum Level...........................  C0128730


IBM 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, 2020, 2021, 2022, 2023 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":"BU058","label":"IBM Infrastructure w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.3.0","Product":{"code":"SWG60","label":"IBM i"},"Component":"5770999","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
23 June 2023