PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB-MSGMCH3601-T/QRWTQRY with 3 part name SQL
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
PRE 5770SS1 V7R2M0 SI59956 00/00 0000
PRE 5770SS1 V7R2M0 SI59345 00/00 0000
PRE 5770999 V7R2M0 MF57614 00/00 0000
CO 5770SS1 V7R2M0 SI62095 00/00 0000
CO 5770SS1 V7R2M0 SI57933 00/00 0000
CO 5770SS1 V7R2M0 SI53839 00/00 0000
DIST 5770SS1 V7R2M0 SI64147 00/00 0000
DIST 5770SS1 V7R2M0 SI64148 00/00 0000
DIST 5770SS1 V7R2M0 SI63630 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
-----------------------------------------------
MSGMCH3601-T/QRWTQRY with 3 part name SQL statement
CORRECTION FOR APAR SE67135 :
-----------------------------
Logic was changed to fix the MSGMCH3601 error.
CIRCUMVENTION FOR APAR SE67135 :
--------------------------------
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 SI56734 :
=================================================
To properly enable this PTF for prestarted server jobs,
you will need to stop and restart the SQL server jobs,
the Directory Services server jobs, the DRDA TCPIP server
jobs, and the host server jobs. Otherwise,
the prestarted server jobs may continue to use older versions
of programs and unexpected results may occur.Applying this
PTF as delayed would achieve the same results.
To stop and restart the SQL server jobs, run the following:
ENDPJ SBS(QSYSWRK) PGM(QSQSRVR) OPTION(*IMMED)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)
To stop and restart the QRWTSRVR prestart jobs, run the following:
ENDPJ SBS(QUSRWRK) PGM(QRWTSRVR) OPTION(*IMMED)
STRPJ SBS(QUSRWRK) PGM(QRWTSRVR)
To stop and restart the DRDA TCPIP server jobs, run the following:
ENDTCPSVR SERVER(*DDM) OPTION(*IMMED)
STRTCPSVR SERVER(*DDM)
To stop and restart the Directory Services server job,
run the following:
ENDTCPSVR SERVER(*DIRSRV) OPTION(*IMMED)
STRTCPSVR SERVER(*DIRSRV)
To stop and restart the host server jobs, the following directions
must be followed.
The database server prestart jobs (QZDAINIT, QZDASOINIT, and
QZDASSINIT) by default are shipped to run in subsystem QSERVER
(QZDAINIT) and QUSRWRK (QZDASOINIT and QZDASSINIT). However, systems
can be customized to allow the database server prestart jobs to run
in other subsystems.
SYSTEMS WITH DEFAULT CONFIGURATION (database server prestart jobs run
ONLY in the QSERVER and QUSRWRK subsystems).
---------------------------------------------------------------------
1) To ensure that the database server prestart jobs are ended,
issue the requests:
QSYS/ENDPJ SBS(QSERVER) PGM(QSYS/QZDAINIT) OPTION(*IMMED)
and
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT) OPTION(*IMMED)
and
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QZDASSINIT) OPTION(*IMMED)
and if a non default prestart job configuration exists
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDAINIT)
If the above commands fail with CPF0922, nothing more needs
to be done (the prestarted jobs are already inactive).
2) To re-enable the function after the PTF is applied, issue the
requests:
Default Instructions
THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.
Supersedes
PTF/FIX NO(S). APAR TITLE LINE
-------------- ------------------------------------------------------------
SI64146 OSP-UNPRED ENDDBMON OF DBMON WITH PARM HOSTVAR(*CONDENSED) L
SI64008 OSP-DB 3-part name replacement for heterogenous, use *SQL na
SI63639 OSP-DB INTERNAL MAINTENANCE
SI63631 OSP-DB-OTHER-F/QSQRUN4-MSGMCH0601 WHEN USING A QUERY DEFINED
SI63621 OSP-DB Improve Index Advisor storage management
SI63179 OSP-DB-MSGMCH3601 QZDASOINIT Job Termination Failing with MC
SI63176 OSP-DB Internal Maintenance
SI63061 OSP-DB-OTHER-T/QSQRUN3-MSGMCH3601 MODULE QSQOPEN PROCEDURE D
SI62286 OSP-DB INTERNAL MAINTAINENCE
SI62096 OSP-DB Internal Maintenance
SI61627 OSP-DB-MSGMCH3402 f/QSQUDFPO t/QSQUDFPO running query with s
SI61166 OSP ALTER TABLE STATEMENT NOT LOGGED BY DBMON
SI60933 OSP-DB INTERNAL MAINTENANCE
SI60477 OSP-DB-PERFM Slow performance when using SQL packages in mul
SI59958 OSP-DB Internal Database Maintenance
SI59800 OSP-DB-INCORROUT INLINED SQL FUNCTION
SI59646 OSP-DB INTERNAL MAINTENANCE
SI59456 OSP-DB Create table LIKE with 3-part name issues misleading
SI59357 OSP-DB INTERNAL MAINTENANCE
SI59343 OSP-DB REMOTE INSERT WITH AN ALIAS THAT HAS A 3 PART NAME FA
SI59245 OSP-DB INFRASTRUCTURE
SI58971 OSP-DB-OTHER-F/QSQRUN3-MSGSQL0517
SI58949 OSP-DB-SQL Support optionally clearing SQLSTATE on truncatio
SI58754 OSP-DB-MSGMCH3402 T/QSQPREP in QDBSxxxxxx system job
SI58140 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENTS
SI58082 OSP-DB Internal Maintenance
SI58080 OSP-DB Internal Maintenance
SI58041 OSP-DB-OTHER-INCORROUT SPECIAL REGISTER VALUE INCORRECTLY RE
SI57941 OSP-DB-MSGSQL0206 when column not defined at precompile time
SI57934 OSP-DB-OTHER SQL0205 F/QSQRUN2 T/QSQRUN2
SI57865 OSP-DB-OTHER-T/QSQSBAS2-MSGCPD0018
SI57264 OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
SI57158 OSP-DB-OTHER-INCORROUT 3010 RECORD MISSING FROM STRDBMON OUT
SI57082 OSP-DB-OTHER-UNPRED STORAGE LEAK USING STRDBMON HOSTVAR(*CON
SI56734 OSP-DB-OTHER-F/QXLXPCPARS-T/QXLXPCPARS-MSGMCH6801 FOR XMLVAL
SI55615 OSP-DB-OTHER-F/#DBDLVLB-T/QQQSRVE1-MSGMCH3203 UPDATE ON TABL
SI55529 OSP-DB QSQPRCED() creates package using a larger capacity *S
SI55516 OSP-DB Internal Maintenance
SI55402 OSP-DB Improve LOB locator performance during commit or roll
SI55270 OSP-DB-OTHER-T/QSQSBAS-MSGMCH1210 MODULE QSQVATTR PROCEDURE
SI55169 OSP-DB-OTHER-RC2-MSGSQL7049
SI55115 OSP-DB-OTHER-UNPRED QSQSVCDMP SPOOLED FILE CREATED
SI54967 OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
SI54963 OSP-DB Internal Maintenance
SI54694 OSP-DB INTERNAL MAINTENANCE
SI54586 OSP-DB-OTHER-T/QQQOOODBOP-MSGMCH3601
SI54530 OSP-DB-OTHER-T/QSQRUN2-MSGSQL0501 WHILE INVOKING TABLE FUNCT
SI54046 OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
SI53840 OSP-DB Internal Maintenance
SI53279 OSP-DB XMLPARSE SQL16168 W/STANDALONE
SI53274 OSP-DB CLIENT SPECIAL REG BRANDING FIX FOR LOCAL CONNECTION
SI53268 OSP-DB-OTHER-F/QSQSBAS-MSGMCH1210 A MSGMCH1210 F/QSQSBAS MAY
SI53067 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
SI52973 OSP-DB-MSGMCH1210 QSQCKRDB For SQL statement with RDB qualif
SI52899 OSP-DB-F/QSQXMLPV-MSGMCH3601 running XMLVALIDATE built-in fu
SI52683 OSP-DB-MSGSQL0423 running a SQL routine that has LOBs
SI52611 OSP-DB INTERNAL MAINTENANCE
SI52611 OSP-DB WHEN USING ALIAS NAME IN SQL THAT IS LONGER THAN 10 C
SI52536 OSP-DB INTERNAL MAINTENANCE
SI52459 OSP-DB-OTHER-INCORROUT WHEN OVERRIDING A TABLE TO ANOTHER TA
SI52459 OSP-DB-OTHER-MSGSQL0443 SERVICEABILITY ENHANCEMENT
SI52275 OSP-DB-OTHER-MSGSQL0443 SERVICEABILITY ENHANCEMENT
SI52196 OSP-DB-OTHER-T/QQQQEXIT-MSGMCH0601
SI51887 OSP-DB Internal Maintenance
SI51819 OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT
SI51754 OSP-DB INTERNAL MAINTENANCE
SI51754 OSP-DB-OTHER-F/QSQSBAS-T/QSQCLOSE-RC461-MSGSQL0904 SQL0904 T
SI51685 OSP-DB-OTHER-F/QSQSBAS-T/QSQCLOSE-RC461-MSGSQL0904 SQL0904 T
SI51579 OSP-DB Internal Maintenance
SI51554 OSP-DB INTERNAL MAINTENANCE
SI51466 OSP-DB INTERNAL MAINTENANCE
SI51451 OSP-DB-MSGSQL0901-F/QSQGTSPC using LOBs in sql procedure
SI51432 OSP-DB-MSGSQL0901-F/QSQGTSPC using LOBs in sql procedure
SI51240 OSP-DB INTERNAL MAINTENANCE
SI51240 OSP-DB Internal Maintenance
Summary Information
System.............................. i
Models..............................
Release............................. V7R2M0
Licensed Program.................... 5770SS1
APAR Fixed.......................... View details for APAR SE67135
Superseded by:...................... View fix details for PTF SI85810
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C7290720
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:
12 March 2024