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 REL NUMBER MIN/MAX OPTION
---- -------- --- ------- ------- ------
PRE 5770SS1 710 SI57899 00/00 0000
PRE 5770SS1 710 SI56613 00/00 0000
PRE 5770SS1 710 SI54588 00/00 0000
PRE 5770SS1 710 SI55504 00/00 0000
PRE 5770SS1 710 SI55437 00/00 0000
PRE 5770SS1 710 SI54475 00/00 0000
PRE 5770SS1 710 SI49567 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 SI60883 00/00 0000
CO 5770SS1 710 SI60118 00/00 0000
CO 5770SS1 710 SI59634 00/00 0000
CO 5770SS1 710 SI56681 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 SI48747 00/00 0000
CO 5770SS1 710 SI44493 00/00 0000
CO 5770SS1 710 SI43510 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 SE64949 :
-----------------------------
INTERNAL MAINTENANCE
CIRCUMVENTION FOR APAR SE64949 :
--------------------------------
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 SI58425 :
=================================================
To properly enable this PTF for prestarted server jobs,
you will need to stop and restart the SQL server jobs,
the Directory Services server jobs, the DRDA TCPIP server
jobs, and the host server jobs. Otherwise,
the prestarted server jobs may continue to use older versions
of programs and unexpected results may occur.Applying this
PTF as delayed would achieve the same results.
To stop and restart the SQL server jobs, run the following:
ENDPJ SBS(QSYSWRK) PGM(QSQSRVR) OPTION(*IMMED)
STRPJ SBS(QSYSWRK) PGM(QSQSRVR)
To stop and restart the QRWTSRVR prestart jobs, run the following:
ENDPJ SBS(QUSRWRK) PGM(QRWTSRVR) OPTION(*IMMED)
STRPJ SBS(QUSRWRK) PGM(QRWTSRVR)
To stop and restart the DRDA TCPIP server jobs, run the following:
ENDTCPSVR SERVER(*DDM) OPTION(*IMMED)
STRTCPSVR SERVER(*DDM)
To stop and restart the Directory Services server job,
run the following:
ENDTCPSVR SERVER(*DIRSRV) OPTION(*IMMED)
STRTCPSVR SERVER(*DIRSRV)
To stop and restart the host server jobs, the following directions
must be followed.
The database server prestart jobs (QZDAINIT, QZDASOINIT, and
QZDASSINIT) by default are shipped to run in subsystem QSERVER
(QZDAINIT) and QUSRWRK (QZDASOINIT and QZDASSINIT). However, systems
can be customized to allow the database server prestart jobs to run
in other subsystems.
SYSTEMS WITH DEFAULT CONFIGURATION (database server prestart jobs run
ONLY in the QSERVER and QUSRWRK subsystems).
---------------------------------------------------------------------
1) To ensure that the database server prestart jobs are ended,
issue the requests:
QSYS/ENDPJ SBS(QSERVER) PGM(QSYS/QZDAINIT) OPTION(*IMMED)
and
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT) OPTION(*IMMED)
and
QSYS/ENDPJ SBS(QUSRWRK) PGM(QSYS/QZDASSINIT) OPTION(*IMMED)
and if a non default prestart job configuration exists
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDAINIT)
If the above commands fail with CPF0922, nothing more needs
to be done (the prestarted jobs are already inactive).
2) To re-enable the function after the PTF is applied, issue the
requests:
QSYS/STRPJ SBS(QSERVER) PGM(QSYS/QZDAINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASOINIT)
and
QSYS/STRPJ SBS(QUSRWRK) PGM(QSYS/QZDASSINIT)
and if a non default prestart job configuration exists
QSYS/STRPJ SBS("subsystem-name") PGM(QSYS/QZDASSINIT)
If the above commands fail with CPF0921, nothing more needs
to be done (the prestarted jobs are already active).
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
-------------- ------------------------------------------------------------
SI60965 OSP-DB-OTHER-INCORROUT Plan Cache VE is showing 0 for rows f
SI60884 OSP-DB INTERNAL MAINTENANCE
SI60776 OSP-DB SQL SHIPPED OBJECTS SHOULD BE OWNED BY QSYS
SI60760 OSP-DB-OTHER-INCORROUT Plan Cache VE is showing 0 for rows f
SI60296 OSP-DB INTERNAL MAINTENANCE
SI60116 OSP-DB INTERNAL MAINTENANCE
SI60098 OSP-DB-OTHER-INCORROUT HTTP FUNCTIONS USE JDBC CONNECTION
SI60003 OSP-DB INTERNAL MAINTENANCE
SI59911 OSP-DB INTERNAL MAINTENANCE
SI59739 OSP-DB INTERNAL MAINTENANCE
SI59670 OSP-DB NETSTAT SERVICES ADD NEW COLUMNS
SI59670 OSP-DB-OTHER-INCORROUT SQL...COL JDBC types incorrect
SI59670 OSP-DB-OTHER-INCORROUT SQLTYPEINFO JDBC types incorrect
SI57440 OSP-DB-OTHER-INCORROUT SYSIBM PROCEDURES ESCAPE INCORRECT
SI57015 OSP-DB INTERNAL MAINTENANCE
SI56121 OSP-DB-OTHER-THREADS-T/QSQRUN1X/11214-MSGSQL0104 WITH CCSID
SI51371 OSP-DB Support returning cursor from SQLStatistics, SQLProce
SI49934 OSP-DB INTERNAL MAINTENANCE
SI44199 OSP-DB ADD LIBRARY LIST support to JDBC getSchemas() method
SI43476 OSP-DB-OTHER-UNPRED-UNPRED Support for JDBC 4.1
SI43389 OSP-DB Metadata procedure changes
SI42771 OSP-DB-MSGSQL0113 SYSIBM.SQLTABLES procedure
SI59635 OSP-DB Add QSYS2.ENVIRONMENT_VARIABLE_INFO service
SI59635 OSP-DB INTERNAL MAINTENANCE
SI58437 OSP-DB-MSGCPF3D95 Vary on of iASP
SI58425 OSP-DB-OTHER-MSGSQL4302 MSGSQL4302 FOR HTTPPOSTCLOB WITH CON
SI49247 OSP-DB HTTP UDF Samples
SI58368 OSP-DB-MSGCPD439C Function INDEX_PARTITION_STATISTICS not fo
SI58132 OSP-DB INTERNAL MAINTENANCE
SI58088 OSP-DB INTERNAL MAINTENANCE
SI58058 OSP-DB INTERNAL MAINTENANCE
SI57927 OSP-DB INTERNAL MAINTENANCE
SI57873 OSP-DB INTERNAL MAINTENANCE
SI57854 OSP-DB ADD ELAPSED_TIME to ACTIVE_JOB_INFO
SI57730 OSP-DB INTERNAL MAINTENANCE
SI57582 OSP-DB Table Function DATABASE_MONITOR_INFORMATION
SI57429 OSP-DB INTERNAL MAINTENANCE
SI57378 OSP-DB INTERNAL MAINTENANCE
SI57272 OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
SI57140 OSP-DB-OTHER-INCORROUT INVALID DATE_FMT RETURNED BY SYSPROGR
SI56816 OSP-DB INTERNAL MAINTENANCE
SI56806 OSP-DB-OTHER-MSGSQL0913 CALLING QSYS2.EXTRACT_STATEMENTS
SI56777 OSP-DB INTERNAL MAINTENANCE
SI56742 OSP-DB Remove TEMPORARY_STORAGE from QSYS2.ACTIVE_JOB_INFO
SI56682 OSP-DB Update SYSTRIGGERS to correct REMARKS column
SI56433 OSP-DB ADD ACTIVE_JOB_INFO, SCHEDULED_JOB_INFO, DRDA_AUTHENT
SI56338 OSP-DB-MSGSQL0204 Function REGEXP_LIKE not found during a va
SI56291 OSP-DB ENHANCE QSYS2/GET_JOB_INFO
SI56240 OSP-DB-OTHER-T/QSQCRTVX/2424-MSGSQL0205 COLUMN CREATE_TIMEST
SI56196 OSP-DB INTERNAL MAINTENANCE
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 SE64949 |
Superseded by:...................... | View fix details for PTF SI75300 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | C6320710 |
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.
Was this topic helpful?
Document Information
Modified date:
02 April 2021