IBM Support

SI75370 - OSP-DB Internal Maintenance

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB Internal Maintenance


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770999  V7R4M0    MF66461   00/00    0000
PRE  5770SS1  V7R4M0    SI69753   00/00    0000
CO   5770SS1  V7R4M0    SI75315   00/00    0000
CO   5770SS1  V7R4M0    SI75399   00/00    0000
CO   5770SS1  V7R4M0    SI75400   00/00    0000
CO   5770SS1  V7R4M0    SI74632   00/00    0000
CO   5770SS1  V7R4M0    SI74627   00/00    0000
CO   5770SS1  V7R4M0    SI74493   00/00    0000
CO   5770SS1  V7R4M0    SI74245   00/00    0000
CO   5770SS1  V7R4M0    SI71213   00/00    0000
CO   5770SS1  V7R4M0    SI71215   00/00    0000
DIST 5770SS1  V7R4M0    SI75312   00/00    0000
DIST 5770SS1  V7R4M0    SI74021   00/00    0000
DIST 5770SS1  V7R4M0    SI74022   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

-----------------------------------------------
Internal product maintenance

CORRECTION FOR APAR SE75087 :
-----------------------------
Maintenance completed.

CIRCUMVENTION FOR APAR SE75087 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI74631 :
=================================================

If the DRDA "listener" server job QRWTLSTN is active in the
QSYSWRK subsystem when this PTF to be applied immediately, the server
job should be ended prior to applying the ptf:
ENDTCPSVR SERVER(*DDM)

Then after the ptf is applied, restart the QRWTLSTN server job:
STRTCPSVR SERVER(*DDM)

Restart the QDBMSRVR prestart jobs
ENDPJ SBS(QUSRWRK) PGM(QDBMSRVR) OPTION(*IMMED)
STRPJ SBS(QUSRWRK) PGM(QDBMSRVR)

Restart the QRWTSRVR prestart jobs
ENDPJ SBS(QUSRWRK) PGM(QRWTSRVR) OPTION(*IMMED)
STRPJ SBS(QUSRWRK) PGM(QRWTSRVR)

Restart the QSQSRVR prestart jobs
ENDPJ SBS(QSYSWRK) PGM(QSQSRVR) OPTION(*IMMED)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)

Restart the QZDASOINIT prestart jobs
ENDPJ SBS(QUSRWRK) PGM(QZDASOINIT) OPTION(*IMMED)
STRPJ SBS(QUSRWRK) PGM(QZDASOINIT)


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI75316      OSP-DB-OTHER-INCORROUT USING UNQUALIFIED TABLE NAME AS MERGE
   SI75316      OSP-DB-OTHER-T/QSQDELET-MSGSQL0918 AFTER REPLICATION STATE C
   SI75310      OSP-DB AN SQL QUERY IS USING A FILE IN THE WRONG LIBRARY AND
   SI75229      OSP-DB-OTHER-T/QSQMERGE-RC3-MSGSQL7008 USING REPLICATED TABL
   SI75222      OSP-DB-Add Blocks Written to Database Monitor
   SI74982      OSP-DB-OTHER-UNPRED SERVICEABILTY ENHANCEMENT
   SI64242      OSP-DB-OTHER-F/QSQSBASMOD/QSQVATTRPROC/BUILDVALSENTRY- MSGMC
   SI64242      OSP-DB-OTHER-UNPRED SUPPORT BLOCKED INSERT ON A REPLICATED F
   SI74797      OSP-DB-OTHER-THREADS-T/QSQINS-MSGMCH3601
   SI74684      OSP-DB-OTHER-UNPRED FULLY SUPPORT STMT_COMPRESS_REUSE_MIN
   SI74677      OSP-DB-MSGCPF2471 T/QSQINS on INSERT with RCAC Violation
   SI74631      OSP-DB-MIRROR MULTIPLE DRDA *APPREQ CMT RSC REG AFTER STATE
   SI74564      OSP-DB-OTHER-T/QSQRCHK-MSGMCH5804 DURING OPTION 1 INSTALL
   SI74494      OSP-DB INTERNAL MAINTENANCE
   SI74443      OSP-DB-OTHER-INCORROUT MODE DB2SQL TRIGGER NOT FAILING WHEN
   SI74443      OSP-DB-OTHER-F/QSQSBAS-T/QSQSBAS-MSGMCH3402-F/QSQSBAS-T/QSQS
   SI74399      OSP-DB INFRASTRUCTURE
   SI74272      OSP-RC3007-MSGSQL0901 MSGSQL0901 TYPE 3007
   SI74255      OSP-DB-OTHER Db2 Mirror Resync Internal Maintenance
   SI74216      OSP-DB-OTHER-F/QSQRUN1X/19989-MSGMCH3601 SELECT STMT VIA ODB
   SI74201      OSP-F/QSQRUN3-T/QDBSIGEX-RC20-MSGCPF5035 MSGCPF5035 F/ QDBSI
   SI74174      OSP-DB-MIRROR IASP VARY OFF 2PHASE COMMITMENT CONTROL FIX
   SI74023      OSP-DB-OTHER-PERFM SQLPKG CREATED BY QSQPRCED FILLING UP
   SI73265      OSP-DBRemote query is not returning data due to SQL0462 warn
   SI73253      OSP-DB-MIRROR-MSGCPD9193-F/QSQEVENT SIGNAL CPD9193 ON MIRROR
   SI73211      OSP-DB-MIRROR POSSIBLE HANG FOR MULTI-THREADED JOBS AT SUSPE
   SI73031      OSP-DB-MERGE and UPDATE statements not working with extended
   SI73015      OSP-DB INTERNAL MAINTENANCE
   SI72862      OSP-DB-MIRROR MIRROR RESYNC HANG DUE TO LOCKS ON TARGET
   SI72855      OSP-DB-OTHER-THREADS-UNPRED DRDA 3 PART NAMING TRIGGER EXECU
   SI72837      OSP-DB-INTERNAL MAINTENANCE
   SI72303      OSP-DB-OTHER-MSGSQL0952 QSQCRTI TURNED INTO SQL0901
   SI72106      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
   SI72077      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
   SI71964      OSP-Internal Maintenance
   SI71812      OSP-F/#CFDATEI-T/QQQIOTMP-MSGMCH1224 TRIGGER ATTEMPTS TO UPD
   SI71812      OSP-DB T-AF AUDIT JOURNAL ENTRIES DURING INSERT STATEMENT.
   SI71760      OSP-DB-MSGCPF8362RC1-F/QTNCMTSP-T/QSQEVENT Db2 MIRROR SUSPEN
   SI71748      OSP-DB-OTHER Db2 Mirror Event Handling Internal Maintenance
   SI71723      OSP-DB-OTHER-INCORROUT PARAMETER MARKER METADATA NOT RETURNE
   SI71708      OSP-DB-OTHER-INCORRECT MSGSQL0151 WHEN UPDATING OR INSERTING
   SI71593      OSP-DB-MSGSQL0904 with Insert with Remote Subselect
   SI71583      OSP-DB-INCORROUT Rows do not match if doing updates to table
   SI71476      OSP-DB-OTHER-T/QSQDELET-RC2203-MSGSQL0901 AFTER CPF4328
   SI71290      OSP-DB-QSQPREP-MSGMCH3402 on prepare of query
   SI71256      OSP-DB DB2 MIRROR DATABASE SERVICEABILITY
   SI71236      OSP-DB Db2 Mirror Commit
   SI71212      OSP-DB-OTHER-F/QSQPREP-RC3007-MSGSQL0901
   SI71183      OSP-DB-OTHER-T/QSQOPEN-MSGMCH3601 PROCEDURE DUMPQDT
   SI71054      OSP-DB-QSQOPEN-PERFM-Space left orphaned
   SI71008      OSP-DB-OTHER-T/QSQFETCH-MSGMCH3601 FETCHING FROM SELECT FROM
   SI70975      OSP-DB-OTHER-F/QDBDLTFI-MSGCPF3202 FOR QASQVRSS
   SI70897      OSP-DB ERROR IN COMMON TABLE EXPRESSION USED WITH UNION NOT
   SI70896      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
   SI70825      OSP-DB-OTHER SQL PROCEDURE GROWS RAPIDLY WITH FETCH FIRST N
   SI70754      OSP-DB-OTHER-F/QSQINS-RC2014-MSGSQL0901 COLLECT ADDITIONAL I
   SI70690      OSP-DB-OTHER-T/QSQINS-MSGCPF4270 ON MIRRORED FILE
   SI70662      A file, that is open for update, while its replication state
   SI70648      OSP-DB-QSQOPEN-Internal Maintenance
   SI70622      OSP-DB MISC SQ SERVICEABILITY FOR DB2 MIRROR
   SI70575      OSP-DB-OTHER-INCORROUT ROWS MISSING AFTER CREATE TABLE AS WI
   SI70527      OSP-DB QSQINS/QSQUPDAT MEMORY LEAK FIX FOR LOBS
   SI70465      OSP-DB-QSQOPEN-INTERNAL MAINTENANCE
   SI70414      OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGSQL5079 MSGSQL5079 F/QSQ
   SI70414      OSP-DB-INTERNAL MAINTENANCE
   SI70286      OSP-DB-INTERNAL MAINTENANCE
   SI70224      OSP-DB-INTERNAL MAINTENANCE
   SI70168      OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGMCH3601 A SELECT STATEME
   SI70142      OSP-DB-INTERNAL MAINTENANCE
   SI70067      OSP-DB INTERNAL MAINTENANCE
   SI70027      OSP-DB INTERNAL MAINTENANCE
   SI70013      OSP-DB-INTERNAL MAINTENANCE
   SI69905      OSP-DB-INTERNAL MAINTENANCE
   SI69847      OSP-DB-INTERNAL MAINTENANCE
   SI69739      OSP-DB-OTHER-UNPRED TEMPSTG ISSUE WHERE JOBS ARE ALLOCATING
   SI69672      OSP NO NATIVELY GENERATED IDENTITY VALUE
   SI69672      OSP-DB-INTERNAL MAINTENANCE
   SI69628      OSP-DB INTERNAL MAINTENANCE
   SI69534      OSP-DB INTERNAL MAINTENANCE
   SI69350      OSP-DB INCORRECT RESULTS AFTER FETCH FIRST N ROWS RUN IN PRO
   SI69350      OSP-DB-OTHER-UNPRED INTERNAL MAINTENANCE
   SI69350      OSP-DB-QQQOOOINV-MSGMCH3601 when using arrays
   SI69209      OSP-DB INTERNAL MAINTENANCE
   SI69600      OSP-DB INTERNAL MAINTENANCE

Summary Information

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


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, 2022 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":"BU058","label":"IBM Infrastructure w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0","Product":{"code":"SWG60","label":"IBM i"},"Component":"5770SS1","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
10 August 2022