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 SI57645 00/00 0000
PRE 5770SS1 710 SI55892 00/00 0000
PRE 5770999 710 MF59270 00/00 0000
PRE 5770SS1 710 SI54647 00/00 0000
PRE 5770SS1 710 SI54477 00/00 0000
PRE 5770SS1 710 SI54026 00/00 0000
PRE 5770SS1 710 SI54027 00/00 0000
PRE 5770SS1 710 SI54028 00/00 0000
PRE 5770SS1 710 SI54031 00/00 0000
PRE 5770SS1 710 SI54030 00/00 0000
PRE 5770SS1 710 SI54032 00/00 0000
PRE 5770SS1 710 SI54033 00/00 0000
PRE 5770SS1 710 SI54034 00/00 0000
PRE 5770SS1 710 SI54035 00/00 0000
PRE 5770SS1 710 SI54036 00/00 0000
PRE 5770SS1 710 SI50196 00/00 0000
PRE 5770SS1 710 SI41677 00/00 0000
CO 5770SS1 710 SI60884 00/00 0000
CO 5770SS1 710 SI57580 00/00 0000
CO 5770SS1 710 SI54478 00/00 0000
CO 5770SS1 710 SI54029 00/00 0000
CO 5770SS1 710 SI50806 00/00 0000
CO 5770SS1 710 SI45895 00/00 0000
CO 5770SS1 710 SI44157 00/00 0000
CO 5770SS1 710 SI44158 00/00 0000
CO 5770SS1 710 SI44159 00/00 0000
CO 5770SS1 710 SI44160 00/00 0000
CO 5770SS1 710 SI43510 00/00 0000
CO 5770SS1 710 SI43509 00/00 0000
CO 5770SS1 710 SI43017 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
-----------------------------------------------
INTERNAL MAINTENANCE
CORRECTION FOR APAR SE64896 :
-----------------------------
INTERNAL MAINTENANCE
CIRCUMVENTION FOR APAR SE64896 :
--------------------------------
None.
Activation Instructions
To properly enable this PTF for prestarted server jobs,
you will need to stop and restart the host server jobs.
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
None.
Default Instructions
THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.
Supersedes
PTF/FIX NO(S). APAR TITLE LINE
-------------- ------------------------------------------------------------
SI60877 OSP-DB DSPDBR shows dependent files with no libraries
SI60580 OSP-DB-INCORROUT Guardium audit journal capture and FTRFILE
SI60297 OSP-DB INTERNAL MAINTENANCE
SI60276 OSP-DB SP/QDBSSUDF2-MSGSQL0802-MOD/QSQJOBLOG
SI60264 OSP-DB subsystem routing problem
SI60117 OSP-DB INTERNAL MAINTENANCE
SI60002 OSP-DB INTERNAL MAINTENANCE
SI59912 OSP-DB INTERNAL MAINTENANCE
SI59671 OSP-DB INTERNAL MAINTENANCE
SI59650 OSP-DB INTERNAL MAINTENANCE
SI59500 OSP-DB Extract Member Failure unexpected failure does not in
SI59489 OSP-DB-MSGSQL0443 Journal Entry Not Compatible With Table
SI59119 OSP-DB OBJECT_STATISTICS returns *INTLIB for object type of
SI59033 OSP-DB INTERNAL MAINTENANCE
SI58775 OSP-DB QSYS2/PTF_INFO detail incorrect
SI58660 OSP-DB Guardium install failure
SI58606 OSP-DB NETSTAT SERVICES ERROR
SI58431 OSP-DB-INCORROUT SYSPARTITIONSTAT catalog lacks range detail
SI58427 OSP-F/QDBIOERRQO-T/QDBIOERRQO-MSGCPF5029 MSGCPF5029 WHEN ACC
SI58427 OSP-MSGMCH3203-D/TQDBGETMQO-PAR QUERY OF SCHEDULED_JOB_INFO
SI58213 OSP-DB-OTHER-MSGMCH3601-T/QSQRUN3 PROCEDURE GETUFCB
SI58169 OSP-DB-PERFM Fix memory leak in QSYS2/JVM_INFO
SI58089 OSP-DB INTERNAL MAINTENANCE
SI58029 OSP-DB INTERNAL MAINTENANCE
SI57966 OSP-DB Incremental Enhancement
SI57929 OSP-DB Internal maintenance
SI57929 OSP-DB Internal maintenance
SI57881 OSP-DB JVM_INFO error
SI57872 OSP-DB INTERNAL MAINTENANCE
SI57852 OSP-DB INTERNAL MAINTENANCE
SI57850 OSP-DB F/QGYOLJBL-MSGMCH3601 QSYS2.JOBLOG_INFO
SI57845 OSP-DB RGZPFM performance improvement
SI57752 OSP-DB INTERNAL MAINTENANCE
SI57738 OSP-DB Incremental Enhancement
SI57729 OSP-DB INTERNAL MAINTENANCE
SI57581 OSP-DB STRDBMON Filter Operator Support
SI57522 OSP-DB-OTHER-UNPRED RGZPFM - BLOB - EMPTY POINTER - ZERO LEN
SI57474 OSP-DB OBJECT_STATISTICS IMPROVEMENTS
SI57428 OSP-DB INTERNAL MAINTENANCE
SI57383 OSP-DB-OTHER-F/QDBRGZPF-MSGCPF2982 RGZPFM MSGSQL0900 F/QSQXC
SI57377 OSP-DB INTERNAL MAINTENANCE
SI57301 OSP-DB INTERNAL MAINTENANCE
SI57273 OSP-DB-OTHER-UNPRED ADD QAQQINI OPTION SQL_STMT_COMPRESS_REU
SI57194 OSP DISPLAY_JOURNAL TABLE FUNCTION HAS STOPPED POPULATING TH
SI56741 OSP-DB Remove TEMPORARY_STORAGE from QSYS2.ACTIVE_JOB_INFO
SI56658 OSP-DB Table Function DATABASE_MONITOR_INFO
SI56431 OSP-DB ADD ACTIVE_JOB_INFO, SCHEDULED_JOB_INFO, DRDA_AUTHENT
SI56195 OSP-DB INTERNAL MAINTENANCE
SI56192 OSP-DB INTERNAL MAINTENANCE
SI56157 OSP-DB Table Function DATABASE_MONITOR_INFORMATION.
SI56083 OSP-DB-OTHER-INCORROUT USER-DEFINED TABLE FUNCTION DISPLAY_J
SI55940 OSP-DB Table Function DATABASE_MONITOR_INFORMATION.
SI55620 OSP-DB INTERNAL MAINTENANCE
SI55443 CA400EXP-OPNAV-DBASE-INCORROUT FIELD TEXT INCLUDING DBCS GOT
SI55439 OSP-DB INTERNAL MAINTENANCE
SI55383 OSP-DB QUERY FAILS WITH MSGMCH3601 T/QDBGETMQO
SI55367 OSP-DB-INCORROUT-MSGCPD0093 Guardium unable to start
SI55285 OSP-DB SP/QDBSSUDF2-MOD/QSQJOBLOG Job log on NLV 2989 system
SI54987 OSP-DB INTERNAL MAINTENANCE
SI54937 OSP-DB INTERNAL MAINTENANCE
SI54753 CA400EXP-OPNAV-DBASE-INCORROUT FIELD TEXT INCLUDING DBCS GOT
SI54753 OSP-DB Improved Turkish support for IBM supplied table funct
SI54753 OSP-DB-OTHER-UNPRED A RGZPFM MAY NOT HANDLE CONCURRENT INSER
SI54479 OSP-DB INTERNAL MAINTENANCE
SI54322 OSP-DB-OTHER-INCORROUT NOT ALL STATEMENTS RETURNED BY SYSPAC
SI54143 OSP-DB LIBRARY_LIST_INFO and REPLY_LIST_INFO views with asso
SI54100 OSP-DB JOURNAL_INFO view and associated table function
SI53914 OSP-OTHER-INCORROUT SQL QUERY TO DETERMINE THE SQL SPACE IN
SI53543 OSP-DB INTERNAL MAINTENANCE
SI53328 OSP-DB-MSGCPF5029 Guardium status procedure SYSPROC/SYSAUDIT
SI53155 OSP-DB INTERNAL MAINTENANCE
SI53083 OSP-DB-OTHER-T/QSQPKSTST-MSGMCH1210
SI53076 OSP-OTHER QDBEXDFI CHECK PENDING NOT CORRECT
SI53074 OSP-DB-MSGCPF4102 QDBSSUDF2/QSQRUN4 GENERATE_SQL procedure
SI53053 OSP-DB INTERNAL MAINTENANCE
SI52838 OSP-DB-OTHER-UNPRED INTERNAL MAINTENAINCE
SI52715 OSP-DB-OTHER-UNPRED INTERNAL MAINTENAINCE
SI52631 OSP-DB Incremental Enhancement
SI52372 OSP-DB-OTHER-INCORROUT T-AF INCORROUT LIKE SE52678 WHEN YOU
SI52036 OSP-DB-MSGMCH3601-T/QSQENVLIM GET_A_ROW
SI52008 OSP-DB INTERNAL MAINTENANCE
SI51804 OSP-DB INTERNAL MAINTENANCE
SI51356 OSP-DB-OTHER-F/QSQXCUTE-T/QSQXCUTE-MSGSQL0104 MSGSQL0104 F/Q
SI51270 OSP-DB Add CP as included by default for new Guardium users
SI50914 OSP - Incremental Enhancement
SI50890 OSP-DB INTERNAL MAINTENANCE
SI50809 OSP-DB Enhance Database Maintenance Index Build Status
SI50758 OSP-DB INTERNAL MAINTENANCE
SI50581 OSP-DB-PERFM Improved Guardium monitoring configuration and
SI50541 OSP-DB SET CORRECT TEXT OF FIELD LENGTH FOR QDBPMSTAT
SI50237 OSP-DB ADD NEW DB2 for i supplied views
SI50197 OSP-DB Internal Maintenance
SI50174 OSP-DB Improved QSYS2/DISPLAY_JOURNAL UDTF
SI50169 OSP-DB-MSGCPF35BE Querying QSYS2/PTF_INFO catalog
SI50143 OSP-DB-INCORROUT qsys2.sysprogramstat column NAMING
SI49961 OSP-DB Improved QSYS2/DISPLAY_JOURNAL UDTF
SI49853 OSP-DB ADD NEW DB2 for i privilege catalogs
SI49773 OSP-DB-MSGMCH1210 RGZPFM ALWCANCEL(*YES) fails with MCH1210
SI49662 OSP-DB-INCORROUT-MSGCPF503E-T/QSQSYSCOL2
SI49554 OSP-DB-INCORROUT-MSGMCH1210-T/QSQOBSTAT OBJECT_STATISTICS
SI49534 OSP-DB RGZPFM enhancment
SI49481 OSP-DB-OTHER Changes to Parallel_Degree *OPTIMIZE percentage
SI49384 OSP-DB ADD DB2 FOR i SUPPLIED OBJECTS
SI49384 OSP-DB ADD DB2 FOR i SUPPLIED OBJECTS
SI49367 OSP-DB RGZPFM Incremental Enhancement
SI49367 OSP-DB RGZPFM enhancment
SI41060 OSP-DB-OTHER-QDBRGZPF Omit Default Record For EXTDBM
SI49335 OSP-DB ADD DB2 FOR i SUPPLIED OBJECTS
SI49066 OSP-DB INTERNAL MAINTENANCE
SI49053 OSP-DB QSYS2/SYSCOLUMNS2 HAS_DEFAULT column contains the wro
SI48995 OSP-DB-OTHER-F/QDBSSUDF2-T/QDBSSUDF2-MSGMCH1210 MCH1210 IN Q
SI48453 OSP-DB INTERNAL MAINTENANCE
SI48383 OSP-DB INTERNAL MAINTENANCE
SI47333 OSP-DB-OTHER-F/QDBIOERRQO-T/QDBIOERRQO-RC1-MSGCPF503E FOR GE
SI47428 OSP-DB Enhance QSYS2/SYSSCHEMAS to avoid AF journal entries
SI47312 OSP-DB INTERNAL MAINTENANCE
SI47205 OSP-DB INTERNAL MAINTENANCE
SI47154 OSP-DB Improve performance of SYSIBM/SQLColPrivileges and SQ
SI46906 OSP-DB INTERNAL MAINTENANCE
SI46769 OSP-DB-OTHER-T/QDBFFCPY-MSGCPF9999 A RGZPFM MAY ENCOUNTER A
SI46750 OSP-DB INTERNAL MAINTENANCE
SI46750 OSP-DB Improve performance of SYSIBM/SQLColPrivileges and SQ
SI46551 OSP-DB-OTHER-UNPRED SHOW INDEXES IN INAVIGATOR RESULTS IN AN
SI46327 OSP-DB-MSGCPF4328 RGZPFM ALWCANCEL(*YES) with file name over
SI46123 OSP-DB-OTHER-QDBEXDFI QDBRNMLB infinite loop during IPL
SI45989 F/QDBSSUDF-MSGMCH1210 MCH1210 QDBRGZMV VALUE TOO SMALL
SI45936 OSP-DB-MSGMCH3601 T/QDBSSUDF2 querying view SYSPARTITIONSTAT
SI45897 OSP-DB Incremental enhancement for field procs
SI45896 OSP-DB Incremental enhancement for field procs
SI45381 OSP-DB ADD procedure QSYS2.Reset_Table_Index_Statistics()
SI45380 OSP-DB ADD procedure QSYS2.Reset_Table_Index_Statistics()
SI45131 OSP-DB-OTHER-PERFM AT 7.1 STRDBG PERFORMANCE IS SLOWER WHEN
SI44790 OSP-DB INTERNAL MAINTENANCE
SI44691 OSP-DB-INCORROUT USING QSYS2/SYSCOLUMNSTAT
SI44691 OSP-DB-MSGMCH3601-T/QDBSSUDF2 QSQPKSTAT Procedure SET_EARLIE
SI44495 OSP-DB Use MTIs as a source of statistics
SI44320 OSP-DB-OTHER-INCORROUT AN INDEX OVER A PARTITIONED TABLE MAY
SI44156 OSP-DB-OTHER-UNPRED DEADLOCK BETWEEN CONCURRENT JOBS EXTRACT
SI41021 OSP-DB Directory locking improvements
SI44068 OSP-DB ADD QSYS2/Display_journal_entry_info() procedure
SI43975 OSP - DB CPF5035 data mapping error canceling RGZPFM shortly
SI43974 OSP - DB MCH3601 f/QDBEXDME t/ QDBEXDME
SI43842 OSP-DB-OTHER-F/#dbcpyfl-T/QDBEXDME-MSGMCH5601 when applying
SI43695 OSP - DB RGZPFM Internal maintenance
SI43695 OSP-DB-OTHER-INCORROUT RGZPFM ALWCANCEL(*YES) INCORRECT HAND
SI43569 OSP-DB ADDITIONAL TCPIP FILTERING ENHANCEMENTS
SI43539 OSP-DB INTERNAL MAINTENANCE
SI43270 OSP-DB-INCORROUT QSYS2/OBJECT_STATISTICS OBJCREATED column
SI43018 OSP-DB INTERNAL MAINTENANCE
SI42847 OSP-DB-OTHER-T/QSQOBSTAT-MSGMCH1001 MCH1001 FOR QSQOBSTAT
SI42722 OSP-DB ADD CONSISTENCY_TOKEN COLUMN to QSYS2/SYSPROGRAMSTAT
SI42581 OSP-DB-MSGMCH3601-T/QDBPIDISK QSYS2/SYSPARTITIONDISK
SI42581 OSP-INCORROUT Base Function to Enable Future Extensions
SI41994 OSP-DB INTERNAL MAINTENANCE
SI41860 OSP-DB-OTHER-QDBEXDME and EXTDBMI changes
SI41902 OSP-DB Internal Maintenance
SI41574 OSP-DB-OTHER-PERFM QUSRMBRD API CONSUMES EXCESSIVE RESOURCE
SI40841 OSP-DB Internal maintenance
SI40606 OSP-DB QSYS2/SYSPACKAGESTAT and SYSPROGRAMSTAT fail to compl
SI40419 OSP-DB Internal Maintenance
SI40102 OSP-DB Internal Maintenance
SI39830 OSP-DB Internal Maintenance
SI39821 OSP-DB Object statistics improvement
SI39821 OSP-DB Internal Maintenance
SI39821 OSP-DB Internal Maintenance
SI38576 OSP-DB Internal Maintenance
SI38512 OSP-DB Internal Maintenance
SI37903 OSP-DB-OTHER-LOOP WHEN TRYING TO ACCESS A TABLE THAT THE USE
SI37828 OSP-DB Internal Maintenance
SI37776 OSP-DB Internal Maintenance
SI37226 OSP-DB Internal Maintenance
SI36952 OSP-DB Fix message text for GET FILE UDFs
SI36636 OSP-DB MSGSQL0901 from GET FILE UDFs
SI36589 OSP-DB-OTHER-T/QSQHEALTH-MSGSQL0443 Health Activity
SI40849 OSP-DB Directory locking improvements
SI40160 OSP-DB Internal Maintenance
SI40032 OSP-DB Internal Maintenance
SI39410 OSP-DB-OTHER-F/CBLABRANCH-T/QDBEXDME-MSGMCH1210 DSPFD GETS M
SI38996 OSP-DB-OTHER-F/QQQSVRTNFMOD-T/QQQSVRTNFMOD-MSGCPF504D MSGCPF
SI38494 OSP-DB Internal Maintenance
SI38069 OSP-INCORROUT QUSRMBRD API IS RETURNING INCORRECT DATA FOR T
SI37849 OSP-DB Internal Maintenance
SI36491 OSP-DB-OTHER-QDBEXDME
SI36452 OSP-DB-OTHER-QDBEXDME
SI40287 OSP-DB Incremental Enhancement
SI39852 OSP-DB-OTHER-T/QDBEXDFIX/0CE0-MSGMCH6801 RUNNING CPFY COMMAN
SI39617 OSP-DB-OTHER-QDBEXDFI Internal Changes
SI39485 OSP-DB DSPFD improvements to report constraint logical damag
SI39174 OSP-DB Internal Maintenance
SI39030 OSP-DB-OTHER-QDBEXDFI Changes
SI38537 OSP-DB-OTHER Check Pending Status Incorrect on Partitioned T
SI38482 OSP-DB Internal Maintenance
SI42716 OSP-DB SQL cancel improvements
SI41914 OSP-DB-OTHER-F/QDBGETDR-T/QDBGETDR-MSGMCH3601 RGZPFM
SI41876 OSP-DB Internal Maintenance
SI41566 OSP-DB RGZPFM ALWCANCEL(*YES) TAKES HOURS TO END OVER HUGE F
SI41538 OSP-DB-F/QDBRGZPF-MSGCPF2982 ON RGZPFM WHEN JAVA IS BEING US
SI41453 OSP-DB-OTHER-PERFM RGZPFM DOESN'T CANCEL IN A QUICK TIMEFRAM
SI41182 OSP-DB-OTHER-F/CFSCVOV-T/QDBRGZMV-MSGMCH3402 ON RGZPFM ON A
SI38596 OSP-DB-OTHER-THREADS-F/QDBFFCPY-T/QDBFFCPY-MSGMCH RGZPFM FAI
SI37594 OSP-DB-OTHER-F/QDBFFCPY-T/QDBFFCPY-MSGMCH3402 RGZPFM ALWCANC
Summary Information
System.............................. | i |
Models.............................. | |
Release............................. | V7R1M0 |
Licensed Program............... | 5770SS1 |
APAR Fixed.......................... | View details for APAR SE64896 |
Superseded by:...................... | View fix details for PTF SI70525 |
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 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:
16 June 2016