PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER-F/RMSLRELEASESEIZENOTOKEN-T/QDBPUTM-MSGMCH3203
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
-----------------------------------------------
An ALTER TABLE ADD COULMN fails with
MSGMCH3203 F/RmslReleaseSeizeNoToken X/00036C
T/QDBPUTM MOD/QDBPUTM PROC/INSERTM2 X/5102
MSGCPF5257 F/QDBSIGEX T/QSQALTER
MSGCPF2972
MSGCPF2950 51742 records copied to EINBAUTEIL in LibREKERS_DB
MSGCPI32B6 Ref Constraint Q_REKERS_DB_EINBAUTEIL_FIRMA_00001
changed
to defined.
MSGCPI32B1 *PRIKEY removed
MSGCPI32B0 Refcst added
MSGCPC32B0 Refcst added to Q_AT000000
MSGCPF7304 Table not changed
MSGSQL0901 QSQALTER RC4411
VL02001720 shows it fails in
MODULE RMSLRELEASESEIZENOTOKEN + 00000370
ENTRY THROWENDOFCHAIN__18RMSLSEIZEHASHTABLEFP12RMSLSRPENTRY
+000001A0
CORRECTION FOR APAR MA46614 :
-----------------------------
Applying this PTF will check for exclusive serialization before
attempting to transition to exclusive serialization , and thus
prevent the exception.
CIRCUMVENTION FOR APAR MA46614 :
--------------------------------
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
-------------- ------------------------------------------------------------
MF63820 OSP-DB-OTHER FILE WITH AUX SPACE BECOMES DAMAGED.
MF63768 OSP-DB-OTHER-PERFM FUNCTIONAL/PERFORMANCE IMPROVEMENTS AND A
MF63655 OSP DATABASE next IDENTITY COLUMN VALUES NOT CORRECT AFTER F
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 MA46614 |
Superseded by:...................... | View fix details for PTF MF68659 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | NONE |
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.
Was this topic helpful?
Document Information
Modified date:
07 June 2021