IBM Support

SI74863 - OSP-DB TRIGGER PROGRAM IS GETTING MCH1210 T/QDBPUT F/QDBPUT

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB TRIGGER PROGRAM IS GETTING MCH1210 T/QDBPUT F/QDBPUT


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770SS1  V7R2M0    SI59900   00/00    0000
PRE  5770SS1  V7R2M0    SI51352   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

-----------------------------------------------
Inserts into files with field procedures fail with MSGMCH1873
F/T/QDBPUT when the field procedure fails.

CORRECTION FOR APAR SE74664 :
-----------------------------
When a field procedure fails when inserting into a file, the
failure is not handled correctly by the operating system. This
fix will ensure that either the operation will be retried or
will fail with MSGCPF503E as expected.

CIRCUMVENTION FOR APAR SE74664 :
--------------------------------
None.


DESCRIPTION OF PROBLEM FIXED FOR APAR SE74606 :
-----------------------------------------------
Trigger program is failing with MSGMCH1210 T/QDBPUT F/QDBPUT
PERFORM_COMPLEX_INSERT.

CORRECTION FOR APAR SE74606 :
-----------------------------
The length of the parameters passed in to the trigger program
was being modified by the trigger program.  When this length was
subsequently used again within QDBUDR, it resulted in the
MCH1210.  The code will be changed to save the parameter length
prior to the trigger program call and restore it back after the
call so as not to use the modified length.

CIRCUMVENTION FOR APAR SE74606 :
--------------------------------
Correct the trigger program to avoid modifying the length
parameter.


Activation Instructions


None.




Special Instructions


None.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI73984      OSP-DB-OTHER-F/QDBPUT-T/QDBPUT-MSGMCH1873 Inserts into files
   SI73247      OSP-DB-OTHER-F/QDBSIGEX-T/QDZXDBI-RC20-MSGCPF5035 CPF5035 RC
   SI68617      OSP-DB-OTHER-UNPRED QDBTREXT BEING CALLED TWICE PER INVOCATI
   SI67742      OSP-DB-OTHER-F/QDBPUT-MSGMCH1873 A MSGMCH1873 F/QDBPUT MAY O
   SI67535      OSP-F/QDBUDR-T/QDBUDR-MSGMCH1210 MCH1210 F/T/QDBUDR
   SI67127      OSP-DB Internal maintenance
   SI66924      OSP-DB-OTHER-T/QDBXREF-MSGMCH6903 QDBSRVXR JOB REACHES HEAP
   SI65377      SQL-RUN-F/CBLABRANCH-MSGMCH1210 MSGMCH1809 FOLLOWED BY MSGMC
   SI64323      OSP-DB-OTHER-F/QDBUDR-T/QDBUDR-MSGMCH0601 WHEN TRIGGER FIRES
   SI61484      OSP-DB-OTHER-F/#DBCPYFL-T/QDBUDR-MSGMCH5003 UPDATE FAILS WIT
   SI61297      Improper handling of MSGMCH1873 f/QDBUDR results in MSGMCH36
   SI61263      OSP-DB-OTHER-F/#DBENFCN-T/QDBPUTDR-MSGMCH1880 WHILE APPLYING
   SI60131      OSP-DB Internal Maintenance
   SI59902      OSP-DB Internal Maintenance
   SI59008      OSP-DB-OTHER-F/QDBPUTMX-T/QDBPUTMX-MSGMCH3402 MCH3402 SQL090
   SI58613      OSP-F/QDBUDR-T/QDBUDR-MSGMCH1873 MSGMCH1873 F/QDBUDR T/QDBUD
   SI57303      OSP-DB-OTHER-INCORROUT IN TRIGGER BUFFER WHEN INSERT OF UTF-
   SI57117      OSP-DB-OTHER-UNPRED LOWER CASE SQL STATEMENTS ARE NOT RECOGN
   SI53005      OSP-DB-MSGMCH1210 unable to delete a large number of records
   SI52699      OSP-JRN-INCORROUT Internal maintenance
   SI52645      OSP-DB-INCORROUT Internal maintenance
   SI52550      OSP-DB-INCORROUT Internal maintenance
   SI52501      OSP-DB-INCORROUT internal maintenance
   SI52485      OSP-DB-INCORROUT Internal maintenance
   SI52370      OSP-DB-INCORROUT Internal maintenance
   SI52292      OSP-DB-INCORROUT Internal maintenance
   SI52174      OSP-DB-INCORROUT Failing trigger programs cause job terminat
   SI51659      OSP-DB-INCORROUT QDBPUTMX PLX port fixes
   SI51504      OSP-DB-INCORROUT QDBPUT QDBPUTDR QDBPUTM QDBPUTMX QDBUDR fix
   SI51470      OSP-DB-INCORROUT QDBPUT QDBPUTDR QDBPUTM QDBPUTMX QDBUDR fix
   SI51351      OSP-DB Internal updates
   SI51351      OSP-DB-INCORROUT Errors in QDBPUT, QDBPUTDR, QDBPUTM, QDBPUT

Summary Information

System..............................i
Models..............................
Release.............................V7R2M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE74664
View details for APAR SE74606
Superseded by:......................
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C1084720


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 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"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2","Product":{"code":"SG15V","label":"PTF Cover Letters - IBM i General"},"Component":"5770SS1","Edition":""},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2","Product":{"code":"SG16F","label":"PTF Cover Letters - IBM i 7.2"},"Component":"5770SS1","Edition":""}]

Document Information

Modified date:
18 April 2021