MF60885 - LIC-DB Force recycled Aux pieces at close

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
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
CO   5770999  710  MF58260   00/00    0000
CO   5770999  710  MF58261   00/00    0000
CO   5770999  710  MF54840   00/00    0000
CO   5770999  710  MF59548   00/00    0000
CO   5770999  710  MF59278   00/00    0000
CO   5770999  710  MF59290   00/00    0000
CO   5770999  710  MF59037   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  MF48484   00/00    0000
CO   5770999  710  MF49948   00/00    0000
CO   5770999  710  MF54635   00/00    0000
CO   5770999  710  MF54638   00/00    0000
CO   5770999  710  MF53200   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

-----------------------------------------------
Customers see 0600 5D69 vlogs after a restore of a file
containing VL field data.  Aux pieces that are not forced do not
get saved and may not survive an IPL or vary-on, thus failing
sanity checks resulting in the vlog.  these are sanity checks
against unused Aux pieces to ensure we do not corrupt actual
user data.

CORRECTION FOR APAR MA45065 :
-----------------------------
This PTFs add code to ensure that recycled aux pieces get forced
at full close and during other force operations.  This will
reduce, but not eliminate the frequency of 0600 5D69 vlogs.

CIRCUMVENTION FOR APAR MA45065 :
--------------------------------
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 MF52128 :
=================================================

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
--------------  ------------------------------------------------------------
   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

Summary Information

IBM i Support