PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB INTERNAL MAINTENANCE
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
PRE 5770SS1 V7R3M0 SI68007 00/00 0000
PRE 5770999 V7R3M0 MF63670 00/00 0000
PRE 5770SS1 V7R3M0 SI65428 00/00 0000
PRE 5770SS1 V7R3M0 SI67582 00/00 0000
PRE 5770SS1 V7R3M0 SI67304 00/00 0000
PRE 5770SS1 V7R3M0 SI64302 00/00 0000
PRE 5770SS1 V7R3M0 SI65393 00/00 0000
PRE 5770SS1 V7R3M0 SI63976 00/00 0000
PRE 5770SS1 V7R3M0 SI63604 00/00 0000
PRE 5770SS1 V7R3M0 SI60221 00/00 0000
PRE 5770SS1 V7R3M0 SI61160 00/00 0000
CO 5770SS1 V7R3M0 SI68504 00/00 0000
CO 5770SS1 V7R3M0 SI68506 00/00 0000
CO 5770SS1 V7R3M0 SI67475 00/00 0000
CO 5770SS1 V7R3M0 SI59638 00/00 0000
DIST 5770SS1 V7R3M0 SI67728 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
-----------------------------------------------
OSP-DB INTERNAL MAINTENANCE
CORRECTION FOR APAR SE70671 :
-----------------------------
OSP-DB INTERNAL MAINTENANCE
CIRCUMVENTION FOR APAR SE70671 :
--------------------------------
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
-------------- ------------------------------------------------------------
SI61175 OSP-DB Add prestart job detail to QSYS2.GET_JOB_INFO()
SI68914 SQL-RUN-F/QDBSSUDF2-T/QDBSSUDF2-MSGMCH3601 IN A SYSTEM WITHO
SI68828 OSP-DB INTERNAL MAINTENANCE
SI68760 OSP-DB INTERNAL MAINTENANCE
SI68720 OSP-DB-OTHER-MSGSQL0206
SI68686 OSP-DB INCORROUT OBJECT_PRIVILEGES SERVICE
SI68585 OSP-DB-OTHER-F/QmExtend-T/QYASPOL-MSGMCH2804 ASP_INFO PROBLE
SI68585 OSP-DB-OTHER-F/QSQSBAS-T/QSQSBAS-MSGMCH3601 IASP RCLSTG SELE
SI68535 OSP-DB Handle failures in QSYS2/PTF_INFO
SI68508 OSP-DB-OTHER-UNPRED APYJRNCHG IGNORES CHGPF MAXMBRS AND ADDP
SI68495 OSP-DB-OTHER ACTIVE_JOB_INFO INCORRECT INFORMATION RETURNED
SI68454 OSP-DB-OTHER-INCORROUT OBJECT_STATISTICS RETURNS SQL0100 WHE
SI68435 OSP-OTHER-INCORROUT PLAN CACHE SNAPSHOT DISPLAY IS INCORRECT
SI68413 OSP-DB INTERNAL MAINTENANCE
SI68356 OSP-DB-PERFM IASP VARY ON
SI68171 OSP-DB-OTHER ASP_INFO INCORRECT INFORMATION RETURNED
SI68171 OSP-DB QSQSQLCAT BETTER HANDLE INVALID IASP PARAMETER
SI68135 SP/QSQSBAS2-MSGMCH0601-MOD/QSQUDFDG SHOWING INDEX VIA ACS WH
SI68121 SP/QSQSBAS2-MSGMCH0601-MOD/QSQUDFDG SHOWING INDEX VIA ACS WH
SI68008 OSP-DB INTERNAL MAINTENANCE
SI68008 OSP-DB INTERNAL MAINTENANCE
SI67858 OSP-F/QDBIOERRQO-T/QSQRUN3-RC17-MSGCPF5035 CPF5035 F/QDBIOER
SI67858 OSP-DB QSYS2.SYSDISKSTAT IS RETURNING A BINARY VALUE (X'01')
SI67723 OSP-DB-OTHER-INCORROUT QUERYING THE SQL VIEW QSYS2.MESSAGE_Q
SI67584 OSP-DB Improve SYSPROC.SYSAUDIT_START_BATCH
SI67584 OSP-DB-OTHER-F/QDBSSUDF2-T/QDBSSUDF2-MSGMCH1210 FROM QSYS2.D
SI67474 OSP-DB-OTHER-RC1-MSGCPF503E GET_BLOB_FROM_FILE FAILS WHEN FI
SI67460 OSP-DB HISTORY_LOG_INFO SYSLOG_EVENT
SI67301 OSP-DB INTERNAL MAINTENANCE
SI67300 OSP-DB Improve error handling for QSYS2.AUTHORIZATION_LIST_I
SI67249 OSP-DB INDEX ADVICE SQL SERVICE UPDATE
SI67126 OSP-DB-OTHER-MSGSQL0206
SI67124 OSP-DB INTERNAL MAINTENANCE
SI66942 OSP-DB INTERNAL MAINTENANCE
SI66931 OSP-DB-OTHER-INCORROUT INCORROUT ON SOME PRODUCTS FOR THE PT
SI66810 OSP-DB Add transaction column to SYSPARTITIONSTAT
SI66628 OSP-DB ENHANCE NETSTAT SERVICES ERROR DATA CAPTURE
SI66611 OSP-DB QSYS2.USER_INFO internal change
SI66558 OSP-DB ENHANCE NETSTAT SERVICES ERROR DATA CAPTURE
SI66521 OSP-DB Internal Maintenance
SI66513 OSP-DB-OTHER-F/QDBRGZPF-MSGCPF3181 RGZPFM ON QSYS2/SYSAUDIT
SI65375 OSP-DB INTERNAL MAINTENANCE
SI65351 OSP-DB-OTHER-F/QSQRUN3X/19728-T/T/QSQRUN3X/19728-MSGSQL0607
SI64452 OSP-DB INTERNAL MAINTENANCE
SI60129 OSP-DB INTERNAL MAINTENANCE
SI59196 OSP-DB-OTHER-F/QSQRUN4-T/QSQRUN4X/42334-MSGSQL0443 INAV SHOW
SI58531 OSP-DB-INCORROUT-MSGMCH0601 QSQPDMON Proc/getmsgrsn
SI66466 OSP-DB INTERNAL MAINTENANCE
SI66425 OSP-INCORROUT Update QPM_QAPMCONF function table as the upda
SI66408 OSP-DB QSYS2.JVM_INFO RETURNS NULL FOR JAVA_THREAD_COUNT WHE
SI66119 OSP-DB-Improve install asynchronous processing
SI66107 OSP-DB ENHANCE NETSTAT SERVICES PORT NAME SUPPORT
SI65941 OSP-DB INTERNAL MAINTENANCE
SI65923 OSP-DB INTERNAL MAINTENANCE
SI65870 OSP-DB Internal Maintenance
SI65829 OSP-DB INTERNAL MAINTENANCE
SI65820 OSP-DB NEW STACK_INFO SERVICE
SI65812 OSP-DB INTERNAL MAINTENANCE
SI65799 OSP-DB INTERNAL MAINTENANCE
SI65772 OSP-DB-OTHER-INCORROUT QSYS2.OUTPUT_QUEUE_ENTRIES SERVICE GI
SI65772 OSP-OTHER-F/QDMSIGNL-T/QDBSSUDF-RC01-MSGCPF4101 SQL QUERY OF
SI65733 OSP-DB-OTHER-MSGSQL0205 S-TAP UPGRADE. SQL0205 F/QSQRUN3 COL
SI65695 OSP-DB CATALOG FIX FOR BLANK ROUTINE NAMES
SI65695 OSP-DB INTERNAL MAINTENANCE
SI65582 OSP-DB-OTHER-INCORROUT INCORROUT FOR IASP WHEN USING QSYS2/U
SI65396 OSP-DB INTERNAL MAINTENANCE
SI65396 OSP-DB INTERNAL MAINTENANCE
SI65372 OSP-DB NEW JOB_QUEUE_INFO SERVICE
SI65235 OSP-DB-OTHER *SHRRD lock left on library after select from O
SI65119 OSP-OTHER-F/SV14CKP-T/QSYAUTCOL-MSGMCH3402 SQL OVER AUTHORIT
SI65021 OSP-DB-PERFM Improved performance of USER_INFO catalog
SI64997 OSP-DB QSYS2/PTF_INFO supersede detail
SI64961 OSP-DB INTERNAL MAINTENANCE
SI64957 OSP-DB INTERNAL MAINTENANCE
SI64938 OSP-DB-OTHER-UNPRED A QUERY OF QSYS2/OBJECT_PRIVILEGES MAY R
SI64770 OSP-MSGSQL0443 QUERY AGAINST QSYS2.DISPLAY_JOURNAL RESULTS I
SI64506 OSP-DB GROUP_PTF_CURRENCY fails with PSP INFORMATION NOT AVA
SI64460 OSP-DB Add check for SYSTOOLS objects to QSQIBMCHK
SI64448 OSP-DB JOB_INFO should issue error for filter combination
SI64392 OSP-DB INTERNAL MAINTENANCE
SI64280 OSP-DB OBJECT_PRIVILEGES performance
SI64112 OSP-DB Updates for SYSTOOLS not happening in CCSID 290
SI64005 OSP-DB PARSE_STATEMENT table function returning delimited na
SI64005 OSP-DB SQL services not updated in SYSTOOLS on IGC system
SI63979 OSP-DB INTERNAL MAINTENACE
SI63887 OSP-DB INCORROUT FROM NETSTAT_INTERFACE_INFO FOR PROXY_ARP_E
SI63745 OSP-Special case unnecessary authority collection entries
SI63745 OSP-DB INTERNAL MAINTENANCE
SI63745 OSP-DB INTERNAL MAINTENANCE
SI63745 OSP-DB INTERNAL MAINTENANCE
SI63745 OSP-DB INTERNAL MAINTENANCE
SI63633 OSP-DB Internal Maintenance
SI63510 OSP-F/QDBIOERRQO-T/QDBIOERRQO-RC1-MSGCPF503E CPF503E RC1 ON
SI63500 OSP-DB INTERNAL MAINTENANCE
SI63429 OSP-DB INTERNAL MAINTENANCE
SI63384 OSP-DB INTERNAL MAINTENANCE
SI63191 OSP-WAIT THIS IS AN ENHANCEMENT FIX SO THAT IF AN ENDJOB *IM
SI62743 OSP-DB-F/QSQFETCH-MSGSQL0904 Reading File Using QSQGTXML, QS
SI63125 OSP-DB MSGMCH3601-QDBSSUDF-QSQJOBINFO querying JOB_INFO
SI62888 OSP-DB INTERNAL MAINTENANCE
SI62794 OSP-DB SYSTOOLS/HTTP FUNCTIONS ARE DOING CASE SENSITIVE COMP
SI62764 OSP-DB-OTHER-LOOP LOOP WITH QDBRGZMV CALLING QDMCOPEN WITH B
SI62764 OSP-DB INTERNAL MAINTENANCE
SI62728 OSP-DB INTERNAL MAINTENANCE
SI62493 OSP-DB INTERNAL MAINTENANCE
SI62493 OSP-DB Running QSQSQLCAT tool may fill job message queue and
SI62441 OSP-DB INTERNAL MAINTENANCE
SI62264 OSP-DB INTERNAL MAINTENANCE
SI62192 OSP-DB Change QSYS2/DISPLAY_JOURNAL() to apply RCAC
SI62047 OSP-DB Internal maintenance
SI61996 OSP-DB INTERNAL MAINTENANCE
SI61966 OSP-DB-PERMF Improve the performance of QSYS2/OBJECT_LOCK_IN
SI61892 OSP-DB INTERNAL MAINTENANCE
SI61626 OSP-DB INTERNAL MAINTENANCE
SI61553 OSP-DB-PERMF Improve the performance of QSYS2/OBJECT_LOCK_IN
SI61271 OSP-DB Improve SYSTOOLS.GROUP_PTF_CURRENCY for pending appli
SI61225 OSP-DB INTERNAL MAINTENANCE
SI61173 OSP-DB Add prestart job detail to QSYS2.GET_JOB_INFO()
SI60972 OSP-DB INTERNAL MAINTENANCE
SI60964 OSP-DB-OTHER-INCORROUT Plan Cache VE is showing 0 for rows f
SI60888 OSP-DB INTERNAL MAINTENANCE
SI60779 OSP-DB SQL SHIPPED OBJECTS SHOULD BE OWNED BY QSYS
SI60759 OSP-DB-OTHER-INCORROUT Plan Cache VE is showing 0 for rows f
SI60738 OSP-DB INFRASTRUCTURE
SI60409 OSP-DB-OTHER-F/QSQCRTV-T/QSQCRTV-MSGSQL0204 CALL QSYS2/QSQXR
SI60281 OSP-DB INCREASE JOBLOG_INFO.MESSAGE_TOKENS to 2048
SI60127 OSP-DB INTERNAL MAINTENANCE
SI60101 OSP-DB-OTHER-INCORROUT HTTP FUNCTIONS USE JDBC CONNECTION
SI60033 OSP-DB INTERNAL MAINTENANCE
SI60033 OSP-DB Add PROCESS_ID and THREAD_ID global variables
SI59923 OSP-DB INTERNAL MAINTENANCE
SI59826 OSP-DB INTERNAL MAINTENANCE
SI59659 OSP-DB INTERNAL MAINTENANCE
SI59659 OSP-DB NETSTAT SERVICES ADD NEW COLUMNS
SI59606 OSP-DB Internal Maintenance
SI59606 OSP-DB Add QSYS2.ENVIRONMENT_VARIABLE_INFO service
SI59395 OSP-DB Add PROCESS_ID and THREAD_ID global variables
SI59270 OSP-DB ADD columns to QSYS2/SYSLIMITS
SI59144 OSP-DB internal maintenance
SI59077 OSP-DB-OTHER-INCORROUT SQL...COL JDBC types incorrect
SI58945 OSP-DB INTERNAL MAINTAINANCE
SI58945 OSP-DB INTERNAL MAINTENANCE
SI58919 OSP-DB ADD columns to QSYS2/SYSLIMITS
SI58803 OSP-DB INFRASTRUCTURE
SI58794 OSP-DB INTERNAL MAINTENANCE
SI58757 OSP-DB Internal maintenance
SI58591 OSP-DB INTERNAL MAINTENANCE
SI58577 OSP-DB INTERNAL MAINTENANCE
SI58549 OSP-DB INTERNAL MAINTENANCE
SI58540 OSP-DB INTERNAL MAINTENANCE
SI58540 OSP-DB INTERNAL MAINTENANCE
SI58540 OSP-DB-OTHER-INCORROUT SQLTYPEINFO JDBC types incorrect
SI58540 OSP-DB-MSGCPD439C Function INDEX_PARTITION_STATISTICS not fo
SI58540 OSP-DB-MSGCPF3D95 Vary on of iASP
SI58540 OSP-DB INTERNAL MAINTENANCE
SI58540 OSP-DB-OTHER-MSGSQL4302 MSGSQL4302 FOR HTTPPOSTCLOB WITH CON
SI62635 OSP-DB INTERNAL MAINTENANCE
SI62626 OSP-DB INTERNAL MAINTENANCE
SI62563 OSP-DB INTERNAL MAINTENANCE
SI62454 OSP-DB-OTHER-INCORROUT GARBAGE TEXT RETURNED FROM SYSPROGRAM
SI62292 OSP-DB INTERNAL MAINTENANCE
SI62265 OSP-DB INTERNAL MAINTENANCE
SI62265 OSP-DB new service for job info
SI62137 OSP-DB Change QSYS2/DISPLAY_JOURNAL() to apply RCAC
SI62135 OSP-DB INTERNAL MAINTENANCE
SI61891 OSP-DB INTERNAL MAINTENANCE
SI61884 OSP-DB MAINTAINED_TEMPORARY_INDEX_SIZE not set in DB2 catalo
SI61637 OSP-DB INTERNAL MAINTENANCE
SI61554 OSP-DB-PERMF Improve the performance of QSYS2/OBJECT_LOCK_IN
SI61226 OSP-DB INTERNAL MAINTENANCE
SI61210 OSP-DB Object_Lock_Info Thread_ID Output Not Set
SI60887 OSP-DB INTERNAL MAINTENANCE
SI60582 OSP-DB-INCORROUT Guardium audit journal capture and FTRFILE
SI60291 OSP-DB-MSGCPF3063 Attempting to start the Guardium Audit ser
SI60282 OSP-DB SP/QDBSSUDF2-MSGSQL0802-MOD/QSQJOBLOG
SI60282 OSP-AUTHORITY_COLLECTION UDTF fails when damaged index
SI60266 OSP-DB subsystem routing problem
SI60128 OSP-DB INTERNAL MAINTENANCE
SI60032 OSP-DB INTERNAL MAINTENANCE
SI59924 OSP-DB INTERNAL MAINTENANCE
SI59660 OSP-DB INTERNAL MAINTENANCE
SI59607 OSP-DB Internal Maintenance
SI59484 OSP-DB INTERNAL MAINTENANCE
SI59484 OSP-DB-MSGSQL0443 Journal Entry Not Compatible With Table
SI59202 OSP MCH3402 in joblog of AUTHORITY_COLLECTION table function
SI59142 OSP-DB OBJECT_STATISTICS returns *INTLIB for object type of
SI59069 OSP-DB INTERNAL MAINTENANCE
SI58944 OSP-DB INTERNAL MAINTENANCE
SI58870 OSP-MCH3402 from AUTHORITY_COLLECTION Table Function
SI58773 OSP-DB QSYS2/PTF_INFO detail incorrect
SI58758 OSP-DB Internal maintenance
SI58679 OSP Authority Collection Absolute Path Indicator field
SI58679 OSP-DB Guardium install failure
SI58608 OSP-DB NETSTAT SERVICES ERROR
SI58548 OSP-DB-INCORROUT SYSPARTITIONSTAT catalog lacks range detail
SI58526 OSP-DB INTERNAL MAINTENANCE
SI58526 OSP-DB-PERFM Fix memory leak in QSYS2/JVM_INFO
SI58526 OSP-DB-OTHER-MSGMCH3601-T/QSQRUN3 PROCEDURE GETUFCB
Summary Information
System.............................. i
Models..............................
Release............................. V7R3M0
Licensed Program.................... 5770SS1
APAR Fixed.......................... View details for APAR SE70671
Superseded by:...................... View fix details for PTF SI85870
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C9311730
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, 2022, 2023, 2024 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.
Was this topic helpful?
Document Information
Modified date:
13 March 2024