IBM Support

SI63236 - OSP-DB RECOVERY OBJECT NOT DELETED WHEN ALTER TABLE FAILS (D

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

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 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 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.

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.1.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15V","label":"PTF Cover Letters - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 January 2017