IBM Support

MF56265 - LIC-DB-OTHER-SRCB6000103-UNPRED SRCB6000103 DURING NORMAL OP

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

LIC-DB-OTHER-SRCB6000103-UNPRED SRCB6000103 DURING NORMAL OP


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF55888   00/00    0000
PRE  5770999  710  MF54246   00/00    0000
PRE  5770999  710  MF51110   00/00    0000
PRE  5770999  710  MF50222   00/00    0000
CO   5770999  710  MF54840   00/00    0000
CO   5770999  710  MF54634   00/00    0000
CO   5770999  710  MF54428   00/00    0000
CO   5770999  710  MF54001   00/00    0000
CO   5770999  710  MF54003   00/00    0000
CO   5770999  710  MF53884   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

-----------------------------------------------
srcB6000103 crashes system & produces MSD.

CORRECTION FOR APAR MA42398 :
-----------------------------
The system termination was due to a problem that was exposed by
the use of SQL inserts with very large blocking. The operating
system did not properly allocate enough space for the input
buffer and data was unexpectedly overwritten.  This APAR
corrects the issue and eliminates the potential for a system
crash in this code path.

CIRCUMVENTION FOR APAR MA42398 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF56136      OSP-MSGMCH3402 f/t stringHighUse/QDBPUT lob insert
   MF56133      MCH3203 F/T QDBPUT "Function error X'0322' in machine instru
   MF56120      OSP-WAIT SEVERE GATE CONTENTION REQUIRING IPL TO RESOLVE
   MF56092      OSP-DB-OTHER-UNPRED INDEXES REBUILDING AFTER UPGRADE
   MF56038      LIC-DB-JRN APYJRNCHG causes system termination
   MF56000      OSP Data Space Index Changes
   MF55960      LIC-DB PERFORMANCE MCLI - QUBaseGate_UnLocks #dbixchn
   MF55865      OSP-DB-OTHER-F/#DBPARIX-T/QDBOPEN-MSGMCH3203 MSGMCH3203 F/#D
   MF55736      OSP- VL0F000702 Commit vlog occurs occasionally
   MF55771      LIC-DB-OTHER-F/DBPMTRAP-T/QDBPUTM-MSGMCH3203 MSGMCH3203 F/DB
   MF55624      OSP Data Space Index Size Diagnostics
   MF55377      OSP-DB-OTHER-PERFM INDEXES OVER A TABLE MAY BE REBUILT WHEN
   MF55334      LIC-DB-SMAPP-PERFM ACCPTHSIZ(*MAX1TB) RESULTS IN A HIGH ESTI
   MF55062      OSP-DB-OTHER-INCORROUT INSERTING BLOCKED RECORDS INTO A PART
   MF54841      LIC-DB-PERFM FILE CONTENTION WHEN AN EXTENT TABLE NEEDS TO B
   MF54636      OSP-DB FieldProc Enhancements
   MF52478      OSP-MSGMCH3404 Object Not Eligible during Alter Table f/#dbr
   MF54639      OSP-DB FieldProc Enhancements
   MF54616      LIC-DB-MSGCPF4126 End of Chain exception ouf of #dbixchn
   MF54490      OSP-F/IXMACHINEINDEXEXTEND-T/QDBCRTME-MSGMCH2804 MSGMCH2804
   MF54430      LIC-DB Large IO buffer efficiency
   MF54430      LIC-DB INZPFM and Alter Table performance ennhancement
   MF54146      OSP-F/QSQRUN3QSQINSCLEANUP28757-T/QSQRUN3QSQINSCLEANUP28757-
   MF54080      LIC-DB-OTHER-F/#DBSELIX-MSGMCH3203 DURING EVI WITH INCLUDE M
   MF54000      LIC-DB-OTHER-LOOP LIC-DB-OTHER-LOOP - RGZPFM HANGS
   MF53906      OSP-WAIT INSERT TO JOURNALED FILE HANGS
   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
   MF54248      LIC-DB Query for file SSD info sees stale data location info

Summary Information

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


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