IBM Support

SI74304 - OSP-DB2MIRROR-OTHER Enhancement for Db2 Mirror internal cont

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB2MIRROR-OTHER Enhancement for Db2 Mirror internal cont


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770SS1  V7R4M0    SI73590   00/00    0000
PRE  5770SS1  V7R4M0    SI73251   00/00    0000
PRE  5770SS1  V7R4M0    SI73310   00/00    0000
PRE  5770999  V7R4M0    MF67207   00/00    0000
PRE  5770999  V7R4M0    MF67208   00/00    0000
PRE  5770999  V7R4M0    MF67133   00/00    0000
PRE  5770SS1  V7R4M0    SI72190   00/00    0000
PRE  5770SS1  V7R4M0    SI72196   00/00    0000
PRE  5770SS1  V7R4M0    SI71191   00/00    0000
PRE  5770SS1  V7R4M0    SI71065   00/00    0000
PRE  5770SS1  V7R4M0    SI70371   00/00    0000
CO   5770SS1  V7R4M0    SI74302   00/00    0000
CO   5770SS1  V7R4M0    SI74258   00/00    0000
CO   5770SS1  V7R4M0    SI74169   00/00    0000
CO   5770SS1  V7R4M0    SI74171   00/00    0000
CO   5770SS1  V7R4M0    SI74172   00/00    0000
CO   5770SS1  V7R4M0    SI74173   00/00    0000
CO   5770SS1  V7R4M0    SI74128   00/00    0000
CO   5770SS1  V7R4M0    SI74130   00/00    0000
CO   5770SS1  V7R4M0    SI74005   00/00    0000
CO   5770SS1  V7R4M0    SI74008   00/00    0000
CO   5770SS1  V7R4M0    SI74009   00/00    0000
CO   5770SS1  V7R4M0    SI73799   00/00    0000
CO   5770SS1  V7R4M0    SI73801   00/00    0000
CO   5770SS1  V7R4M0    SI73714   00/00    0000
CO   5770SS1  V7R4M0    SI73802   00/00    0000
CO   5770SS1  V7R4M0    SI73272   00/00    0000
CO   5770SS1  V7R4M0    SI73133   00/00    0000
CO   5770SS1  V7R4M0    SI72673   00/00    0000
CO   5770SS1  V7R4M0    SI72674   00/00    0000
CO   5770SS1  V7R4M0    SI72617   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

-----------------------------------------------
OSP-DB INFRASTRUCTURE

CORRECTION FOR APAR SE74388 :
-----------------------------
OSP-DB INFRASTRUCTURE

CIRCUMVENTION FOR APAR SE74388 :
--------------------------------
None.


DESCRIPTION OF PROBLEM FIXED FOR APAR SE74362 :
-----------------------------------------------
Enhancement for Db2 Mirror internal controls.

CORRECTION FOR APAR SE74362 :
-----------------------------
PTF will be created to provide an enhancement for Db2 Mirror
Data Queue objects support.

CIRCUMVENTION FOR APAR SE74362 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI74256      OSP-DB2MIRROR-OTHER Enhancement for Db2 Mirror configuration
   SI74256      OSP-DB INFRASTRUCTURE
   SI74229      OSP-DB INFRASTRUCTURE
   SI74229      SYSTEM_STATUS_INFO is enhanced to avoid unnecessary AF entri
   SI74229      OSP-DB OBJECT_STATISTICS TABLE FUNCTION DATA MAPPING ERROR
   SI74170      OSP-DB2MIRROR INCREMENTAL ENHANCEMENT
   SI74132      OSP-DB2MIRROR-OTHER Enhancement for Db2 Mirror internal cont
   SI74094      OSP-DB2MIRROR-OTHER Enhancement for Db2 Mirror configuration
   SI74076      OSP-DB INFRASTRUCTURE
   SI74076      OSP-DB OBJECT_STATISTICS TABLE FUNCTION INSUFFICIENT MESSAGE
   SI74010      OSP-DB2MIRROR-OTHER Enhancement for Db2 Mirror internal cont
   SI74010      OSP-DB2MIRROR-OTHER Enhancement for Db2 Mirror configuration
   SI74010      OSP-DB INFRASTRUCTURE
   SI73908      Message with bad offset causes MESSAGE_FILE_DATA to report M
   SI73841      OSP-DB INFRASTRUCTURE
   SI73800      OSP-DB INFRASTRUCTURE
   SI73800      OSP-DB2MIRROR-OTHER Enhancement for Db2 Mirror configuration
   SI73754      OSP-DB-INCORROUT OBJECT_STATISTICS TABLE FUNCTION OBJLONGSCH
   SI73754      OSP-DB-INCORROUT QSYS2.MESSAGE_QUEUE_INFO DOES NOT RETURN AL
   SI73697      OSP-DB GENERATE_SQL_OBJECTS missing from SERVICES_INFO table
   SI73666      OSP-DB INFRASTRUCTURE
   SI73666      OSP-DB OBJECT_STATISTICS TABLE FUNCTION DATA MAPPING ERROR
   SI73573      OSP-DB INFRASTRUCTURE
   SI73573      OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGSQL0010 FUNCTION SYSTO
   SI73534      OSP-DB INFRASTRUCTURE
   SI73534      OSP-DB AUTHORITY FAILURE ENTRIES IN QAUDJRN WHEN USING QSYS2
   SI73389      OSP-DB INTERNAL MAINTENANCE
   SI73271      OSP-DB INTERNAL MAINTENANCE
   SI73271      OSP-DB-OTHER-INCORROUT DISPLAY_JOURNAL
   SI73271      OSP-DB INTERNAL MAINTENANCE
   SI73132      OSP-DB2MIRROR-OTHER Enhancement for Db2 Mirror configuration
   SI73072      OSP-DB INTERNAL MAINTENANCE
   SI73036      OSP-DB INTERNAL MAINTENANCE
   SI72877      OSP-DB GUARDIUM ENHANCEMENT
   SI72877      OSP-DB INTERNAL MAINTENANCE
   SI72844      OSP-DB INTERNAL MAINTENANCE
   SI72676      OSP-DB2MIRROR-OTHER Enhancement for Db2 Mirror configuration
   SI72655      OSP-DB INTERNAL MAINTENANCE
   SI72629      OSP-DB Incremental Enhancement
   SI72555      OSP-DB2MIRROR INCREMENTAL ENHANCEMENT
   SI72515      OSP-DB INTERNAL MAINTENANCE
   SI72515      OSP-DB INTERNAL MAINTENANCE
   SI72515      OSP-DB-OTHER-INCORROUT HISTORY_LOG_INFO SQLSTATE 58004
   SI72314      OSP-DB INTERNAL MAINTENANCE
   SI72314      OSP-DB INTERNAL MAINTENANCE
   SI72137      OSP-DB-MSGCPF2990 Unexpected authority failure from RGZPFM f
   SI72113      OSP-DB2MIRROR-OTHER Enhancements for Db2 Mirror TRACKING sta
   SI72062      OSP-DB QSYS2.USER_INFO GENERATES AF AUDIT RECORDS
   SI72062      OSP-DB-OTHER-INCORROUT HISTORY_LOG_INFO SYSLOG_EVENT
   SI72062      OSP-DB INTERNAL MAINTENANCE
   SI72062      OSP-DB INTERNAL MAINTENANCE
   SI72062      OSP-DB INTERNAL MAINTENANCE
   SI72029      OSP-DB2MIRROR INCREMENTAL ENHANCEMENT
   SI71828      Internal Maintenance
   SI71707      OSP-DB-OTHER-INCORROUT NO RESULT RETURNED FROM SYSTOOLS.FIRM
   SI71245      OSP-DB SQL OBJECT_STATISTICS PARAMETER VERIFICATION
   SI71245      OSP-DB-OTHER-INCORROUT QSYS2.PTF_INFO VIEW INCORRECT OUTPUT
   SI71556      OSP-DB-MSGSQL0404 when running DB2M_CAPTURE_JOBLOGS
   SI71478      OSP-DB INTERNAL MAINTENANCE
   SI71469      OSP-DB-UNPRED Data out of sync after suspending Db2 Mirror w
   SI71306      OSP-DB-UNPRED Records out of sync for Db2 Mirror after cance
   SI71285      OSP-DB INTERNAL MAINTENANCE
   SI71285      OSP-DB-INCORROUT QSYS2.JOB_INFO JOB_SUBSYSTEM COLUMN INCORRE
   SI71224      OSP-DB-UNPRED Records out of sync after using RGZPFM ALWCANC
   SI71224      OSP-DB Incremental Enhancement
   SI71216      OSP-DB INTERNAL MAINTENANCE
   SI71165      OSP-DB INTERNAL MAINTENANCE
   SI71098      OSP-DB INTERNAL MAINTENANCE
   SI71061      OSP-DB INTERNAL MAINTENANCE
   SI71061      OSP-DB QSYS2.GROUP_PROFILE_ENTRIES generates many AF audit r
   SI71021      OSP-DB-INCORROUT IASP SQL CATALOG AUTHORIZATION INFORMATION
   SI71021      OSP-DB INTERNAL MAINTENANCE
   SI70889      OSP-DB SQL JOBLOG_INFO SERVICE ENHANCEMENT
   SI70889      OSP-DB SQL JOBLOG_INFO SERVICE ENHANCEMENT
   SI70756      OSP-DB-F/QQQSVRTN-T/QQQSVRTN-MSGMCH3601 SELECT FROM VIEW FAI
   SI70752      OSP-DB RGZPFM during mirror resync fails with CPF2995
   SI70713      OSP-DB2MIRROR-MSGSQL0443 While attempting MIRROR_COMPARE_OBJ
   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 SE74388
View details for APAR SE74362
Superseded by:......................View fix details for PTF SI76134
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C1091740


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:
13 May 2021