IBM Support

SI43634 - OSP-DB-OTHER-F/EXSNDPM-T/QSQRUN2-MSGMSGMCH3601 A QZDASOINIT

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-F/EXSNDPM-T/QSQRUN2-MSGMSGMCH3601 A QZDASOINIT


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI42122   00/00    0000
PRE  5770SS1  710  SI41677   00/00    0000
PRE  5770SS1  710  SI41229   00/00    0000
CO   5770SS1  710  SI42856   00/00    0000
CO   5770SS1  710  SI42831   00/00    0000
CO   5770SS1  710  SI42839   00/00    0000
CO   5770SS1  710  SI42836   00/00    0000
CO   5770SS1  710  SI42467   00/00    0000
CO   5770SS1  710  SI41046   00/00    0000
CO   5770SS1  710  SI40611   00/00    0000
CO   5770SS1  710  SI40612   00/00    0000
CO   5770SS1  710  SI39903   00/00    0000
CO   5770SS1  710  SI39905   00/00    0000
CO   5770SS1  710  SI39180   00/00    0000
CO   5770SS1  710  SI39377   00/00    0000
DIST 5770SS1  710  SI43062   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

-----------------------------------------------
A QZDASOINIT JOB MAY ENCOUNTER A MSGMCH3601 F/EXSNDPM T/QSQRUN2
TMOD/QSQVALUE TPROC/SLINTO X/7846

CORRECTION FOR APAR SE48084 :
-----------------------------
The problem is fixed with this PTF.

CIRCUMVENTION FOR APAR SE48084 :
--------------------------------
None.


Activation 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) 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:

QSYS/STRPJ SBS(QSERVER) PGM(QSYS/QZDAINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASSINIT)
and if a non default prestart job configuration exists
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASSINIT)

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





Special Instructions


None.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI43400      OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH1210 AFTER UPGRADE
   SI43063      OSP-DB-OTHER-INCORROUT STATEMENTS NOT ADDED TO AN SQL PACKAG
   SI43063      OSP-DB-OTHER-UNPRED EXTENDED DYNAMIC SQL PACKAGE LAST CHANGE
   SI42882      OSP-DB-UNPRED Internal DRDA Maintenance
   SI42857      OSP-DB-OTHER-PERFM WHEN TRYING TO SEND A LARGE BLOB AS PARAM
   SI42857      OSP-DB-OTHER-UNPRED REMOVE STATEMENTS FROM QZDAPKG
   SI42842      OSP-DB-OTHER-F/QSQALTER-RC4-MSGSQL0685
   SI42834      OSP-DB-QSQCMPDS High CPU during long running job
   SI42541      OSP-DB-INCORROUT Inline UDF Support
   SI42248      OSP-DB-MSGSQL0723 occurred calling trigger on long running j
   SI42173      OSP-DB-OTHER-F/QDBIOERRQO-T/QSQRUN2-MSGCPD5036 A MSGCPD5036
   SI42160      OSP-DB-OTHER-F/QSQRUN1-T/QSQRUN1-RC167-MSGSQL0904 QZDASOINIT
   SI42123      OSP-DB Internal Maintenance
   SI41891      OSP-DB-OTHER Internal Maintenance
   SI41762      OSP-DB Internal Maintenance
   SI41729      OSP-DB-INCORROUT Inline UDF Support
   SI41657      OSP-DB Internal Maintenance
   SI41620      OSP-DB-MSGSQL0443 From the TRANSLATE builtin function
   SI41589      OSP-DB RCLSTG of IASP is not progressing
   SI41477      OSP-DB-INCORROUT Inline UDF Support
   SI41422      OSP-DB-UNPRED Support QIBM_SQL_PASSIVE_UNQUALIFIED_RDB
   SI41353      OSP-DB Internal Maintenance
   SI41317      OSP-DB-UNPRED Statement rewrite fails when alias name longer
   SI41300      OSP-DB-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
   SI41232      OSP-DB-UNPRED Reprepare of DRDA cursors when open attributes
   SI41225      OSP-DB SQ EXIT PROGRAM FAILED AND ENDED QDBXRVXR2.
   SI41225      OSP-DB-OTHER-F/QSQCLOSE-MSGCPF9898
   SI41045      OSP-DB-OTHER-F/QXLXPCPARS-T/QXLXPCPARS-MSGMCH3601 DECOMPOSE
   SI41006      OSP-DB-UNPRED Three-part aliases failing on rewrite of state
   SI40962      OSP-DB-INCORROUT Inline UDF Support
   SI40880      OSP-DB-QSQCLS-MSGSQL0501 for allocated cursor using DRDA
   SI40613      OSP-DB-UNPRED Three part alias statement rewrite
   SI40412      OSP-DB QM QUERY FAILS WITH MCH1210
   SI40355      OSP-DB-INCORROUT Inline UDF Support
   SI40286      OSP-DB-UNPRED SQL statements not picking up table to alias c
   SI40171      OSP-DB-MSGSQL0501 for result set cursor
   SI40168      OSP-DB-OTHER-MSGMCH2601-T/QSQSBAS MODULE QSQUDTCK
   SI40158      OSP-DB-OTHER-MSGMCH3601-T/QSQRUN3 MODULE QSQOPEN WHEN USING
   SI40024      OSP-DB INTERNAL MAINTENANCE
   SI39990      OSP-DB-OTHER-UNPRED 1000 3000 Storage Managment VLOGs
   SI39904      OSP-DB-QSQASLOC-MSGSQL0204 when using specific name on ASSOC
   SI39874      OSP-DB-UNPRED Use of DDM for SQL three-part aliases failing
   SI39840      OSP-DB-OTHER-UNPRED SERVICEABILITY ENHANCEMENT TO QIBM_SQL_S
   SI39833      OSP-DB-MSGMCH3601 F/QQQSQCMP FROM SELECT FROM INSERT STATEME
   SI39788      OSP-DB Internal Maintenance
   SI39604      OSP-DB-MSGMCH5804-F/RmslLockSpaceLoc-T/QSQRUN1-MOD/QSQDESC S
   SI39564      OSP-DB-INCORROUT Inline UDF Support
   SI39510      OSP-DB-MSGMCH1210 F/QSQDBMHV RUNNING DATABASE MONITOR WITH L
   SI39392      OSP-DB Extended indicators used in INSERT with subselect
   SI39378      OSP-DB-OTHER-UNPRED XML LIMITS
   SI39350      OSP-DB-OTHER-UNPRED XML PROCESSING
   SI39349      OSP-DB-OTHER-F/QSQROUTX-T/QSQROUTX-MSGSQL0313 SELECT FROM FI
   SI39162      OSP-DB Internal Maintenance
   SI39157      OSP-DB Internal Maintenance
   SI39129      OSP-DB Internal Maintenance
   SI39117      OSP-DB-MSGMCH3601 f/t stringHighUse4K/QSQROUTE issued in enc
   SI39058      OSP-DB Internal Maintenance
   SI39024      OSP-DB implicit char to numeric conversion fails
   SI38886      OSP-DB Internal Maintenance
   SI38834      OSP-DB-OTHER XML PROCESSING
   SI38756      OSP-DB Internal Maintenance
   SI38697      OSP-DB-OTHER-UNPRED QIBM_SQL_SERVICE ENVIRONMENT VARIABLE NO
   SI38569      OSP-DB-INCORROUT Array Support
   SI38553      OSP-DB-MSGMCH5003-T/QSQSBAS
   SI38441      OSP-DB Internal Maintenance
   SI38425      OSP-DB-MSGCPD32D7 Attempting SELECT from INSERT
   SI38336      OSP-DB-SQL  Array Subcript exceeds bounds
   SI38294      OSP-DB-MSGMCH3601 F/QSQROUTA SET GLOBAL VARIABLE = DEFAULT I
   SI38225      OSP-DB-OTHER Internal Maintenance
   SI38106      OSP-DB-OTHER XML PROCESSING
   SI38100      OSP-DB Internal Maintenance
   SI38007      OSP-DB-INCORROUT SQL UPDATE WITH GLOBAL VARIABLES AND MIXTUR
   SI37956      OSP-DB Internal Maintenance
   SI37911      OSP-DB-MSGSQL0901-F/QSQOPEN Array Support
   SI37869      OSP-DB-OTHER XML PROCESSING
   SI37775      OSP-DB Internal Maintenance
   SI37678      OSP-DB Internal Maintenance
   SI37629      OSP-DB-QSQRUN4-MSGMCH1210 on ASSOCIATE LOCATOR
   SI37627      OSP-DB QSQSBAS2/QSQUDFPR LOOPING when FIELD PROC's are prese
   SI37618      OSP-DB Internal Maintenance
   SI37612      OSP-DB-PERFM ENHANCE SERVICEABILITY. TRAP WHEN SWSC DESTROYE
   SI37591      OSP-DB-OTHER XML PROCESSING
   SI37591      OSP-DB-OTHER XML PROCESSING
   SI37407      OSP-DB-MSGSQL7049 when running with result sets
   SI37389      OSP-DB Internal Maintenance
   SI37258      OSP-DB Internal Maintenance
   SI37214      OSP AFTER SEVERAL INSERTS BEING DONE IN A SINGLE JOB - THE J
   SI37182      OSP-DB XML PROCESSING
   SI37180      OSP-DB-UNPRED Failure to create sequence from within stored
   SI37162      OSP-DB-UNPRED Failure to create sequence from within stored
   SI37140      OSP-DB Internal Maintenance
   SI37056      OSP-DB-MSGMCH1210-F/QSQEXPEVAL Array Support
   SI36902      OSP-DB INTERNAL MAINTENANCE
   SI36876      OSP-DB XML PROCESSING
   SI36859      OSP-DB INTERNAL MAINTENANCE
   SI36785      OSP-DB-UNPRED DRDA errors
   SI36738      OSP-DB XML PROCESSING
   SI36682      OSP-DB XML PROCESSING
   SI36613      OSP-DB-QSQROUTE-MSGMCH3601 running in server mode
   SI36582      OSP-DB Array Support
   SI36555      OSP DB GLOBAL VARIABLE PROCESSING
   SI36525      OSP-DB XML PROCESSING
   SI36444      OSP-DB-UNPRED Three-part naming corrections

Summary Information

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


System 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 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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1 environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
08 June 2011