IBM Support

MF70297 - OSP-DB-OTHER-MSGMCH1668 DAMAGED OBJECT (database file) after

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-MSGMCH1668 DAMAGED OBJECT (database file) after


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770999  V7R3M0    MF67016   00/00    0000
PRE  5770999  V7R3M0    MF67978   00/00    0000
PRE  5770999  V7R3M0    MF65941   00/00    0000
PRE  5770999  V7R3M0    MF67045   00/00    0000
PRE  5770999  V7R3M0    MF65555   00/00    0000
CO   5770999  V7R3M0    MF70266   00/00    0000
CO   5770999  V7R3M0    MF70268   00/00    0000
CO   5770999  V7R3M0    MF70269   00/00    0000
CO   5770999  V7R3M0    MF70270   00/00    0000
CO   5770999  V7R3M0    MF68971   00/00    0000
CO   5770999  V7R3M0    MF68912   00/00    0000
CO   5770999  V7R3M0    MF66122   00/00    0000
CO   5770999  V7R3M0    MF66126   00/00    0000
CO   5770999  V7R3M0    MF66117   00/00    0000
CO   5770999  V7R3M0    MF67413   00/00    0000
CO   5770999  V7R3M0    MF67332   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

-----------------------------------------------
mch1668 occurs accessing recently restored database file member.

Additional Message Information
Message ID . . . . . . : MCH1668 Severity . . . . . . . : 40
Message type . . . . . : Escape
Date sent . . . . . . : 09/02/22 Time sent . . . . . . :
11:19:06
Message . . . . : System object xxxx  yyyy  partially damaged.
Internal dump ID . Error class 0, device number X'0000'.
Cause . . . . . : This partially damaged system object PJKTST5
SAL8001 ha
an error class 0 and a device number X'0000'. Error class
indicates how
damage was detected:
0000-previously marked damage;
0001-detected abnormal condition;
0002-logically invalid device sector;
0003-device error.
For error class 0003, the device number identifies the failing
device, or
contains zero if main storage is damaged.

CORRECTION FOR APAR MA49852 :
-----------------------------
file changes being accessed by the save operation have been
corrected.

CIRCUMVENTION FOR APAR MA49852 :
--------------------------------
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 MF61374 :
=================================================

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
--------------  ------------------------------------------------------------
   MF70267      OSP-DB Internal maintenance - diagnostics in file open in SL
   MF63170      LIC-DB Reduce concurrent insert interference with RGZPFM whi
   MF70206      LIC-DB Restore of database files terminates with user profil
   MF70170      LIC-DB logging improvements during internal deleted entry co
   MF70146      OSP-DB Enhanced lic log data in #dbldds
   MF69998      OSP-DB Debug enhancements to DB IPL file deleted entry count
   MF69890      OSP-DB *file restore processing for partitioned tables with
   MF61072      OSP-DB Internal changes to Data Space D/A/D and VLOG dump da
   MF60948      OSP-DB Internal Maintenance for DB IPL/Vary-on
   MF69896      OSP-DB *file restore processing for partitioned tables with
   MF69893      OSP-DB *file restore processing for partitioned tables with
   MF69763      LIC-DB Jobs hung between JO-EVAL task and job in #dbupden
   MF69643      OSP-DB SLIC DB improvements to vl60056B9
   MF69500      OSP-DB-OTHER-UNPRED PARTIAL DAMAGE FROM INCREASING DATA SPAC
   MF68998      SQL-RUN-INCORROUT FOR A TABLE WITH A TRIGGER, GENERATED ALWA
   MF68972      OSP-DB-OTHER-F/RMSLRELEASESEIZENOTOKEN-T/QDBPUTM-MSGMCH3203
   MF68929      OSP-DB internal maintenance on SLIC DB #dbldds validation an
   MF68924      OSP-DB-OTHER-UNPRED A CHGPF MAY RESET THE "RECORD CAPACITY"
   MF68873      SQL-RUN-INCORROUT FOR A TABLE WITH A TRIGGER, GENERATED ALWA
   MF68856      OSP-DB INDEX IS GETTING INVALIDATED.
   MF68789      LIC-DB Sanity check journal entry length on record update
   MF68617      OSP-DB-OTHER-MSGCPF3145 MSGCPF3145 VL06002E1C VL06001389
   MF68304      LIC-DB NULL x'00' put in PF by COBOL after CLRPFM
   MF68257      OSP-DB-OTHER-F/RMSLRELEASESEIZENOTOKEN- T/QDBPUTMMOD/QDBPUTM
   MF68075      OSP-DB IPL and/or IASP vary-on processing of database file w
   MF67989      OSP-DB internal trace controls for SLIC DB in-use table
   MF67983      OSP-DB restore failure diagnostics
   MF67981      OSP-DB SLIC DB IPL/Vary-on diagnostics for data space and it
   MF67942      LIC-DB NULL x'00' put in PF by COBOL after CLRPFM
   MF67205      OSP-DB extended functions in SLIC DB MI Materialze Data Spac
   MF67920      OSP-DB restore failure diagnostics
   MF67909      LIC-DB NULL x'00' put in PF by COBOL after CLRPFM
   MF67876      OSP-DB Remove 0600-0600 vlog generation for #dbixchn_02
   MF67809      OSP-PERFM LONG FLASH TIME WITH DATABASE INITIALIZATION
   MF67742      OSP-DB SLIC DBIX diagnostics for I/O with invalid unique ind
   MF67569      OSP-DB concurrent insert performance optimization
   MF67410      OSP-DB enhanced debug on insert 'first burst of code' proces
   MF67329      LIC-DB-JRN-PERFM THE TARGET SIDE JOURNAL APPLY JOB IS SLOWER
   MF67206      OSP-DB extended functions in SLIC DB MI Materialze Data Spac
   MF67132      OSP-DB improvements & ehnancements to SLIC DB interfaces
   MF66930      OSP-DB SLIC DB debug diagnostic improvement to #dbdschk vlog
   MF66764      OSP-DB-OTHER-UNPRED UNEXPECTED ACCESS PATH REBUILD VL06002E1
   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
   MF66123      OSP-DB-OTHER-PERFM TLBIE RESPONSE TIMES SPIKES AND CACHE LIN
   MF69442      OSP-DB Diagnostic improvements in SLIC LD for restore failur
   MF69023      OSP-DB-OTHER-INCORROUT LDCPXXXXXX TASK HOLDING GATE REQUIRIN
   MF68996      OSP-DB internal maintenance on SLIC DB #dbldds validation an
   MF68973      OSP internal maintenance for SLIC DBLD and file member/table
   MF68934      OSP-DB internal maintenance on SLIC DB #dblddsi validation a
   MF68927      OSP-DB internal maintenance on SLIC DB #dbldds validation an
   MF68516      OSP-DB-OTHER-INCORROUT LDCPXXXXXX TASK HOLDING GATE REQUIRIN
   MF67921      OSP-DB restore failure diagnostics
   MF66576      OSP-DB *file restore internal validation enhancements
   MF65764      OSP-DB *file restore diagnostic enhancement
   MF61374      LIC-DB Correct Save/Restore inconsistancy in Recycle index
   MF60985      LIC-DB Correct Save/Restore inconsistancy in Recycle index

Summary Information

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


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 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:
17 October 2022