PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-OTHER-T/QSQTRUNC-MSGSQL0913 TRUNCATING A REPLICATED F
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
PRE 5770SS1 V7R4M0 SI75401 00/00 0000
PRE 5770SS1 V7R4M0 SI69753 00/00 0000
CO 5770SS1 V7R4M0 SI78405 00/00 0000
CO 5770SS1 V7R4M0 SI78406 00/00 0000
CO 5770SS1 V7R4M0 SI78080 00/00 0000
CO 5770SS1 V7R4M0 SI77343 00/00 0000
CO 5770SS1 V7R4M0 SI75316 00/00 0000
CO 5770SS1 V7R4M0 SI75227 00/00 0000
CO 5770SS1 V7R4M0 SI74709 00/00 0000
CO 5770SS1 V7R4M0 SI74337 00/00 0000
CO 5770SS1 V7R4M0 SI73582 00/00 0000
CO 5770SS1 V7R4M0 SI73258 00/00 0000
CO 5770SS1 V7R4M0 SI73259 00/00 0000
CO 5770SS1 V7R4M0 SI71085 00/00 0000
CO 5770SS1 V7R4M0 SI69914 00/00 0000
DIST 5770SS1 V7R4M0 SI76904 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
-----------------------------------------------
Truncating a replicated file when there are pseudo closed
cursors holding a lock on the file can result in a SQL0913
error.
CORRECTION FOR APAR SE77057 :
-----------------------------
Code has been added to close the pseudo cursors on the Target
mirror system to prevent the SQL0913.
CIRCUMVENTION FOR APAR SE77057 :
--------------------------------
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
-------------- ------------------------------------------------------------
SI78407 OSP-DB-OTHER-MSGCPFC922 DLTOBJ ON REPLICATED TRIGGER PROGRAM
SI78362 OSP-DB-MSGMCH3601-T/MRDBRCLIXK DROP FUNCTION FAILURE FOR NO
SI78209 OSP-DB INTERNAL MAINTENANCE
SI77910 OSP-DB-Internal Maintenance
SI77747 OSP DB2 - FOR MERGE SQL STATEMENT DIAGNOSTICS NOT RETURNED O
SI77666 OSP-DB-Internal Maintenance
SI77421 OSP-DB-OTHER-T/QSQMERGE-MSGMCH1001
SI77361 OSP-DB INFRASTRUCTURE
SI77342 OSP-DB-OTHER-F/QSQRUN4MOD/QSQMERGEPROC/RUN_DEL_SUBSTMTX/1616
SI77322 OSP-DB SQL MERGE RUNS LONGER IN IBM I 7.4 DB GROUP (FIXPACK)
SI77236 OSP-DB-OTHER-RC1022-MSGSQL0901 RUNNING A MERGE IN A QSQSRVR
SI77205 OSP-DB CLOB OUTPUT PARM BAD DATA
SI77109 OSP-DB-OTHER-UNPRED-UNPRED Lock left on *SQLUDT object after
SI76953 OSP-DB-MSGSQL9015-F/QSQPROCR RSTLIB FAILS W/LONG NAME GIVES
SI76906 OSP-DB-OTHER-UNPRED Support DB2Mirror with nodes at differen
SI76873 OSP-DB-Internal Maintenance
SI76828 OSP-DB-MSGSQL0502-F/QSQROUTX MULTIPLE SQL DIAG MSGS CAUSE IN
SI76697 OSP-DB-OTHER-F/QSQRUN3-T/QSQRUN3-MSGSQL0507 MSGSQL0507 F/QSQ
SI76373 OSP-DB-OTHER-T/QSQCALLSP-MSGMCH5603
SI76186 OSP-DB-OTHER-INCORROUT USING WLM_SET_CILENT_INFO TO SET SQL
SI75949 OSP-DB INFRASTRUCTURE
SI75890 OSP-DB-HANG QUERY SUPERVISOR EXIT PROGRAM FIRING FOR SYSTEM
SI75848 OSP-DB WHEN RESTORED, AN EXTERNAL ROUTINEE THAT IS CREATED I
SI75824 OSP-DB INFRASTRUCTURE
SI75747 OSP-DB INFRASTRUCTURE
SI75584 OSP-DB-Return CLIENT_IPADDR for all interfaces.
SI75526 OSP-DB SQL OPTION MONITOR=*SYSTEM NOT HONORED
SI75434 OSP-DB INFRASTRUCTURE
SI75399 OSP-DB-OTHER-T/QSQOPEN-MSGCPF4326 ON MERGE STATEMENT
SI75314 OSP-F/QQQSRVE1-T/QSQRUN3-RC7-MSGCPD4374 TRIGGER PROGRAM FAIL
SI75278 OSP-DB-Return CLIENT_IPADDR for all interfaces.
SI75276 OSP-MSGSQL0579 CALLING IFS_WRITE SERVICE (PROCEDURE) W/COMMI
SI75228 OSP-DB-OTHER-T/QSQMERGE-RC3-MSGSQL7008 USING REPLICATED TABL
SI75143 OSP-F/QQQSRVE1-T/QSQRUN3-RC7-MSGCPD4374 TRIGGER PROGRAM FAIL
SI74839 OSP-DB-OTHER-UNPRED SUPPORT BLOCKED INSERT ON A REPLICATED F
SI74729 OSP-DB-OTHER-INCORROUT INCORRECT AG ACTIVATION FROM QSQROUTE
SI74705 OSP-DB INFRASTRUCTURE
SI74644 OSP-DB-OTHER-INCORROUT AN SPC OR UDF THAT IS CREATED IN SYSB
SI74342 OSP-DB Incremental Enhancement.
SI74312 OSP-DB INTERNAL MAINTENANCE
SI74217 OSP-DB SQL DUMPS FOR SYSPARMS ERRORS IN QDBSRVXR2 JOBS
SI74217 OSP-DB-QSQCALLSP-MSGSQL0444-Incorrect message text
SI74202 OSP-F/QSQRUN3-T/QDBSIGEX-RC20-MSGCPF5035 MSGCPF5035 F/ QDBSI
SI74105 OSP-DB INFRASTRUCTURE
SI74105 SQL-CMPL-MSGSQL7032 SQL ROUTINE FAILS TO CREATE
SI73767 OSP-DB-MSGSQL7034 External procedure with CLOB parameter
SI73741 OSP-F/QSQRUN4-T/QSQRUN4-RC1-MSGSQL0446 MSQSQL0446 F/QSQRUN4
SI73583 OSP-DB-OTHER-SOFTWARE RECLONE SUPPORT
SI73308 OSP-DB-OTHER-T/QSQTRNOWN-RC9201-MSGSQL0901
SI73257 OSP-DB-OTHER-MSGSQL0913 AFTER MIRRORED LOCK TABLE
SI73009 OSP-DB INTERNAL MAINTENANCE
SI72827 OSP-DB SQL MERGE STATEMENT MAY LOOK FOR A FILE IN A WRONG LI
SI72824 OSP-DB INTERNAL MAINTENANCE
SI72587 OSP-DB-OTHER-F/QSQPROC-MSGSQL0204
SI72349 OSP-DB-OTHER-F/QSQRUN4-RC2554-MSGSQL0901
SI72349 OSP-DB INTERNAL MAINTENANCE
SI72231 OSP-DB-OTHER-T/QSQCRTT-MSGSQL7909
SI72147 OSP-DB-OTHER-MSGSQL9010 MSGSQL0454 MSGSQL0204
SI72044 OSP-DB-QSQMERGE-MSGSQL0788 incorrect error when record locke
SI72038 OSP ATOMIC STORED PROCEDURES WITH A DRDA HETEROGENEOUS CONNE
SI72011 OSP-DB-QSQAUTH-MSGSQL0204 on GRANT when multiple iASPs used
SI71869 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
SI71869 OSP-DB-QSQPROC-MSGSQL0901 when mirroring blocked
SI71811 OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGMCH3601 MSGMCH3601 F/QSQ
SI71629 OSP-DB INTERNAL MAINTENANCE
SI71574 OSP-DB-MSGSQL799B SQL LABEL OR COMMENT STATEMENT WARNING
SI71514 OSP-DB-OTHER-UNPRED JOB HUNG ON FETCH FROM MIRRORED FILE
SI71391 OSP-DB-OTHER-T/QSQPROC-MSGCPF4326
SI71385 OSP-DB Support new CREATE INDEX syntax for GENERATE_SQL
SI71356 OSP-DB-OTHER-UNPRED MISCELLANEOUS CHANGES TO ALTER ROUTINE M
SI71267 OSP-DB-OTHER-F/QSQCRTUT-RC4357-MSGSQL0901 RESUMING WHILE CRE
SI71233 OSP-DB-OTHER_INCORROUT MSGSQL0301 SUBSTITUTION TEXT INCORREC
SI71189 OSP-DB-OTHER-F/QSQPROC-T/QSQPROC-MSGSQL0204 A MSGSQL0204 MAY
SI71185 OSP-DB-OTHER SQLCLI procedure with output parms does not ret
SI71143 OSP-DB-INTERNAL MAINTENANCE
SI71122 OSP-DB-OTHER-INCORROUT AFTER MIRRORED ALTER ROUTINE IS SUSPE
SI71086 OSP-DB INTERNAL MAINTENANCE
SI71031 OSP-DB-OTHER-INCORROUT MIRRORED EXTERNAL FUNCTION NOT DROPPE
SI70976 OSP-DB-OTHER-F/QSQPROC-MSGSQL0456 on RESYNC OF ALTER FUNCTIO
SI70866 OSP-DB GENERATE_SQL procedure not unqualifying global variab
SI70833 OSP-DB INTERNAL MAINTENANCE
SI70755 OSP-DB-OTHER-T/QSQMERGE-RC2500-MSGSQL0901 COLLECT ADDITIONAL
SI70692 OSP-DB-OTHER-INCORROUT COMMIT VALUE NOT MIRRORED CORRECTLY F
SI70647 OSP-DB-QSQPROC-MSGMCH3402 on DROP PROCEDURE with commit *NON
SI70579 OSP-DB-OTHER-T/QSQMERGE-MSGSQL0913 DOING MIRRORED UPDATE
SI70533 OSP-DB-OTHER-UNPRED PROCEDURE NOT MIRRORED CORRECTLY WITH CR
SI70342 OSP-DB-OTHER-F/QSQPROC-MSGSQL0601
SI70290 OSP-DB-OTHER-RCQSQRFRSH-MSGSQL7061-SQLSTATE-0169G
SI70225 OSP-DB-INTERNAL MAINTENANCE
SI70065 OSP-DB-INTERNAL MAINTENANCE
SI70008 OSP-DB-INTERNAL MAINTENANCE
SI69895 OSP-DB-INTERNAL MAINTENANCE
SI69850 OSP-DB-OTHER-INCORROUT INCONSISTENT OBJECT SCHEMA IN SYSROUT
SI69850 OSP-DB-INTERNAL MAINTENANCE
SI69736 OSP-DB-INTERNAL MAINTENANCE
SI69671 OSP-DB-OTHER-UNPRED WRONG CHARACTER_MAXIMUM_LENGTH FOR TIMES
SI69671 OSP-DB-INTERNAL MAINTENANCE
SI69601 OSP-DB-OTHER-UNPRED AFTER INSERT TRIGGER THAT GOES TO SQL PR
SI69348 OSP-DB-MSGSQL0387 remove from job log
SI69208 OSP-DB-OTHER-UNPRED INTERNAL MAINTENANCE
Summary Information
System.............................. i
Models..............................
Release............................. V7R4M0
Licensed Program.................... 5770SS1
APAR Fixed.......................... View details for APAR SE77057
Superseded by:...................... View fix details for PTF SI85812
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C2328740
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, 2023, 2024 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.
Was this topic helpful?
Document Information
Modified date:
11 March 2024