IBM Support

SI70889 - OSP-DB SQL JOBLOG_INFO SERVICE ENHANCEMENT

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB SQL JOBLOG_INFO SERVICE ENHANCEMENT


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED           PTF/FIX  LEVEL

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770SS1  V7R4M0    SI70757   00/00    0000
PRE  5770SS1  V7R4M0    SI70371   00/00    0000
PRE  5770999  V7R4M0    MF66399   00/00    0000
CO   5770SS1  V7R4M0    SI70705   00/00    0000
CO   5770SS1  V7R4M0    SI70078   00/00    0000
CO   5770SS1  V7R4M0    SI69755   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

-----------------------------------------------
When a user is not authorized to access a job or a job is not
found, the QSYS2.JOBLOG_INFO table function will return an error
condition.

An authorization problem is returned as SQLCODE 42501.
A job not found is returned as SQLCODE 42704.

This behavior is working as designed.

For some use cases, it would be better to return a warning
condition rather than an error condition for these situations.
This PTF provides an enhancement to allow this different
behavior.

CORRECTION FOR APAR SE71847 :
-----------------------------
The QSYS2.JOBLOG_INFO table function has been modified so that
an optional second parameter named IGNORE_ERRORS has been added.
The default value of the parameter is 'NO', which means that an
error condition will occur when the job cannot be accessed. If
this parameter is specified with a value of 'YES', a warning
condition will instead occur when the job cannot be accessed.

An authorization problem is returned as warning SQLCODE 01548.
A job not found is returned as warning SQLCODE 01532.

CIRCUMVENTION FOR APAR SE71847 :
--------------------------------
None.


DESCRIPTION OF PROBLEM FIXED FOR APAR SE72015 :
-----------------------------------------------
When a user is not authorized to access a job or a job is not
found, the QSYS2.JOBLOG_INFO table function will return an error
condition.

An authorization problem is returned as SQLCODE 42501.
A job not found is returned as SQLCODE 42704.

This behavior is working as designed.

For some use cases, it would be better to return a warning
condition rather than an error condition for these situations.
This PTF provides an enhancement to allow this different
behavior.

CORRECTION FOR APAR SE72015 :
-----------------------------
The QSYS2.JOBLOG_INFO table function has been modified so that
an optional second parameter named IGNORE_ERRORS has been added.
The default value of the parameter is 'NO', which means that an
error condition will occur when the job cannot be accessed. If
this parameter is specified with a value of 'YES', a warning
condition will instead occur when the job cannot be accessed.

An authorization problem is returned as warning SQLCODE 01548.
A job not found is returned as warning SQLCODE 01532.

CIRCUMVENTION FOR APAR SE72015 :
--------------------------------
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
--------------  ------------------------------------------------------------
   SI70756      OSP-DB-F/QQQSVRTN-T/QQQSVRTN-MSGMCH3601 SELECT FROM VIEW FAI
   SI70752      OSP-DB RGZPFM during mirror resync fails with CPF2995
   SI70713      OSP-DB2MIRROR-MSGSQL0443 While attempting MIRROR_COMPARE_OBJ
   SI70704      OSP-DB2MIRROR Incorrect parallel degree value allowed
   SI70694      OSP-DB INTERNAL MAINTENANCE
   SI70635      OSP-DB-UNPRED RGZPFM ALWCANCEL(*YES) with Db2 Mirror leaves
   SI70590      OSP-DB-INTERNAL MAINTENANCE
   SI70576      OSP-DB-INTERNAL MAINTENANCE
   SI70373      OSP-DB Add resync category to Db2 Mirror flight recorder
   SI70373      OSP-DB-INCORROUT SQL CATALOGS AND SERVICES INCORRECT COLUMN
   SI70373      SQL-RUN-INCORROUT PARSE_STATEMENT FUNCTION RETURNS WRONG VAL
   SI70373      OSP-DB SQL MESSAGE_FILE_DATA SERVICE ERROR
   SI70350      OSP-DB-UNPRED RGZPFM ALWCANCEL(*YES) with Db2 Mirror leaves
   SI70344      OSP-DB INCORROUT SQL SERVICE UPDATES
   SI70344      OSP-DB INCORROUT OBJECT_PRIVILEGES SERVICE
   SI70281      OSP-DB-OTHER SQL CATALOG OR SERVICE NOT FOUND ON RESTORE
   SI70226      OSP-DB-UNPRED RGZPFM ALWCANCEL(*YES) causes out of sync when
   SI70139      OSP-DB INTERNAL MAINTENANCE
   SI70069      OSP-DB INTERNAL MAINTENANCE
   SI70015      OSP-DB INTERNAL MAINTENANCE SQL SERVICE(IFS)
   SI69897      OSP-DB INCORROUT SQL SERVICE UPDATES
   SI69846      OSP-DB INTERNAL MAINTENANCE
   SI69757      OSP-DB2MIRROR INTERNAL MAINTENANCE
   SI69670      OSP-DB INTERNAL MAINTENANCE
   SI69602      OSP-DB INTERNAL MAINTENANCE
   SI69594      OSP-DB-OTHER SQL OVER QSYS2.MEDIA_LIBRARY_INFO WILL SOMETIME
   SI69526      OSP-DB INTERNAL MAINTENANCE
   SI69408      OSP-DB-INTERNAL MAINTENANCE
   SI69352      OSP-DB INTERNAL MAINTENANCE
   SI69352      OSP-DB-OTHER-UNPRED SQL LOGGER FILE QSQ901S
   SI69341      OSP-DB Internal Maintenance
   SI69216      OSP-DB INTERNAL MAINTENANCE
   SI69717      OSP-OTHER-T/QSYAUTCOL-MSGMCH3411 Running AUTHORITY_COLLECTIO
   SI70148      OSP-DB Incremental Enhancement
   SI70337      OSP-DB2MIRROR INTERNAL MAINTENANCE
   SI70279      OSP-DB2MIRROR INTERNAL MAINTENANCE
   SI70077      OSP-DB2MIRROR INTERNAL MAINTENANCE
   SI69754      OSP-DB2MIRROR INTERNAL MAINTENANCE
   SI69754      OSP-DB2MIRROR INTERNAL MAINTENANCE
   SI69296      OSP-DB2MIRROR INTERNAL MAINTENANCE
   SI69296      OSP-DB2MIRROR INTERNAL MAINTENANCE

Summary Information

System..............................i
Models..............................
Release.............................V7R4M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE71847
View details for APAR SE72015
Superseded by:......................View fix details for PTF SI75255
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C0121740


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.4","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.4","Product":{"code":"SS9QQS","label":"IBM i 7.4"},"Component":"5770SS1","Edition":""}]

Document Information

Modified date:
05 March 2021