MF69317 - OSP-DB-OTHER CONCURRENT RGZPFM AND DB STAT COLLECTION MARKIN

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
CO   5770999  V7R3M0    MF69316   00/00    0000
CO   5770999  V7R3M0    MF69318   00/00    0000
CO   5770999  V7R3M0    MF68122   00/00    0000
CO   5770999  V7R3M0    MF67939   00/00    0000
CO   5770999  V7R3M0    MF67554   00/00    0000
CO   5770999  V7R3M0    MF67227   00/00    0000
CO   5770999  V7R3M0    MF67230   00/00    0000
CO   5770999  V7R3M0    MF67231   00/00    0000
CO   5770999  V7R3M0    MF61344   00/00    0000
CO   5770999  V7R3M0    MF63517   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

-----------------------------------------------
While executing a RGZPFM, the DB Statistics Collection Job
attempts to work on the file being reorged and marks the file as
partially damaged. Resulting in VL 0600 5EED.

CORRECTION FOR APAR MA49391 :
-----------------------------
Changes were made to ensure that file records being accessed by
DB statistics without serialization do not result in damage, if
the access itself is not valid, ex., record beyond file end,
etc.

CIRCUMVENTION FOR APAR MA49391 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF69238      OSP-DB-OTHER-WAIT EVI APYJRNCHG HUNG
   MF68736      OSP-DB-OTHER-F/DBPMTRAP-T/QDBGETMQSO-MSGMCH3203 MSGMCH3203 F
   MF68690      LIC-DB-OTHER-F/RMSLRELEASESEIZENOTOKEN-T/QQQOOOUPCL-MSGMCH32
   MF68201      OSP-DBSMP-PERFM SQL QUERY USING DB2 SMP *OPTIMIZE OR *MAX NE
   MF68123      LIC-DB-OTHER-MSGCPF5027 WITH CS USE CURRENTLY COMMITTED not
   MF67938      OSP-OTHER-PERFM IMPROVEMENTS IN CACHE LINE USAGE
   MF67553      LIC-DB-OTHER-UNPRED Base support for query monitoring
   MF67226      LIC-DB-OTHER-UNPRED Base support for query monitoring
   MF67168      OSP-WAIT JOBS NOT ENDING WHILE IN A FLUSH SEIZE CONTENTION/L
   MF66608      OSP-MSGCPI0999 TMPSTGLK-STATIC DIRECTORY FRAGMENTATION WITH
   MF66130      OSP-UNPRED NAVIGATOR FOR I MTIS DELETED COUNT IS INCORRECT
   MF66095      OSP-DB-OTHER-UNPRED NEED ADDITIONAL INFORMATION ON SOFT DAMA
   MF65213      OSP MCH3203 F/SMSEGMENTADDRESSRANGESTATUS T/QDBGETMQO
   MF65161      LIC-DB-OTHER-INCORROUT FLOAT or DOUBLE -0.0 may be grouped i
   MF64962      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF64776      LIC-DB-OTHER-PERFM Reduce CPU utilization for Numeric and De
   MF64423      LIC-DB-OTHER-F/DBPMRESOURCE-T/QDBGETMQO-RC1202-MSGMCH3203 VL
   MF63964      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF63724      OSP-PERFM QDBFSTCCOL GENERATING HIGH I/O TO DBPMSERVER TASKS
   MF63516      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF63461      LIC-DB-OTHER-PERFM Hash join query performance impacted by e
   MF63436      LIC-DB-OTHER-WAIT Job hung in TIMW with DbpmMutex in stack a
   MF63359      LIC-DB Internal Maintenance
   MF63287      LIC-DB-OTHER-WAIT Job hung in TIMW with DbpmMutex in stack a
   MF62686      LIC-OTHER-WAIT PROCESS CAN BE BLOCKED FROM DISPATCHING UNDER
   MF63248      LIC-DB Internal Maintenance
   MF63023      LIC-DB-OTHER-PERFM Internal Database Maintenance
   MF62361      OSP-DB-OTHER-F/DBPMDSPACCESS-T/QDBGETMQO-MSGMCH3402 MCH3402
   MF62341      LIC-DB-OTHER Support for PERCENTILE_CONT with RCAC
   MF62230      LIC-DB-OTHER-PERFM Internal Database Maintenance
   MF62124      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF62115      LIC-DB-OTHER Database runtime support for PERCENTILE_CONT an
   MF62010      OSP-DB-OTHER-UNPRED TEMPORARY STORAGE MAY OCCASIONALLY BE OR
   MF61765      LIC-OTHER-LOOP JOB RUNNING DB QUERY WON'T END EVEN AFTER END
   MF61229      LIC-DB-OTHER-LOOP a query accessing a table that is being re
   MF61851      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF61104      LIC-DB-OTHER-F/DBPMTRAP-T/QQQOOOUPCL-RCX'1720'-MSGMCH3203 CR
   MF61708      LIC-DB-OTHER-PERFM DBPMSERVER TASK CAUSING CONTENTION DUE TO
   MF61652      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF66609      OSP-MSGCPI0999 TMPSTGLK-STATIC DIRECTORY FRAGMENTATION WITH
   MF65544      LIC-DB-OTHER-INCORROUT TIMING CONDITION DURING QUERY CANCELL
   MF65475      LIC-DB-OTHER-F/DBPMTRAP-T/QQQSRVE1-RC1720-MSGMCH3203 SQL que
   MF64422      LIC-DB-OTHER-F/DBPMRESOURCE-T/QDBGETMQO-RC1202-MSGMCH3203 VL
   MF64221      OSP-DB-OTHER-WAIT QUERY WAIT ON SMP THREAD MUTEX DBOP-PLANCA
   MF64053      OSP-DB A CURSOR WILL REMAIN IN A FAILED STATE IF TEMPORARY R
   MF63955      F/QDBIOERRQO-MSGCPF5257 QUERY FAILS INTERMITTENTLY USING SMP
   MF62232      LIC-DB-OTHER-PERFM Internal Database Maintenance
   MF61764      LIC-OTHER-LOOP JOB RUNNING DB QUERY WON'T END EVEN AFTER END
   MF61338      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF61230      LIC-DB-OTHER-LOOP a query accessing a table that is being re
   MF63506      SQL-RUN-WAIT SQL SELECT QUERIES HANG. THE JOBS REMAINED IN E

Summary Information
System..............................  i
Models..............................  
Release.............................  V7R3M0
Licensed Program....................  5770999
APAR Fixed..........................  View details for APAR MA49391
Superseded by:......................  
Recompile...........................  N
Library.............................  QSYS
MRI Feature ........................  NONE
Cum Level...........................  C2132730

IBM i Support