IBM Support

MF63655 - OSP DATABASE next IDENTITY COLUMN VALUES NOT CORRECT AFTER F

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP DATABASE next IDENTITY COLUMN VALUES NOT CORRECT AFTER F


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF63652   00/00    0000
PRE  5770999  710  MF60659   00/00    0000
PRE  5770999  710  MF60080   00/00    0000
PRE  5770999  710  MF59938   00/00    0000
PRE  5770999  710  MF57137   00/00    0000
PRE  5770999  710  MF55888   00/00    0000
PRE  5770999  710  MF50222   00/00    0000
PRE  5770999  710  MF53950   00/00    0000
PRE  5770999  710  MF55195   00/00    0000
CO   5770999  710  MF58260   00/00    0000
CO   5770999  710  MF58261   00/00    0000
CO   5770999  710  MF59278   00/00    0000
CO   5770999  710  MF59290   00/00    0000
CO   5770999  710  MF54001   00/00    0000
CO   5770999  710  MF53884   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  MF54635   00/00    0000
CO   5770999  710  MF54638   00/00    0000
CO   5770999  710  MF55217   00/00    0000
CO   5770999  710  MF54035   00/00    0000
CO   5770999  710  MF53295   00/00    0000
CO   5770999  710  MF53789   00/00    0000
DIST 5770SS1  710  SI45297   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

-----------------------------------------------
After a flash copy and vary-on (or crash), the next database
Identity Column values assigned upon insert operations may not
be correct.  When there is a unique index over the columnm,
duplicate keys will be experienced and result in CPF5009.

CORRECTION FOR APAR MA46400 :
-----------------------------
The vary-on/IPL recovery of the data space header internal next
identity value structure had a problem which has been fixed.

CIRCUMVENTION FOR APAR MA46400 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF MF61046 :
=================================================

MF61046, along with MF62518, includes changes that allow restore of the
file after an internal structure has been converted to be more robust,
which requires the PTFs to be installed on the target of a restore if
the source of the save had the PTF applied.

If one or both of the PTFs for MA45275 or MA45104 have been installed
on a system when a table or physical file is saved, then BOTH of those
PTFs must also be installed on the system where the file is restored to
prevent the possibility of a restore failure.  Specifically, some files
with variable length or LOB fields may be damaged during the restore if
the PTFs are not present.  Because this may occur when restoring across
releases, PTFs for all releases are listed.

NOTE:  One or both of the PTFs for MA45275 and MA45104 may be installed
on the restore system when a table or physical file is restored even if
the PTFs were not installed on the save system at the time of the save.
This includes saving a file from a system at one release and restoring
it to a system at a different release.

The PTFs for MA45275 are:
V7R1:   MF62518
V7R2:   MF62519
V7R3:   MF61374

The PTFs for MA45104 are:
V7R1:   MF61046
V7R2:   MF61047
V7R3:   MF60986

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF MF62655 :
=================================================

APAR MA40422's PTF corrects an internal database index processing
problem during an Alter Table.  Without the PTF, a system crash after
the Alter Table exposes certain indexes to possible damage or
incomplete recovery.

Only a very small subset of indexes have the potential exposure to this
damage.
An index could become damaged during the system crash if:
- Main storage was not preserved at the time of the system crash
- The index's physical file was in use for update, insert, or delete at
the time of the system crash
- The index was explicitly journaled at the time of the crash (via the
STRJRNAP CL command)
- The index's physical file was altered at some point subsequent to
starting explicit access path journaling.
The alter of the physical file was performed in one of the following
three ways:
1) The SQL ALTER TABLE statement was performed
2) The CHGPF CL command with a SRCFILE keyword, or
3) An SQL DELETE statement without a WHERE clause (where all rows were
deleted) under commitment control)
- The index has not been rebuilt since the system crash

If you suspect you may have indexes that meet this criteria, you should
consider rebuilding these indexes or checking to ensure that the
indexes are not damaged.

To determine which indexes are currently explicitly journaled, you can
issue the following command:
DSPFD FILE(*ALL/*ALL) TYPE(*ACCPTH) OUTPUT(*OUTFILE) OUTFILE(QTEMP/A)

Then query the resulting table. For example, via the following SQL
statement:
SELECT * FROM qtemp.a WHERE APACPJ = 'Y'

To check indexes and ensure that the indexes are not damaged, the check
index tool can be used.  It is documented at
http://www-912.ibm.com/s_dir/slkbase.NSF/DocNumber/585335019.


Default Instructions

THIS IS A DELAYED PTF TO BE APPLIED AT IPL TIME.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   MF63276      LIC-DB performance improvement accessing force bitmap
   MF63037      LIC-DB excessive 06004C31 vlogs
   MF62919      OSP-F/#DBUPDIM-T/QDBUDR-MSGMCH4801 APPLY JOB FAILS WITH MCH4
   MF62808      OSP-DB A JOB MAY CREATE MANY THREADS (THOUSANDS) IF CQE USES
   MF62655      OSP-DB Internal Maintenance for SLIC DB - Implicitly turn on
   MF62636      OSP Database maintain dababase index unique key counts and r
   MF62555      OSP-DB LIC DB Parallel index build cash performance tuning
   MF62537      OSP-DB SLIC DB Internal Maintenance for LOB processing of Au
   MF62492      OSP-DB-OTHER-UNPRED FOLLOWING A CLRPFM A CPF8111 DAMAGE ON M
   MF62404      OSP Database maintain dababase index unique key counts and r
   MF62311      OSP-PAR B6001215
   MF62191      LIC-DB Future release compatibility changes
   MF54096      OSP Enhance data in VL06001710 vlog
   MF53794      OSP-MSGCPF3793-MSGMCH2803-MSGCPF5272 RC1 Database File proce
   MF52766      LIC-OTHER-INCORROUT RESTORING A LARGE PHYSICAL FILE CRASHES
   MF62190      LIC-DB Future release compatibility changes
   MF62189      LIC-DB Future release compatibility changes
   MF62188      LIC-DB Future release compatibility changes
   MF62187      LIC-DB Future release compatibility changes
   MF62186      LIC-DB Future release compatibility changes
   MF62185      LIC-DB Future release compatibility changes
   MF62181      LIC-DB Future release compatibility changes
   MF62175      LIC-DB Future release compatibility changes
   MF56955      OSP MSGCPF8111 FILE DAMAGED / VL06003585 / VL0300020B
   MF55214      LIC-DB Simple record deadlock detection improvement
   MF55052      OSP- VL0F000702 Commit vlog occurs occasionally
   MF54036      LIC-DB-OTHER-UNPRED ACCESS PATH LOGICAL READ COUNTERS ARE NO
   MF53449      LIC-DB-RUN-WAIT HANG CONDITION - DB WAIT IN SEIZE/GATE
   MF53294      OSP-DB-OTHER-F/QDBSIGEX-T/QDBSIGEX-MSGCPF5027 ORPHANED WEAK
   MF52990      LIC-DB-MSGCPF5027 against orphaned internal record lock
   MF50757      LIC-DB-OTHER-WAIT LONG-RUNNING QUERY COULD NOT BE ENDED
   MF50081      LIC-DB-OTHER-INCORROUT INCORROUT DURING CONCURRENT PROCESSIN
   MF48778      OSP-DB SETCR Seize Monitor for numerous consecutive deleted
   MF62236      OSP-F/EXSNDPM-T/QQQQUERY-MSGMCH3203 OPNQRYF LEADS TO MSGMCH3
   MF62200      OSP-DB Internal performance improvements for cpyf, alter tab
   MF62029      OSP-DB Internal Maintenance to add diagnostics to #dbcinds o
   MF61964      OSP-F/#DBCINDS-T/QQQOOODBOP-MSGMCH2804 MCH2804 RECEIVED ON A
   MF61857      OSP-DB Performance scaling (cache line) #dbscblk
   MF61602      OSP-DB Performacne scaling (cache line) #dbreten
   MF61599      OSP-DB General
   MF61559      OSP-DB Database IPL/Vary on Database Processing Improvements
   MF61556      OSP-DB Database IPL/Vary on Database Recovery & Initializati
   MF61532      OSP-DB Database IPL/Vary on Database Recovery Processing Imp
   MF61518      LIC-DB Put out info VLOG for long running Catch-Up (Phase 2)
   MF61471      OSP-DB Database IPL/Vary on Database Recovery Processing Imp
   MF61459      LIC-DB-OTHER-SRCB6005121-UNPRED SYSTEM HALT DURING NORMAL OP
   MF61371      OSP-DB Database Create Temp OMLOBB Data Space Improvements
   MF61362      OSP-DB Database Insert Processing Improvements
   MF61316      LIC-DB Put out info VLOG for long running Catch-Up
   MF61290      OSP-DB DataBase Vary-On processing to avoid tolerated except
   MF61169      OSP-DB DataBase Vary-On processing to avoid tolerated except
   MF61161      OSP-DB-OTHER-THREADS-PERFM RESTORE FAILS WITH MCH1604
   MF61158      OSP-DB LIC DB Index Build Concurrency Tuning
   MF61046      LIC-DB Correct Save/Restore inconsistancy in Recycle index
   MF61004      LIC-DB 060056B9 vlogs on first touch after IPL, IASP vary on
   MF60891      OSP-DB Internal Maintenance for SLIC DB IPL/Vary-on
   MF60885      LIC-DB Force recycled Aux pieces at close
   MF60840      OSP-F/#DBDELIM-T/QDBUDR-RC1716-MSGMCH3203 RGZPFM WITH ALWCAN
   MF60837      OSP-F/#DBDELIM-T/QDBUDR-RC1716-MSGMCH3203 RGZPFM WITH ALWCAN
   MF60782      OSP-DB-OTHER-UNPRED DOCUMENTING WHEN THE UNIQUE COUNTS FOR A
   MF60707      LIC-DB VL06005EED for very large files
   MF60679      OSP-DB-OTHER-UNPRED ALTER TABLE RESTART IDENTITY COLUMN F-IT
   MF60660      OSP-DB Database Access Path Build Resource Consumption Tunin
   MF60645      LIC-DB Long wait at end of RGZPFM
   MF60558      OSP-DB LIC DB Index Build Concurrency Tuning
   MF60528      OSP-DB-OTHER-F/#DBGETAXX/1716-T/QDBPUTMX/0702-MSGMCH3203 ALT
   MF60499      OSP-PERFM LARGE AMOUNTS OF READS ON FILE CAN CAUSE EXCESSIVE
   MF60540      LIC-DB Excessive Page fault during SQL statement
   MF60426      OSP-INCORROUT WHEN INTERNAL STRUCTURES ARE INCORRECT AND DEL
   MF60303      OSP-DB RGZPFM INCREASES THE SIZE OF A PF WITH LOB COLUMNS
   MF60194      LIC-DB Prevent Performance issue caused by repeated rebuild
   MF60182      F/DBMODIX-MSGMCH3404 MCH3404 ON THE REPLAY OF THE SECOND F C
   MF60127      LIC-DB Aux stg garbage collection and addt'l sanity check
   MF60083      LIC-DB Internal maintenance
   MF59959      OSP-DB ROLLBACK OF AN ALTER TABLE MAY NOT FULLY CLAN UP RECO
   MF59940      OSP-DB Internal maintenance
   MF59808      LIC-DB Opening a delayed maintenance Access Path causes cont
   MF59763      LIC-DB-OTHER-UNPRED TEMP STORAGE GROWTH DUE TO TEMP RADIX IN
   MF59752      LIC-DB Delay deleted entry count processing until end of RGZ
   MF59708      OSP-DB-OTHER-F/DBMAPV2F-T/QDBUDR-MSGMCH3203 A MSGMCH3203 MAY
   MF59690      OSP-DB Internal Maintenance #dbdelcp/#dbdelct VLOG long runn
   MF59673      LIC-DB EVI on IASP not refreshing when overflow reaches thre
   MF59620      OSP DB MCH3203 f/#dbentad t/QDBPUT with VL02001716 from #dbe
   MF59618      OSP-DB-OTHER-F/#DBGETAX-T/QDBPUT-MSGMCH3203 A MSGMCH3203 MAY
   MF59598      LIC-DB-OTHER-F/#DBXSIZE-T/QDBMAINT-MSGMCH2804 INDEX ACCESS P
   MF59594      MSGMSGCPDB8E4RC6-DISK-HLIC VARY ON OF IASP FAILS WITH MSGCPD
   MF59549      LIC-DB Set last used VL storage at IPL.
   MF59545      OSP-SRCB6001215-UNPRED DURING NORMAL OPERATIONS, SYSTEM FAIL
   MF59474      LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
   MF59479      OSP-DB-OTHER-UNPRED VL06001389 INDEX INVALIDATED. FILES SHOW
   MF59454      LIC-DB-JRN EVI refresh inhibits force, impacts journal sync
   MF59274      OSP-DB-OTHER-PERFM SCAN OF EVI OVERFLOW AREA CAUSES PERFORMA
   MF59270      OSP-DB INTERNAL MAINTENANCE
   MF59210      LIC-DB Index mismatch and records not appearing in file
   MF59105      LIC-DB Data space fixup on first touch
   MF59010      OSP-DB-JRN-F/#CFTSMPI-T/QJODSPJE-MSGMCH1222 ON REPLICATION O
   MF58146      OSP-DB-OTHER-UNPRED RGZPFM ALWCANCEL(*NO) DOES NOT RETURN AU
   MF57698      LIC-DB-JRN Tolerate incorrect ordinal number in R DL journal
   MF57477      OSP-DB DBDS TR enhancements
   MF52171      OSP-DB Define and format new DSI header field
   MF57483      OSP-DB DBMN TR enhancements
   MF57231      OSP Database RGZPFM enhancements
   MF57107      OSP-DB-OTHER-PERFM A RGZPFM THAT HAS BEEN RESTARTED MY CAUSE
   MF56665      OSP-DB-OTHER-WAIT CHGPF AND CHGLF TO SSD DON'T SEEM TO BE MA
   MF56662      LIC-DB Additional support for DBStats during RGZPFM
   MF56550      LIC-DB Failure during materialize file processing due to no
   MF56107      LIC-DB-SRCB6001215 System terminated out of DbReuse.
   MF55451      LIC-DB AFTER AN ALTER TABLE, PROCESSING EVI'S MAY BE SLOWER
   MF54842      LIC-DB-PERFM FILE CONTENTION WHEN AN EXTENT TABLE NEEDS TO B
   MF54679      F/#DBHCEOD-MSGMCH3203 RGZPFM MCH3203 F/#DBHCEOD T/QDBRGZPF F
   MF52927      LIC-DB Slow RGZPFM on extremely large file
   MF52550      LIC-DB Deleted entry count discovery and correction during R
   MF52258      LIC-DB-JRN-PERFM REPLAY OF RGZPFM ENTRIES CONSUMES SYSTEM RE
   MF50473      SRCB6005121-HLIC-94XXDOC 1 SRCB6005121 3 SRC0002000A 4 SRC00
   MF49942      LIC-DB Jobs take longer during RGZPFM KEYFILE(*RPLDLTRCD) AL
   MF49071      OSP RGZPFM RUNS LONGER AT R610 WHEN READING THROUGH THE DELE
   MF54634      OSP-DB FieldProc Enhancements
   MF54478      OSP-DB-OTHER-F/IXMACHINEINDEX-T/QDBSVPRE-MSGMCH3203 BACKUP F
   MF54303      OSP-Database Add Partition, Index Processing Performance Imp
   MF54250      LIC-DB Query for file SSD info sees stale data location info
   MF54115      LIC-DB Serialized async move to SSD
   MF54040      LIC-DB-MSGMCH3402 occurs after DSPFD completes
   MF54002      LIC-DB-OTHER-LOOP LIC-DB-OTHER-LOOP - RGZPFM HANGS
   MF53542      osp database file allocation on Alter Table and Restore
   MF53433      Async Move to SSD
   MF53236      OSP-DB #dbrecyc diagnostics improved and recix max limit inc
   MF53188      OSP-DB Field Procedure (FieldProc) Journal Entry processing
   MF52549      LIC-DB Deleted entry count discovery and correction during R
   MF52514      OSP Damaged Physical File Member - ROWID or Identity Column
   MF52322      OSP VL20006002 encountered
   MF52128      OSP Alter Table Move Index Fix
   MF51569      LIC-DB-OTHER-PERFM QUSRMBRD API CONSUMES EXCESSIVE RESOURCE
   MF50997      LIC-DB Additional materialization data
   MF50734      LIC-DB-UNPRED Alter table on partitioned index
   MF50082      LIC-DB-OTHER-UNPRED TEMP STORAGE INCREASING ON SYSTEM WITH A
   MF49880      LIC-DB-MSGMCH5601 Alter Table/Alter Column to Set Fieldproc
   MF49528      LIC-DB-OTHER MCH1864 on Create Table with field procedures a
   MF49755      LIC-DB-OTHER-F/QQQSVRTN -T/QQQSVRTN-MSGMCH3601 Fieldproc and
   MF49647      LIC-DB-SRCB6001215 #dbcdsrt referencing too far into a DSR s
   MF49469      LIC-DB-OTHER SRCB6000302 on DSPFD with fieldprocs
   MF49423      OSP-CL-RUN Support In Memory option for database objects
   MF47894      OSP-Database synchronously move physical file member to new
   MF52718      OSP-DB long constraint processing time after restore of larg
   MF50278      osp-db-MSGmch3203 f/#dbricdm adding RI constraint
   MF50079      OSP-MSGMCH3203 f #dbricdm on Alter Table/Add PF Cst on Tbl w
   MF49598      LIC-DB-JRN-SRCB6000317-UNPRED SRCB6000317
   MF49575      OSP-MSGMCH3203 f/#dbricdm on create table/file or add cst/al
   MF49516      OSP-DB-JRN TEMP STORAGE LEAK IN 21AB-0000 QJODSPJE
   MF49362      OSP DB partitioned table add referential integrity constrain
   MF49030      LIC-DB-OTHER Internal maintenance option for journal
   MF48756      OSP-DB-MSGMCH3203 F/#dbricdm Referential Integrity Cascade C
   MF48749      OSP-DB Partitioned Tables & RI Constraints Fixes
   MF48537      OSP-Database RI Partitioned Table Fixes
   MF48149      OSP-Database DBDS Fixes
   MF47914      OSP-Database DBDS Fixes
   MF52095      OSP Internal OS component to component change.
   MF47913      OSP-Database DBMN Fixes
   MF59250      OSP-DB looping QClnSysLog job in database I/O (delete operat
   MF59233      OSP-DB-OTHER-INCORROUT A SAVE-WHILE-ACTIVE WHILE A RGZPFM IS
   MF59036      LIC-DB Prevent rebuild of internal recycle index
   MF58549      OSP-DB-OTHER-INCORROUT ROW CHANGE TIMESTAMP NOT SET BY AFTER
   MF58534      LIC-DB LOG 06005D60 vlogs
   MF58526      OSP-DB-OTHER-UNPRED NEED A WAY TO IDENTIFY A ACCESS PATH REB
   MF58259      OSP- CPF5079 Number of locks under commit in job exceeds lim
   MF58201      LIC-DB-UNPRED Index build status file 16 byte alignment
   MF57986      OSP-DB-OTHER-UNPRED SELECT FROM INSERT STATEMENT CAUSES INDE
   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
   MF54246      LIC-DB Query for file SSD info sees stale data location info
   MF53436      Async Move to SSD
   MF58791      LIC-DB-OTHER-WAIT LONG SEIZE HOLD ON CQE QUERY
   MF57009      LIC-DB-OTHER-WAIT LONG SEIZE HOLD ON CQE QUERY
   MF49414      LIC-DB-OTHER-LOOP LOOP IN DBL3* TASKS
   MF49410      OSP-LOOP SEIZE CONFLICT CAUSED BY A LOOP
   MF58257      OSP-DB-OTHER-T/QTNDTCOBX/01E8-MSGMCH6204 RPGSQL PGM FAILS WI
   MF57836      LIC-DB DBL3 tasks causing seize contention
   MF57262      OSP-MSGMCH3601 f/#dbxfmp2 on keyed/logical file processing w
   MF57111      UNPRED-HLIC-94XXMISC CPYF SKIPS THE DENT BYTE VALIDATION.
   MF54843      LIC-DB-PERFM FILE CONTENTION WHEN AN EXTENT TABLE NEEDS TO B
   MF54637      OSP-DB FieldProc Enhancements
   MF51729      OSP-DB-LOOP enable user profile authority for read triggers
   MF54460      OSP-DB-OTHER-INCORROUT INCORRECT OUTPUT RETURNED ON A FETCH
   MF53932      OSP-DB-OTHER ADD ABILITY TO END A JOB READING FROM AN INDEX
   MF48536      LIC-DB record validity check in Retrieve Sequential
   MF53152      OSP-F/#DBENTAD-T/QDBGETM-RC1716-MSGMCH3203 QUERY FAILS WITH
   MF49764      LIC-DB-OTHER-F/QQQSVRTN -T/QQQSVRTN-MSGMCH3601 Fieldproc and
   MF54427      LIC-DB Large IO buffer efficiency
   MF52253      OSP-DB-OTHER-T/QDBGETMX/1720-MSGMCH3203 SELECT STMT FAILS WI
   MF61392      OSP-DB Database IPL/Vary on Database Recovery Statistics
   MF60834      OSP-DB Internal Maintenance for DB IPL/Vary-on
   MF60769      LIC-DB-OTHER-PERFM IASP VARY ON SPENDING MORE TIME THEN EXPE
   MF60511      OSP-DB-OTHER-LOOP AFTER A WARM FLASHCOPY, IASP VARYON GOT ST
   MF59662      LIC-DB Set last used VL storage at IPL.
   MF59037      LIC-DB Preserve Variable length storage after an IPL
   MF55203      F/QDBSVPRE-MSGCPF3285 LIC-DB-OTHER-F/QDBSVPRE-T/QDBSVPRE-MSG
   MF50384      LIC-DB Damaged Partition Table With Identity/RowID after CRA
   MF49789      OSP Damaged file Insert into table fails with message "Syste
   MF48487      OSP-Database file found damaged during save attempt
   MF59548      LIC-DB Set last used VL storage at IPL.

Summary Information

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


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