IBM Support

SI56196 - OSP-DB INTERNAL MAINTENANCE

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB INTERNAL MAINTENANCE


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI56157   00/00    0000
PRE  5770SS1  710  SI55504   00/00    0000
PRE  5770SS1  710  SI55437   00/00    0000
PRE  5770SS1  710  SI54784   00/00    0000
PRE  5770SS1  710  SI54475   00/00    0000
PRE  5770SS1  710  SI53424   00/00    0000
PRE  5770SS1  710  SI49567   00/00    0000
PRE  5770SS1  710  SI49247   00/00    0000
PRE  5770SS1  710  SI48685   00/00    0000
PRE  5770SS1  710  SI48642   00/00    0000
PRE  5770SS1  710  SI45893   00/00    0000
PRE  5770SS1  710  SI45856   00/00    0000
PRE  5770SS1  710  SI45901   00/00    0000
PRE  5770SS1  710  SI46166   00/00    0000
PRE  5770SS1  710  SI43643   00/00    0000
PRE  5770SS1  710  SI43651   00/00    0000
CO   5770SS1  710  SI56195   00/00    0000
CO   5770SS1  710  SI55749   00/00    0000
CO   5770SS1  710  SI54767   00/00    0000
CO   5770SS1  710  SI52625   00/00    0000
CO   5770SS1  710  SI49410   00/00    0000
CO   5770SS1  710  SI49434   00/00    0000
CO   5770SS1  710  SI48847   00/00    0000
CO   5770SS1  710  SI48747   00/00    0000
CO   5770SS1  710  SI44493   00/00    0000
CO   5770SS1  710  SI43510   00/00    0000
CO   5770SS1  710  SI43476   00/00    0000
CO   5770SS1  710  SI42001   00/00    0000
DIST 5770SS1  710  SI53443   00/00    0000
DIST 5770ST1  710  SI43654   NONE     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

-----------------------------------------------
INTERNAL MAINTENANCE

CORRECTION FOR APAR SE61418 :
-----------------------------
INTERNAL MAINTENANCE

CIRCUMVENTION FOR APAR SE61418 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


********************************************************************
THE FOLLOWING ARE SUPERSEDED SPECIAL INSTRUCTIONS. IF THE SUPERSEDED
PTF HAS ALREADY BEEN APPLIED AND ITS SPECIAL INSTRUCTION FOLLOWED,
IT IS NOT NECESSARY TO FOLLOW THAT SPECIAL INSTRUCTION AGAIN.
********************************************************************

SPECIAL INSTRUCTIONS FOR SUPERSEDED PTF SI41819 :
=================================================

When applying this PTF in immediate mode will result in exit program
processing that will drop and recreate DB2 for i supplied objects in
QSYS2, SYSIBM and several other system libraries.  The exit program may
not complete quickly.  It is recommended that when this PTF is applied
in immediate mode, that application which rely upon DB2 for i supplied
objects are quiesced.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI56187      OSP-DB Table Function DATABASE_MONITOR_INFORMATION.
   SI55949      OSP-DB Table Function DATABASE_MONITOR_INFORMATION.
   SI55788      OSP-DB ADD DB2 for i services for Java
   SI55753      OSP-DB-INCORROUT qsys2/syspackagestat system_package_name
   SI55596      OSP-DB INTERNAL MAINTENANCE
   SI55511      OSP-SQ-RUN Support CLEAR_PLAN_CACHE
   SI55438      OSP-DB ROUTING DRDA CONNECTIONS TO USER SPECIFIED SBS BY USE
   SI55371      OSP-DB-OTHER-F/#AUEXCPT-T/QSQSYSIBM/QSQCCSID-MSGMCH1001
   SI55301      OSP-DB INTERNAL MAINTENANCE
   SI54936      OSP-DB JOBLOG_INFO table function
   SI54768      OSP-DB-MSGMCH1210-T/QSQSBAS QSQRCFHT using QSYS2/EXTRACT_STA
   SI54615      OSP-DB ADD SYSTOOLS/GROUP_PTF_CURRENCY VIEW
   SI54598      OSP-DB INTERNAL MAINTENANCE
   SI54492      OSP-DB INTERNAL MAINTENANCE
   SI54146      OSP-DB LIBRARY_LIST_INFO AND REPLY_LIST_INFO views with asso
   SI54099      OSP-DB JOURNAL_INFO view and associated table function
   SI53969      OSP-DB Set internal CCSID for literals correctly for Turkish
   SI53933      OSP-DB INTERNAL MAINTENANCE
   SI53790      OSP-DB ADD Procedures to import plan cache into Navigator
   SI53440      OSP-DB INTERNAL MAINTENANCE
   SI53429      OSP-DB Set internal CCSID for literals correctly for Turkish
   SI53318      OSP-DB Set internal CCSID for literals correctly for Turkish
   SI53158      OSP-DB Add Last Used column to USER_INFO catalog
   SI53090      OSP-DB INTERNAL MAINTENANCE
   SI52885      OSP-DB ENHANCE QSYS2/GET_JOB_INFO
   SI52753      OSP-DB-OTHER-UNPRED INTERNAL MAINTENAINCE
   SI52635      OSP-DB Incremental Enhancement
   SI52496      OSP-DB INTERNAL MAINTENANCE
   SI52267      OSP-DB INTERNAL MAINTENANCE
   SI52002      OSP-DB-PERFM CHANGE SYSLIMTBL PRUNER IMPLEMENTATION
   SI51911      OSP-DB INTERNAL MAINTENANCE
   SI51704      osp-db internal maintenance
   SI51455      osp-db internal maintenance
   SI51455      OSP-DB-Other Enable additional Plan Cache Properties and opt
   SI50967      OSP-DB INTERNAL MAINTENANCE
   SI50805      OSP-DB Enhancements to QSQSYSIBM API
   SI50805      OSP-DB Enhance Database Maintenance Index Build Status
   SI50579      OSP-DB-PERFM Improved Guardium monitoring configuration and
   SI50422      OSP-DB INTERNAL MAINTENANCE
   SI50251      OSP-DB ADD NEW DB2 for i supplied views
   SI50242      OSP-DB-OTHER-F/QSQPROCR-T/QSQPROCR-MSGCPF9898 A MSGCPF9898 F
   SI50200      OSP-DB Internal Maintenance
   SI50152      OSP-DB Internal Maintenance
   SI49960      OSP-DB Improved QSYS2/DISPLAY_JOURNAL UDTF
   SI49960      OSP-DB INTERNAL MAINTENANCE
   SI49883      OSP-DB-OTHER-F/QQQVALID-T/QSQCRTV-MSGCPD4381 QSQSYSIBM USES
   SI49854      OSP-DB ADD NEW DB2 for i privilege catalogs
   SI49730      OSP-DB-MSGMCH0601-T/QSQCCATV Procedure CRTSCV QDBSRVXR2 job
   SI49646      OSP-DB ADD QSYS2/SYSPACKAGEAUTH catalog
   SI49646      OSP-DB ADD QSYS2/SYSPACKAGEAUTH catalog
   SI49504      OSP-DB-INCORROUT-MSGCPF2227-T/QSQCCATV
   SI49409      OSP-DB ADD DB2 FOR i SUPPLIED OBJECTS
   SI49409      OSP-DB INTERNAL MAINTENANCE
   SI49337      OSP-DB ADD DB2 FOR i SUPPLIED OBJECTS
   SI49337      OSP-DB ADD QSYS2/GET_JOB_INFO UDTF
   SI49213      OSP-DB-INCORROUT-MSGCPF2227-T/QSQCCATV
   SI48990      OSP-DB ADD CONTROL FOR Database Perspectives
   SI48820      OSP-DB ADD CATALOG TOOLS TO SYSTOOLS
   SI48792      OSP-DB ADD QSYS2/SQL_CHECK_AUTHORITY UDF
   SI48681      OSP-DB-OTHER-UNPRED Internal Maintenance
   SI48373      OSP-DB INTERNAL MAINTENANCE
   SI48152      OSP-DB INTERNAL MAINTENANCE
   SI48021      OSP-DB INTERNAL MAINTENANCE
   SI47840      OSP-DB Change qsqsysibm to use CREATE OR REPLACE
   SI47765      OSP-DB INTERNAL MAINTENANCE
   SI47561      OSP-DB INTERNAL MAINTENANCE
   SI47105      OSP-DB INTERNAL MAINTENANCE
   SI46924      OSP-DB-OTHER-T/QSQRLSPC-MSGMSGMCH3402
   SI46764      OSP-DB Improve performance of SYSIBM/SQLColPrivileges and SQ
   SI46622      OSP-DB-MSGSQL0332-T/QSQDELET CALLING QSYS2.REMOVE_PERFORMANC
   SI46437      OSP-DB INTERNAL MAINTENANCE
   SI46324      OSP-DB ADD WRAP AND CREATE_WRAPPED TO SYSIBMADM
   SI46200      OSP-DB-MSGSQL0206 using SYSTOOOLS.ACT_ON_INDEX_ADVICE proced
   SI45394      OSP-DB ADD procedure QSYS2.Reset_Table_Index_Statistics()
   SI45167      OSP-OSP-F/QQQVFMT-T/QDBXXREFSP-MSGCPD439C MSGCPD439C IN SCPF
   SI45082      OSP-DB ADD QSYS2/REMOVE_PERFORMANCE_MONITOR() PROCEDURE
   SI44948      OSP-DB ADD SYSTOOLS.REMOVE_INDEXES
   SI44948      OSP-DB SYSTOOLS.ACT_ON_INDEX_ADVICE ERROR HANDLING
   SI44937      OSP-DB-OTHER-UNPRED VIEW QSYS2/USAGE_PRIVILEGES MAY BE MISSI
   SI44913      OSP-DB QSQIBMCHK should not check for QSQPDTBL
   SI44686      OSP-DB ADD QSYS2/SYSDISKSTAT catalog
   SI44496      OSP-DB Use MTIs as a source of statistics
   SI44366      OSP-DB-MSGSQL0104 FROM QSQGNDDL() API GENERATED SQL
   SI44167      OSP-DB-MSGMCH2601-T/QSQCCATV GetIdentityValue install failur
   SI44069      OSP-DB ADD QSYS2/Journal_Entry_Info() procedure
   SI43658      OSP-DB ADD QSYS2.SQLQMProfilesAudit for improved audit suppo
   SI43568      OSP-DB ADDITIONAL TCPIP FILTERING ENHANCEMENTS
   SI43475      OSP-DB-OTHER-UNPRED-UNPRED Support for JDBC 4.1
   SI43429      OSP-DB ADD CHECKS TO QSYS/QSQIBMCHK
   SI43271      OSP-DB-INCORROUT QSYS2/OBJECT_STATISTICS OBJCREATED column
   SI42721      OSP-DB ADD CONSISTENCY_TOKEN COLUMN to QSYS2/SYSPROGRAMSTAT
   SI42586      OSP-INCORROUT Base Function to Enable Future Extensions
   SI41967      OSP-DB Internam Maintenance
   SI41880      OSP-DB ADD QSYS2/TCPIP_INFO Procedure and View
   SI41819      OSP-DB ADD QSYS2/FIND_AND_CANCEL_QSQSRVR_SQL and DUMP_SQL_CU
   SI41819      OSP-DB ADD QSYS2/GET_HOST_DATA() procedure
   SI40843      OSP-DB Add QSYS2/SYSPARTITIONDISK AND SYSPARTITIONINDEXDISK
   SI40634      OSP-DB-OTHER-UNPRED MULTIPLE ROWS APPEAR IN QSYS2/SYSPACKAGE
   SI40418      OSP-DB Internal Maintenance
   SI40101      OSP-DB ADD QSYS2.FIND_QSQSRVR_JOBS() procedure
   SI40101      OSP-DB Internal Maintenance
   SI39931      OSP-DB ADD QSYS2/INDEX_ADVICE PROCEDURE
   SI39820      OSP-DB Improve QSYS2/SYSPARTITIONDISK FOR SSD
   SI39820      OSP-DB Add QSYS2/Display_Journal UDTF
   SI39336      OSP-DB Internal Maintenance
   SI39225      OSP-DB-OTHER-UNPRED DYNDFTCOL REMAINS SET AFTER CALL TO QSQS
   SI39054      OSP-DB INTERNAL CHANGES TO SUPPORT MOVE/RENAME TEXT SEARCH I
   SI38564      OSP-DB Internal Maintenance
   SI38064      OSP-DB Internal Maintenance
   SI37814      OSP-DB Internal Maintenance
   SI37634      OSP-DB-QSQCAT-MSGCPF7002 on vary on of independent ASP
   SI37526      OSP-DB Internal Maintenance
   SI37402      OSP-DB Internal Maintenance
   SI37227      OSP-DB Internal Maintenance
   SI37118      OSP-DB Internal Maintenance
   SI36961      OSP-DB INTERNAL MAINTENANCE
   SI36808      OSP-DB INTERNAL MAINTENANCE
   SI36611      OSP-DB-QSQROUTE-MSGMCH3601 running in server mode
   SI40917      OSP-DB FILES DELETED AFTER INSTALLING PTF'S
   SI37005      OSP-DB-RUN reset identity counters on SYSTXT catalogs

Summary Information

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


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.1","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.1","Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1"},"Component":"5770SS1","Edition":""}]

Document Information

Modified date:
02 April 2021