IBM Support

SI75144 - OSP-DB-OTHER-MSGCPFA0A9 QQQOOOCACH CHANGING CURRENT DIRECTOR

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix
 
Abstract

OSP-DB-OTHER-MSGCPFA0A9 QQQOOOCACH CHANGING CURRENT DIRECTOR


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770999  V7R2M0    MF65140   00/00    0000
PRE  5770999  V7R2M0    MF64145   00/00    0000
PRE  5770999  V7R2M0    MF64091   00/00    0000
PRE  5770999  V7R2M0    MF64043   00/00    0000
PRE  5770999  V7R2M0    MF58842   00/00    0000
PRE  5770999  V7R2M0    MF58331   00/00    0000
CO   5770SS1  V7R2M0    SI73234   00/00    0000
CO   5770SS1  V7R2M0    SI71243   00/00    0000
CO   5770SS1  V7R2M0    SI67880   00/00    0000
CO   5770SS1  V7R2M0    SI65679   00/00    0000
CO   5770SS1  V7R2M0    SI61308   00/00    0000
CO   5770SS1  V7R2M0    SI52445   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

-----------------------------------------------
Programs calling QQQOOOCACH then making subsequent calls to
commands using relative paths to files in the IFS worked until
current cumulative PTFs were applied. After applying SI73391 the
programs start failing with authorization errors to the path
/QIBM/UserData/OS400/SQE and message CPFA0A9 is also occurring
because the current directory for the job has been changed from
what it was prior to the call to QQQOOOCACH to
/QIBM/UserData/OS400/SQE.

CORRECTION FOR APAR SE74219 :
-----------------------------
There was an oversight in the design for the functional change
for SQE trace management and security. The code did not expect
that the QQQOOOCACH interface would be called for any reason
other than for SQE tracing and plan cache utilities. With this
new functionality, the current working directory was changed to
the directory used to store SQE traces and was not reset. This
PTF will correct the problem for all QQQOOOCACH options.

CIRCUMVENTION FOR APAR SE74219 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI74851      OSP-DB-OTHER VE of Statement Number in Floating point
   SI74142      OSP-OTHER-PERFM ENABLE QAQQINI SERVICE OPTION
   SI73233      OSP-DB-OTHER-MSGSQL0429 LOB LOCATOR ORPHANED UDTF
   SI73075      LIC-DB-OTHER Internal Maintenance
   SI73061      LIC-DB-OTHER Add Longest Run and Current Run Host variables
   SI72635      OSP-DB-OTHER Serviceability enhancements
   SI72630      OSP-DB-OTHER Serviceability enhancements
   SI71326      OSP-DB-OTHER DATABASE IS NOT DETECTING SKEW TO THE LOWER SID
   SI71244      OSP-DB-MSGSQL0443 f/QSQFETCH t/QSQRUN2 when select from view
   SI70898      OSP-OTHER-INCORROUT ANALYZE_PLAN_CACHE PICKING WRONG CCSID
   SI69595      OSP-DB-OTHER-PERFM PERFORMANCE IMPROVEMENT TO QDS IO COSTING
   SI69160      OSP-MSGCPF426A USER DEFINED FUNCTION USING A VIEW THAT WAS R
   SI68731      LIC-DB-OTHER Database serviceability enhancement
   SI68729      LIC-DB-OTHER Database serviceability enhancement
   SI68186      OSP-DB-MSGCPF4268 f/QQQSRVV1 fmod/QQQVFILE t/QQQOOOUPCL tmod
   SI68099      Internal Maintenance
   SI68004      OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4-MSGSQL0438 COALESCE CPF503E
   SI67958      OSP-DB-MSGSQL0204 Failure in plan cache tools
   SI67878      OSP-DB IBM i Internal Maintenance
   SI67528      OSP-DB Database Monitor Internal Maintenance
   SI67590      OSP-DB-OTHER-F/DBOPEXPRVALMISC-T/QQQOOODBOP-MSGMCH3203 RCAC
   SI67440      OSP-DB-OTHER-INCORROUT A RPG CHAIN MAY NOT FIND CORRECT VALU
   SI66927      OSP-DB-OTHER Additional QAQQINI options to VisualExplan
   SI66889      Internal Maintenance
   SI66878      OSP-DB-OTHER-F/DBOPQUERY-T/QQQOOODBOP-MSGMCH3203 OPNQRYF THA
   SI66873      OSP-DB-OTHER-MSGCPF4128 LOCKS NOT RELEASED WHEN SQL SELECT I
   SI66872      OSP-S36E-OTHER-F/QDMCOPEN-T/QDMCOPEN-MSGMCH3601 ODP GETS NUL
   SI66712      OSP-DB-OTHER Delete specific plan via QQQOOOCACH
   SI66536      F/DBOPNODE-MSGMCH3203-PRCS/1720 F/DBOPNODE-MSGMCH3203-PRCS/1
   SI66247      Internal Maintenance
   SI66206      OSP-DB-OTHER-PERFM SQL STATEMENT CONTAINING COALESCE/IFNULL
   SI66191      LIC-DB-OTHER Internal Database Maintenance.
   SI66054      OSP-DB Internal Maintenance
   SI66047      OSP-DB-OTHER-INCORROUT JSON_ARRAY with fullselect and orderi
   SI65980      Fix for missing labels in Visual Explain for LIMIT/OFFSET.
   SI65879      OSP-DB IBM i enhanced support for LIMIT and OFFSET.
   SI65785      OSP-DB IBM i enhanced support for LIMIT and OFFSET.
   SI65736      OSP-DB-OTHER ADD QRO Hash to iNav/ACS PlanCache view
   SI65680      Internal Maintenance
   SI65340      OSP-DB-MSGMCH3601 f/QQQQEXIT t/QQQQEXIT proc/CLOSE_USER_UFCB
   SI65179      OSP-DB-OTHER Support to control data copy allowance for open
   SI64972      OSP-DB-OTHER MSGMCH3203 F/DBPMTRAP T/QQQOOODBOP VL0600BADD V
   SI64788      SQL-RUN B9003E10
   SI64527      OSP-DB-PERFM Performance issue with SQL Expression Evaluator
   SI64363      OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F
   SI64021      OSP-DB System i XML publishing function special character es
   SI63752      LIC-DB-UNPRED Failure tracing Query
   SI63623      OSP-DB-MSGMCH3601 using inlined UDF with a parameter that ha
   SI63522      OSP-DB-OTHER-F/QQQOOODBOP-T/QQQOOODBOP-MSGMCH3601 QQQDTQRO B
   SI63495      OSP-DB Internal Database Maintenance
   SI63465      OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH3601 MSGMCH3601 F/Q
   SI63048      OSP-DB-PERFM PERFORMANCE ISSUES READING SQL VIEW THAT WAS OP
   SI62987      OSP-DB-OTHER-F/QQQSRVE1-T/QQQSRVE1-MSGMCH3601 MSGMCH3601 F/Q
   SI62834      OSP-DB-f/QQQSRVV1-MSGCPD432D when inlining UDF with a select
   SI62798      OSP-DB Internal Database Maintenance
   SI62751      LIC-DB-PERFM Excessive optimization time when MQTs enabled
   SI62555      F/OPTIMIZER-UDFWITHDETERMINISTICBEHAVIOUR OPTIMIZER-UDF WITH
   SI62100      OSP-DB-Internal Database Maintenance
   SI61561      OSP-DB INFRASTRUCTURE
   SI61486      OSP-DB Internal Database Maintenance
   SI61319      OSP-DB Internal Database Maintenance
   SI61218      OSP-DB-OTHER-F/DBOPSTRATEGY-T/QQQOOODBOP-MSGMCH3203 F/DBOPST
   SI61218      OSP-DB-MSGMCH3203 f/DbopAffinity t/QQQOOODBOP running GROUP
   SI60937      OSP-DB-OTHER-MSGQRY2283 A MSGQRY2283 MAY OCCUR WITH A QUERY/
   SI60389      OSP-DB Internal Database Maintenance
   SI60010      OSP-DB Internal Database Maintenance
   SI59734      OSP-LOOP CREATE FUNCTION WITH NESTED REPLACE LOOPS
   SI59686      OSP-DB-UNPRED-MSGMCH3402 clear_plan_cache stored procedure
   SI59272      OSP-DB Internal Database Maintenance
   SI59090      OSP-DB Internal Database Maintenance
   SI59060      OSP-DB-OTHER-F/ASSERT-T/QQQOOOINV-MSGMCH3203 SQL FAILING WIT
   SI58154      OSP-DB-OTHER Query INI Option ALLOW_EVI_ONLY_ACCESS support
   SI58094      OSP-DB-MSGSQL0443 MCH1210 When Visual Explaining a query wit
   SI58069      OSP-DB-OTHER Query INI Option ALLOW_EVI_ONLY_ACCESS support
   SI57944      OSP-DB-OTHER Query INI Option ALLOW_EVI_ONLY_ACCESS support
   SI57926      OSP-DB-OTHER ALLOW TEMPORARY INDEXES BY DEFAULT FOR OPNQRYF
   SI57913      OSP-OTHER-PERFM A QUERY WITH A RECURSIVE COMMON TABLE EXPRES
   SI57337      OSP-DB-OTHER-INCORROUT TRIGGER BUFFER HAS INCONSISTENT ENCOD
   SI57184      OSP PERFORMANCE DEGRADATION SENDING STATUS MESSAGES WHEN SCR
   SI57121      OSP-DB-INCORROUT OPNQRYF OUTPUT MISSING RECORDS
   SI56543      OSP-DB - SUPPORT SHARED AND PUBLIC MEMORY POOL NAMES IN QAQQ
   SI56209      OSP-DB-OTHER Add Index Not Used list to VE
   SI55636      OSP-DB-MSGMCH3601 F/QQQOOODBOP T/QQQOOODBOP OPNQRYF of Logic
   SI55505      OSP-QQ-RUN Change to debug program
   SI55415      OSP-DB Incremental Enhancement
   SI55377      LIC-PERFM QUERIES AT R710 ARE RUNNING SLOWER UNLESS THE INLI
   SI54733      OSP-DB database monitor fixes for the STRDBMON HOSTVAR parm.
   SI54674      LIC-DB-PERFM Enable Pessimistic IO costing for Index Probe a
   SI54594      OSP-DB-OTHER-F/MNRESOLVECONTEXT-T/QQQVWCMP-MSGMCH3401 CANNOT
   SI54594      OSP-DB database monitor service option for the 3010 record
   SI54318      OSP-DB-OTHER Add QRO Hash to Visual Explain.
   SI54312      OSP-DB-INCORROUT Update or insert incorrectly allowed for op
   SI54154      OSP-MSGCPF2189-D/TQQQOOOPLNC ATTEMPTING TO RUN VISUAL EXPLAI
   SI54016      OSP-DB-MSGMCH3203 f/DbopQuery t/QQQOOODBOP for native open o
   SI53924      OSP-DB-OTHER-F/QDBGETM-T/DBPMNATIVEACCESS-MSGMCH1825 ON A _R
   SI53924      OSP-DB-MSGSQL0952 Process termination running SQL GROUP BY q
   SI53245      OSP-DB SOME FUNCTIONS IN VISUAL EXPLAIN MAY FAIL IF AN INDEX
   SI53139      OSP-DB-RUN Additional Plan Cache Properties
   SI53132      OSP-DB Internal Database Maintenance
   SI53059      OSP-DB-RUN Plan Cache Snapshot Does Not Default to QTEMP
   SI53023      OSP-DB Internal Database Maintenance
   SI52879      OSP-DB-OTHER-INCORROUT SUBSTITUTION CHARACTER X'00' USED INS
   SI52817      OSP-DB Internal Database Maintenance
   SI52727      OSP-DB Internal Database Maintenance
   SI52584      OSP-DB Internal Database Maintenance
   SI52442      OSP-DB Internal Database Maintenance
   SI52288      OSP-DB SQL Internal support for RCAC, dump permissions and m
   SI52236      OSP-DB Internal Database Maintenance
   SI51862      OSP-DB Internal Database Maintenance
   SI51696      OSP-DB Internal Database Maintenance
   SI51665      OSP-DB Internal Database Maintenance
   SI51630      OSP-DB Internal Database Maintenance
   SI51475      OSP-DB Internal Database Maintenance
   SI51411      OSP-DB Internal Database Maintenance
   SI51243      OSP-DB Internal Database Maintenance
   SI52911      OSP-DB-OTHER Change Plan Cache Snapshots creation to avoid j
   SI51359      OSP-DB INTERNAL MAINTENANCE
   SI52740      OSP-DB-OTHER-F/RMSLLOCKMIOBJECT-T/QDBOPEN-MSGMCH5802 QDBSRV
   SI52740      OSP-DB-RUN Plan Cache Event Monitor Cannot be Ended
   SI52740      OSP-DB Internal maintainence
   SI52289      OSP-DB SQL Internal support for RCAC, dump permissions and m

Summary Information

System.............................. i
Models..............................
Release............................. V7R2M0
Licensed Program............... 5770SS1
APAR Fixed.......................... View details for APAR SE74219
Superseded by:......................
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 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"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2","Product":{"code":"SG15V","label":"PTF Cover Letters - IBM i General"},"Component":"5770SS1","Edition":""},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2","Product":{"code":"SG16F","label":"PTF Cover Letters - IBM i 7.2"},"Component":"5770SS1","Edition":""}]

Document Information

Modified date:
21 March 2021