IBM Support

MF53906 - OSP-WAIT INSERT TO JOURNALED FILE HANGS

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-WAIT INSERT TO JOURNALED FILE HANGS


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF53433   00/00    0000
PRE  5770999  710  MF51110   00/00    0000
PRE  5770999  710  MF50222   00/00    0000
CO   5770999  710  MF53884   00/00    0000
CO   5770999  710  MF53872   00/00    0000
CO   5770999  710  MF51142   00/00    0000
CO   5770999  710  MF49896   00/00    0000
CO   5770999  710  MF49122   00/00    0000
CO   5770999  710  MF49180   00/00    0000
CO   5770999  710  MF48918   00/00    0000
CO   5770999  710  MF48484   00/00    0000
CO   5770999  710  MF49948   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

-----------------------------------------------
Jobs inserting records into the same journaled file hung. IPL
required to recover. Job A is waiting for file held by job B.
Job B is waiting for journal 'gate.' Journal gate is held by job
C. Job C is waiting for job A. Deadlock resulted. Job A was
inserting without errors. Job B was inserting and got an error.
Job C was doing DLTJRNRCV. ----call stack details.---- Job A
call stack from job watcher. ... #dbjswap #journal #dbinsim
#dbinsen ... qdbput user program writing a record. Job B call
stack ... #journal #dbinseh processCleanupHandlers
realDoThrow__FP16realDoThrowInput __DoThrow
ExThrowSysEx__FP15SystemException exfanout #dbckten #dbinsim
#dbinsen ... qdbput user program writing a record. Job C call
stack. ... #cfdesto #jodesjs ... QJODLTRC QLIDLOBJ QCMDEXC user
program doing a dltjrnrcv.

CORRECTION FOR APAR MA41252 :
-----------------------------
Problem with internal LIC exception handler for insert errors
can cause deadlock situation.  This APAR corrects the condition.


CIRCUMVENTION FOR APAR MA41252 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF53883      LIC-DB DB Index Seize contention
   MF53875      LIC-DB Check stats for staleness on insert/update/delete ops
   MF53545      LIC-DB floating point conversion exception during ALTER TABL
   MF53494      OSP-MSGMCH3203 f/SmAsmSignalException t/QDBPUT on insert of
   MF53435      Async Move to SSD
   MF53434      Async Move to SSD
   MF53406      LIC-DB F IZ journal enties out of sequence
   MF53379      LIC-DB-PERFM Performances changes for P7 hardware.
   MF52975      LIC-DB-MSGCPF5027 at times incorrectly displays *TNSOBJ
   MF49949      OSP-DB Performance enhancement for SQL MERGE statement
   MF52928      LIC-DB Potential damage to index after attempting to end job
   MF52614      LIC-DB Long Delete with triggers and nested commit
   MF52717      OSP-DB-OTHER-RC2-MSGCPF7091 FILE SHOWING AS DAMAGED WITH MSG
   MF52620      LIC-DB Alternate Nullmap Fieldproc enablement
   MF52551      LIC-DB Deleted entry count discovery and correction during R
   MF52242      LIC-DB A DELETED RECORD HAS BEEN FOUND AS NOT REPORTED IN TH
   MF51792      OSP-UNPRED EVI BUILD IS USING UP TEMP STORAGE
   MF49427      LIC-DB EVI with INCLUDE journaling fix.
   MF51439      OSP-DB-OTHER-PERFM PERFORMANCE ENHANCEMENTS FOR TRIGGER OPER
   MF51416      OSP-OTHER-PERFM SQL DELETE STATEMENT TAKES A LOT LONGER WHEN
   MF51420      OSP-OTHER-PERFM SQL DELETE STATEMENT TAKES A LOT LONGER WHEN
   MF51408      OSP-DB ALL SAP JOBS TRYING TO ACCESS THE TABLE USRSTAMP GETT
   MF51248      LIC-DB-WAIT Data Base seize deadlock
   MF51165      LIC-DB-THREADS-PERFM Extra field procedure threads created d
   MF51151      OSP-DB-OTHER-INCORROUT ROW CHANGE TIMESTAMP DESTROYED BY BEF
   MF51109      LIC-DB-MSG3402 Intermittent MCH3402 from #dbixsiz
   MF51001      LIC-DB Additional materialization data
   MF50690      LIC-DB-INCORROUT LOB+fieldproc data lost at Enforce Constrai
   MF50690      LIC-DB-INCORROUT LOB+fieldproc data lost at Enforce Constrai
   MF50612      LIC DB relax seize on parent key lookup during RI Enforcemen
   MF50548      OSP-F/#DBPARIX-T/QDBCRTME-MSGMCH3203 CRTLF FAILS WITH MSGMCH
   MF50436      LIC-DB Delete of records fails when delete cascade enforceme
   MF50321      LIC-DB Maintenance
   MF50240      OSP-DB RI Cascade Set Default and LOB column in dependent fi
   MF50223      LIC-DB ROW CHANGE TIMESTAMP INCORROUT
   MF50205      LIC-DB Maintenance
   MF50148      OSP Incremental enhancement for fieldproc
   MF50124      LIC-DB-UNPRED Indexes not considered for query after partiti
   MF50104      LIC-DB Index build status information
   MF50080      OSP MSGMCH3601 F #DBXFMP2 on RI Cascade Set Null/Default of
   MF49920      LIC-DB-INCORROUT Uninitialized pointer caused incorrect outp
   MF49897      LIC-DB-INCORROUT Aggregate EVI forcing fixes
   MF49809      LIC-DB-OTHER-UNPRED RUN-TIME DEFERRED UNIQUE KEY ENFORCEMENT
   MF49780      LIC-DB JOBS HUNG ON THEIR PROD BOX, IPL WAS NEEDED.
   MF49754      LIC-DB-OTHER-F/QQQSVRTN -T/QQQSVRTN-MSGMCH3601 Fieldproc and
   MF49753      LIC-DB-OTHER-F/QQQSVRTN -T/QQQSVRTN-MSGMCH3601 Fieldproc and
   MF49673      LIC-DB-JRN-PERFM SMAPP IS OVER-PROTECTING SMALL ACCESS PATHS
   MF49648      LIC-DB-SRCB6001215 #dbcdsrt referencing too far into a DSR s
   MF49608      LIC-DB-MSGMCH3601-F/#DBMATIX
   MF49535      LIC-DB Index build status information
   MF49438      OSP-CL-Run Support In Memory option for database objects
   MF49435      LIC-DB Index build status information
   MF49425      OSP-CL-RUN Support In Memory option for database objects
   MF49127      LIC-DB-PERFM Performances changes for P7 hardware.
   MF49088      LIC-DB-INCORROUT Problem in EVI with INCLUDE recovery functi
   MF48915      LIC-DB-INCORROUT Fix problem in restore of aggregate EVI
   MF48692      LIC-DB-MSGMCH3601  Creation of EVI with INCLUDE fails with M
   MF48628      LIC-DB-INCORROUT Update of an INCLUDE field is not being app
   MF48599      LIC-DB Index build status information
   MF48431      LIC-DB EVI with INCLUDE build status function not working as
   MF48192      LIC-DB Clear fields in #dbxbinx
   MF48482      LIC-DB Aggregate EVI recovery fixes
   MF47895      OSP-Database synchronously move access path to new unit
   MF48014      OSP- System journal 2000 6111 vlogs
   MF49354      MSGMCH3203 f/ #dbenfcn while inserting into partitioned tabl
   MF49179      OSP-DB CASCADING DELETES CAN GENERATE MCH6206 MCH6220 HAPPEN
   MF48750      OSP-DB Partitioned Tables & RI Constraint Fixes
   MF48538      OSP-Database RI Partitioned Table Fixes
   MF49613      LIC-DB-OTHER-THREADS-PERFM Fieldproc thread leak during Sele
   MF49609      OSP-DB-OTHER-INCORROUT TABLE WITH DBCLOB FIELD (UNICODE 1348
   MF49128      LIC-DB-PERFM Performances changes for P7 hardware.
   MF48289      LIC-DB MCH3203 from #dbundel or #dbupdim on partition table
   MF49491      LIC-DB-MSGMCH5003 f/t #dbupden/QDBUDR in a before trigger on

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770999
APAR Fixed..........................View details for APAR MA41252
Superseded by:......................View fix details for PTF MF68659
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C2115710


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.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"5770999","Edition":""}]

Document Information

Modified date:
07 June 2021