IBM Support

SI61007 - OSP-DB-OTHER-RCTYPE3-MSGCPF32A6 QDBSRVXR JOB WITH MSGCPF32A6

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-RCTYPE3-MSGCPF32A6 QDBSRVXR JOB WITH MSGCPF32A6


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770SS1  710  SI49551   00/00    0000
CO   5770SS1  710  SI48644   00/00    0000
DIST 5770SS1  710  SI40705   00/00    0000
DIST 5770SS1  710  SI40706   00/00    0000
DIST 5770SS1  710  SI40707   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

-------------------------------------------------
When upgrading from R540 to R710, customer experienced several
cross reference errors in the QDBSRVXR job, most commonly
msgCPF32A6, type 3. RCLDBXREF *CHECK *FIX was generating
msgMCH5801. Development found the issue to be because the cross
files failed to restore during the upgrade due to the existing
cross reference files having an incorrect owner of QDFTOWN
instead of QSYS.

CORRECTION FOR APAR 'SE64998' :
-------------------------------
The operating system will detect the incorrect ownership and
assign ownership to QSYS user profile to avoid this problem from
occurring in the future.  Once this fix has been applied and the
cross reference files have been changed to be owned by QSYS, a
re-install of the base operating system language objects will be
required to ensure the 710 version of the files get restored.

CIRCUMVENTION FOR APAR 'SE64998' :
----------------------------------
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
--------------  ------------------------------------------------------------
   SI60513      OSP-DB MCH0601 F/T stringHighUse/QQQVWDEP in QDBSRVXR job
   SI55561      OSP-DB-OTHER-INCORROUT INDEX NAMES APPEAR MULTIPLE TIMES
   SI54510      OSP - Do not set cross reference authorities if already corr
   SI53948      OSP-DB-OTHER-PERFM RUNNING MANY RESTORE LIBRARIES AT THE SAM
   SI53948      OSP-DB-OTHER-PERFM QDBXRVXR CAUSING HIGH ASYNC WRITES WHICH
   SI53711      OSP-DB-OTHER RCLSTG *DBXREF FAILS TO OPEN ALL FILES AND CAUS
   SI52909      OSP-DB-Other Internal Maintenance
   SI50897      OSP VIEW TEXT MISSING AFTER RESTORING LOGICAL FILES.
   SI50328      OSP-DB-OTHER-F/QDBXREF-T/QDBXREF-MSGMCH3601 unmonitored when
   SI49983      OSP-DB-OTHER Delimiters not removed from trigger schema name
   SI49553      OSP-DB-OTHER-T/QDBXXREFSPX/2121-MSGMCH5801 RCLDBXREF *CHECK
   SI49460      OSP-DB-OTHER-MSGCPF4131 LEVELCHECK ACCESSING QADBIATR THOUGH
   SI48642      OSP-DB-OTHER Cross Reference - Incremental Enhancement
   SI48642      OSP-DB-OTHER DELIMITERS NOT REMOVED FROM QADBXTRIGD FIELDS W
   SI47827      OSP-DB-OTHER-F/QDBCRTFI-T/QDBCRTFI-MSGMCH1210 R540 UPGRADE T
   SI47634      OSP-F/CKMIOBJECT-T/QDBMAINT-MSGMCH3402 ADD PARTITION MSGSQL4
   SI46263      OSP-UNPRED RMVRDBDIRE DOESN'T WORK WITH GENERIC NAMES
   SI41913      OSP-DB PERF WITH XREF PROCESSING SQL LONG NAMES OBJECTS AFTE
   SI41037      OSP-DB QADBFDEP not updated for global variable view depende
   SI40887      OSP-DB MCH5801 Dequeue operation not satifisfied waiting on
   SI40754      OSP-DB-INCORROUT Query text generated for a CREATE VIEW SQL
   SI37060      OSP-DB Internal Maintenance
   SI37032      OSP-DB Internal Maintenance
   SI48643      OSP-DB-OTHER Cross Reference - Incremental Enhancement
   SI47826      OSP-DB-OTHER-F/QDBCRTFI-T/QDBCRTFI-MSGMCH1210 R540 UPGRADE T
   SI41622      IPL-SRCC9002C25 LONG SRCC9002C25 DURING IPL R710

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE64998
Superseded by:......................View fix details for PTF SI67326
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C6320710


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

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
29 June 2016