IBM Support

SI49730 - OSP-DB-MSGMCH0601-T/QSQCCATV Procedure CRTSCV QDBSRVXR2 job

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-MSGMCH0601-T/QSQCCATV Procedure CRTSCV QDBSRVXR2 job


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
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  SI45828   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  SI49410   00/00    0000
CO   5770SS1  710  SI49405   00/00    0000
CO   5770SS1  710  SI49434   00/00    0000
CO   5770SS1  710  SI49384   00/00    0000
CO   5770SS1  710  SI48989   00/00    0000
CO   5770SS1  710  SI48847   00/00    0000
CO   5770SS1  710  SI48747   00/00    0000
CO   5770SS1  710  SI48018   00/00    0000
CO   5770SS1  710  SI46347   00/00    0000
CO   5770SS1  710  SI44493   00/00    0000
CO   5770SS1  710  SI43510   00/00    0000
CO   5770SS1  710  SI43509   00/00    0000
CO   5770SS1  710  SI43476   00/00    0000
CO   5770SS1  710  SI42001   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

-----------------------------------------------
Under some conditions, the application of DB2 for i PTFs over an
IPL fails repeatedly in the QDBSRVXR2 job with MSGMCH0601
exceptions within QSQCCATV procedure CRTSCV at Statement 13745.

CORRECTION FOR APAR SE55225 :
-----------------------------
The catalog management of DB2 for i shipped objects has been
changed to avoid having this problem.

CIRCUMVENTION FOR APAR SE55225 :
--------------------------------
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
--------------  ------------------------------------------------------------
   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 SE55225
Superseded by:......................View fix details for PTF SI75300
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C3298710


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