IBM Support

SI68398 - OSP-DB IBM i Reship QSQJSON2 *SRVPGM

PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB IBM i Reship QSQJSON2 *SRVPGM


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770SS1  V7R2M0    SI67815   00/00    0000
CO   5770SS1  V7R2M0    SI68098   00/00    0000
CO   5770SS1  V7R2M0    SI67878   00/00    0000
CO   5770SS1  V7R2M0    SI67525   00/00    0000
CO   5770SS1  V7R2M0    SI67529   00/00    0000
CO   5770SS1  V7R2M0    SI67232   00/00    0000
CO   5770SS1  V7R2M0    SI66888   00/00    0000
CO   5770SS1  V7R2M0    SI57230   00/00    0000
DIST 5770999  V7R2M0    MF60074   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

-----------------------------------------------
System halts at signon with CPF1123 or the system halting at
SRCB90037FF after a PTF install of SF99702 level 23.

Word 11: B90037FF
Word 12: 0D200080
Word 13: 20A00010
Word 14: D8C3C1D5 = QCANPARS
Word 15: D7C1D9E2
Word 16: 404004B9 = 04B9
Word 17: D4C3C8F3 = MCH3401
Word 18: F4F0F100
Word 19: 00000000

CORRECTION FOR APAR SE70022 :
-----------------------------
Prevents system from halting at signon with CPF1123 or the
system halting at SRCB90037FF after a PTF install of SF99702
level 23.

CIRCUMVENTION FOR APAR SE70022 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


None.


Default Instructions

THIS IS A DELAYED PTF TO BE APPLIED AT IPL TIME.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI68166      Database Monitor Internal Maintenance
   SI68100      Internal Maintenance
   SI67966      OSP-DB-OTHER-F/QQQQEXIT-T/QQQQEXIT-MSGMCH3402 MSGMCH3402 F/Q
   SI67879      Internal Maintenance
   SI67864      OSP-DB Database Monitor Internal Maintenance
   SI67625      OSP-DB Database Monitor Internal Maintenance
   SI67526      OSP-DB Database Monitor Internal Maintenance
   SI67404      Internal Maintenance
   SI67230      OSP-DB DB2 for IBM i Internal Maintenance
   SI66887      Internal Maintenance
   SI66295      OSP Database Field Procedure Enhancements
   SI66186      OSP-DB-OTHER-INCORROUT DATE FIELD DESCRIPTION INCORRECT
   SI66186      OSP-DB-MSGMCH4419 f/AiEagerActivator t/QQQUDFAC during IPL
   SI66055      OSP-DB Internal Maintenance
   SI65837      Internal Maintenance
   SI65797      Internal Maintenance
   SI65749      Internal Maintenance
   SI65681      Internal Maintenance
   SI64015      Internal Maintenance
   SI63694      Internal Maintenance
   SI63643      OSP-DB-OTHER Allow more then 8192 literals values in a query
   SI63496      OSP-DB Internal Database Maintenance
   SI62488      OSP-DB Internal Database Maintenance
   SI62277      OSP-DB MSGCPF503E F/QQURB X/1741 T/QQUDA X/03FA
   SI62021      OSP-DB-OTHER-F/QQQVEXPL-MSGMCH1210 TRYING TO OPEN VISUAL EXP
   SI61804      OSP-DB Internal Database Maintenance
   SI61562      OSP-DB-OTHER Allow more then 8192 literals values in a query
   SI61487      OSP-DB Internal Database Maintenance
   SI61082      OSP-DB-OTHER-THREADS-F/QC2UTIL1-T/QQQSVUSR-MSGMCH3601 TO_DAT
   SI60421      OSP-DB-OTHER-INCORROUT Plan Cache VE is showing 0 for rows f
   SI60390      OSP-DB Internal Database Maintenance
   SI60251      OSP-DB Internal Database Maintenance
   SI60160      OSP-DB MUTEX BUILD UP DUE TO DATABASE CODE.
   SI60095      OSP-DB Internal Database Maintenance
   SI59703      OSP-DB Internal Database Maintenance
   SI59596      OSP-DB-MSGMCH1210 f/QQQQUERY t/QQQQUERY proc/CRTNEWQDT
   SI59354      OSP-DB Internal Database Maintenance
   SI59003      OSP-DB Internal Database Maintenance
   SI58667      OSP-DB-OTHER MSGMCH6903 T/QC2UTIL1 CAN BE SEEN WHEN THE REGE
   SI58111      OSP-DB-OTHER-F/QQQUDFHL-T/QSQRUN3-MSGCPF426A A MSGCPF426A MA
   SI58095      OSP-DB-MSGSQL0443 MCH1210 When Visual Explaining a query wit
   SI58071      OSP-XTND-OTHER-F/QDBSIGEX-T/QDZXDBI-MSGCPF5257 CPF5257, SQL0
   SI57942      OSP-DB-OTHER Query INI Option ALLOW_EVI_ONLY_ACCESS and Addi
   SI57674      OSP-DB-MSGSQL0443 F/QSQROUTS t/QSQROUTS using SQL CONTAINS o
   SI57674      OSP-DB-OTHER Database Monitor causes Process Queue Space lim
   SI57371      F/QQQQUERY-MSGCPD438C CPD438C REASON CODE 18 IS RECEIVED WHE
   SI57333      OSP-DB-OTHER Scalar Function Error Support
   SI57269      OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
   SI57229      OSP-DB STRDBMON Filter Operator Support
   SI56924      OSP-DB-OTHER Scalar Function Support
   SI56812      OSP-FieldProc using wrong usrprf after PROFILE HANDLER (QSYG
   SI56662      OSP-DB-OTHER Scalar Function Support
   SI56409      OSP-DB function not found in QSYS2 when using default parame
   SI56270      OSP-DB-MSGMCH3601 in QQQSETUP for query of laterally correla
   SI56225      OSP-DB-OTHER-THREADS-WAIT qqcatlup in THDW
   SI56211      OSP-DB-OTHER Scalar Function Support
   SI56156      OSP-DB Extend QSQPRCED() to include some QAQQINI options
   SI56134      OSP-DB-OTHER-F/QQQVEXPL-MSGMCH3601 ON VISUAL EXPLAIN OF A ME
   SI56094      OSP-OTHER-PERFM FULL OPNQRYF TEXT NOT DISPLAYING CORRECTLY I
   SI56048      OSP-DB-OTHER Scalar Function Support
   SI55327      OSP-DB-MSGMCH3601 f/QQQVFMT when using UDFs as parameters to
   SI55218      OSP-DB Internal Maintenance
   SI55109      OSP-DB-OTHER-MSGSQL0462 THE MESSAGE TEXT IN THE SQL0462 ERRO
   SI55075      OSP-DB-OTHER-F/MNRESOLVECONTEXT-T/QQQUDFAC-MSGMCH3401 A VARY
   SI54962      OSP-DB REGEXP Scalar Function Support
   SI54734      OSP-DB database monitor fixes for the STRDBMON HOSTVAR parm.
   SI54595      OSP-DB database monitor service option for the 3010 record
   SI54595      OSP-DB database monitor fixes for the STRDBMON HOSTVAR parm.
   SI54279      OSP-DB Support HOSTVAR parameter on STRDBMON command
   SI54279      OSP-DB Support 10 User Profiles on the FTRUSER parameter on
   SI54279      OSP-DB-INCORROUT Extra call to table function with CLOB outp
   SI53968      OSP-DB-OTHER Improved ability to change File Filtering choic
   SI54086      OSP-DB Internal Database Maintenance
   SI54039      OSP-DB Support HOSTVAR parameter on STRDBMON command - Phase
   SI53895      OSP-DB CURSOR BEING HARD CLOSED.
   SI53786      OSP-DB LPAD and RPAD Scalar Function Support
   SI53645      OSP-DB Internal Database Maintenance
   SI53422      OSP-DB INTERNAL MAINTENANCE
   SI53365      OSP-DB Internal Database Maintenance
   SI52995      OSP-DB Internal Database Maintenance
   SI52880      OSP-DB-MSGCPD4301 f/QQQVFMT t/QSQRUN3 running query with lat
   SI52678      OSP-DB MSGMCH3402 F/QQQQEXIT on job completion
   SI52565      OSP-DB Internal Database Maintenance
   SI52443      OSP-DB Internal Database Maintenance
   SI52282      OSP-DB-OTHER-INCORROUT INCORROUT IN QUERY WITH LOB DATA AND
   SI52282      OSP-DB Function & Procedure with same name not correctly reg
   SI52237      OSP-DB Internal Database Maintenance
   SI52033      OSP-DB Internal Database Maintenance
   SI51986      OSP-DB Internal Database Maintenance
   SI51861      OSP-DB Internal Database Maintenance
   SI51631      OSP-DB Internal Database Maintenance
   SI51458      OSP-DB Internal Database Maintenance
   SI51410      OSP-DB Internal Database Maintenance
   SI51244      OSP-DB Internal Database Maintenance
   SI61217      OSP-DB-INCORROUT OPNQRYF statement text not correct in Datab
   SI57653      OSP-DB-INCORROUT OPNQRYF statement text not correct in Datab
   SI56799      OSP-DB-OTHER Scalar Function Support

Summary Information

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


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

Document information

More support for: i family

Software version: V7R2M0

Operating system(s): OS/400

Reference #: SI68398

Modified date: 25 September 2018