IBM Support

MF64647 - LIC-DB-OTHER-F/QRCDMGLG-T/QSYSOPR-MSGCPF8174 Full damage on

PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

LIC-DB-OTHER-F/QRCDMGLG-T/QSYSOPR-MSGCPF8174 Full damage on


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
CO   5770999  V7R2M0    MF64648   00/00    0000
CO   5770999  V7R2M0    MF64033   00/00    0000
CO   5770999  V7R2M0    MF64034   00/00    0000
CO   5770999  V7R2M0    MF63415   00/00    0000
CO   5770999  V7R2M0    MF63293   00/00    0000
CO   5770999  V7R2M0    MF59488   00/00    0000
CO   5770999  V7R2M0    MF59489   00/00    0000
CO   5770999  V7R2M0    MF58281   00/00    0000
CO   5770999  V7R2M0    MF57657   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 'IBM License Agreement for Machine
Code', the terms of which were provided in a printed document that was
delivered with the machine.

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.





APAR Error Description / Circumvention

-----------------------------------------------
The VERIFY_GROUP_FOR_USER() scalar function implementation
searches the authorized user table for the specified user or
group profile.  Serialization of that access was incomplete, so
a search while there is a concurrent update to that table can
result in the table being damaged.

CORRECTION FOR APAR MA46906 :
-----------------------------
The VERIFY_GROUP_FOR_USER() scalar function implementation was
updated to perform the correct serialization of the authorized
user table.

CIRCUMVENTION FOR APAR MA46906 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF64495      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF64035      LIC-DB Internal Maintenance
   MF64030      OSP-F/DBPMTRAP-T/QQQOOODBOP-RC1720-MSGMCH3203 SQL FAILS WITH
   MF63806      LIC-DB-PERFM reduce data copies for SQL query
   MF63442      OSP Update XLATEMB MI instruction to enable support for CCSI
   MF63413      OSP-DB-OTHER-MSGCPI0999 XMLAGG QUERIES MAY RESULT IN LARGE A
   MF63292      LIC-DB Internal Maintenance
   MF59725      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF62454      F/00000 WANTING TO USE &#10 IN XML ATTRIBUTES
   MF59119      QRY-QRYCPY-INCORROUT A PROBLEM HAS BEEN FOUND IN SQE PACKED
   MF61092      LIC-DB-OTHER-SRCB6005121-UNPRED Stack overflow caused by Dbp
   MF60456      LIC-DB Allow UTF-16 casing map
   MF60240      LIC-DB Allow UTF-16 casing map
   MF62505      LIC-DB-OTHER-PERFM Performance of large LPAD and RPAD operat
   MF62254      LIC-DB-OTHER Internal database maintenance
   MF62226      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF61240      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF60676      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF60414      OSP-DB-OTHER-F/DBPMBINARYOPERATION-T/QQQOOOINVX/4957-MSGMCH3
   MF60310      OSP-DB-OTHER-INCORROUT RUNQRY SHOW '+' INSTEAD OF DATA. RESU
   MF59490      LIC-DB-OTHER-PERFM Performance improvements for SQE EVI Acce
   MF58959      OSP-DB-OTHER-INCORROUT A QUERY WITH A -CAST(-2147483648 AS I
   MF58818      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF58712      OSP-DB-OTHER-INCORROUT Round, ceiling and floor may produce
   MF58366      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF58279      LIC-DB-OTHER-UNPRED Internal Database Maintenance
   MF57655      LIC-DB-OTHER-UNPRED Internal Database Maintenance

Summary Information

System.............................. i
Models..............................
Release............................. V7R2M0
Licensed Program............... 5770999
APAR Fixed.......................... View details for APAR MA46906
Superseded by:...................... View fix details for PTF MF65139
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C8249720


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.

Document information

More support for: i family

Software version: V7R2M0

Operating system(s): OS/400

Reference #: MF64647

Modified date: 09 March 2018