IBM Support

SI80452 - OSP-DB-MSGMCH3411 QTNNTXSP Looping

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-MSGMCH3411 QTNNTXSP Looping


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770999  V7R4M0    MF69411   00/00    0000
CO   5770SS1  V7R4M0    SI75227   00/00    0000
CO   5770SS1  V7R4M0    SI74632   00/00    0000
CO   5770SS1  V7R4M0    SI74631   00/00    0000
CO   5770SS1  V7R4M0    SI72276   00/00    0000
CO   5770SS1  V7R4M0    SI71568   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

-----------------------------------------------
QTNNTXSP loops following an MCH3411 in the joblog.

CORRECTION FOR APAR SE78170 :
-----------------------------
An additional exception handler detects the condition and ends
program execution.

CIRCUMVENTION FOR APAR SE78170 :
--------------------------------
None.


Activation Instructions

None.




Special Instructions


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)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)

To stop and restart the DRDA TCPIP server jobs, run the following:

ENDTCPSVR SERVER(*DDM)
STRTCPSVR SERVER(*DDM)

To stop and restart the Directory Services server job, run the
following:

ENDTCPSVR SERVER(*DIRSRV)
STRTCPSVR SERVER(*DIRSRV)

To stop and restart the host server jobs, the following directions
must be followed.  These prestart jobs (QZDAINIT, QZDASOINIT,
QZDASSINIT, QRWTSRVR, and QDBMSRVR) by default are shipped to run
in subsystem QSERVER (QZDAINIT) and QUSRWRK (QZDASOINIT, QZDASSINIT,
QRWTSRVR, and QDBMSRVR).  However, systems can be customized to
allow the database server prestart jobs to run in other subsystems.
If the system has been changed in this manner, these instructions
will need to be modified to specify the correct subsystem.

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
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QRWTSRVR) OPTION(*IMMED)
and
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QDBMSRVR) OPTION(*IMMED)

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:

QSYS/STRPJ SBS(QSERVER) PGM(QSYS/QZDAINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASSINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QRWTSRVR)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QDBMSRVR)

If the above commands fail with CPF0921, nothing more needs
to be done (the prestarted jobs are already active).

3) To re-enable the function for each subsystem "subsystem-name"
identified, issue the following requests after the PTF is
applied:

QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDAINIT)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASOINIT)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASSINIT)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QRWTSRVR)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QDBMSRVR)

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

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)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)

To stop and restart the DRDA TCPIP server jobs, run the following:

ENDTCPSVR SERVER(*DDM)
STRTCPSVR SERVER(*DDM)

To stop and restart the Directory Services server job, run the
following:

ENDTCPSVR SERVER(*DIRSRV)
STRTCPSVR SERVER(*DIRSRV)

To stop and restart the host server jobs, the following directions
must be followed.  These prestart jobs (QZDAINIT, QZDASOINIT,
QZDASSINIT, QRWTSRVR, and QDBMSRVR) by default are shipped to run
in subsystem QSERVER (QZDAINIT) and QUSRWRK (QZDASOINIT, QZDASSINIT,
QRWTSRVR, and QDBMSRVR).  However, systems can be customized to
allow the database server prestart jobs to run in other subsystems.
If the system has been changed in this manner, these instructions
will need to be modified to specify the correct subsystem.

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
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QRWTSRVR) OPTION(*IMMED)
and
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QDBMSRVR) OPTION(*IMMED)

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:

QSYS/STRPJ SBS(QSERVER) PGM(QSYS/QZDAINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASSINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QRWTSRVR)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QDBMSRVR)

If the above commands fail with CPF0921, nothing more needs
to be done (the prestarted jobs are already active).

3) To re-enable the function for each subsystem "subsystem-name"
identified, issue the following requests after the PTF is
applied:

QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDAINIT)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASOINIT)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASSINIT)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QRWTSRVR)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QDBMSRVR)


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)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)

To stop and restart the DRDA TCPIP server jobs, run the following:

ENDTCPSVR SERVER(*DDM)
STRTCPSVR SERVER(*DDM)

To stop and restart the Directory Services server job, run the
following:

ENDTCPSVR SERVER(*DIRSRV)
STRTCPSVR SERVER(*DIRSRV)

To stop and restart the host server jobs, the following directions
must be followed.  These prestart jobs (QZDAINIT, QZDASOINIT,
QZDASSINIT, QRWTSRVR, and QDBMSRVR) by default are shipped to run
in subsystem QSERVER (QZDAINIT) and QUSRWRK (QZDASOINIT, QZDASSINIT,
QRWTSRVR, and QDBMSRVR).  However, systems can be customized to
allow the database server prestart jobs to run in other subsystems.
If the system has been changed in this manner, these instructions
will need to be modified to specify the correct subsystem.

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
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QRWTSRVR) OPTION(*IMMED)
and
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QDBMSRVR) OPTION(*IMMED)

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:

QSYS/STRPJ SBS(QSERVER) PGM(QSYS/QZDAINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASSINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QRWTSRVR)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QDBMSRVR)

If the above commands fail with CPF0921, nothing more needs
to be done (the prestarted jobs are already active).

3) To re-enable the function for each subsystem "subsystem-name"
identified, issue the following requests after the PTF is
applied:

QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDAINIT)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASOINIT)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASSINIT)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QRWTSRVR)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QDBMSRVR)


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)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)

To stop and restart the DRDA TCPIP server jobs, run the following:

ENDTCPSVR SERVER(*DDM)
STRTCPSVR SERVER(*DDM)

To stop and restart the Directory Services server job, run the
following:

ENDTCPSVR SERVER(*DIRSRV)
STRTCPSVR SERVER(*DIRSRV)

To stop and restart the host server jobs, the following directions
must be followed.  These 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.  If the system has been changed in this manner,
these instructions will need to be modified to specify the correct
subsystem.

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)

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:

QSYS/STRPJ SBS(QSERVER) PGM(QSYS/QZDAINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASSINIT)

If the above commands fail with CPF0921, nothing more needs
to be done (the prestarted jobs are already active).

3) To re-enable the function for each subsystem "subsystem-name"
identified, issue the following requests after the PTF is
applied:

QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDAINIT)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASOINIT)
and
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASSINIT)


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI80418      OSP-MSGMCH3601-D/TQTNCMTEP DB2 MIRRORED NODE IS INTERMITTENT
   SI80416      OSP- CPF9898 messages indicate mirror when SNA
   SI80346      OSP-DB IPL stuck at C900 2AA1 - Commit Recovery (XPF)
   SI79812      [Db2M Integration Test:iDeliver] SHIPMENT table has unmatche
   SI79760      OSP-DB-OTHER-F/QTNFRSCE-T//QSQUNCON-RC2-MSGCPF8362 MSGCPF836
   SI79676      OSP- CPF83EC nested transaction failed reason code 4
   SI79511      OSP-DB-MSGMCH3411 Looping in QTNCTMEP
   SI79307      OSP-DB Allow IASPs and SYSBASE in different mirror states
   SI78669      OSP- VCP Table out of sync after regression test run
   SI78213      OSP-DB Job spends more time waiting on journal after PTFs ap
   SI78134      OSP- CPD83FF XA transactions prevent vary OFF
   SI77750      OSP-DB-MSGSQL0910 Resync failed, *FILE with pending change
   SI77730      OSP-DB Vary ON stuck at C900 2AA1
   SI77431      OSP-DB Job spends more time waiting on journal after PTFs ap
   SI77345      OSP-DB CPF8364 IN QDBSRVXR2 JOBLOG
   SI77203      OSP-DB-OTHER MSGCPF8190 - OBJECT CBLK... TYPE X'0FC1' DAMAGE
   SI77156      OSP-DB-SQL0901 f/t QSQROUTS/QSQROUTS when create distributed
   SI77031      OSP-DB-OTHER-WAIT SYSTEM HANG DURING NORMAL OPERATIONS
   SI76776      OSP-UNPRED WRKCMTDFN RETURNS DIFFERENT RESULTS AFTER AN OPER
   SI76374      OSP-DB Db2 Mirror Commit
   SI76158      OSP-DB-OTHER-F/QTNROLLB-T/QTNROLLB-MSGMCH3402 QDBSRV JOBS FO
   SI76107      OSP-DB Db2 Mirror Commit
   SI76004      OSP-DB Db2 Mirror Commit
   SI75988      OSP-DB-MSGCPF4326 DRDA and DFM resource clean up
   SI75821      OSP-DB Db2 Mirror Commit
   SI75339      OSP- MCH3601 QTNCMTEP+206E
   SI75232      OSP-DB Db2 Mirror Commit
   SI74862      OSP-DB Db2 Mirror Commit
   SI74767      OSP-DB Db2 Mirror Commit
   SI74627      OSP-DB Db2 Mirror Commit
   SI74524      OSP-DB Db2 Mirror Commit MCH3402 F/t QRWTPROT/QRWTPROT on re
   SI74483      OSP-DB-JRN-F/QTNCMTSP-T/QTNCMTSP-MSGMCH3402 MSGMCH3402 F/QTN
   SI74411      OSP-DB-JRN-F/QTNCMTSP-T/QTNCMTSP-MSGMCH3402 MSGMCH3402 F/QTN
   SI74309      OSP-DB Db2 Mirror Commit
   SI74175      OSP-DB Db2 Mirror Commit
   SI74153      OSP-MSGCPD83FF VARYOFF FAILS WITH CPD83FF
   SI74067      OSP-DB Db2 Mirror Commit
   SI73840      OSP-DB Db2 Mirror Commit
   SI73551      OSP-DB Db2 Mirror Commit
   SI73489      OSP-DB INTERNAL MAINTENANCE
   SI73454      OSP-DB INTERNAL MAINTENANCE
   SI73215      OSP-DB Db2 Mirror Commit
   SI73175      OSP-DB INTERNAL CN SYNCHRONIZATION OBJECTS LEFT LOCKED AT TH
   SI73024      OSP-DB-MIRROR-MSGCPF8361RC20-F/QTNCMTSP XA DB2 MIRROR COMMIT
   SI72849      OSP-DB Db2 Mirror Commit
   SI72203      OSP-DB Db2 Mirror Commit
   SI72093      OSP-DB Db2 Mirror Commit
   SI71940      OSP-DB Db2 Mirror Commit
   SI71774      OSP-DB-OTHER-T/QTNSYUTL-RCX/2562-MSGMCH3402 VARYOFF IASP FAI
   SI71582      OSP-DB Db2 Mirror Commit
   SI71182      OSP-DB Db2 Mirror Commit
   SI70912      OSP-DB Db2 Mirror Commit
   SI70751      OSP-DB Db2 Mirror Commit
   SI70545      OSP-DB Db2 Mirror Commit MCH5601 CPF83EC MCH3601 MCH1210
   SI70381      OSP-DB Db2 Mirror Commit MCH3203 CPF83EC CPF8367
   SI70296      OSP-DB Db2 Mirror Commit MCH3601 MCH3402
   SI70193      OSP-DB Incremental Enhancement
   SI70150      OSP-DB Incremental Enhancement
   SI70092      OSP-DB Incremental Enhancement
   SI70025      OSP-DB Incremental Enhancement
   SI69911      OSP-DB Incremental Enhancement
   SI69856      OSP-DB Incremental Enhancement
   SI69744      OSP-DB Incremental Enhancement
   SI69691      OSP-DB Incremental Enhancement
   SI69603      OSP-DB Incremental Enhancement
   SI69540      OSP-DB Incremental Enhancement
   SI69425      OSP-DB Incremental Enhancement
   SI69361      OSP-DB Incremental Enhancement
   SI69228      OSP-DB Incremental Enhancement
   SI72321      OSP-DB WRKCMTDFN LOCAL CHANGES PENDING NOT INCLUDING LOCAL D

Summary Information

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


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:
19 August 2022