IBM Support

SI78422 - OSP-DB-OTHER-MSGCPF4572 0 RECORDS LOST WHEN MEMBER <XXX> CLO

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-MSGCPF4572 0 RECORDS LOST WHEN MEMBER <XXX> CLO


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770999  V7R3M0    MF67499   00/00    0000
CO   5770SS1  V7R3M0    SI74162   00/00    0000
CO   5770SS1  V7R3M0    SI61564   00/00    0000
DIST 5770SS1  V7R3M0    SI60882   00/00    0000
DIST 5770999  V7R3M0    MF67929   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

-----------------------------------------------
A program uses _Rwrite function to insert data into PF with
buffer. If one of the records in the buffer contains a unique
key that is a duplicate of an existing record, the duplicated
key record cannot be inserted. After _Rclose function is called
to close the file, the joblog has a message CPF4572 to show the
number of unsuccessful records inserted. This message
incorrectly shows 0 record lost.

CORRECTION FOR APAR SE76890 :
-----------------------------
A change made to calculate the number of records correctly when
the file reached the maximum number of increments did not work
correctly for some other error conditions such as duplicate key.


This fix will ensure the correct number of records lost is
reported in CPF4572.

CIRCUMVENTION FOR APAR SE76890 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI76825      OSP-DB Incremental enhancement
   SI75916      OSP-DB Internal maintenance
   SI75809      OSP-DB-MSGMCH0801-F/QDBPUT UNINITIALIZED PTR FAILS RECLAIM X
   SI75453      OSP-DB-OTHER-F/QDBPUT-MSGCPF5035 A MSGCPF5035 MAY OCCUR WITH
   SI74715      OSP-DB-OTHER-F/QDBPUT-T/QDBPUT-MSGMCH1873 QRWTSRVR JOB POSTI
   SI74463      OSP-DB UPDATING A PARTITIONED TABLE THAT CAUSES ROWS TO BE M
   SI73985      OSP-DB-OTHER-F/QDBPUT-T/QDBPUT-MSGMCH1873 Inserts into files
   SI72668      OSP-DB-OTHER-F/QDBSIGEX-T/QDZXDBI-RC20-MSGCPF5035 CPF5035 RC
   SI72322      OSP-DB-OTHER-UNPRED COMMITMENT CONTROL NOT BEHAVING AS EXPEC
   SI68447      OSP-DB-OTHER-UNPRED QDBTREXT BEING CALLED TWICE PER INVOCATI
   SI68429      OSP-MSGMCH1210-D/TQDBPUT-PAR CUSTOMER UPGRADED TO IBM I 7.3
   SI67743      OSP-DB-OTHER-F/QDBPUT-MSGMCH1873 A MSGMCH1873 F/QDBPUT MAY O
   SI67536      OSP-F/QDBUDR-T/QDBUDR-MSGMCH1210 MCH1210 F/T/QDBUDR
   SI67128      OSP-DB Internal maintenance
   SI66923      OSP-DB-OTHER-T/QDBXREF-MSGMCH6903 QDBSRVXR JOB REACHES HEAP
   SI66922      SQL-RUN-F/CBLABRANCH-MSGMCH1210 MSGMCH1809 FOLLOWED BY MSGMC
   SI64787      OSP-DB-OTHER-F/QDBUDR-T/QDBUDR-MSGMCH0601 WHEN TRIGGER FIRES
   SI61485      OSP-DB-OTHER-F/#DBCPYFL-T/QDBUDR-MSGMCH5003 UPDATE FAILS WIT
   SI61298      Improper handling of MSGMCH1873 f/QDBUDR results in MSGMCH36
   SI60132      OSP-DB Internal Maintenance
   SI59693      OSP-DB Internal Maintenance
   SI59301      OSP-F/QDBUDR-T/QDBUDR-MSGMCH1873 MSGMCH1873 F/QDBUDR T/QDBUD
   SI59293      OSP-DB Internal Maintenance
   SI59256      OSP-DB Internal Maintenance
   SI59153      OSP-DB Internal Maintenance
   SI58934      OSP-DB Internal Maintenance
   SI58933      OSP-DB Internal Maintenance
   SI58736      OSP-DB Internal Maintenance
   SI58651      OSP-DB Internal Maintenance
   SI58559      OSP-DB Internal Maintenance
   SI75205      OSP-DB Incremental Enhancement
   SI65378      OSP-DB-OTHER Internal Maintenance
   SI61565      OSP-DB INFRASTRUCTURE
   SI74855      OSP-DB Internal maintenance
   SI61287      OSP-DB-OTHER-F/QDBIOERRQO-T/QSQRUN2-MSGCPF5153 JOB IS FAILIN
   SI70929      OSP-F/QDBGETKY-T/QDBGETKY-MSGMCH3601 REPLICATION SOFTWARE FA
   SI70697      SQL-RUN-F/QDBGETM-T/QDBGETM-MSGMCH0601 SEQUEL APPLICATION FA
   SI68278      OSP-F/QDBGETKY-RC1-MSGSQL0952 SQL0952 RC1 SQLCANCEL GET FUNC
   SI67913      OSP-DB-OTHER-F/#CFXLTDS-T/QDBGETM-MSGMCH5003 MCH5003 - SCALA
   SI67542      OSP-MSGMCH1810-PAR JOB ENDED CONTROLLED GET INTO LOOP REPORT
   SI65243      OSP-DB-OTHER-F/QDBGETM-T/QDBGETM-MSGMCH3402 PERFORMING OVRDB
   SI64767      OSP-F/QDBGETSQ-T/QDBGETSQ-MSGMCH3402 OCCURS WITH OVRDBF MBR(
   SI64767      OSP-MSGMCH1805-D/TQDBGETSQ-PAR SEQUENTIAL READ OF RECORDS RE
   SI63706      OSP-MSGMCH1810-D/TQDBGETSQ-PAR WHEN USING EOFDLY ON OVRDBF,
   SI61020      OSP-DB-OTHER-F/QDBGETKY-T/QDBGETM OPNQRYF CPF9898 A KEY MISM
   SI60339      OSP-MSGMCH3601-D/TQDBGETSQ-PAR A RPG PROGRAM TRYING TO READ
   SI60164      OSP-DB-OTHER-F/#CFDAMST-T/QDBGETM-MSGMCH1668 ERROR IS NOT HA
   SI60164      F/QDBGETM-MSGMCH3402 QDBGETM PROCEDURE CLEAN UP LOOPING AND
   SI60164      OSP-DB-OTHER-F/#DBRETEN-T/QDBGETSQ-MSGMCH1806 THE MCH1806 ME
   SI58560      OSP-DB Internal Maintenance
   SI77374      OSP-DB-OTHER-RC8488-MSGSQL0901 ON ALTER TABLE
   SI75900      OSP-DB-Internal Maintenance
   SI75379      SQL-RUN-LOOP SYSTEMMONITOR SHOWS THE JOB IN A LOOP FOR SRVPG
   SI74673      OSP-DB-OTHER-F/QSQROUTS-T/QSQROUTS-MSGSQL0487 A MSGSQL0487 M
   SI74163      OSP-DB-OTHER-F/RMSLLOCKSPACELOC-T/QDBOPEN-MSGMCH5804 FIRST T
   SI72888      OSP-DB-OTHER-MSGCPF4234 MSGCPF4234 ON ROPEN() WITH ALWUPD(*N
   SI71087      OSP-DB-OTHER-F/QDBSVPRE-T/QDBSVPRE-MSGMCH0601 MSGMCH0601 F/Q
   SI70915      OSP-DB Incremental Enhancement
   SI70549      OSP-INCORROUT INDEXES NOT REMOVED FROM EDTRBDAP LIST
   SI70549      OSP-DB MSGCPF4234 when MIMIX replicating a file
   SI68992      OSP-DB-OTHER-UNPRED ALLOW INSERTING OF DELETED ENTRIES BEYON
   SI67747      OSP-DB-OTHER-F/QQQQEXIT-T/QQQQEXIT-MSGMCH3402 ERROR MESSAGE
   SI67388      OSP-DB-OTHER-F/QQQVALIDX/6604-T/QSQRUN3X/30447-MSGCPF4270 QD
   SI67335      OSP-DB-OTHER-F/QDBSIGEX-T/LOCKTRG-MSGCPF4128 CPF4128 - RNX12
   SI66554      OSP-F/QDBOPEN-T/QDBOPEN-MSGCPF9898 MSGCPF9898 F/T/QDBOPEN AF
   SI66546      OSP-DB-OTHER-MSGCPF9898 - Logical file internal field not fo
   SI66109      OSP-DB MCH0601 f/stringHighUse t/QDBOPEN stmt 3971
   SI65952      OSP-DB-OTHER JOB LOOPS IN QDBOPEN.
   SI65807      OSP-DB-OTHER-F/QDBOPEN-T/QDBOPEN-MSGMCH1210 PROGRAM FAILING
   SI65006      OSP-DB-OTHER-UNPRED PROVIDE A WAY TO CLEAR A TEMPORAL TABLE
   SI64254      OSP-DB-OTHER-T/QDBOPENX/18021-MSGMCH5804 MASSIVE QSQSVCDMPS
   SI62847      OSP-DB-OTHER-F/DBOPSTRATEGY-T/QQQOOODBOP-MSGMCH3203 F/DBOPST
   SI62212      OSP-DB ALLOW_DDL_CHANGES_WHILE_OPEN CPF4326 Commit definitio
   SI61048      F/QDBCKCOL-MSGMCH0601 MSGMCH0601 F/QDBCKCOL T/QDBCKCOL
   SI61043      OSP-DB-OTHER-PERFM _ROPEN API THREAD MTX LOCKSLOWWITHINITALL
   SI61026      OSP-DB MCH3601 From QDBCLOSE 02AE to QDBCLOSE 02AE
   SI60515      OSP-DB-OTHER-F/QSQRUN3/QSQINS-MSGSQL0913X/31981 UPDATE FAILS
   SI60873      OSP-DB-OTHER-F/QDBSIGEX-T/QDBSIGEX-RC3-MSGCPF502F ON WRITE I
   SI60100      OSP-DB Internal Maintenance
   SI60047      OSP-DB Internal Maintenance
   SI59692      OSP-DB Internal Maintenance
   SI59300      OSP-DB-MSGCPF4326 Open of file without commitment control fa
   SI59255      OSP-DB Internal Maintenance
   SI59125      OSP-DB Internal Maintenance
   SI58931      OSP-DB Internal Maintenance
   SI58558      OSP-DB Internal Maintenance

Summary Information

System..............................  i
Models..............................  
Release.............................  V7R3M0
Licensed Program....................  5770SS1
APAR Fixed..........................  View details for APAR SE76890
Superseded by:......................  
Recompile...........................  N
Library.............................  QSYS
MRI Feature ........................  NONE
Cum Level...........................  C2132730


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":"5770SS1","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
25 May 2022