IBM Support

SI64620 - OSP-DB-OTHER-INCORROUT SYSPINDEX SHOWS AN EVI AS A 4GB ON TA

PTF Cover Letter


PTF ( Program Temporary Fixes ) Cover letter


Order this fix

Abstract

OSP-DB-OTHER-INCORROUT SYSPINDEX SHOWS AN EVI AS A 4GB ON TA


Pre/Co-Requisite PTF / Fix List

REQ  LICENSED      PTF/FIX  LEVEL

TYPE PROGRAM  REL  NUMBER   MIN/MAX  OPTION
---- -------- ---  -------  -------  ------
PRE  5770SS1  710  SI50902   00/00    0000
PRE  5770SS1  710  SI50656   00/00    0000
PRE  5770SS1  710  SI43092   00/00    0000
PRE  5770SS1  710  SI37443   00/00    0000
PRE  5770SS1  710  SI50770   00/00    0000
PRE  5770SS1  710  SI50762   00/00    0000
CO   5770SS1  710  SI55805   00/00    0000
CO   5770SS1  710  SI55347   00/00    0000
CO   5770SS1  710  SI50806   00/00    0000
CO   5770SS1  710  SI50205   00/00    0000
CO   5770SS1  710  SI45895   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

-----------------------------------------------
select index_name, accpth_type from syspindex

shows an EVI as a 4GB on Target after Flashcopy.  DSPFD is
correct

CORRECTION FOR APAR SE67146 :
-----------------------------
The EVI indicator is stored in the associated space of the
index.  The code that set this indicator did not ensure that
this indicator was written out to disk.  The code will be
changed to ensure this indicator is written out to disk.

CIRCUMVENTION FOR APAR SE67146 :
--------------------------------
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 SI43723 :
=================================================

Please read the cover letter for this PTF. This PTF will correct an
error for creating a file with field procedures, 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
--------------  ------------------------------------------------------------
   SI63839      OSP MSGCPF69AB LOGGED TRYING TO EXECUTE APYJRNCHG AFTER REST
   SI62124      OSP-DB-OTHER-F/QTNECCID-T/QDBCRTME-RC2-MSGCPF83EB DECLARE GL
   SI59867      F/QDBDLTFI-MOD/QDBDLTFI JOB ENTERS INFINITE LOOP IN QDBDLTFI
   SI59247      OSP-MSGCPD32D7-D/TQDDCLF-PAR COMPILING DDS SOURCE WITH A JOI
   SI58893      OSP-DB Change Increment value for System Limits Maximum numb
   SI58890      OSP-DB Change Increment value for System Limits Maximum numb
   SI56152      OSP-DB-OTHER-UNPRED AUTHORISATION DROPPED ON VIEW BY ALTER T
   SI55807      OSP-DB Memory leak when restoring with deferred logical file
   SI55790      OSP-MSGCPI9871 RESTORING DATA CAUSES CPF9810 FOLLOWED BY CPI
   SI55345      OSP-DB-OTHER-UNPRED AUTHORIZATION DROPPED ON UPDATE TABLE VI
   SI55273      OSP-DB-OTHER-F/QSRRSDEQ-MSGCPF3731 MSGCPF3731 DURING RESTORE
   SI54293      OSP-DB-OTHER-MSGCPI9871 RESTORING DATA CAUSES CPF9810 FOLLOW
   SI53942      OSP-DB-OTHER-PERFM QDBRSPRE WAITING TO LOCK FILE QADBRSDFR
   SI53942      OSP-MSGMCH5203-T/QSRRSRQI during restore from parallel save
   SI52761      OSP-DB-OTHER-INCORROUT DEFINER FIELD IS BLANK ON SYSTEM I NA
   SI51168      OSP-MSGCPF3283-F/QDBRSPRE Logical file restore fails
   SI50773      OSP-DB-OTHER Incremental Enhancement
   SI50748      F/QDBRSPRE-MSGMCH0605 DURING PARALLEL RESTORE OF A LIBRARY,
   SI49723      OSP-DB ALTER TABLE ON A PARTITIONED TABLE TO ADD COLUMNS IS
   SI49520      OSP-DB-OTHER-UNPRED RESTORE 21 HANGS ON THE SAME LIBRARY
   SI49492      OSP-DB-OTHER CHECK FORMAT LEVEL ID
   SI49081      OSP-DB-OTHER-T/QDBCHGFI-MSGMCH3402 RCLDBXREF BEFORE INSTALL
   SI44942      OSP-DB-OTHER-UNPRED DATA DICTIONARY INFORMATION MAY BE MISSI
   SI42869      OSP-DB RSTOBJ FAILS MCH3601 F/QDBRSPRE X/10ED T/QDBRSPRE X/1
   SI42452      OSP-DB-OTHER-QDBRSPRE V710TR2.SWFST.Restore(D/R) is extremel
   SI42219      OSP-DB-OTHER-UNPRED RESTORE OF A JOIN LOGICAL FILE MAY RESUL
   SI40751      OSP-DB Directory locking improvements
   SI39553      OSP-DB-OTHER-QDBRSPRE Internal Changes
   SI37939      OSP-DB-OTHER-QDBRSPRE MCH0601 Occurs in Restoring Library
   SI36450      OSP-DB-OTHER-INCORROUT RI WITH PARTITIONED TABLES
   SI37431      OSP-DB-OTHER-QDBRSPRE
   SI36981      OSP-DB-OTHER-F/QDBRSPRE-T/QDBRSPRE-MSGMCH3601 RSTLIB JOBLOG
   SI53940      OSP-DB-OTHER-PERFM RUNNING MANY RESTORE LIBRARIES AT THE SAM
   SI53086      OSP-DB-OTHER-UNPRED FORMAT LEVEL ID CHANGES RESTORING FILE U
   SI52643      OSP-DB RESTORE OF A PF IS FAILING WITH MSGMCH3402 T/QDBCRTFI
   SI52629      OSP-DB Incremental Enhancement
   SI52180      OSP-OTHER QDBCRTFI VIEW CAPABILITIES NOT SET CORRECTLY
   SI52149      OSP-OTHER QDBCRTME ALLOW 256 BASED ON MEMBERS
   SI51417      OSP-DB-OTHER-T/QDBDLTMEX/07B5-MSGMCH3402 RMVM FAILED WITH MS
   SI51405      OSP-DB-OTHER-MSGSQL0901 AFTER A RNMM OF A MEMBER AN ATLER TA
   SI50808      OSP-DB Enhance Database Maintenance Index Build Status
   SI50772      OSP-DB-OTHER Incremental Enhancement
   SI50659      OSP-DB-OTHER-MSGCPD432B -  global variable object not found
   SI50636      OSP-DB-OTHER-MSGSQ20246 ADDING A FIELD PROCEDURE TO A PF FAI
   SI50598      OSP-DB-OTHER-UNPRED DROP TABLE "TABLE" CASCADE FAILS WITH SQ
   SI50539      OSP-DB WHEN RESTORING A FILEGETTING MSGCPF3230 F/QDBCRTFI T/
   SI50206      OSP-DB-OTHER-F/QDBCDMER-T/QDBCDMER-MSGMCH3602 CHGPF FAILS WH
   SI50206      OSP-DB-OTHER-UNPRED REPLAYING A CREATE TABLE WITH FK CONSTRA
   SI49480      OSP-OTHER-WAIT DLTF TAKES SEVERAL SECONDS
   SI49304      OSP-DB INTERNAL MAINTENANCE
   SI48996      OSP-PAR-940XBASE IASP VARY ON HANGING ON UID/GID MISMATCH
   SI47952      OSP-DB-OTHER-F/QDBDLTFI-T/QLIDLOBJ-MSGMCH3402 USING DLTF IN
   SI47913      OSP-DB-LOOP F/QDBDLTFI BAD POINTER IN LOCK TEMPLATE
   SI47529      OSP-MSGSQL0913 ORPHAN LOCK CAUSE SQL0913 ON ALTER OR DROP TA
   SI47310      OSP-MSGSQL0913 ORPHAN LOCK CAUSE SQL0913 ON ALTER OR DROP TA
   SI47070      OSP-DB-OTHER-F/QDBADDCT-T/QDBARCFR-MSGCPF3202 ORPHANED CONST
   SI46603      OSP-DB-LOOP Looping in QDBDLTFI when rolling back the delete
   SI46002      OSP-DB-OTHER-F/#DBXMUSE-T/QDBDLTME-MSGMCH3406 RMVM COMMAND O
   SI45220      OSP-DB DLTF or SQL DROP TABLE results in MCH3601 F/RmslLockS
   SI44312      OSP-DB-OTHER FILE THAT IS DAMAGED IS UNABLE TO BE DELETED
   SI44268      OSP-OTHER-F/QDBCRTFI-T/QLICRDUP-MSGCPF327E CRTDUPOBJ INTO EM
   SI43629      OSP-DB Trigger Claim Entry(ies) Left In XREF When Deleting A
   SI43512      OSP-DB CPF3130 f/ QDBCLRPF using CLRPFM
   SI43293      OSP-T/QDBOPEN-MSGMCH3402 DAMAGED QAQQINI RESULTS IN MSGMCH34
   SI43085      OSP-DB-OTHER-MSGMCH1604 MSGMCH1604, MSGCPF8113 & MSGCPF4182C
   SI43085      OSP-DB MCH1885 f/ #dbdds t/ QDBDLTFI deleting file with prim
   SI41178      OSP-DB Internal Maintenance
   SI41048      OSP-DB Directory locking improvements
   SI40656      OSP-DB Internal Maintenance
   SI39975      OSP-DB-OTHER-F/SETSPACEPTRFROMPTR-T/QSQCLSCR-MSGMSG3402 TEMP
   SI39854      OSP-DB Internal Maintenance
   SI39540      OSP-DB Internal Maintenance
   SI38936      OSP-DB-OTHER-F/QDBCRTFI-MSGCPF3220 DLTF ON LOGICAL FILE FAIL
   SI38299      OSP-T/QDBSIZFI-MSGMCH3402 MQT BECOMES CORRUPTED AFTER CRTDUP
   SI37905      OSP-DB-OTHER-QDBDLTFI LOOPING
   SI37502      OSP-DB-OTHER-QDBDLTFI
   SI37447      OSP-DB Internal Maintenance
   SI37109      OSP-DB-OTHER-QDBDLTFI
   SI36964      OSP-DB-OTHER-QDBDLTFI for MQT using Commitment Control
   SI36783      OSP-DB-OTHER-QDBDLTFI
   SI36459      OSP-DB Internal Maintenance
   SI49930      OSP-DB-MSGSQL0190 alter table to add field procedure fails
   SI49666      OSP-DB STRJRNLIB Journaling not started if user not authoriz
   SI49666      OSP-DB-OTHER-MSGCPF2499 FIELD PROCEDURE ERRORS - CPF9889 - C
   SI49353      OSP-DB-UNPRED Internal maintenance
   SI49303      OSP-DB INTERNAL MAINTENANCE
   SI49300      OSP-DB-OTHER SUPPORT QPTFOBJ1 and QPTFOBJ2
   SI49209      OSP-DB-OTHER FIX VARLEN DEFAULT VALUE
   SI48874      OSP-DB INTERNAL MAINTENANCE
   SI48673      OSP-DB-OTHER-F/QDBCRTFI-T/QDBRSPPRE-MSGCPF3225 LF OPEN FIELD
   SI48017      OSP-DB Incremental Enhancement
   SI47832      OSP-DB-OTHER-QDBCRTFI SQL Index MCH5601
   SI47645      F/QDBCRTFI-MSGCPF3223 CRTPF REQUIRING *OBJOPR AUTHORITY TO A
   SI47444      OSP-DB Internal Maintenance
   SI46929      OSP ALTER TABLE TO ADD A PARTITION FAILS W/ CPF3236 WHEN USI
   SI46874      OSP-DB-OTHER-QDBDUPFI
   SI46148      OSP-DB-JRN-INCORROUT Logical file does not start journaling
   SI46050      OSP-DB-OTHER-F/#CFOCHKR-T/QDBCRTFI-MSGMCH2601 CRTPF FAILS WI
   SI46011      OSP-DB Incremental enhancement for field procs
   SI45465      OSP-DB-OTHER-UNPRED QDBRPLAY FOR CRTLF NOT MAKING A D CT ENT
   SI44619      OSP-DB msgCPF4204 t/ SYSBAS_XREF_CHG_CCSID using QDBCXRC api
   SI44539      OSP-DB-OTHER-F/QSQALTER-T/QSQALTER-MSGCPF3204 ALTERING A MEM
   SI44267      OSP-OTHER-F/QDBCRTFI-T/QLICRDUP-MSGCPF327E CRTDUPOBJ INTO EM
   SI44057      OSP-DB-OTHER-UNPRED R610 AND R710 DATA MISALIGNMENT IN LF
   SI44007      OSP-DB QDBRPLAY REPLAYING A D CT ENTRY FROM A REMOTE JOURNAL
   SI43913      OSP-DB-OTHER-F/QDBCRTFI-MSGMCH3601 AFTER APPLYING CUM TL6110
   SI43735      OSP-DB-OTHER-T/QDBCRTME-MSGMCH1210 WHEN CREATING A LF WITH A
   SI43723      OSP-DB-OTHER-MSGMCH1202 A MSGMCH1202 MAY OCCUR WITH DFU AND
   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
   SI36494      OSP-DB-OTHER-QDBCDMER
   SI36460      OSP-DB Internal Maintenance
   SI40756      OSP-DB Directory locking improvements

Summary Information

System..............................i
Models..............................
Release.............................V7R1M0
Licensed Program...............5770SS1
APAR Fixed..........................View details for APAR SE67146
Superseded by:......................
Recompile...........................N
Library.............................QSYS
MRI Feature ........................NONE
Cum Level...........................C7192710


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.

[{"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:
23 May 2017