IBM Support

SI43723 - OSP-DB-OTHER-MSGMCH1202 A MSGMCH1202 MAY OCCUR WITH DFU AND

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-MSGMCH1202 A MSGMCH1202 MAY OCCUR WITH DFU AND


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI43092   00/00    0000
PRE  5770SS1  710  SI42354   00/00    0000
PRE  5770SS1  710  SI40353   00/00    0000
PRE  5770SS1  710  SI38857   00/00    0000
PRE  5770SS1  710  SI37806   00/00    0000
PRE  5770SS1  710  SI37443   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

-----------------------------------------------
A msgMCH1202 may occur with DFU and QUERY/400 queries with files
that have Field Procedures.

CORRECTION FOR APAR SE48196 :
-----------------------------
When the file was created with field procedures, the default
record length was not being calculated correctly. This means a
file with a field procedure may have the default record build
incorrectly. To recover from this error, the user must load the
PTF and must correct the file by 1) delete the existing file and
recreate the file, or 2) do the following steps;

a) CPYF FROMFILE(FROMLIB/FROMFILE) TOFILE(NEWLIB/TOFILE)
CRTFILE(*YES)

b) DLTF  FROMLIB/FROMFILE

c) MOVOBJ OBJ(NEWLIB/TOFILE) OBJTYPE(*FILE) TOLIB(FROMLIB).

CIRCUMVENTION FOR APAR SE48196 :
--------------------------------
None.


Activation Instructions


None.




Special Instructions


Please read the cover letter for this PTF. This PTF will correct an
error for creating a file with field procdures, however, the file with
this error must be recreated by the user.


Default Instructions

THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.



Supersedes

PTF/FIX NO(S).  APAR TITLE LINE
--------------  ------------------------------------------------------------
   SI43106      OSP-DB-UNPRED Problems with creating files with long names i
   SI43093      OSP-DB-JRN-INCORROUT UNDER SOME CIRCUMSTANCES JOURNAL ENTRIE
   SI42801      OSP-OTHER-F/#DBXVDE-T/QDBCRTME-MSGMCH1819 CHANGING CCSID VIA
   SI42639      OSP-DB CPD3260 f/t QDBCRTF/QSQCRTI 'Format for field COL_700
   SI42323      OSP-F/#LDPREP-T/QSRSVRQI-MSGMCH5601 SAVE FAILS WITH MSGMCH56
   SI42039      OSP-DB CPF32FB RC1 FOR A CRTDUPOBJ OBJ(SBP) FROMLIB(DPFQLIB)
   SI36941      OSP-DB Support CRTDUPOBJ & CPYLIB commands for Text Search I
   SI41798      OSP-DB-UNPRED Not all journal entries applied to logical fil
   SI41753      OSP-DB-OTHER-F/#DBXVDER-T/QDBCRTME-MSGMCH1819 ERROR WHEN CRE
   SI41177      OSP-DB Internal Maintenance
   SI41148      MSGMCH5401 F/#somodx T/QDBEXDFI When QDBEXDFI Is Call By QDB
   SI41032      OSP-DB-OTHER-F/QDBCRTFI-T/QDBRSPRE-MSGCPD3260 SI40264 CAUSED
   SI40951      OSP-DB-OTHER-INCORROUT CRTDUPOBJ LEFT ACCESS PATH INVALIDATE
   SI40768      OSP-MSGMCH5601 From #DBDEFLT To QDBCRTME When Default Return
   SI40505      OSP-DB-OTHER-QDBCRTME MCH5601
   SI40490      OSP-INCORROUT INCORRECT FORMAT IDENTIFIER FOR A VIEW
   SI40489      OSP-DB-OTHER INCORROUT CHAIN
   SI40489      OSP-DB-OTHER-UNPRED USING QDBRPLAY TO PROCESS D-CT JOURNAL E
   SI40367      OSP-DB-OTHER-QDBCRTME Internal Changes
   SI40359      OSP-DB Limit The Number Of LOB Fields With Field Procedures
   SI40096      OSP-DB-OTHER-F/QDBSIGEXX/0539-MSGCPF5123 RPG PGM FAILS WITH
   SI39776      OSP-DB Incorrect Field Table For LOB Fields With A Field Pro
   SI39657      OSP-DB CREATE TABLE SHOULD FAIL WHEN USING AN SQL FIELD PROC
   SI39224      OSP-DB Join Logical Files Fail To Create With Same Field Pro
   SI39199      OSP-DB-OTHER-INCORROUT DSPFD SHOWS A FILE JOURNALED WHEN IT
   SI39171      OSP-DB APYJRNCHG CPF3213 f/ QDBAPDDL when applying creation
   SI39170      OSP-DB CPD438B from/to QQQIMPLE/QSQRUN3 Error occurred while
   SI39169      OSP-DB Internal Maintenance
   SI39103      OSP-DB CPF327E f/ QDBCRTFI Alternative name not allowed for
   SI38953      OSP-DB-OTHER-QDBCRTME Hung job caused by Alter table recreat
   SI38579      OSP-DB-OTHER-QDBCRTME Unlocking library
   SI38489      OSP-DB Internal Maintenance
   SI38479      OSP-DB Internal Maintenance
   SI37444      OSP-DB Internal Maintenance
   SI37317      OSP-DB-OTHER-QDBCRTME
   SI37211      OSP-DB-OTHER-QDBCRTME
   SI37042      OSP-DB-OTHER-F/#DBCINX-T/QDBCRTME-MSGMCH5601 MSGMCH5601 WHEN
   SI36888      OSP-DB-OTHER-F/#DBCINX-T/QDBCRTME-MSGMCH5601 WHEN CREATING A
   SI36545      OSP-DB-OTHER-QDBCRTME
   SI38058      OSP-DB Message CPD32D7 Return Code 13 When Creating Keyed Lo
   SI37445      OSP-DB Internal Maintenance
   SI37161      OSP-DB Internal Maintenance
   SI37117      OSP-T/QDBEXDFI-MSGMCH3402 AFTER GOING TO R610 A JOB COULD FA
   SI36765      OSP-DB-OTHER-F/QDBSIGEX-T/QUOCMD-RC12-MSGCPD4002 CRTLF FAILS
   SI36456      OSP-DB Internal Maintenance
   SI37815      OSP-DB-OTHER-QDBCRTF2

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE48196
Superseded by:......................View fix details for PTF SI64620
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C1270710


System 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 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"},"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":""}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG16D","label":"PTF Cover Letters - IBM i 7.1 environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
13 June 2011