IBM Support

MF68182 - osp-db database table insert/update performance when file ha

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

osp-db database table insert/update performance when file ha


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770999  V7R4M0    MF66982   00/00    0000
PRE  5770999  V7R4M0    MF67430   00/00    0000
PRE  5770999  V7R4M0    MF67046   00/00    0000
PRE  5770999  V7R4M0    MF66843   00/00    0000
PRE  5770999  V7R4M0    MF65931   00/00    0000
CO   5770999  V7R4M0    MF67414   00/00    0000
CO   5770999  V7R4M0    MF67331   00/00    0000
CO   5770999  V7R4M0    MF66607   00/00    0000
CO   5770999  V7R4M0    MF66439   00/00    0000
CO   5770999  V7R4M0    MF66017   00/00    0000
CO   5770999  V7R4M0    MF66022   00/00    0000
CO   5770999  V7R4M0    MF66024   00/00    0000
CO   5770999  V7R4M0    MF66025   00/00    0000
CO   5770999  V7R4M0    MF66026   00/00    0000
CO   5770999  V7R4M0    MF66304   00/00    0000
CO   5770999  V7R4M0    MF66307   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

-----------------------------------------------
When multiple jobs are concurrently performing insert (and some
types of updates) to a database table (file) which has variable
length or lob (clob/dblob/blob) columns, some contention exists
when allocating storage for the variable length/lob data.

CORRECTION FOR APAR MA48796 :
-----------------------------
Improvements have been made to increase concurrency for the
insert (and some types of updates) to the database table.

CIRCUMVENTION FOR APAR MA48796 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF67834      OSP-DB reduce SLIC DB intervals which require Flush_All seiz
   MF68168      OSP-DB Improved internal logging during MCH2804 f/#dbcalcs
   MF68149      OSP-DB enhanced error logging in close database file process
   MF68073      LIC-DB Hang during immediate RI enmforcement
   MF68072      OSP-DB reduce storage fragmentation on database object opera
   MF67880      LIC-DB Objects in transaction remain out of sync
   MF67879      LIC-DB Objects in transaction remain out of sync
   MF67854      LIC-DB Rolled back delete of child record circumvents delete
   MF67850      LIC-DB SQL0901 error after constraint violation during phase
   MF67815      LIC-DB Set rollback-only at job cancelation
   MF67814      LIC-DB Resync jobs looping
   MF67765      LIC-DB Rolled back changes not replayed during reclone/resyn
   MF67762      LIC-DB NULL x'00' put in PF by COBOL after CLRPFM
   MF67207      OSP-DB extended functions in SLIC DB MI Materialze Data Spac
   MF67739      LIC_DB Additional info on TVI exception
   MF67738      LIC-DB Records marked out of sync and file placed on OTL aft
   MF67726      LIC-DB Rolled back changes not replayed during reclone/resyn
   MF67692      LIC-DB Row count wrong after DELETE w/ RI fails due to MCH36
   MF67658      LIC-DB Deadlock during insert when mirroring is suspended
   MF67601      LIC_DB Hang during resync after side-effect RI when parallel
   MF67521      LIC-DB out-of-sync records not maintained during copy or alt
   MF67521      LIC-DB MCH3601 from #dbdents during restore of mirrored file
   MF67519      Internal SLIC DB vlog documentation update
   MF67494      OSP-DB entry not journaled rollback failure
   MF67492      OSP-DB concurrent insert performance optimization
   MF67491      LIC-DB Gather additional data on exception on insert when ou
   MF67442      OSP-DB-OTHER-F/ASSERT-T/QDBGETKEY-MSGMCH3203 MSGCPF427D F/QD
   MF67437      OSP-DB CREATE OR REPLACE TABLE TO ALTER IT WITH NO FORMAT CH
   MF67434      LIC-CO process exception during tracking
   MF67433      LIC-DB Gather additional data on exception during insert
   MF67431      LIC-CO Records left locked in QDBMSRVR job after IASP varied
   MF67411      OSP-DB enhanced debug on insert 'first burst of code' proces
   MF67380      LIC-DB-CO Better tracking of upcall outcome to facilitate pr
   MF67379      LIC-DB Resync performance enhancements for journaled databas
   MF67328      LIC-DB-JRN-PERFM THE TARGET SIDE JOURNAL APPLY JOB IS SLOWER
   MF67299      LIC-DB Threads hung under commit during tracking of mirrored
   MF67269      LIC-DB Mark file "partial transactions" if rollback fails le
   MF67223      LIC-DB Prevent looping during Mirror resync
   MF67017      OSP-DB SLIC DB LIC LOG object information logging tolerance
   MF66654      OSP-DB SLIC DB support to return additional internal data sp
   MF66631      OSP-DB MCH2804 f/#dbgetax on OS (internal) OMLOBB DS
   MF66497      OSP-DB internal diagnostic enhancements for object storage l
   MF66227      DB-LIC Additional MI servicibility
   MF65783      LIC-DB Large file reports incorrect size
   MF67222      LIC-DB MCH3404 Object not eligible for requested operation
   MF67220      LIC-DB Jobs hang on insert when tracking while mirrored
   MF67147      LIC-DB Commit blocks marked damaged when removing deleted ob
   MF67146      LIC DB U L1 and U L4 jurnal entries errantly deposited in jo
   MF67145      LIC-DB Resync of DB2 Mirror does not resync
   MF67133      OSP-DB improvements to SLIC DB interfaces
   MF67128      LIC-DB Objects in transaction remain out of sync
   MF67074      LIC-DB Objects in transaction remain out of sync
   MF67074      LIC-DB Objects in transaction remain out of sync
   MF67074      LIC-DB Objects in transaction remain out of sync
   MF67074      LIC-DB Objects in transaction remain out of sync
   MF67074      LIC-DB Objects in transaction remain out of sync
   MF67074      LIC-DB Objects in transaction remain out of sync
   MF66916      LIC-DB Remove extraneous vlog
   MF66883      LIC-DB Enable pending RI side-effect during resync
   MF66691      LIC-DB Bypass delayed RI enforcement during target resync
   MF66691      LIC-DB Changes in files with RI side-effects not replicated
   MF67019      OSP-DB Deactivate & Destroy Cursor Exception Handling Improv
   MF66921      LIC-DB Remove extraneous vlog
   MF66917      LIC-DB MCH2804 #dbcalcs Tried to go larger than storage limi
   MF66898      LIC-DB Enable pending RI side-effect during resync - Phase I
   MF66897      LIC-DB Enable pending RI side-effect during resync - Phase I
   MF66882      LIC-DB Enable pending RI side-effect during resync
   MF66832      LIC-DB Move Record enablement
   MF66760      OSP-DB-OTHER-UNPRED UNEXPECTED ACCESS PATH REBUILD VL06002E1
   MF66728      LIC-DB System outage when transition to tracked
   MF66690      LIC-DB Changes in files with RI side-effects not replicated
   MF66689      LIC-DB Bypass delayed RI enforcement during target resync
   MF66688      LIC-DB Changes in files with RI side-effects not replicated
   MF66668      OSP-DB improve performacne of internally used *file initiali
   MF66638      LIC-DB-OTHER-PERFM - Improve Dataspace Index read counters p
   MF66584      LIC-DB IX not marked to skip unique checking during resync
   MF66583      LIC-DB additional debug journal entry
   MF66438      OSP-DB SLIC Database in-use table write optimizations
   MF66021      OSP-DB-OTHER-PERFM TLBIE RESPONSE TIMES SPIKES AND CACHE LIN
   MF66581      LIC-DB Records out of sync when under commit during suspend
   MF66582      LIC-DB Records out of sync when under commit during suspend
   MF66563      LIC-DB EVI indexes invalidated during Mirror resync
   MF66522      OSP Database insert performance on a secondary system of a d
   MF66505      OSP-DB-INCORROUT non-partitioned INDEX OVER A PARTITIONED TA
   MF66450      LIC-DB remove frequesntly occurring 0600 3039 vlogs
   MF66437      OSP-DB SLIC Database in-use table write optimizations
   MF66399      LIC_DB Support for change-end-of-data during mirrored resync
   MF66398      LIC-DB Abundance of journal entries on mirrored target
   MF66379      OSP-DB Db2 Mirror Commit MCH3203 CPF83EC CPF8367
   MF66225      OSP-DB database file insert exception handling changes
   MF66331      LIC-DB Allow preverification of CEOD operation
   MF66306      osp database field procedures and buffer data content for nu
   MF66228      DB-LIC Additional MI servicibility
   MF66186      LIC-DB Additional debug journal entries
   MF66184      LIC-DB Additional debug journal entries
   MF66084      LIC-DB Duplicate Index during resync
   MF66040      LIC-DB Performance issue when marking dentsync for every rec
   MF66079      OSP-DB read from physical file with field procedure (fieldpr
   MF66039      LIC-DB Target allows insert of record into wrong partition
   MF66019      OSP-DB-OTHER-PERFM TLBIE RESPONSE TIMES SPIKES AND CACHE LIN
   MF65883      OSP-DB-OTHER-SRCB6000308-INCORROUT SRCB6000308
   MF65874      OSP-DB insert fixes
   MF65862      LIC-DB-TN Rows not synced when in a partially complete trans
   MF65847      OSP-DB regenerate permanent curor internal code for files wi
   MF65835      LIC-DB Dump additional info in #dbdents
   MF65820      LIC_DB Additional support for ACTCR
   MF65797      LIC-DB-OTHER-PERFM Reduce contention on cacheline modified d
   MF65782      Add journal entries for debug
   MF65781      LIC-DB Function check out of #comocob when mirroring is susp
   MF66018      OSP-DB-OTHER-PERFM TLBIE RESPONSE TIMES SPIKES AND CACHE LIN
   MF65954      LIC-DB-TN Rows tracked on blocked system
   MF65920      LIC-DB-TN Rows tracked on blocked system
   MF67151      LIC-DB Record lock timeout on target during rollback
   MF65934      LIC-DB Throw record lock exception when record in use
   MF65953      LIC-DB Duplicate key when mirroring suspended on file with t
   MF65895      OSP-DB file update with trigger and "default user" may not s

Summary Information

System..............................i
Models..............................
Release.............................V7R4M0
Licensed Program...............5770999
APAR Fixed..........................View details for APAR MA48796
Superseded by:......................View fix details for PTF MF68788
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C1091740


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.4.0","Product":{"code":"SWG60","label":"IBM i"},"Component":"5770999","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
07 September 2021