IBM Support

SI55006 - OSP-DB JOURNAL AUDIT ENTRY 'OW' OBJ INFO NOT SET FOR SQL PAC

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB JOURNAL AUDIT ENTRY 'OW' OBJ INFO NOT SET FOR SQL PAC


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
CO   5770SS1  710  SI47379   00/00    0000
CO   5770SS1  710  SI40609   00/00    0000
CO   5770SS1  710  SI40610   00/00    0000
CO   5770SS1  710  SI40612   00/00    0000
CO   5770SS1  710  SI40613   00/00    0000
CO   5770SS1  710  SI40757   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

-----------------------------------------------
Object information not filled in for OW audit entry on behalf of
SQL package creation.  There exists an 'OW' record prior that
does have the object information set correctly.

CORRECTION FOR APAR SE60381 :
-----------------------------
Removed the errant 'OW' audit entry generated by QSQSCPKG.

CIRCUMVENTION FOR APAR SE60381 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI50370      OSP DB-TERASPACE STORAGE LEAK IN QSQSCPKG CAUSING SQL0901 IN
   SI49911      OSP-DB-MSGMCH3602-T/-QSQSCPKG CRTSQLPKG FAILURE TO DESS DUE
   SI49395      OSP-DB HETEROGENEOUS BIND WITH TIME SEPARATOR INCORRECT FOR
   SI49090      OSP-DB HETEROGENEOUS BIND WITH TIME FORMAT INCORRECT FOR HMS
   SI48128      OSP-DB INTERNAL MAINTENANCE
   SI47580      OSP-DB-OTHER-MSGMCH3601 MCH3601 FOR PRTSQLINF
   SI47380      OSP-DB AUTO-CREATE NULLID SCHEMA QSYS OWNER AT EXECUTE
   SI47100      OSP-DB-MSGSQL0551 QSQLPKG2 PACKAGE PUBLIC *EXCLUDE AUTHORITY
   SI47049      OSP-DB-MSGSQL0551 DB2 FOR LUW CLI NULLID PACKAGES PUBLIC *EX
   SI45893      OSP-DB Internal Maintenance
   SI43550      OSP-DB-INCORROUT-MSGSQL0901-F/QSQICPKG
   SI43341      OSP-DB-MSGMCH3601-F/QRWSBIND HETRO DYNAMIC PACKAGE CREATION
   SI42873      OSP-DB-UNPRED Internal DRDA Maintenance
   SI42666      OSP-DB-MSGSQL0805 DRDA HETRO CNN QZD PACKAGES NOT FOUND OR C
   SI42262      OSP-DB-OTHER-F/QTNEND-T/QWTPITP2-RC01-MSGCPI8352 F/QTNEND T/
   SI41337      OSP-DB-UNPRED Auto create NULLID packages if not found
   SI41009      OSP-DB-UNPRED DRDA package creation fails
   SI40611      OSP-DB-UNPRED Three part alias statement rewrite
   SI40563      OSP-DB-INCORROUT Expressions in CALL Support
   SI40373      OSP-DB-UNPRED SQL procedures using DRDA selecting wrong pack
   SI38016      OSP-DB Internal Maintenance
   SI37172      OSP-DB-UNPRED Implicit package creation
   SI37137      OSP-DB Internal Maintenance
   SI36816      OSP-DB Arrays over DRDA
   SI36769      OSP-DB Arrays over DRDA
   SI36660      OSP-DB-UNPRED DRDA errors
   SI36586      OSP-DB-UNPRED Server mode error handling
   SI43807      OSP-DB-OTHER-F/QIZAECVN-T/QUIMNDRV-MSGCPDB0E2 STROBJCVN AND
   SI36960      OSP-DB-T/QSQEXPLN-MSGMCH1210 DURING STROBJCVN

Summary Information

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


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

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1","Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"5770SS1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
13 August 2020