PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
OSP-DB RECOVERY OBJECT NOT DELETED WHEN ALTER TABLE FAILS (D
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM REL NUMBER MIN/MAX OPTION
---- -------- --- ------- ------- ------
PRE 5770SS1 710 SI48644 00/00 0000
PRE 5770SS1 710 SI48223 00/00 0000
PRE 5770SS1 710 SI46695 00/00 0000
PRE 5770SS1 710 SI38411 00/00 0000
PRE 5770SS1 710 SI37443 00/00 0000
CO 5770SS1 710 SI55345 00/00 0000
CO 5770SS1 710 SI49932 00/00 0000
CO 5770SS1 710 SI46545 00/00 0000
CO 5770SS1 710 SI46299 00/00 0000
CO 5770SS1 710 SI44269 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
-----------------------------------------------
In some cases using QDBREPLAY or APYJRNCHG to replay a CHGPF
UNIT(*SSD) to a file that already has UNIT(*SSD), changes it to
UNIT(*ANY) instead of leaving it at UNIT(*SSD).
CORRECTION FOR APAR SE66033 :
-----------------------------
The CHGPF UNIT(*SSD) command will now preserve UNIT(*SSD) using
QDBREPLAY or APYJRNCHG if UNIT is not being changed to a
different value.
CIRCUMVENTION FOR APAR SE66033 :
--------------------------------
None.
DESCRIPTION OF PROBLEM FIXED FOR APAR SE65730 :
-----------------------------------------------
ALTER TABLE fails with msgMCH1807 from #dbixchn to QDBPUTM. The
system is running with minimum storage available.
CORRECTION FOR APAR SE65730 :
-----------------------------
The MCH1807 can occur for an alter of a table with a dependent
MQT and minimum storage is available. ALTER TABLE is corrected
to ensure the operation can be rolled back. This ptf is
preventative not corrective. To recover, delete the file and
restore from backup.
CIRCUMVENTION FOR APAR SE65730 :
--------------------------------
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
-------------- ------------------------------------------------------------
SI62961 OSP-DB-OTHER-F/QQQQUERY-T/QQQQUERY-MSGMCH1210 MSGMCH1210 F/Q
SI62481 OSP-DB-OTHER-F/QDBCHGFI-T/QSQALTER-MSGCPD32CC MSGCPD32CC F/Q
SI62119 OSP-DB Compression of deleted records for an ALTER TABLE not
SI62119 OSP-DB-OTHER-F/QTNECCID-T/QDBCRTME-RC2-MSGCPF83EB DECLARE GL
SI62119 OSP-DB-OTHER-UNPRED FAST DELETE DEFLATED VIEW
SI60999 OSP-DB Internal Maintenance
SI60999 F/QDBCHGFITR-MSGCPD32CA CHGPF FAILS WITH CPD32CA ON INSERT W
SI60367 OSP-DB SQL INSERT to a partitioned table results in MCH1807
SI59746 OSP-DB Internal Maintenance
SI59296 OSP-DB-MSGMCH0801 error when replaying CHGPF
SI58681 OSP-DB-OTHER-F/QDBCHGFI-T/QDBCHGFI-MSGMCH1210 WHEN ALTER TAB
SI58091 OSP-DB RGZPFM performance improvement
SI58091 OSP-DB-OTHER-F/QDBCRTME-T/QSQALTER-MSGCPF3213 CPF7304 PARTIT
SI58091 OSP NON-SPANNING INDEXES REBUILDING WHEN TABLE PARTITION IS
SI57736 OSP-DB Altering a partition range to extend the ending-claus
SI57402 OSP-DB-OTHER-WAIT QDBCHGFI DEADLOCKED WITHIN ONE JOB
SI56985 OSP-DB Incremental Enhancement
SI56892 OSP-DB-OTHER-F/QJOJRNPF-MSGCPF703C MSGCPF703C F/QJOJRNPF DUE
SI56559 OSP-DB Fast delete not allowed for a table with disabled tri
SI56143 OSP-DB-OTHER-UNPRED AUTHORISATION DROPPED ON VIEW BY ALTER T
SI56143 OSP-DB Incremental Enhancement
SI55381 OSP-DB-OTHER-F/QQQSRVI1-T/QQQSVRTN-MSGCPF9898 A MSGCPF9898 M
SI55347 OSP-DB-OTHER-UNPRED AUTHORIZATION DROPPED ON UPDATE TABLE VI
SI55347 OSP-DB Incremental Enhancement
SI55347 OSP-DB-OTHER-F/QDBCHGFI-MSGCPF3203 ON CHGPF COMMAND
SI54136 OSP-DB-OTHER-F/QFICHECK-T/QFICHK-MSGCPD3DC8 AFTER CALLING QD
SI53784 OSP-DB-OTHER-F/#DBMDSAT-T/QDBCHGFI-MSGMCH5601 ALTER TABLE
SI53539 OSP-DB-OTHER-PERFM QDBRLAY OF CHGPF TO CHANGE COLUMN ATTRIBU
SI52929 OSP-DB D JF JOURNAL ENTRY NOT HIDDEN
SI52488 OSP-DB-OTHER-F/QDBCHGFI-T/QUIMNDRV-RC4-MSGCPF326A CHGPF FILE
SI52439 OSP-DB-MSGMCH5601 MCH5601 t/QDBCHGFI when using CHGPF to add
SI51989 OSP-DB-OTHER-T/QDBCHGFI-MSGMCH3601 DROP PARTITION WITH IDENT
SI51814 OSP-DB-OTHER-F/QDBCHGFI-T/QDBAPDDL-MSGCPD3216 ON REPLAY OF A
SI51276 OSP-OTHER-F/QLZASSIX-T/QLPEX050-MSGCPD3DC8 MSGCPD3DC8 RECEIV
SI50771 OSP-DB-OTHER Incremental Enhancement
SI50448 OSP-DB Incremental Enhancement
SI49931 OSP-DB-OTHER-MSGCPF3234 PUBLIC AUTHORITIES ARE REMOVED AFTER
SI49931 OSP-DB Incremental enhancemen
SI49336 OSP-DB-MSGCPD439C cannot CREATE OR REPLACE VIEW for SYSINDEX
SI49073 OSP-DB-OTHER-T/QDBCHGFI-MSGMCH3402 RCLDBXREF BEFORE INSTALL
SI48891 OSP-DB-OTHER Incremental Enhancement
SI48225 OSP - DB RI Delete Cascade Rule Not Done During Drop of Part
SI48225 OSP-F/QDBCHGFI-T/QSQALTER-MSGCPD32CE MSGCPD32CE WHEN DOING A
SI48225 OSP-DB Incremental Enhancement
SI47637 OSP-DB-OTHER-F/#DBMDSAT-T/QDBCHGFI-MSGMCH5601 USING CHGPF OR
SI47443 OSP-DB Internal Maintenance
SI46546 OSP-DB-OTHER-T/QDBTRIG2X/16637-MSGCPF83DE ALTER TABLE FAILS
SI46531 OSP-DB PARTITIONED TABLE TAKING UP LARGE AMOUNT OF SPACE WIT
SI46457 F/QDBSIGEX-MSGCPF4160 LABEL ON/COMMENT ON CAUSING FIELDPROC
SI46018 OSP-DB-OTHER-INCORROUT FOREIGN KEY IS NOT IN CHECK PENDING S
SI46018 OSP-DB SQL0901 CREATE OR REPLACE view failure
SI46018 OSP-DB SQL DELETE FROM statement without WHERE clause using
SI46018 OSP-DB MSGMCH1210 F/QDBCHGFI T/QDBCHGFI ALTER TABLE
SI44974 OSP-DB SQL0901 F/QSQCRTV Reason/4408 - Create or Replace Vie
SI44655 OSP-DB-UNPRED Adding or changing the long name may corrupt a
SI44620 OSP-DB msgCPF4204 t/ SYSBAS_XREF_CHG_CCSID using QDBCXRC api
SI44603 OSP-DB-JRN-UNPRED NO JOURNAL ENTRIES ARE GENERATED WHEN THE
SI44538 OSP-DB-OTHER-INCORROUT AN INDEX OVER A PARTITIONED TABLE MAY
SI44284 OSP-DB-OTHER-F/QSQCRTV-T/QSQCRTV-MSGSQL0901 CREATE REPLACE O
SI44266 OSP-OTHER-F/QDBCRTFI-T/QLICRDUP-MSGCPF327E CRTDUPOBJ INTO EM
SI44153 OSP-DB ALTER TABLE performance improvement
SI43236 OSP-DB HUNG JOBS WITH A DAMAGED MACHINE INDEX
SI43109 OSP-DB-UNPRED Problems with renaming the long name of a file
SI42904 OSP-DB CHGLF UNIT parm not using SSD storage
SI42786 OSP-DB-OTHER-F/QDBCHGFI-T/QDBXXREFSP-MSGCPF2958 QADBIFLD DEL
SI42699 OSP-DB-OTHER-RC8-MSGCPD32CC MSGCPD32CC RC/8 USING THE QDBRPL
SI42699 OSP-DB Internal Maintenance
SI42640 OSP-DB 7.1 upgrade MCH1210 f/ QQQQUERY t/ QQQQUERY or CPF989
SI42555 OSP-DB-OTHER-MSGCPF325E MSGCPF325E
SI42555 OSP-DB CALL QDBCXRC Failure results in CCSIDS of 66535 for Q
SI41611 OSP-DB MCH3406 f/#dbdds t/QDBDLTFI dropping a partitioned ta
SI41896 OSP-DB-OTHER-F/QDBCHGFI-T/QDBCHGFI-MSGCPF9898 JOB FAILS WITH
SI41265 OSP-DB Internal Maintenance
SI41119 OSP-DB Incremental Enhancement
SI41013 OSP-DB-OTHER-INCORROUT CHGLF UNIT(*SSD) DOES NOT CHANGE THE
SI40655 OSP-DB Internal Maintenance
SI40535 OSP-DB Directory locking improvements
SI40488 OSP-DB Incremental Enhancement
SI40348 OSP-DB Internal Maintenance
SI40031 OSP-DB MCH3402 f/QDBCHGFI t/QDBCHGFI CRT_NEW_FILE dropping f
SI40008 OSP-DB ALTER COLUMN TO CHANGE THEIR DB FROM EBCDIC TO UTF16
SI39751 OSP-DB A FAST DELETE THAT FAILS LEAVES JOURNAL ENTRIES JM AN
SI39584 OSP-DB-OTHER-F/QSQRUN3-MSGSQL0913 ON DELETE OF ALL THE RECOR
SI39584 OSP-DB-OTHER-F/QDBDLTFI-T/QSQALTER-MSGCPF3219 CASCADING DROP
SI39539 OSP-Reduce contention between concurrent ALTER TABLEs
SI39091 OSP-DB-OTHER-QDBCHGFI Constraint not in check pending after
SI38877 OSP-DB-OTHER-QDBCHGFI Changes
SI38680 OSP-DB-OTHER-QDBCHGFI SQL0901 from QSQALTER partitioning a t
SI38668 OSP-DB-OTHER-THREADS-INCORROUT CONSTRAINT DOESNT GO INTO CHE
SI38668 OSP-DB-OTHER-F/QDBCHGFI-T/QDBCHGFI-MSGMCH1210 RENAME INDEX F
SI38668 OSP-T/QDBSIZFI-MSGMCH3402 MQT BECOMES CORRUPTED AFTER CRTDUP
SI38485 OSP-DB Internal Maintenance
SI38413 OSP-DB Incremental Enhancement
SI37514 OSP-DB-OTHER-SAP400-UNPRED AFTER AN ALTER TABLE PRIMARY CONS
SI37493 OSP CHGPF CAN HANG
SI37448 OSP-DB Internal Maintenance
SI36657 OSP-DB Incremental Enhancement
SI36457 OSP-DB Internal Maintenance
Summary Information
System.............................. | i |
Models.............................. | |
Release............................. | V7R1M0 |
Licensed Program............... | 5770SS1 |
APAR Fixed.......................... | View details for APAR SE66033 View details for APAR SE65730 |
Superseded by:...................... | View fix details for PTF SI65960 |
Recompile........................... | N |
Library............................. | QSYS |
MRI Feature ........................ | NONE |
Cum Level........................... | C7192710 |
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 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:
11 January 2017