IBM Support

SI78548 - OSP-DB-OTHER-T/QSQTRUNC-MSGSQL0913 TRUNCATING A REPLICATED F

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

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

[{"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:
11 March 2024