MF63656 - OSP DATABASE next IDENTITY COLUMN VALUES NOT CORRECT AFTER F

TYPE PROGRAM  RELEASE   NUMBER   MIN/MAX  OPTION
---- -------- --------- -------  -------  ------
PRE  5770999  V7R2M0    MF63653   00/00    0000
CO   5770999  V7R2M0    MF59668   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 'IBM License Agreement for Machine
Code', the terms of which were provided in a printed document that was
delivered with the machine.

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.





APAR Error Description / Circumvention

-----------------------------------------------
After a flash copy and vary-on (or crash), the next database
Identity Column values assigned upon insert operations may not
be correct.  When there is a unique index over the columnm,
duplicate keys will be experienced and result in CPF5009.

CORRECTION FOR APAR MA46400 :
-----------------------------
The vary-on/IPL recovery of the data space header internal next
identity value structure had a problem which has been fixed.

CIRCUMVENTION FOR APAR MA46400 :
--------------------------------
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
--------------  ------------------------------------------------------------
   MF62656      OSP-DB Internal Maintenance for SLIC DB - Implicitly turn on
   MF62269      LIC-DB Future release compatibility changes
   MF62268      LIC-DB Future release compatibility changes
   MF59691      OSP-DB Internal Maintenance #dbdelcp/#dbdelct VLOG long runn
   MF61965      OSP-F/#DBCINDS-T/QQQOOODBOP-MSGMCH2804 MCH2804 RECEIVED ON A
   MF61557      OSP-DB Database IPL/Vary on Database Recovery & Initializati
   MF61533      OSP-DB Database IPL/Vary on Database Recovery Processing Imp
   MF61472      OSP-DB Database IPL/Vary on Database Recovery Processing Imp
   MF61393      OSP-DB Database IPL/Vary on Database Recovery Statistics
   MF61162      OSP-DB-OTHER-THREADS-PERFM RESTORE FAILS WITH MCH1604
   MF61005      LIC-DB 060056B9 vlogs on first touch after IPL, IASP vary on
   MF60833      OSP-DB Internal Maintenance for DB IPL/Vary-on
   MF60770      LIC-DB-OTHER-PERFM IASP VARY ON SPENDING MORE TIME THEN EXPE
   MF60512      OSP-DB-OTHER-LOOP AFTER A WARM FLASHCOPY, IASP VARYON GOT ST
   MF59687      OSP-MSGCPF8111 PARTIAL DAMAGE ON FILE MEMBER WHEN PERFORMING
   MF59665      LIC-DB Set last used VL storage at IPL.
   MF59610      OSP-MSGCPF8111 PARTIAL DAMAGE ON FILE MEMBER WHEN PERFORMING
   MF59334      LIC-DB Preserve Variable length storage after an IPL

Summary Information

IBM i Support