IBM Support

SI43085 - OSP-DB-OTHER-MSGMCH1604 MSGMCH1604, MSGCPF8113 & MSGCPF4182C

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-MSGMCH1604 MSGMCH1604, MSGCPF8113 & MSGCPF4182C


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI37443   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 license agreement which
accompanied, or was contained in, the Program for which you are obtaining
the PTF.  You are not authorized to install or use the PTF except as part
of a Program for which you have a valid Proof of Entitlement.

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.

The applicable license agreement may have been provided to you in printed
form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR)
CL command.





APAR Error Description / Circumvention

-----------------------------------------------
msgMCH1604, msgCPF8113 & msgCPF4182 Constraint damage



Deletion of a parent file with a damaged member led to logical
damage of foreign key constraints.

CORRECTION FOR APAR SE47374 :
-----------------------------
Error handling in delete file code has been improved to avoid
logically damaging the foreign key constraints.



This ptf is preventative not corrective.  To fix logically
damaged constraints you must remove all constraints from the
file with the logical damage:



RMVPFCST FILE(YourLib/YourFile) CST(*all) TYPE(*ALL)
RMVCST(*KEEP)

CIRCUMVENTION FOR APAR SE47374 :
--------------------------------
None.


DESCRIPTION OF PROBLEM FIXED FOR APAR SE47375 :
-----------------------------------------------
Message MCH1885 "Operation conflicts with data space
constraints" is in joblog for the delete of a file that has a
primary key or unique key constraint.   Further investigation
shows that all dependent foreign key constraints were also
deleted but there is no indication of this in the joblog.

CORRECTION FOR APAR SE47375 :
-----------------------------
Delete file processing has been modified to send informational
CPI32B1 for each dependent constraint that is removed.
Diagnostic message CPF3272 (damage ignored) is also sent for the

dependent file that had foreign key constraints removed.

CIRCUMVENTION FOR APAR SE47375 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI41178      OSP-DB Internal Maintenance
   SI41048      OSP-DB Directory locking improvements
   SI40656      OSP-DB Internal Maintenance
   SI39975      OSP-DB-OTHER-F/SETSPACEPTRFROMPTR-T/QSQCLSCR-MSGMSG3402 TEMP
   SI39854      OSP-DB Internal Maintenance
   SI39540      OSP-DB Internal Maintenance
   SI38936      OSP-DB-OTHER-F/QDBCRTFI-MSGCPF3220 DLTF ON LOGICAL FILE FAIL
   SI38299      OSP-T/QDBSIZFI-MSGMCH3402 MQT BECOMES CORRUPTED AFTER CRTDUP
   SI37905      OSP-DB-OTHER-QDBDLTFI LOOPING
   SI37502      OSP-DB-OTHER-QDBDLTFI
   SI37447      OSP-DB Internal Maintenance
   SI37109      OSP-DB-OTHER-QDBDLTFI
   SI36964      OSP-DB-OTHER-QDBDLTFI for MQT using Commitment Control
   SI36783      OSP-DB-OTHER-QDBDLTFI
   SI36459      OSP-DB Internal Maintenance

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE47374
View details for APAR SE47375
Superseded by:......................View fix details for PTF SI64620
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C1270710


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

Document Information

Modified date:
18 April 2011