IBM Support

MF57986 - OSP-DB-OTHER-UNPRED SELECT FROM INSERT STATEMENT CAUSES INDE

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-UNPRED SELECT FROM INSERT STATEMENT CAUSES INDE


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF57137   00/00    0000
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

-----------------------------------------------
SELECT FROM INSERT statement causes index rebuilding

CORRECTION FOR APAR MA43408 :
-----------------------------
This PTF will properly detect and process file entries on a
segment group boundary when using them as the source for a
secondary file when doing a SELECT FROM INSERT.

CIRCUMVENTION FOR APAR MA43408 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF57659      LIC-DB Improve checklock for delay aux recycle
   MF57494      LIC-DB iASP varyon hang at Commit Recovery
   MF57480      OSP-DB DBRT TR enhancements
   MF57029      LIC-DB Performance degredation in DBGETAX/SMISSAME 540 to 61
   MF56798      LIC-DB Damage to SYSIXADV after crash
   MF56499      LIC-DB-OTHER-PERFM PERFORMANCE DEGRADATION FOR LARGE DELETE
   MF56077      LIC-DB-OTHER-LOOP DBIOXX CONSUMING CPU #DBRECYC, EOJ STUCK,
   MF53952      PERFM-LIC-DB EXCESSIVE I/O DURING DBMON ANALYSIS QUERY W/MAX
   MF51375      OSP-DB #dbrecyc diagnostics improved and recix max limit inc
   MF49873      OSP- MSGMCH1210-F/CBLABRANCH-T/QDBEXDME DSPFD GETS MCH1210
   MF57366      LIC-DB-SRCB6000308 #DBPARIX
   MF57150      OSP-DB-OTHER-F/#DBIXSIZ-T/QDBEXDME-MSGMCH3403 MCH3203 AND CP
   MF57122      LIC-DB Improve temp storage usage parallel index build
   MF57112      OSP-DB-OTHER-LOOP SOME CONDITIONS WHERE PAGES GET ZEROED OUT
   MF57110      OSP DAMAGED FILE OCCURS DURING TOLERATED EXCEPTION
   MF57095      LIC-DB IO count buffering
   MF57070      OSP-DB A STORED PROCEDURE FAILS MSGCPF5035 RC16 F/QDBSIGEX T
   MF57063      IPL-SRCB6000103 SYSTEM AUTO IPLED.
   MF56874      OSP-Database Data Space Index Improvements
   MF56859      LIC-DB Improve temp storage usage parallel index build
   MF56634      OSP- Internal maintenance
   MF56633      OSP- Internal maintenance
   MF56587      OSP-DB-OTHER-SRCB6001215 SYSTEM CRASHED DOUBLE SRCB6001215.
   MF56392      LIC-DB-JRN-MSGMCH4801 #DBUPDIM CHECKSUM FAILURE
   MF56265      LIC-DB-OTHER-SRCB6000103-UNPRED SRCB6000103 DURING NORMAL OP
   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 MA43408
Superseded by:......................View fix details for PTF MF68054
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C4143710


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

Document Information

Modified date:
01 December 2020