IBM Support

SI70713 - OSP-DB2MIRROR-MSGSQL0443 While attempting MIRROR_COMPARE_OBJ

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB2MIRROR-MSGSQL0443 While attempting MIRROR_COMPARE_OBJ


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770SS1  V7R4M0    SI70371   00/00    0000
PRE  5770999  V7R4M0    MF66399   00/00    0000
CO   5770SS1  V7R4M0    SI70705   00/00    0000
CO   5770SS1  V7R4M0    SI70693   00/00    0000
CO   5770SS1  V7R4M0    SI70078   00/00    0000
CO   5770SS1  V7R4M0    SI69755   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

-----------------------------------------------
While attempting to perform a compare of a mirrored object that
resides in a currently  SUSPENDED IASP via the
QSYS2.MIRROR_COMPARE_OBJECT SQL Service, an invalid SQL State of
'560DE' is signaled.

CORRECTION FOR APAR SE71869 :
-----------------------------
The QSYS2.MIRROR_COMPARE_OBJECT SQL Service incorrectly
determined that it was unable to perform the compare of the
object that resides in the SUSPENDED IASP. A PTF will be
provided that will correct the problem.

For a complete fix, the PTF should be applied to both nodes of a
Db2 Mirror pair. It is not necessary to apply the PTF to both
nodes of the pair at the same time, but the problem could occur
on a node that does not have the PTF applied.

CIRCUMVENTION FOR APAR SE71869 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI70704      OSP-DB2MIRROR Incorrect parallel degree value allowed
   SI70694      OSP-DB INTERNAL MAINTENANCE
   SI70635      OSP-DB-UNPRED RGZPFM ALWCANCEL(*YES) with Db2 Mirror leaves
   SI70590      OSP-DB-INTERNAL MAINTENANCE
   SI70576      OSP-DB-INTERNAL MAINTENANCE
   SI70373      OSP-DB Add resync category to Db2 Mirror flight recorder
   SI70373      OSP-DB-INCORROUT SQL CATALOGS AND SERVICES INCORRECT COLUMN
   SI70373      SQL-RUN-INCORROUT PARSE_STATEMENT FUNCTION RETURNS WRONG VAL
   SI70373      OSP-DB SQL MESSAGE_FILE_DATA SERVICE ERROR
   SI70350      OSP-DB-UNPRED RGZPFM ALWCANCEL(*YES) with Db2 Mirror leaves
   SI70344      OSP-DB INCORROUT SQL SERVICE UPDATES
   SI70344      OSP-DB INCORROUT OBJECT_PRIVILEGES SERVICE
   SI70281      OSP-DB-OTHER SQL CATALOG OR SERVICE NOT FOUND ON RESTORE
   SI70226      OSP-DB-UNPRED RGZPFM ALWCANCEL(*YES) causes out of sync when
   SI70139      OSP-DB INTERNAL MAINTENANCE
   SI70069      OSP-DB INTERNAL MAINTENANCE
   SI70015      OSP-DB INTERNAL MAINTENANCE SQL SERVICE(IFS)
   SI69897      OSP-DB INCORROUT SQL SERVICE UPDATES
   SI69846      OSP-DB INTERNAL MAINTENANCE
   SI69757      OSP-DB2MIRROR INTERNAL MAINTENANCE
   SI69670      OSP-DB INTERNAL MAINTENANCE
   SI69602      OSP-DB INTERNAL MAINTENANCE
   SI69594      OSP-DB-OTHER SQL OVER QSYS2.MEDIA_LIBRARY_INFO WILL SOMETIME
   SI69526      OSP-DB INTERNAL MAINTENANCE
   SI69408      OSP-DB-INTERNAL MAINTENANCE
   SI69352      OSP-DB INTERNAL MAINTENANCE
   SI69352      OSP-DB-OTHER-UNPRED SQL LOGGER FILE QSQ901S
   SI69341      OSP-DB Internal Maintenance
   SI69216      OSP-DB INTERNAL MAINTENANCE
   SI69717      OSP-OTHER-T/QSYAUTCOL-MSGMCH3411 Running AUTHORITY_COLLECTIO
   SI70148      OSP-DB Incremental Enhancement
   SI70337      OSP-DB2MIRROR INTERNAL MAINTENANCE
   SI70279      OSP-DB2MIRROR INTERNAL MAINTENANCE
   SI70077      OSP-DB2MIRROR INTERNAL MAINTENANCE
   SI69754      OSP-DB2MIRROR INTERNAL MAINTENANCE
   SI69754      OSP-DB2MIRROR INTERNAL MAINTENANCE
   SI69296      OSP-DB2MIRROR INTERNAL MAINTENANCE
   SI69296      OSP-DB2MIRROR INTERNAL MAINTENANCE

Summary Information

System..............................i
Models..............................
Release.............................V7R4M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE71869
Superseded by:......................View fix details for PTF SI75255
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C9304740


IBM 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, 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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4","Product":{"code":"SG15V","label":"PTF Cover Letters - IBM i General"},"Component":"5770SS1","Edition":""},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4","Product":{"code":"SS9QQS","label":"IBM i 7.4"},"Component":"5770SS1","Edition":""}]

Document Information

Modified date:
05 March 2021