SI42581 - OSP-DB-MSGMCH3601-T/QDBPIDISK QSYS2/SYSPARTITIONDISK

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770999  710  MF51569   00/00    0000
PRE  5770999  710  MF51001   00/00    0000
PRE  5770SS1  710  SI37775   00/00    0000
CO   5770SS1  710  SI42586   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 license agreement which
accompanied, or was contained in, the Program for which you are obtaining
the PTF.  You are not authorized to install or use the PTF except as part
of a Program for which you have a valid Proof of Entitlement.

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.

The applicable license agreement may have been provided to you in printed
form and/or may be viewed using the Work with Software Agreements (WRKSFWAGR)
CL command.





APAR Error Description / Circumvention

-----------------------------------------------
A query of qsys2/syspartitionindexdisk leaves MSGMCH3601
failures in the joblog.

For example:
select table_schema, table_name,index_name, disk_model,
disk_type,UNIT_SPACE_USED, UNIT_MEDIA_CAPACITY,
UNIT_SPACE_AVAILABLE  from qsys2/syspartitionindexdisk
where unit_number=4 order by UNIT_SPACE_USED desc  fetch first
20 rows only

CORRECTION FOR APAR SE46734 :
-----------------------------
The MSGMCH3601 exceptions in the joblog did not cause the query
to fail.  The support has been changed to avoid leaving these
messages in the joblog.

CIRCUMVENTION FOR APAR SE46734 :
--------------------------------
None.


DESCRIPTION OF PROBLEM FIXED FOR APAR SE46736 :
-----------------------------------------------
This change provides base function to enable future extensions.

CORRECTION FOR APAR SE46736 :
-----------------------------
Function provided.

CIRCUMVENTION FOR APAR SE46736 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI41994      OSP-DB INTERNAL MAINTENANCE
   SI41860      OSP-DB-OTHER-QDBEXDME and EXTDBMI changes
   SI41902      OSP-DB Internal Maintenance
   SI41574      OSP-DB-OTHER-PERFM QUSRMBRD API CONSUMES EXCESSIVE RESOURCE
   SI40841      OSP-DB Internal maintenance
   SI40606      OSP-DB QSYS2/SYSPACKAGESTAT and SYSPROGRAMSTAT fail to compl
   SI40419      OSP-DB Internal Maintenance
   SI40102      OSP-DB Internal Maintenance
   SI39830      OSP-DB Internal Maintenance
   SI39821      OSP-DB Object statistics improvement
   SI39821      OSP-DB Internal Maintenance
   SI39821      OSP-DB Internal Maintenance
   SI38576      OSP-DB Internal Maintenance
   SI38512      OSP-DB Internal Maintenance
   SI37903      OSP-DB-OTHER-LOOP WHEN TRYING TO ACCESS A TABLE THAT THE USE
   SI37828      OSP-DB Internal Maintenance
   SI37776      OSP-DB Internal Maintenance
   SI37226      OSP-DB Internal Maintenance
   SI36952      OSP-DB Fix message text for GET FILE UDFs
   SI36636      OSP-DB MSGSQL0901 from GET FILE UDFs
   SI36589      OSP-DB-OTHER-T/QSQHEALTH-MSGSQL0443 Health Activity
   SI40849      OSP-DB Directory locking improvements
   SI40160      OSP-DB Internal Maintenance
   SI40032      OSP-DB Internal Maintenance
   SI39410      OSP-DB-OTHER-F/CBLABRANCH-T/QDBEXDME-MSGMCH1210 DSPFD GETS M
   SI38996      OSP-DB-OTHER-F/QQQSVRTNFMOD-T/QQQSVRTNFMOD-MSGCPF504D MSGCPF
   SI38494      OSP-DB Internal Maintenance
   SI38069      OSP-INCORROUT QUSRMBRD API IS RETURNING INCORRECT DATA FOR T
   SI37849      OSP-DB Internal Maintenance
   SI36491      OSP-DB-OTHER-QDBEXDME
   SI36452      OSP-DB-OTHER-QDBEXDME
   SI40287      OSP-DB Incremental Enhancement
   SI39852      OSP-DB-OTHER-T/QDBEXDFIX/0CE0-MSGMCH6801 RUNNING CPFY COMMAN
   SI39617      OSP-DB-OTHER-QDBEXDFI Internal Changes
   SI39485      OSP-DB DSPFD improvements to report constraint logical damag
   SI39174      OSP-DB Internal Maintenance
   SI39030      OSP-DB-OTHER-QDBEXDFI Changes
   SI38537      OSP-DB-OTHER Check Pending Status Incorrect on Partitioned T
   SI38482      OSP-DB Internal Maintenance

Summary Information

IBM i Support